> It could be as simple as
>
> Table.sqlmeta.addColumn(UnicodeCol('name'), changeSchema=True)
>
>
Yes we are using addColumn method and it works great (Firebird SQL).
The other question still remains: "How to find if the table was updated
already". We are maintaining hundreds of the databases with the same
structure on different machines and we were not sure where the table was
already updated and where not.
Because of that, we were using following (but I do not know if it is the
best way):?
from kinterbasdb import ProgrammingError
try:
Table.select()[0]
except IndexError:
# this means table Table is OK, new column(s) was created already, no
data in the column
pass
except ProgrammingError:
Table.sqlmeta.addColumn(UnicodeCol('name'), changeSchema=True)
Cheers
Petr
------------------------------------------------------------------------------
Protect Your Site and Customers from Malware Attacks
Learn about various malware tactics and how to avoid them. Understand
malware threats, the impact they can have on your business, and how you
can protect your company and customers by using code signing.
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
