[Sqlalchemy-users] calling create_engine multiple times with same connection string

2006-11-14 Thread Brad Clements
I thought at one time that calling create_engine multiple times with the same connection string would return the same engine. Now it seems that I get a different engine each time, and hence a different connection pool, so my Paste based application eventually consumes all available database

[Sqlalchemy-users] SQLAlchemy and MySQLdb creator?

2006-11-14 Thread Basil Shubin
Hi friends! For this code: from sqlalchemy import * import MySQLdb def connect(user, passwd, dbname, host): return MySQLdb.connect(user=user, passwd=passwd, db=dbname, host=host) if __name__ == '__main__': db = create_engine('mysql://',

Re: [Sqlalchemy-users] SQLAlchemy and MySQLdb creator?

2006-11-14 Thread Basil Shubin
Basil Shubin пишет: Hi friends! For this code: from sqlalchemy import * import MySQLdb def connect(user, passwd, dbname, host): return MySQLdb.connect(user=user, passwd=passwd, db=dbname, host=host) if __name__ == '__main__': db =

[Sqlalchemy-users] How to lock database row on select?

2006-11-14 Thread Basil Shubin
Hi friends! I have use SQLAlchemy 0.3 with MySQLdb 1.2.1 How I can lock row in database table when I select it? So nobody can access it in same time. BTW I use tables with InnoDB engine. -- Basil Shubin Freelance Software Developer