Let's say we want to query our Polls app for all Questions that have popular (more than 5 votes) choices that contain Python in the choice_text.

We could query our database as follows:

SELECT * FROM question JOIN (SELECT * FROM choice WHERE vote_count > 5 AND …

READ MORE

from sqlalchemy.sql import text from sqlalchemy import create_engine import secrets engine = create_engine( 'mssql+pyodbc://{}:{}@MSSQL'.format( secrets.username, secrets.password ) ) conn = engine.connect() s = text("SELECT * FROM users WHERE name = :name") result = conn.execute(s, name=name).fetchall() print result

For further information on installing and configuring unixODBC (requirement for pyodbc) …

READ MORE