Thread: [SQLObject] Change the auto_increment id
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Leandro M. de S. <lea...@gm...> - 2007-06-20 16:52:00
|
Hi, I want to use the internel sqloject self.id to identify a specific object. I want to change the start value to 0, not to 1. In this well I can do MyClass.get(0) as the first database Item. How can I change the start value to 0, instand of 1. Thanks, Leandro. |
From: Oleg B. <ph...@ph...> - 2007-06-20 16:59:26
|
On Wed, Jun 20, 2007 at 01:51:56PM -0300, Leandro Melo de Sales wrote: > I want to use the internel sqloject self.id to identify a specific > object. I want to change the start value to 0, not to 1. In this well > I can do MyClass.get(0) as the first database Item. How can I change > the start value to 0, instand of 1. Autoincrement is performed by DB, not SQLObject. In Postgres one can manipulate the sequence that is used for autoincremented id. Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: Leandro M. de S. <lea...@gm...> - 2007-06-20 17:45:19
|
I'm using SQLLIte. How can I manipulate the autoincrement for this database by using sqlobject. Thanks, Leandro. 2007/6/20, Oleg Broytmann <ph...@ph...>: > On Wed, Jun 20, 2007 at 01:51:56PM -0300, Leandro Melo de Sales wrote: > > I want to use the internel sqloject self.id to identify a specific > > object. I want to change the start value to 0, not to 1. In this well > > I can do MyClass.get(0) as the first database Item. How can I change > > the start value to 0, instand of 1. > > Autoincrement is performed by DB, not SQLObject. In Postgres one can > manipulate the sequence that is used for autoincremented id. > > Oleg. > -- > Oleg Broytmann http://phd.pp.ru/ ph...@ph... > Programmers don't die, they just GOSUB without RETURN. > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > sqlobject-discuss mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss > -- Leandro Melo de Sales. Pervasive and Embedded Computing Laboratory http://embedded.ufcg.edu.br/ +55 083 3310-1404 (extension 208) "There are 10 types of people in this world: those who understand binary, those who don't" |
From: Oleg B. <ph...@ph...> - 2007-06-20 17:57:04
|
On Wed, Jun 20, 2007 at 02:45:14PM -0300, Leandro Melo de Sales wrote: > I'm using SQLLIte. How can I manipulate the autoincrement for this > database by using sqlobject. You cannot. SQLite doesn't have a proper autoincrement, and the builtin default for the first value is always 1: http://www.sqlite.org/faq.html#q1 Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |
From: Leandro M. de S. <lea...@gm...> - 2007-06-20 19:18:51
|
Thank you! Leandro. 2007/6/20, Oleg Broytmann <ph...@ph...>: > On Wed, Jun 20, 2007 at 02:45:14PM -0300, Leandro Melo de Sales wrote: > > I'm using SQLLIte. How can I manipulate the autoincrement for this > > database by using sqlobject. > > You cannot. SQLite doesn't have a proper autoincrement, and the builtin > default for the first value is always 1: http://www.sqlite.org/faq.html#q1 > > Oleg. > -- > Oleg Broytmann http://phd.pp.ru/ ph...@ph... > Programmers don't die, they just GOSUB without RETURN. > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > sqlobject-discuss mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss > |