[sqlalchemy] Failing to connect to MongoDB BIconnector - a restricted MySQL implementation

2017-05-12 Thread Jonathan Underwood
Hi, I am trying to do use SQLAlchemy with the MongoDB BI connector, which presents itself as a MySQL server. However, the supported operations correspond only to the SQL-99 SELECT operations (i.e. it's a read only server) . See:

Re: [sqlalchemy] Recursive CTE failing with (pysqlite2.dbapi2.OperationalError) no such table

2016-07-13 Thread Jonathan Underwood
On Wednesday, July 13, 2016 at 4:25:24 PM UTC+1, Jonathan Vanasco wrote: > > > > On Wednesday, July 13, 2016 at 11:01:08 AM UTC-4, Jonathan Underwood wrote: > > Thanks - you're right. That's weird though, as it contradicts the >> documentation. Anyway, I've found

Re: [sqlalchemy] Recursive CTE failing with (pysqlite2.dbapi2.OperationalError) no such table

2016-07-13 Thread Jonathan Underwood
On Wednesday, July 13, 2016 at 4:01:08 PM UTC+1, Jonathan Underwood wrote: > > > > On Wednesday, July 13, 2016 at 2:35:06 PM UTC+1, Антонио Антуан wrote: >> >> `cteq_alias.union_all(...` >> >> Also, you do not need to create cteq_alias, you can use cteq,

Re: [sqlalchemy] Recursive CTE failing with (pysqlite2.dbapi2.OperationalError) no such table

2016-07-13 Thread Jonathan Underwood
arent_id == cteq.c.id) ) objs = session.query(Obj).select_from(r).all() seems to do the job. I've actually ran the example given in the docs (Query API section), and that fails in the same way I reported in my original mail too. Cheers, Jonathan > ср, 13 июл. 2016 г. в 15:20, Jona

[sqlalchemy] Recursive CTE failing with (pysqlite2.dbapi2.OperationalError) no such table

2016-07-13 Thread Jonathan Underwood
Hi, I am struggling to get a simple recursive CTE query to work with sqlalchemy 1.0.14, sqlite backend (3.8.10.2) and pysqlite 2.8.2, python 2.7.12. Below is a reproducer: from sqlalchemy.ext.declarative import declarative_base from sqlalchemy import Column, String from sqlalchemy import orm

Re: [sqlalchemy] Make the default _declarative_constructor work in mutliple inheritance situations

2016-07-02 Thread Jonathan Underwood
On 2 July 2016 at 14:54, Mike Bayer <mike...@zzzcomputing.com> wrote: > > > On 07/02/2016 07:46 AM, Jonathan Underwood wrote: >> >> Hi, >> >> As documented, the default constructor for objects that inherit from >> Base doesn't work in multiple i

[sqlalchemy] Make the default _declarative_constructor work in mutliple inheritance situations

2016-07-02 Thread Jonathan Underwood
Hi, As documented, the default constructor for objects that inherit from Base doesn't work in multiple inheritance situations (unless Base is last in the list of classes, I suppose). It wouldn't be too difficult to change this without breaking existing expectations, I believe. Something like