[sqlalchemy] Re: sql executemany and postgresql - probably bug

2007-08-27 Thread che
Thanks Michael, it is not urgent to me. if i found time i'll look down what is causing this and eventually try to patch. regards, stefan On 25 Авг, 03:09, Michael Bayer [EMAIL PROTECTED] wrote: On Aug 23, 2007, at 11:18 AM, che wrote: i cant reply to this issue for another week since im

[sqlalchemy] Re: One To Many Polymorphic Association.

2007-08-27 Thread praddy
Currently, unable to find any solution for this problem. I think my little knowledge with respect to sqlalchemy is restricting me to get a solution for this issue. Anyone with somewhat more in-depth knowledge should be able to find a solution. Waiting... Regards, Pradeep Jindal On Aug 25, 1:15

[sqlalchemy] Re: interface error with Decimal(0) in where clause

2007-08-27 Thread Michael Bayer
the convert to Decimal thing is a new feature for Numeric types in version 0.4. If you wish to use Python floats, you can either use the Float type, or specify asdecimal=False to the constructor of any Numeric type. On Aug 27, 2007, at 12:44 AM, cfriedalek wrote: Thanks. I didn't

[sqlalchemy] Re: sql executemany and postgresql - probably bug

2007-08-27 Thread Michael Bayer
Ive added ticket #759 for this and I think before 0.4 is finalized, I'll be working out the full solution for Postgres inserts/updates, which will allow a flag inline=True on all Insert/Update constructs indicating that all SQL expressions should execute inline (i.e. no pre-execution),

[sqlalchemy] Re: One To Many Polymorphic Association.

2007-08-27 Thread Michael Bayer
On Aug 24, 2007, at 8:39 AM, praddy wrote: ## from sqlalchemy import * meta = BoundMetaData('sqlite://', echo=False) # Parents table. parents = Table('parents', meta, Column(id, Integer, primary_key=True), Column(data,

[sqlalchemy] Re: SA 0.4, pylons 0.9.6rc3

2007-08-27 Thread pablo masoero
On 22 ago, 19:29, jason kirtland [EMAIL PROTECTED] wrote: Anil wrote: Actually, there was some information in the logs that I just noticed that might help detect the problem (some kind of unicode issue?): 12:58:21,710 INFO [sqlalchemy.engine.base.Engine.0x..50] SHOW CREATE TABLE `User`

[sqlalchemy] outerjoin constructor throws exception from 0.3.9. Bug or user error?

2007-08-27 Thread mc
Hi, I have the following two tables (in MySql): CREATE TABLE `A` ( `xkey` varchar(200) NOT NULL, `yval` int(11) default NULL, PRIMARY KEY (`xkey`) ) ENGINE=InnoDB; and CREATE TABLE `B` ( `xkey` varchar(200) NOT NULL default '', `s` enum('yes','no') NOT NULL default 'yes', PRIMARY

[sqlalchemy] Re: One To Many Polymorphic Association.

2007-08-27 Thread Pradeep Jindal
On Monday 27 August 2007 19:57:21 Michael Bayer wrote: On Aug 24, 2007, at 8:39 AM, praddy wrote: ## from sqlalchemy import * meta = BoundMetaData('sqlite://', echo=False) # Parents table. parents = Table('parents', meta,

[sqlalchemy] Re: SA 0.4, pylons 0.9.6rc3

2007-08-27 Thread jason kirtland
pablo wrote: Sorry, but I'm still having the same issue. I updated only the file in the changeset and the error keeps appearing. I'm missing something? That table is reflecting without issues for me in the trunk. Are you seeing the same warning in the log?

[sqlalchemy] Re: sqlalchemy with turbogears and mapper-part3 relation and flow control

2007-08-27 Thread Lukasz Szybalski
Hello, ok so I got the connection, select statements working using turbogears, assign_mapper and sqlalchemy. Now i need to work out the relation. User has a one to many relation with address, email, accounts. In reverse: address, email and accounts have many to one... #here is my table

[sqlalchemy] Testing Conditions for insertion, and grouping queries together

2007-08-27 Thread Mike Lewis
Hi, I'm new to SQLAlchemy, and I was wondering if there's a way to test a condition while inserting. I'm trying to make my application use as few separate queries at the same time as possible. Here's a couple cases I have had issues with: Inserting something with a unique column if it doesn't