On Friday, August 15, 2014 8:28:41 PM UTC-5, Michael Bayer wrote: > > > On Aug 15, 2014, at 5:03 PM, Greg Silverman <g...@umn.edu <javascript:>> > wrote: > > > Then, I thought, what if this is an SQLAlchemy issue. Looks to be. I ran > the following script as a test: > > import pyodbc > import sqlalchemy > from sqlalchemy.engine import reflection > from sqlalchemy.engine.reflection import Inspector > > def connect(): > return pyodbc.connect( > 'DRIVER={FreeTDS};SERVER=<ip_address>;' > 'DATABASE=<db_name>;UID=test;PWD=test;port=1433;' > 'TDS_Version=9.1;') > engine = sqlalchemy.create_engine('mssql://', creator=connect) > conn = engine.connect() > print conn > > for row in engine.execute('select 6 * 7 as [Result];'): > print row.Result > > insp = reflection.Inspector.from_engine(engine) > table_name = 'irb_desc' > table_names = insp.get_table_names() > if table_name not in table_names: > print 'A' > > Again, I am connecting fine with the database create.engine method (that > is '42' is printing as expected), but when I run the > inspector.get_table_names method with the given conditional it is printing > the 'A' (I have tried other table names in the same database to which I > added 'irbd_balance,' all with the same result. > > > > what is the SQL output if you set echo=‘debug’; then, take the SQL you > see and take a look at what it’s SELECTing so you can see what might be > wrong. Probably some schema name setting or something like that. >
Thanks, I did not realize this was an option (actually, it is echo=True, but at least I can see the SQL being sent). Hopefully this will lead me to an answer. Greg-- -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.