
#5: SQLAlchemy and data access in Python
Talk Python To Me
00:00
How to Use Python to Combine Security and SQL Queries
I really like the fluent API that you put together there where you basically you start the query and whatever you do to it what comes out of the query. I took this thing right from from Ian Bicking's SQL object which was that you overload python operators like the double equals operator or the greater than operator so that when you have these little objects that refer to columns and values in a database you can compare them with the python comparison operators and they kind of auto magically create another object like a comparison. If you want to get some quick results for a program you're writing you might want to start with the ORM first and then and then do a deeper dive later. There's just two ways
Play episode from 16:29
Transcript


