[sqlalchemy] Re: sqlalchemy foreignkey relation with inheritance

2017-09-22 Thread John Smith
Whoa! Fantastic! Thank you very much!!! -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. ---

Re: [sqlalchemy] ResourceClosedError with mysql-connector-python and sqlalchemy.

2017-09-22 Thread Mike Bayer
On Thu, Sep 21, 2017 at 3:46 PM, Ergo wrote: > Thanks, we had errors with: > > "InternalError: (mysql.connector.errors.InternalError) Unread result found" > and "ResourceClosedError: This result object does not return rows. It has > been closed automatically." exceptions. > > I

Re: [sqlalchemy] Re: ResourceClosedError with mysql-connector-python and sqlalchemy.

2017-09-22 Thread Mike Bayer
plus two of Simon's got thrown into the queue also for some crazy reason. Google is angry today.unfortunately they don't tell me about messages in the queue until a few days later. On Fri, Sep 22, 2017 at 7:48 AM, Ergo wrote: > There was one more reply in this thread,

Re: [sqlalchemy] sqlalchemy foreignkey relation with inheritance

2017-09-22 Thread Simon King
On Fri, Sep 22, 2017 at 9:42 AM, Simon King wrote: > On Fri, Sep 22, 2017 at 8:18 AM, John Smith wrote: >> I have the following database schema: >> >> Table "Parent": >> 1. id - primary key identifier. >> 2. type - polymorphic_identity. >> 3.

Re: [sqlalchemy] sqlalchemy foreignkey relation with inheritance

2017-09-22 Thread Simon King
On Fri, Sep 22, 2017 at 8:18 AM, John Smith wrote: > I have the following database schema: > > Table "Parent": > 1. id - primary key identifier. > 2. type - polymorphic_identity. > 3. name - string data column. > > Table "Child" - inherits Parent: > 1. id - primary key

[sqlalchemy] Re: ResourceClosedError with mysql-connector-python and sqlalchemy.

2017-09-22 Thread Ergo
There was one more reply in this thread, seems it was moderated and removed. Can someone explain what happened? -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable

[sqlalchemy] Re: sqlalchemy foreignkey relation with inheritance

2017-09-22 Thread John Smith
Btw, I'm libraries versions are SQLAlchemy==1.1.14 psycopg2==2.7.1 -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve

[sqlalchemy] sqlalchemy foreignkey relation with inheritance

2017-09-22 Thread John Smith
I have the following database schema: *Table "Parent"*: 1. id - primary key identifier. 2. type - polymorphic_identity. 3. name - string data column. *Table "Child"* - inherits Parent: 1. id - primary key identifier. 2. parent_id - foreignkey to Parent. 3. category - string data column.