Thread: [SQLObject] problem with tables
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: fortuna123 Gazeta.p. <for...@ga...> - 2011-01-19 17:44:02
|
Hello i have problem with tables when i write class Person(SQLObject): ... fname = StringCol() ... mi = StringCol(length=1, default=None) ... lname = StringCol() ... >>> Person.createTable() This create table in base who don't have name but i have base who i create write this createdb fortuna_bib and i don't know how i create class in this base. I'm sorry for my english. Thank you for help me if you can. Rafał Fortuniak |
From: Oleg B. <ph...@ph...> - 2011-01-19 18:22:27
|
Hi! On Wed, Jan 19, 2011 at 06:18:21PM +0100, fortuna123 Gazeta.pl wrote: > class Person(SQLObject): > ... fname = StringCol() > ... mi = StringCol(length=1, default=None) > ... lname = StringCol() > ... > >>> Person.createTable() > > This create table in base who don't have name but i have base who i create > write this I don't think the table is in a DB without a name. All DB operations require a connection to a DB; either you have a connection or SQLObject complains. > createdb fortuna_bib and i don't know how i create class in this base. Create a connection to that database. There are a few ways to do it in SQLObject: sqlobject.sqlhub.processConnection = connectionForURI('postgres:/fortuna_bib') sqlhub is the global connection that's shared between all SQLObject tables. Or do Person.setConnection('postgres:/fortuna_bib') This sets connection only for the table. And now, when you have the connection to the specific database - call Person.createTable() Oleg. -- Oleg Broytman http://phdru.name/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: Petr J. <pet...@tp...> - 2011-01-19 21:07:30
|
> > > This sets connection only for the table. > > And now, when you have the connection to the specific database - call > > Person.createTable() > > Oleg, thanks for giving me a lesson. I mean lesson about kindness and helpfulness, not lesson about programming.. Cheers Petr |
From: Oleg B. <ph...@ph...> - 2011-01-19 21:38:59
|
On Wed, Jan 19, 2011 at 10:07:23PM +0100, Petr Jake?? wrote: > thanks for giving me a lesson. > > I mean lesson about kindness and helpfulness, not lesson about programming.. > > Cheers > > Petr Thank you for the nice words! Oleg. -- Oleg Broytman http://phdru.name/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |