Re: [sqlalchemy] Writing simple dialect for iSeries + pyodbc in order to use engine.execute for sql statements.

2014-06-11 Thread Jaimy Azle
Actually the ibm_db_sa support several methods to connect to iSeries; natively through ibm_db, pyodbc, or jdbc (with jython). On Jun 8, 2014 8:53 AM, Cory Lutton cory.lut...@gmail.com wrote: Thanks for such a quick reply. Great to hear that I am starting out on the right path with building a

Re: [sqlalchemy] another quick question regarding abstract classes

2014-06-11 Thread Richard Gerd Kuesters
thanks again Mike! i'll work this here :) my best regards, richard. On 06/10/2014 07:14 PM, Mike Bayer wrote: On Tue Jun 10 15:36:09 2014, Richard Gerd Kuesters wrote: so, here i am again with another weird question, but it may be interesting for what it may come (i dunno yet). the problem:

[sqlalchemy] Re: Sub-classing declarative classes

2014-06-11 Thread Jonathan Vanasco
On Tuesday, June 10, 2014 3:47:00 PM UTC-4, Noah Davis wrote: I suspect there's some way to tell the ORM to Do The Right Thing here, but I have no idea what it might be. I'd like the particular applications to be as unaware of the underlying table information as possible. I guess in

Re: [sqlalchemy] Sub-classing declarative classes

2014-06-11 Thread Simon King
On Tue, Jun 10, 2014 at 8:47 PM, Noah Davis neopygmal...@gmail.com wrote: Hi, I've been banging my head against this one for several days now, and aside from a three year-old post here, I've come up empty. I've got a python module that defines a set of Declarative models that several

[sqlalchemy] pandas - issue with SQL server and checking for table existence with user-defined default schema

2014-06-11 Thread Joris Van den Bossche
Hi, Since version 0.14 (released two weeks ago), pandas uses sqlalchemy in the SQL reading and writing functions to support different database flavors. A user reported an issue with SQL server: https://github.com/pydata/pandas/issues/7422 (and question on SO:

Re: [sqlalchemy] Writing simple dialect for iSeries + pyodbc in order to use engine.execute for sql statements.

2014-06-11 Thread Cory Lutton
Looks like I wasn't looking at it correctly then... What I did so far lets it pass through statements using execute() which is what I need for now but at least I know not to spend much more time on it. I just took another look at the ibm_db_sa and installed it but it seems to have Python 3

Re: [sqlalchemy] how to tell if a relationship was loaded or not ?

2014-06-11 Thread Mike Bayer
On 6/11/14, 2:17 PM, Jonathan Vanasco wrote: I can't find this in the API or by using `inspect` on an object. I'm trying to find out how to tell if a particular relationship was loaded or not. ie, I loaded Foo from the ORM, and want to see if foo.bar was loaded. I thought it might have

Re: [sqlalchemy] pandas - issue with SQL server and checking for table existence with user-defined default schema

2014-06-11 Thread Mike Bayer
On 6/11/14, 4:07 PM, Joris Van den Bossche wrote: Hi, Since version 0.14 (released two weeks ago), pandas uses sqlalchemy in the SQL reading and writing functions to support different database flavors. A user reported an issue with SQL server: https://github.com/pydata/pandas/issues/7422

Re: [sqlalchemy] Writing simple dialect for iSeries + pyodbc in order to use engine.execute for sql statements.

2014-06-11 Thread Jaimy Azle
The iSeries support of ibm_db_sa has not been tested on python3 when I write it. On Jun 12, 2014 4:04 AM, Cory Lutton cory.lut...@gmail.com wrote: Looks like I wasn't looking at it correctly then... What I did so far lets it pass through statements using execute() which is what I need for