>
> Thanks for the replies..
>
> In my case, the ID is used to store a generated uuid, as a completely
> unique string. The overall process, is that I have multiple systems, and
> they each run a local process, with a local db/tbl structure.. I then
> reconcile all the processes on a centralized mysql db process at a later
> time..
>
> My process enforces that the ID is essentually unique across all my
> systems. I don't want to change this approach. Nor do I simply want to have
> an ID that's an int, simply to use SQLObject...
>
> So.. my goal is to be able to use sqlobject to interface with the existing
> mysql db/tbl, and to be able to modify/handle an id that's a string...
>
So what is the problem?
simply connect to both tables, (the Source table and the Target table) using
two different connections.
class Source(SQLObject):
class sqlmeta:
fromDatabase = True
idName = "SOURCE_TABLE_ID_NAME"
idType= str
class Target(SQLObject):
class sqlmeta:
fromDatabase = True
idName = "TARGET_TABLE_ID_NAME"
idType= str
and read data from Source and write it to Target (as you can see in my
previous posting). I am not sure about the performance, but I think it must
work.
Alternatively you can export a .csv file from the Source table (using
SQLobject of course) and than import it to the to the Target table (here is
use of the SQLobject not recommended because of the performance issue).
Petr Jakes
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
