Top "Sqlalchemy" questions

SQLAlchemy is a Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL.

SQLAlchemy boolean value is None

I have this table in my Pyramid app class User(Base): __tablename__ = 'users' id = Column(Integer, primary_key=True) ..... is_…

python sqlalchemy pyramid
Applying LIMIT and OFFSET to all queries in SQLAlchemy

I'm designing an API with SQLAlchemy (querying MySQL) and I would like to force all my queries to have page_…

python sqlalchemy api-design
SQLAlchemy support of Postgres Schemas

We host a multitenant app with SQLAlchemy and postgres. I am looking at moving from having separate databases for each …

postgresql sqlalchemy
SQLAlchemy and going through a large result set

I need to read data from all of the rows of a large table, but I don't want to pull …

pagination sqlalchemy
How to build a flask application around an already existing database?

I already have an existing Database that has a lot of tables and a lot of data in MySQL. I …

python mysql sqlalchemy flask flask-sqlalchemy
Could not assemble any primary key columns for mapped table

When I'm trying to create a database schema migration, I'm getting this weird error. Can you please help me to …

python sqlalchemy flask-sqlalchemy flask-migrate
sqlalchemy foreign key relationship attributes

I have a User table and a Friend table. The Friend table holds two foreign keys both to my User …

python sqlalchemy flask-sqlalchemy
SQLAlchemy: a better way for update with declarative?

I am a SQLAlchemy noob. Let's say I have an user table in declarative mode: class User(Base): __tablename__ = 'user' …

python sqlalchemy declarative
SQLAlchemy, get object not bound to a Session

I am trying to get an collection of objects out of a database and pass it to another process that …

python sqlalchemy
Strange SQLAlchemy error message: TypeError: 'dict' object does not support indexing

I am using hand crafted SQL to fetch data from a PG database, using SqlAlchemy. I am trying a query …

python postgresql sqlalchemy