Python object SQL dumper. More...

#include "RowsetReader.h"

Inheritance diagram for SetSQLDumper:

Collaboration diagram for SetSQLDumper:

Public Member Functions
	SetSQLDumper (const char table, const char keyField, FILE *out)

bool	VisitTuple (const PyTuple *rep)
	the nested types Visitor More...

bool	VisitObject (const PyObject *rep)
	Object type visitor. More...

Public Member Functions inherited from PyVisitor
virtual	~PyVisitor ()

virtual bool	VisitInteger (const PyInt *rep)
	primitive data visitors More...

virtual bool	VisitLong (const PyLong *rep)

virtual bool	VisitReal (const PyFloat *rep)

virtual bool	VisitBoolean (const PyBool *rep)

virtual bool	VisitNone (const PyNone *rep)

virtual bool	VisitBuffer (const PyBuffer *rep)

virtual bool	VisitString (const PyString *rep)

virtual bool	VisitWString (const PyWString *rep)

virtual bool	VisitToken (const PyToken *rep)

virtual bool	VisitList (const PyList *rep)

virtual bool	VisitDict (const PyDict *rep)

virtual bool	VisitObjectEx (const PyObjectEx *rep)

virtual bool	VisitPackedRow (const PyPackedRow *rep)
	PackedRow type visitor. More...

virtual bool	VisitSubStruct (const PySubStruct *rep)
	wrapper types Visitor More...

virtual bool	VisitSubStream (const PySubStream *rep)

virtual bool	VisitChecksumedStream (const PyChecksumedStream *rep)

Protected Attributes
const std::string	mTable

const std::string	mKeyField

FILE *const	mOut

Detailed Description

Python object SQL dumper.

Scans visited PyRep for any dumpable rowsets or tuplesets; if any is found, it's dumped using RowsetToSQL.

Author: Zhur, Bloody.Rabbit

Definition at line 191 of file RowsetReader.h.

Constructor & Destructor Documentation

SetSQLDumper::SetSQLDumper	(	const char *	table,
		const char *	keyField,
		FILE *	out
	)

Definition at line 247 of file RowsetReader.cpp.

 : mTable( table ),
   mKeyField( keyField ),
   mOut( out )
 {
 }

Member Function Documentation

bool SetSQLDumper::VisitObject ( const PyObject * rep )

virtual

Object type visitor.

Reimplemented from PyVisitor.

Definition at line 311 of file RowsetReader.cpp.

References PyString::content(), mKeyField, mOut, mTable, sLog, PyObject::type(), and PyVisitor::VisitObject().

 {
     if( rep->type()->content() == "util.Rowset" )
     {
         //we found a friend, decode it
         util_Rowset rowset;
 
         //must be duplicated in order to be decoded ...
         PyObject* dup = new PyObject( *rep );
         if( !rowset.Decode( &dup ) )
             sLog.Error( "SetSQLDumper", "Unable to load a rowset from the object body!" );
         else
         {
             RowsetReader reader( rowset );
             if( ReaderToSQL<RowsetReader>( mTable.c_str(), mKeyField.c_str(), mOut, reader ) )
                 return true;
 
             sLog.Error( "SetSQLDumper", "Failed to convert rowset to SQL." );
         }
     }
 
     //fallback
     return PyVisitor::VisitObject( rep );
 }

Here is the call graph for this function:

bool SetSQLDumper::VisitTuple ( const PyTuple * rep )

virtual

the nested types Visitor

Reimplemented from PyVisitor.

Definition at line 254 of file RowsetReader.cpp.

References PyRep::AsList(), PyList::begin(), PyList::end(), PyTuple::GetItem(), PyRep::IsList(), mKeyField, mOut, mTable, PyTuple::size(), sLog, and PyVisitor::VisitTuple().

 {
     //first we want to check to see if this could possibly even be a tupleset.
     if(    2 == rep->size()
         && rep->GetItem( 0 )->IsList()
         && rep->GetItem( 1 )->IsList() )
     {
         const PyList* possible_header = rep->GetItem( 0 )->AsList();
         const PyList* possible_items = rep->GetItem( 1 )->AsList();
 
         //check each element of the lists to make sure they line up.
         bool valid = true;
         PyList::const_iterator cur, end;
 
         cur = possible_header->begin();
         end = possible_header->end();
         for(; valid && cur != end; ++cur)
         {
             if( !(*cur)->IsString() )
                 valid = false;
         }
 
         cur = possible_items->begin();
         end = possible_items->end();
         for(; valid && cur != end; ++cur)
         {
             if( !(*cur)->IsList() )
                 valid = false;
 
             //it would be possible I guess to check each element of each item to make sure
             //it is a terminal type (non-container), but I dont care right now.
         }
 
         if( valid )
         {
             //ok, it looks like a tupleset... nothing we can do now but interpret it as one...
             util_Tupleset rowset;
 
             //must be duplicated in order to be decoded ...
             PyTuple* dup = new PyTuple( *rep );
             if( !rowset.Decode( &dup ) )
                 sLog.Error( "SetSQLDumper", "Unable to interpret tuple as a tupleset, it may not even be one." );
             else
             {
                 TuplesetReader reader( rowset );
                 if( ReaderToSQL<TuplesetReader>( mTable.c_str(), mKeyField.c_str(), mOut, reader ) )
                     return true;
 
                 sLog.Error( "SetSQLDumper", "Failed to convert tupleset to SQL." );
             }
         }
     }
 
     //fallback
     return PyVisitor::VisitTuple( rep );
 }