Frequently Asked Questions
- How do I configure logging?
- How do I pass custom connect arguments to my database API?
- “Commands out of sync; you can’t run this command now” / “This result object does not return rows. It has been closed automatically”
- Why does SQLAlchemy issue so many ROLLBACKs?
- How do I get at the raw DBAPI connection when using an Engine?
- MetaData / Schema
- Performance
- I’m re-loading data with my Session but it isn’t seeing changes that I committed elsewhere
- My Query does not return the same number of objects as query.count() tells me - why?
- I’m using
joinedload()
orlazy=False
to create a JOIN/OUTER JOIN and SQLAlchemy is not constructing the correct query when I try to add a WHERE, ORDER BY, LIMIT, etc. (which relies upon the (OUTER) JOIN) - How Do I use Textual SQL with ORM Queries?
- why isn’t my
__init__()
called when I load objects? - I set the “foo_id” attribute on my instance to “7”, but the “foo” attribute is still
None
- shouldn’t it have loaded Foo with id #7? - Is there a way to automagically have only unique keywords (or other kinds of objects) without doing a query for the keyword and getting a reference to the row containing that keyword?
- Third Party Integration Issues