Thread: [SQLObject] addColumn, delColumn with sqlite
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Tom E. <tom...@ja...> - 2008-12-10 15:17:17
|
Dear all, http://www.sqlobject.org/SQLObject.html#runtime-column-and-join-changes claims that "SQLite does not support this feature". However for the simple case I have tried it works just as well on sqlite as postgres (see code below). Also, http://www.sqlobject.org/News.html#id25 claims that "Implemented addColumn() for SQLite." This is all inconsistent. What's the true state of addColumn and delColumn on sqlite? Tom % cat changi.py from sqlobject import * import sys if len(sys.argv) > 1 and sys.argv[1] == 'sqlite': sqlhub.processConnection = connectionForURI('sqlite:/:memory:') else: sqlhub.processConnection = connectionForURI('postgres:///var/run/postgresql/changi') class Person(SQLObject): pass Person.createTable() Person() print list(Person.select()) Person.sqlmeta.addColumn(StringCol('name'), changeSchema=True) Person(name='Tom') print list(Person.select()) Person.sqlmeta.delColumn('name', changeSchema=True) Person() print list(Person.select()) % python changi.py sqlite [<Person 1 >] [<Person 1 name=None>, <Person 2 name='Tom'>] [<Person 1 >, <Person 2 >, <Person 3 >] % python changi.py [<Person 1L >] [<Person 1L name=None>, <Person 2L name='Tom'>] [<Person 1L >, <Person 2L >, <Person 3L >] |
From: Oleg B. <ph...@ph...> - 2008-12-10 15:28:05
|
On Wed, Dec 10, 2008 at 03:17:15PM +0000, Tom Ellis wrote: > http://www.sqlobject.org/SQLObject.html#runtime-column-and-join-changes > claims that "SQLite does not support this feature". However for the simple > case I have tried it works just as well on sqlite as postgres (see code > below). > > Also, http://www.sqlobject.org/News.html#id25 claims that "Implemented > addColumn() for SQLite." > > This is all inconsistent. What's the true state of addColumn and delColumn > on sqlite? True state: addColumn() and delColumn() are fully supported for SQLite; delColumn was announced at http://www.sqlobject.org/News.html#id2. The only problem is documentation. I will remove the sentence. Thank you for spotting this. Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |