Re: [sqlalchemy] Problem build a query using just core

2014-09-16 Thread Mike Bernson
That worked Thanks On 09/16/2014 12:04 PM, Michael Bayer wrote: from sqlalchemy import * import datetime db = create_engine('sqlite:///test.db') metadata = MetaData(db) trs_transaction = Table( "trs_transaction", metadata, Column('transaction_id', Integer(), primary_key=True, autoinc

Re: [sqlalchemy] Problem build a query using just core

2014-09-16 Thread Michael Bayer
from sqlalchemy import * import datetime db = create_engine('sqlite:///test.db') metadata = MetaData(db) trs_transaction = Table( "trs_transaction", metadata, Column('transaction_id', Integer(), primary_key=True, autoincrement=True), Column('account', BigInteger(), index=True, nullabl

Re: [sqlalchemy] Problem build a query using just core

2014-09-15 Thread Mike Bernson
Here is simple table def from sqlalchemy import * db = create_engine('sqlite:///test.db') metadata = MetaData(db) trs_transaction = Table("trs_transaction", metadata, Column('transaction_id', Integer(), primary_key=True, autoincrement=True), Column('account', BigInteger(), index=True, n

Re: [sqlalchemy] Problem build a query using just core

2014-09-15 Thread Michael Bayer
if you want to send (simplified, succinct) table defs i can show you how to get that in core. On Sep 15, 2014, at 6:39 PM, Mike Bernson wrote: > Given the table below I am trying to get the where statement built > using just core. I have tried a number of thing and am not able to > get the que

[sqlalchemy] Problem build a query using just core

2014-09-15 Thread Mike Bernson
Given the table below I am trying to get the where statement built using just core. I have tried a number of thing and am not able to get the query built. I can get the query close but not correct. I must be missing something simple. The database is Mysql and SQLAchemy is 9.7 The query does wor