[sqlalchemy] How to create table from select statements in sqlalchemy

2015-06-01 Thread Ranjith Ramachandra
I am using sqlalchemy's core features do write some abstraction layer. The layer itself needs to be able to create tables from select statements. Sample code: metadata = MetaData(bind=engine) table = Table(table_name, metadata, autoload=True, autoload_with=engine) s =

[sqlalchemy] Re: How to create table from select statements in sqlalchemy

2015-06-01 Thread Ranjith Ramachandra
I have also asked the question at http://stackoverflow.com/questions/30575111/how-to-create-a-new-table-from-select-statement-in-sqlalchemy On Monday, 1 June 2015 19:09:13 UTC+5:30, Ranjith Ramachandra wrote: I am using sqlalchemy's core features do write some abstraction layer. The layer

[sqlalchemy] query not working properly with innodb

2012-09-14 Thread Ranjith Ramachandra
I am using sqlalchemy as ORM I have a class like this: class Token(Base): __tablename__ = 'token_table' id = Column(Integer, primary_key=True, autoincrement=True) token = Column(Unicode(300), unique=True) last_accessed = Column(DateTime,