Re: [sqlalchemy] SQLAlchemy: backref and object loaded from DB not working?

2017-08-17 Thread Mike Bayer
On Thu, Aug 17, 2017 at 3:57 PM, cecemel wrote: > Is the backref relationship supposed to work with objects loaded from the > DB? > > > Here is the case: > > Similar to the (doc/tutorial) I have the following classes: > > from sqlalchemy import Integer, ForeignKey,

[sqlalchemy] SQLAlchemy: backref and object loaded from DB not working?

2017-08-17 Thread cecemel
Is the backref relationship supposed to work with objects loaded from the DB? Here is the case: Similar to the (doc/tutorial ) I have the following classes: from sqlalchemy import Integer, ForeignKey, String,

Re: [sqlalchemy] Ingres with SQLAlchemy

2017-08-17 Thread Mike Bayer
On Thu, Aug 17, 2017 at 8:03 AM, wrote: > Does anyone know how to connect to an Ingres DB using SQLAlchemy? I am able > to use pyodbc to connect in Python. As Ingres is not supported does this > mean I can't easily connect to it from SQLAlchemy? that is what that means,

Re: [sqlalchemy] Raising on usage of attribute in SQL queries

2017-08-17 Thread Mike Bayer
On Wed, Aug 16, 2017 at 7:35 PM, Neena Parikh wrote: > Hi there! > > I'm looking to create a helper or decorator function that will enable us to > "mark" a column or table as “unused”, and raise an error if that column or > table is queried for in SQL. There's a lot of ways

Re: [sqlalchemy] SelectIn loader joining on parent table

2017-08-17 Thread Aidan Kane
Thanks for all the info Mike. I sort of figured that was the case as I started writing out my question — apologies for bothering you with it anyway! Awesome release, by the way. Loving all the new features. Thanks, as ever, for all your hard work. On Thursday, 17 August 2017 00:09:40 UTC+1,

[sqlalchemy] Ingres with SQLAlchemy

2017-08-17 Thread jimsmith13386
Does anyone know how to connect to an Ingres DB using SQLAlchemy? I am able to use pyodbc to connect in Python. As Ingres is not supported does this mean I can't easily connect to it from SQLAlchemy? -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper

Re: [sqlalchemy] Raising on usage of attribute in SQL queries

2017-08-17 Thread Simon King
On Thu, Aug 17, 2017 at 12:35 AM, Neena Parikh wrote: > Hi there! > > I'm looking to create a helper or decorator function that will enable us to > "mark" a column or table as “unused”, and raise an error if that column or > table is queried for in SQL. > > > Context > The