sqlalchemy

You may access the internal __dict__ of a SQLAlchemy object, like the following: for u in session.query(User).all(): print u.__dict__

filter_by is used for simple queries on the column names using regular kwargs, like db.users.filter_by(name=”Joe”) The same can be accomplished with filter, not using kwargs, but instead using the ‘==’ equality operator, which has been overloaded on the db.users.name object: db.users.filter(db.users.name==’Joe’) You can also write more powerful queries using filter, such as expressions like: db.users.filter(or_(db.users.name==’Ryan’, … Read more

A Session object is basically an ongoing transaction of changes to a database (update, insert, delete). These operations aren’t persisted to the database until they are committed (if your program aborts for some reason in mid-session transaction, any uncommitted changes within are lost). The session object registers transaction operations with session.add(), but doesn’t yet communicate … Read more

Just as an FYI, you can also specify those things as column attributes. For instance, I might have done: .order_by(model.Entry.amount.desc()) This is handy since it avoids an import, and you can use it on other places such as in a relation definition, etc. For more information, you can refer this SQLAlchemy 1.4 Documentation