Re: [SQLObject] can't make sqlobject-admin upgrade to work

2006-06-07 Thread Rick Flosi
On Wed, 7 Jun 2006, sophana wrote: Rick Flosi a écrit : On Wed, 7 Jun 2006, sophana wrote: I'm using sqlobject-0.7 I'm trying to follow the sqlobject-admin documentation did a sqlobject-admin record -m Sql I can see a new table created containing the current version then I add a column 'foo

Re: [SQLObject] can't make sqlobject-admin upgrade to work

2006-06-07 Thread sophana
Rick Flosi a écrit : > On Wed, 7 Jun 2006, sophana wrote: > > >> I'm using sqlobject-0.7 >> I'm trying to follow the sqlobject-admin documentation >> >> did a >> sqlobject-admin record -m Sql >> I can see a new table created containing the current version >> then I add a column 'foo' to one of m

Re: [SQLObject] create a row

2006-06-07 Thread Oleg Broytmann
On Wed, Jun 07, 2006 at 05:12:41PM +0200, Ivan Horvath wrote: > here i send the mysqlconnection.py, i made the modification > it works now for me, please test it. I applied both your patches to the trunk and to the 0.7-bugfix branch. Thank you! Oleg. -- Oleg Broytmann

Re: [SQLObject] can't make sqlobject-admin upgrade to work

2006-06-07 Thread Rick Flosi
On Wed, 7 Jun 2006, sophana wrote: > I'm using sqlobject-0.7 > I'm trying to follow the sqlobject-admin documentation > > did a > sqlobject-admin record -m Sql > I can see a new table created containing the current version > then I add a column 'foo' to one of my tables ** You need to do another

Re: [SQLObject] create a row

2006-06-07 Thread Oleg Broytmann
On Wed, Jun 07, 2006 at 04:41:55PM +0200, Ivan Horvath wrote: > ts_project(title=u"ivan project1") > formencode.api.Invalid: expected an int in the IntCol 'clientID', got 'unicode'> u'0' instead > > i think this is also not correct, here should be done also a kind > of conversion rega

[SQLObject] can't make sqlobject-admin upgrade to work

2006-06-07 Thread sophana
Hi I'm using sqlobject-0.7 I'm trying to follow the sqlobject-admin documentation did a sqlobject-admin record -m Sql I can see a new table created containing the current version then I add a column 'foo' to one of my tables then I do sqlobject-admin upgrade -c it says database is up to date, bu

Re: [SQLObject] create a row

2006-06-07 Thread Oleg Broytmann
On Wed, Jun 07, 2006 at 01:41:49PM +0200, Ivan Horvath wrote: > >> if you need the code (main.py) i can send you for further process Let me try to guess what is going on. "use_unicode" suggests you use MySQL, and I think you use fromDatabase=True. With this setup mysqlconnection.py constru

Re: [SQLObject] create a row

2006-06-07 Thread Oleg Broytmann
On Wed, Jun 07, 2006 at 12:56:58PM +0200, Ivan Horvath wrote: > maybe i've found a bug. > in my connection string i specify use_unicode=True > > when the system construct the kw dictionary in the > SQLObject._create method in main.py, the column names are > unicode, theref

Re: [SQLObject] create a row

2006-06-07 Thread Ivan Horvath
Dear All, maybe i've found a bug. in my connection string i specify use_unicode=True when the system construct the kw dictionary in the SQLObject._create method in main.py, the column names are unicode, therefore the keywords in kw are also unicode. i've made alread

Re: [SQLObject] Does SQLObject support creating a class fromexisting table in SQLite?

2006-06-07 Thread Oleg Broytmann
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 Broytmannhttp://phd.pp.ru/[EMAIL PROTECTED] Programm

Re: [SQLObject] Does SQLObject support creating a class fromexisting table in SQLite?

2006-06-07 Thread Didrik Pinte
Le mercredi 07 juin 2006 à 10:43 +0100, Yang, W (Wanjuan) a écrit : > >> For a driver to implent fromDatabase it must have > columnsFromSchema(). > >>sqliteconnection.py doesn't implement it. > > Will this be implemented in near future? > > wendy It must be implemented in the sqlobject/sql

Re: [SQLObject] Does SQLObject support creating a class fromexisting table in SQLite?

2006-06-07 Thread Yang, W (Wanjuan)
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Oleg Broytmann Sent: 07 June 2006 10:13 To: sqlobject-discuss@lists.sourceforge.net Subject: Re: [SQLObject] Does SQLObject support creating a class fromexisting table in SQLite? On Wed, Jun 07, 2006 at 09

Re: [SQLObject] Does SQLObject support creating a class from existing table in SQLite?

2006-06-07 Thread Oleg Broytmann
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.

[SQLObject] Does SQLObject support creating a class from existing table in SQLite?

2006-06-07 Thread Yang, W (Wanjuan)
Title: Does SQLObject support creating a class from existing table in SQLite? 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,