[sqlalchemy] Re: INSERT IGNORE

2007-10-03 Thread Michael Bayer
ive added ticket #804 for this. On Oct 1, 2007, at 5:35 PM, Jim Musil wrote: I'm not seeing the ability to use the INSERT IGNORE ... syntax. Is this available anywhere? Jim Musil --~--~-~--~~~---~--~~ You received this message because you are

[sqlalchemy] Re: limit=bindparam(result_limit)

2007-10-03 Thread Michael Bayer
ive added ticket # 805 for the LIMIT/OFFSET bind parameter feature. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe

[sqlalchemy] Re: INSERT IGNORE

2007-10-03 Thread Michael Bayer
we could potentially support a mysql_ignore keyword argument to the Insert() construct in order to achieve this (we've been adding a few postgres flags as of late). In the interim you'd have to use textual clauses for this. On Oct 1, 2007, at 5:35 PM, Jim Musil wrote: I'm not seeing

[sqlalchemy] non-blocking row locks?

2007-10-03 Thread sacha
Hi, I am attempting to implement a job queue in a postgres database. There is a simple job table in which each row represents a job to be run. There are multiple dispatcher threads that pull jobs off the queue and run them. I need concurrency control to prevent multiple threads from dispatching

[sqlalchemy] Re: non-blocking row locks?

2007-10-03 Thread Michael Bayer
On Oct 3, 2007, at 10:40 AM, sacha wrote: Hi, I am attempting to implement a job queue in a postgres database. There is a simple job table in which each row represents a job to be run. There are multiple dispatcher threads that pull jobs off the queue and run them. I need concurrency

[sqlalchemy] 04ormtutorial: IntegrityError: (IntegrityError) 1062, Duplicate entry

2007-10-03 Thread [EMAIL PROTECTED]
Hi! I'm using tutorial http://www.sqlalchemy.org/docs/04/ormtutorial.html#datamapping_manytomany When I create and save 1st object, all works fine. But when I save 2nd post-object with the SAME KEYWORD: cut lang=python wendy = session.query(User).filter_by(name='wendy').one() post =

[sqlalchemy] 04ormtutorial: IntegrityError: (IntegrityError) 1062, Duplicate entry

2007-10-03 Thread [EMAIL PROTECTED]
Hi! I'm using tutorial http://www.sqlalchemy.org/docs/04/ormtutorial.html#datamapping_manytomany When I create and save 1st object, all works fine. But when I save 2nd post-object with the SAME KEYWORD: cut lang=python wendy = session.query(User).filter_by(name='wendy').one() post =

[sqlalchemy] Re: non-blocking row locks?

2007-10-03 Thread Ants Aasma
Coincidentally I had to implement almost exactly the same thing today. I used separate job checkout/checkin transactions, serializable isolation level to find out when there is a collision and job checkout time to see which jobs are currently running. By default the checkout time is a special

[sqlalchemy] SELECT executemany

2007-10-03 Thread Paul Kippes
Is there some other way I can execute a query using a list as a bound parameter? res = db.db_con.text('SELECT module_extra_key_name FROM module_extra_keys WHERE module_id IN :module_ids').execute({'module_ids': [1,2]}) The above is giving me an You cannot execute SELECT statements in

[sqlalchemy] Re: mySQL and timedelta

2007-10-03 Thread jason kirtland
Noufal wrote: Hello everyone, I'm having some trouble with a query involving a timedelta object with a mySQL backend (MyISAM). I have a table called Run that has two fields like so. sa.Column('starttime', sa.TIMESTAMP), sa.Column('endtime', sa.TIMESTAMP) I'm trying to find all

[sqlalchemy] Re: INSERT IGNORE

2007-10-03 Thread Jim Musil
Thanks! On Oct 3, 9:13 am, Michael Bayer [EMAIL PROTECTED] wrote: ive added ticket #804 for this. On Oct 1, 2007, at 5:35 PM, Jim Musil wrote: I'm not seeing the ability to use the INSERT IGNORE ... syntax. Is this available anywhere? Jim Musil

[sqlalchemy] Re: SELECT executemany

2007-10-03 Thread Michael Bayer
On Oct 3, 2007, at 2:46 PM, Paul Kippes wrote: Is there some other way I can execute a query using a list as a bound parameter? res = db.db_con.text('SELECT module_extra_key_name FROM module_extra_keys WHERE module_id IN :module_ids').execute({'module_ids': [1,2]}) The above is