SELECT default_schema_name FROM
sys.database_principals
WHERE name = ?
AND type = 'S'
On Mon, Aug 18, 2014 at 9:47 AM, Horcle <g...@umn.edu> wrote:
> 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> 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 a topic in the
> Google Groups "sqlalchemy" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/sqlalchemy/YSjU_Ohsyvw/unsubscribe.
> To unsubscribe from this group and all its topics, 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.
>
--
Greg M. Silverman
Senior Developer Analyst
Cardiovascular Informatics <http://www.med.umn.edu/cardiology/>
University of Minnesota
612-626-0919
g...@umn.edu
› flora-script <http://flora-script.grenzi.org/> ‹
› grenzi.org ‹
--
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.
