Re: [sqlalchemy] The problem with Oldest transaction (Firebird)

2013-06-22 Thread graf
суббота, 22 июня 2013 г., 8:26:58 UTC+3 пользователь werner написал: On 22/06/2013 01:03, graf wrote: sweep - sort of a garbage collector which removes unused versions of transaction. There is Database header page information, where you can see the the current transaction state

Re: [sqlalchemy] The problem with Oldest transaction (Firebird)

2013-06-22 Thread graf
суббота, 22 июня 2013 г., 17:39:56 UTC+3 пользователь Michael Bayer написал: On Jun 22, 2013, at 10:19 AM, graf a.zhabo...@gmail.com javascript: wrote: суббота, 22 июня 2013 г., 8:26:58 UTC+3 пользователь werner написал: On 22/06/2013 01:03, graf wrote: sweep - sort of a garbage

Re: [sqlalchemy] The problem with Oldest transaction (Firebird)

2013-06-21 Thread graf
четверг, 20 июня 2013 г., 21:52:37 UTC+3 пользователь Michael Bayer написал: On Jun 18, 2013, at 6:09 PM, graf a.zhabo...@gmail.com javascript: wrote: I use SQLAlchemy inside Tornado, and I use a singleton to make the Firebird connection inside application. class FirebirdDatabase

Re: [sqlalchemy] The problem with Oldest transaction (Firebird)

2013-06-21 Thread graf
sweep - sort of a garbage collector which removes unused versions of transaction. There is Database header page information, where you can see the the current transaction state, there are two parameters: Oldest transaction and Next transaction. The range from Oldest to Next - is the versions of

[sqlalchemy] The problem with Oldest transaction (Firebird)

2013-06-18 Thread graf
I use SQLAlchemy inside Tornado, and I use a singleton to make the Firebird connection inside application. class FirebirdDatabase(object): def __init__(self, firebird_params, echo=False): engine = create_engine('firebird+fdb://%(user)s:%(password)s@%(host)s:%(port)s/%(path)s' %

[sqlalchemy] SQLAlchemy 0.8.1 + fdb, row size

2013-06-17 Thread graf
I use sqlautocode to get declarative tables of the Firebird and now, when I try to insert new row with unicode value for the field to the database I got an error ValueError: Value of parameter (30) is too long, expected 20, found 22' which is Column('Myfield', VARCHAR(length=20)), The db