From: Roger H. <cro...@ya...> - 2004-08-24 17:58:02
|
The current CVS head for Middlekit now generates and expects the serialNum field for all SQL tables to be called "serialNum" where before the serialNum field for each table would be called <tablename> + "Id". This breaks a lot of existing code as all SQL tables created with prior versions will not work. Here is a excerpt from a new create.sql written by Generate.py from CVS head: ... create table User ( serialNum int not null primary key auto_increment, deleted datetime null, firstName varchar(15), lastName varchar(15), password varchar(63), ... And an excerpt from a create.sql made with 8.1 Middlekit: ... create table User ( userId int not null primary key auto_increment, deleted datetime, firstName varchar(15), lastName varchar(15), password varchar(63), ... Roger Haase __________________________________ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail |
From: Chuck E. <Chu...@ya...> - 2004-08-25 20:04:03
|
On Tue, 24 Aug 2004 10:57:52 -0700 (PDT), Roger Haase wrote: > The current CVS head for Middlekit now generates and expects the > serialNum field for all SQL tables to be called "serialNum" where > before the serialNum field for each table would be called > <tablename> + "Id". > > This breaks a lot of existing code as all SQL tables created with > prior versions will not work. Not to worry. As the author of MiddleKit I also have older projects that I= don't want broken (and don't feel like upgrading). Consequently, when I= make changes like this, I always add an option to get the old behavior. In= this case, the setting is: { =09'SQLSerialColumnName': '%(className)sId', } Which goes in Settings.config inside your Foo.mkmodel. Also you may need this one if you don't want object references split into 2= columns (class id and obj id): =09'UseBigIntObjRefColumns': 1, Cheers, -Chuck |
From: Roger H. <cro...@ya...> - 2004-08-26 20:17:47
|
--- Chuck Esterbrook <Chu...@ya...> wrote: > Not to worry. As the author of MiddleKit I also have older projects > that I don't want broken (and don't feel like upgrading). > Consequently, when I make changes like this, I always add an option > to get the old behavior. In this case, the setting is: > > { > 'SQLSerialColumnName': '%(className)sId', > } > > Which goes in Settings.config inside your Foo.mkmodel. > > Also you may need this one if you don't want object references split > into 2 columns (class id and obj id): > 'UseBigIntObjRefColumns': 1, > Thanks Chuck, that works for me. Roger Haase __________________________________ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail |