Thread: [SQLObject] Does SQLObject support creating a class from existing table in SQLite?
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Yang, W \(Wanjuan\) <w....@dl...> - 2006-06-07 08:52:23
|
Hi, everybody, I have created tables in SQLite, Can I define a class based on these tables? For example, I have got a table 'address': Create table address ( id INTEGER PRIMARY KEY, addr TEXT, postcode TEXT); I define the class: class Address(SQLObject): class sqlmeta: fromDatabase =3D True table =3D 'address' It doesn't work. Is it right way to do it? Does SQLObject not support creating a class from existing table in SQLite at all? If not, Does anybody know any other tools can do this job? Any reply would be highly appreciated! Kind Regards, Wendy |
From: Oleg B. <ph...@ma...> - 2006-06-07 09:12:42
|
On Wed, Jun 07, 2006 at 09:52:17AM +0100, Yang, W (Wanjuan) wrote: > I have created tables in SQLite, Can I define a class based on these > tables? For a driver to implent fromDatabase it must have columnsFromSchema(). sqliteconnection.py doesn't implement it. Please look at mysqlconnection.py and postgresconnection.py, create columnsFromSchema() for sqliteconnection and make a patch. I'd be glad to test it. Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: Yang, W \(Wanjuan\) <w....@dl...> - 2006-06-07 09:45:53
|
-----Original Message----- From: sql...@li... [mailto:sql...@li...] On Behalf Of Oleg Broytmann Sent: 07 June 2006 10:13 To: sql...@li... Subject: Re: [SQLObject] Does SQLObject support creating a class fromexisting table in SQLite? On Wed, Jun 07, 2006 at 09:52:17AM +0100, Yang, W (Wanjuan) wrote: > I have created tables in SQLite, Can I define a class based on these > tables? >> For a driver to implent fromDatabase it must have columnsFromSchema(). >>sqliteconnection.py doesn't implement it. Will this be implemented in near future? wendy _______________________________________________ sqlobject-discuss mailing list sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss |
From: Didrik P. <dp...@it...> - 2006-06-07 09:54:13
|
Le mercredi 07 juin 2006 =E0 10:43 +0100, Yang, W (Wanjuan) a =E9crit : > >> For a driver to implent fromDatabase it must have > columnsFromSchema(). > >>sqliteconnection.py doesn't implement it. > =20 > Will this be implemented in near future?=20 >=20 > wendy It must be implemented in the sqlobject/sqlite/sqliteconnection.py file. Using the "PRAGMA table_info(table-name);" specific to sqlite statement for example. Didrik |
From: Oleg B. <ph...@ma...> - 2006-06-07 09:58:54
|
On Wed, Jun 07, 2006 at 10:43:48AM +0100, Yang, W (Wanjuan) wrote: > Will this be implemented in near future? http://sourceforge.net/mailarchive/forum.php?thread_id=10323168&forum_id=30269 Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |