[SQLObject] Re: DateTimeCol - how to insert properly

2006-03-14 Thread Grzesiek Slusarek
Hi Oleg. I have still the same. I've upgrade my SqObject and i have the same error in SQLObject 0.7.1 and 0.8.0 (dev version). I've checked that I have tho columns DateTimeCol() but to DateTimeValidator classes are passed 3 values!! First two are really type datetime so method from python r

Re: [SQLObject] DateTimeCol - how to insert properly

2006-03-14 Thread Oleg Broytmann
On Tue, Mar 14, 2006 at 10:10:55PM +0100, Grzesiek Slusarek wrote: > class Logging(SQLObject): > class sqlmeta: > table = 'logowania' > fromDatabase = True > idName = 'nrlogowania' > Idwykladowcy = ForeignKey('User', dbName="idwykladowcy") >

[SQLObject] DateTimeCol - how to insert properly

2006-03-14 Thread Grzesiek Slusarek
Hi all. I've got table from database which has columns datetimecol. I'm trying make new record but i can't. Ican properly give a datetime to that columns. My class definition: class Logging(SQLObject): class sqlmeta: table = 'logowania' fromDatabase = True

Re: [SQLObject] Patch to make tableExists work with "db.table" table name

2006-03-14 Thread Justin Johnson
Hi, What's the current situation with SQLObject development? I've read that Ian's started an SQLObject2 addressing some of his concerns with the architecture and so on. Is SQLObject 8.0 scheduled for release? I'm currently using SQLObject with TurboGears and I'm looking to provide migrati

Re: [SQLObject] Patch to make tableExists work with "db.table" table name

2006-03-14 Thread David Faure
On Tuesday 14 March 2006 16:25, Oleg Broytmann wrote: > def tableExists(self, tableName): > try: > self.query('DESCRIBE %s' % (tableName)) > return True > except MySQLdb.ProgrammingError, e: > if e.args[0] == 1146: # ER_NO_SUCH_TABLE >

Re: [SQLObject] Patch: support for locking rows

2006-03-14 Thread Oleg Broytmann
On Thu, Mar 09, 2006 at 02:01:58PM +0100, David Faure wrote: > OK, I have reworked the support for "select for update" so that it now looks > like > obj.select(forUpdate = True) > > Patch and testcase attached. You have forgotten to patch (of forgot to include diff) sresults.py. And your te

Re: [SQLObject] Patch to make tableExists work with "db.table" table name

2006-03-14 Thread Oleg Broytmann
On Wed, Mar 08, 2006 at 03:12:32PM +0100, David Faure wrote: > On Tuesday 21 February 2006 15:32, David Faure wrote: > def tableExists(self, tableName): > +try: > +self.query('DESCRIBE %s' % (tableName)) > return True > +except MySQLdb.ProgrammingEr

Re: [SQLObject] Are those transactions any good?

2006-03-14 Thread Oleg Broytmann
(Answer to the list, please) On Tue, Mar 14, 2006 at 03:45:48PM +0100, Soni Bergraj wrote: > [EMAIL PROTECTED] wrote: > > On Tue, Mar 14, 2006 at 03:31:47PM +0100, Soni Bergraj wrote: > > > >>the classic problem. Two writers try to increase a value. > > > >The classical solution: *serializea

Re: [SQLObject] Are those transactions any good?

2006-03-14 Thread Soni Bergraj
(to oleg: sorry for the dup, this was meant for the ml:) >The classical solution: *serializeable* transactions! That ought to be true. But how to get one. I found nothing about in the archives or the docs. What kind of transaction does conn.transaction() give me? Read committed? Any help is

Re: [SQLObject] Are those transactions any good?

2006-03-14 Thread Oleg Broytmann
On Tue, Mar 14, 2006 at 03:31:47PM +0100, Soni Bergraj wrote: > the classic problem. Two writers try to increase a value. The classical solution: *serializeable* transactions! Oleg. -- Oleg Broytmannhttp://phd.pp.ru/[EMAIL PROTECTED] Programmers don't d

[SQLObject] Are those transactions any good?

2006-03-14 Thread Soni Bergraj
Hello, i just tried to do a minimal example, but ran into problems. Let's assume the classic problem. Two writers try to increase a value. A B begin begin x = x + 1 x = x + 1 commitcommit When i do this congruent, both commits succeed with no error.

Re: [SQLObject] sqlobject Primary Keys

2006-03-14 Thread Oleg Broytmann
On Tue, Mar 14, 2006 at 03:23:50PM +0100, Uwe Grauer wrote: > So a good ORM have to have the possibility to map these. Patches will be gladly accepted. Oleg. -- Oleg Broytmannhttp://phd.pp.ru/[EMAIL PROTECTED] Programmers don't die, they just GOSUB with

Re: [SQLObject] sqlobject Primary Keys

2006-03-14 Thread Uwe Grauer
Oleg Broytmann wrote: > On Tue, Mar 14, 2006 at 02:46:03PM +0100, Uwe Grauer wrote: >Decimal value as a primary key?! Oops... > Or (in other wolds) a Firebird BIGINT eg. 64bit signed. >>>Is it mapped to Decimal? Not int or long? Wierd... >>> >> Yes, if your interested: >> Fireb

Re: [SQLObject] sqlobject Primary Keys

2006-03-14 Thread Oleg Broytmann
On Tue, Mar 14, 2006 at 02:46:03PM +0100, Uwe Grauer wrote: > >>>Decimal value as a primary key?! Oops... > >>> > >> Or (in other wolds) a Firebird BIGINT eg. 64bit signed. > > > >Is it mapped to Decimal? Not int or long? Wierd... > > > Yes, if your interested: > Firebird data types compa

Re: [SQLObject] Re: query for foreignkey

2006-03-14 Thread Oleg Broytmann
On Tue, Mar 14, 2006 at 01:40:59PM +, Vivek wrote: > KeyError: 'alpha' I've only fixed an error with syntax (with .select() parameters), not the query itself. Oleg. -- Oleg Broytmannhttp://phd.pp.ru/[EMAIL PROTECTED] Programmers don't die, they just

Re: [SQLObject] sqlobject Primary Keys

2006-03-14 Thread Uwe Grauer
Oleg Broytmann wrote: > On Tue, Mar 14, 2006 at 01:50:27PM +0100, Uwe Grauer wrote: >>>Decimal value as a primary key?! Oops... >>> >> Or (in other wolds) a Firebird BIGINT eg. 64bit signed. > >Is it mapped to Decimal? Not int or long? Wierd... > > Oleg. Yes, if your interested: Firebird

[SQLObject] Re: query for foreignkey

2006-03-14 Thread Vivek
Oleg Broytmann mail2.phd.pp.ru> writes: > > On Tue, Mar 14, 2006 at 12:54:11PM +, Vivek wrote: > > a=Entries.select(Entries.q.aCount==3,Entries.q.alpha==myalpha) > > a=Entries.select(AND(Entries.q.aCount==3,Entries.q.alpha==myalpha)) > > Oleg. I get this error :( >>> a=Entries.select(AND

Re: [SQLObject] query for foreignkey

2006-03-14 Thread Oleg Broytmann
On Tue, Mar 14, 2006 at 12:54:11PM +, Vivek wrote: > a=Entries.select(Entries.q.aCount==3,Entries.q.alpha==myalpha) a=Entries.select(AND(Entries.q.aCount==3,Entries.q.alpha==myalpha)) Oleg. -- Oleg Broytmannhttp://phd.pp.ru/[EMAIL PROTECTED] Programmer

Re: [SQLObject] sqlobject Primary Keys

2006-03-14 Thread Oleg Broytmann
On Tue, Mar 14, 2006 at 01:50:27PM +0100, Uwe Grauer wrote: > >Decimal value as a primary key?! Oops... > > > Or (in other wolds) a Firebird BIGINT eg. 64bit signed. Is it mapped to Decimal? Not int or long? Wierd... Oleg. -- Oleg Broytmannhttp://phd.pp.ru/[E

[SQLObject] query for foreignkey

2006-03-14 Thread Vivek
I have two tables. I want to query for an entry where want to look for entries which have the foreign key and the and a count. which doesn not seem to happen when I look to pass the foreign key and the count. something like this.. a=Entries.select(Entries.q.aCount==3,Entries.q.alpha==myalpha)

Re: [SQLObject] sqlobject Primary Keys

2006-03-14 Thread Uwe Grauer
Oleg Broytmann wrote: > On Mon, Mar 13, 2006 at 01:25:25PM +0100, Uwe Grauer wrote: >> Only strings? > >Only strings (and even that was patched in not so long ago). > >> I'm planning to use something equivalent to DecimalCol(size=18, >> precision=0). > >Decimal value as a primary key?! O