Thread: [SQLObject] common column definitions for a newbie
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Sells, F. <fr...@ad...> - 2006-01-25 16:24:45
|
in order to guarantee column definition consistency I would like to define my columns in one place, then use them in various tables as objects like xemployee =3D StringCol(length=3D6) xppid =3D DecimalCol(size=3D7, precision=3D2) xaction =3D EnumCol(enumValues=3D['REG1', 'REG2', 'REG3']) xhours =3D DecimalCol(size=3D6, precision=3D3) class Labor(SQLObject): =20 employee =3D xemployee =20 =20 ppid =3D xppid =20 action =3D xaction =20 ... class Edits(SQLObject): =20 supervisor =3Dxemployee) =20 action =3D xaction =09... =20 I'm not sure what SQLObject does under the hood. Will this work and is it a good idea, or will I have different tables using common column objects with wierd results. Would it work if my tables were created from std SQL statements, and SQLObject used only to reference them. I apologize for asking a question I could figure out by trial and error, but I'm still getting my feet wet with SQLObjects and fear doing something that will corrupt my db in a way that i don't catch initially. --------------------------------------------------------------------------- The information contained in this message may be privileged and / or confidential and protected from disclosure. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by replying to this message and deleting the material from any computer. --------------------------------------------------------------------------- |
From: Oleg B. <ph...@ma...> - 2006-01-25 16:37:09
|
On Wed, Jan 25, 2006 at 11:27:59AM -0500, Sells, Fred wrote: > xemployee = StringCol(length=6) > > class Labor(SQLObject): > employee = xemployee > > I'm not sure what SQLObject does under the hood. Will this work and is it a It should work. Under the hood SQLObject replaces these declarations with instances of SOCol classes that do real job. See col.py for the actual code of the columns. > Would it work if my tables were created from std SQL > statements, and SQLObject used only to reference them. Yes. Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |