[sqlalchemy] SQL Alchemy on Insert to DB

2015-02-16 Thread Javier Pajuelo
I get the following error: sqlalchemy.exc.IntegrityError: (IntegrityError) column id is not unique u'INSERT INTO candidates (id, timeStamp, name, link) VALUES (?, ?, ?, ?)' (u'ORaE9+aCdP0', '2015-02-16 18: 19:58.00', u'Kunal Sethi',

Re: [sqlalchemy] Use multiple database for read and write operations

2015-02-16 Thread ahmadjaved . se
Thanks Michael for your time. Yes, I am using scope session to create Session. I want that all types of write operations *(insert, delete, update)* should run on write engine and only read operations will perform on read engine. class SQLAlchemySessionRouter(Session): def get_bind(self,