[sqlalchemy] Re: Import problem

2007-09-21 Thread Goutham Lakshminarayan
Bingo! easy_install -u sqlalchemy worked. (Btw wouldn't mind knowing what was wrong wen i first installed it :O. The folder wasnt empty and easy_install.pth did have a refernece to the egg). Thnx a lot! regards Goutham --~--~-~--~~~---~--~~ You received this

[sqlalchemy] Re: Auto load problem with SQLAlchemy 0.3.10 and mySQL

2007-09-21 Thread jason kirtland
Noufal wrote: On Sep 20, 10:34 pm, Noufal [EMAIL PROTECTED] wrote: [..] I create the tables using SQLAlchemy. I'll send you the output in a day, I'm away from the machine where this code is right now. The output of the create table column looks like this CREATE TABLE `stats` ( `sid`

[sqlalchemy] Re: Built-in escape function?

2007-09-21 Thread Paul Johnston
Hi, It doesn't, and that would be a reasonable addition. I'm also thinking that startswith, endswith and contains should probably do the escaping by default. If you create a ticket I'll look at it sometime, although not for a couple of weeks (I'm on holiday, woo :-) Paul On 9/21/07, Felix

[sqlalchemy] Re: Built-in escape function?

2007-09-21 Thread Felix Schwarz
Hi, Paul Johnston wrote: If you create a ticket I'll look at it sometime, although not for a couple of weeks (I'm on holiday, woo :-) [x] done, http://www.sqlalchemy.org/trac/ticket/791 fs --~--~-~--~~~---~--~~ You received this message because you are

[sqlalchemy] Re: Elixir

2007-09-21 Thread Gaetan de Menten
On 9/20/07, Christine [EMAIL PROTECTED] wrote: Any elixir fans? Any idea on when it will finally be made an extension? Let me know. Not sure. I'd like to answer: When it's ready. But ven when it'll be ready, this might not happen. There would be some positive points to that, but also some

[sqlalchemy] 0.4.0beta5 breaks [Oracle] query, works on 0.3.7 and with cxOracle

2007-09-21 Thread m h
Ok, so this looks impossible to me, but it's happening. I figure people with more experience debugging SA might be able to help. I've got a generated query (no ORM). I was using 0.3.7 with no problems, but thought I'd give .4 a try to see if I can take advantage of performance improvements.

[sqlalchemy] Re: Auto load problem with SQLAlchemy 0.3.10 and mySQL

2007-09-21 Thread Noufal
The MyISAM storage engine doesn't retain foreign key information- to autoload FKs you must create the table with a storage engine that supports FKs such as InnoDB. That looks like: Table('stats', metadata, ..columns.., mysql_engine='InnodB') You can also use ALTER TABLE via mysql to

[sqlalchemy] Re: 0.4.0beta5 breaks [Oracle] query, works on 0.3.7 and with cxOracle

2007-09-21 Thread m h
Just for kicks I tried using .3.10 and it failed giving the same error that was reported in the Aug 18 thread autoloading Oracle tables with column defaults:: File /home/matt/work/vpython/lib/python2.4/site-packages/SQLAlchemy-0.3.10-py2.4.egg/sqlalchemy/databases/oracle.py, line 117, in

[sqlalchemy] Re: session.dirty, not behaving as I expected...

2007-09-21 Thread Michael Bayer
On Sep 20, 2007, at 12:55 PM, Alexandre Conrad wrote: It turns out that even if the values were kept unchanged, the slot get's ditry. Of course, I'd understand that as soon as the setattr() is called against the slot, it automaticly gets dirty regardless of the replaced data. it