Re: [sqlalchemy] contains_eager option on polymorphic joined query

2019-03-09 Thread jay . chia
Ah my bad! I really didn't do good testing. Your reply prompted me to find the root of the problem and solution though. Posting it here just in case this is useful to anyone else! A gist of the problem I actually had was that I has a column_property in Common defined in terms of the

Re: [sqlalchemy] Security Implications of Directly Executing Queries Compiled to Strings

2019-03-09 Thread Walter Askew
> On Mar 8, 2019, at 9:06 PM, Mike Bayer wrote: > > Datatypes like Integer() when rendering the literal value pass the > incoming input directly to str() which goes straight to the database... Thank you so much for the explanation! This is very helpful. -- SQLAlchemy - The Python SQL

Re: [sqlalchemy] MySQL Connector

2019-03-09 Thread Mike Bayer
Note the mysql-connector people actually contacted us this week on the devel list, and while mysql-connector-python does still have a lot of major issues they are not as bad as the ones I listed on the site, as apparently there is a totally different fork of it called mysql-connector also on pypi

[sqlalchemy] Referencing the value of a table linked by a foreign Key

2019-03-09 Thread C
Hello every one, I am new on Python/SqlAlchemy and I try to develop an app but I can't find how to display the name of people and not their foreignkey when I reference them, could you help me ? Here are my classes : from application.main import db class Lettre(db.Model):