Re: [SQLObject] MS SQL pain for a newb
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Mike D. <mdr...@co...> - 2008-02-12 14:39:32
|
Oleg, > -----Original Message----- > From: sql...@li... > [mailto:sql...@li...] On > Behalf Of Oleg Broytmann > Sent: Tuesday, February 12, 2008 8:37 AM > To: sql...@li... > Subject: Re: [SQLObject] MS SQL pain for a newb > > On Tue, Feb 12, 2008 at 08:22:17AM -0600, Mike Driscoll wrote: > > > Or, if empID is the Primary Key, use it as the id: > > > > > > class tblAcctPrefs(SQLObject): > > > class sqlmeta: > > > idName = "emp_id" > > > idType = str > > > pref_name = StringCol() > > > pref_value = StringCol() > > > > > since the tables I will be using have been created by > vendors and are > > outside of my control, I cannot alter the tables as that > would break > > their use for other programs that access them. > > My last advise was not about altering the tables but about > naming of the primary key. SQLObject requires a single-column > primary key of type INT or string, not necessary named 'id'. > Unfortunately if there are tables with multiple columns > primary key you are out of luck - SQLObject cannot handle them. > > Oleg. That's what I figured from the docs. Thanks for confirming that and for being so kind of helpful. Mike > -- > Oleg Broytmann http://phd.pp.ru/ > ph...@ph... > Programmers don't die, they just GOSUB without RETURN. > > -------------------------------------------------------------- > ----------- > This SF.net email is sponsored by: Microsoft Defy all > challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > sqlobject-discuss mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss > s > |