Re: [SQLObject] Altering/updating a database

2011-03-05 Thread Oleg Broytman
On Sat, Mar 05, 2011 at 08:29:54AM +, Timothy W. Grove wrote: > Thanks for the advice, Oleg. I found a solution which may not be > elegant, but it works for me! Instead of trying to work with two > different class definitions I've just kept one which declares the column > I wish to add to

Re: [SQLObject] Altering/updating a database

2011-03-05 Thread Timothy W. Grove
On 04/03/2011 2:00 PM, Oleg Broytman wrote: On Fri, Mar 04, 2011 at 12:49:50PM +, Timothy W. Grove wrote: It seems to me that there should be a simple way to add the attribute to the class if the column has been added already, or not if it has been added through updating There is no a

Re: [SQLObject] Altering/updating a database

2011-03-04 Thread Oleg Broytman
On Fri, Mar 04, 2011 at 12:49:50PM +, Timothy W. Grove wrote: > It seems to me that there should be a simple way to add the attribute to > the class if the column has been added already, or not if it has been > added through updating There is no a simple way. You have to create the tabl

Re: [SQLObject] Altering/updating a database

2011-03-04 Thread Timothy W. Grove
On 13/01/2011 10:12 PM, Oleg Broytman wrote: On Thu, Jan 13, 2011 at 09:36:03PM +, Timothy W. Grove wrote: I want to update an existing database by adding a new column (UnicodeCol) to an existing table. Can anyone suggest a way to automatically accomplish this through sqlobject ? It cou

Re: [SQLObject] Altering/updating a database

2011-01-14 Thread Imri Goldberg
On Fri, Jan 14, 2011 at 2:57 AM, Petr Jakeš wrote: > 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 ma

Re: [SQLObject] Altering/updating a database

2011-01-13 Thread Petr Jakeš
> 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 w

Re: [SQLObject] Altering/updating a database

2011-01-13 Thread Oleg Broytman
On Thu, Jan 13, 2011 at 09:36:03PM +, Timothy W. Grove wrote: > I want to update an existing database by adding a new column > (UnicodeCol) to an existing table. Can anyone suggest a way to > automatically accomplish this through sqlobject ? It could be as simple as Table.sqlmeta.addColu

Re: [SQLObject] Altering/updating a database

2011-01-13 Thread Imri Goldberg
Hi I've had the same problem some time ago, however I was (and still am) using mysql, so YMMV. I asked a similar question on this mailing list, and Oleg gave an example of what he was using. What I did was adapt Oleg's code to some "generic" db updating code: (this might need further adaptation to