SQLAlchemy engine SELECT aggregate
from sqlalchemy import create_engine
dbname = 'test.db'
engine = create_engine('sqlite:///' + dbname)
result = engine.execute('SELECT COUNT(*) FROM person')
r = result.fetchone()[0]
print(r)
result.close()
Press ← or → to navigate between chapters
Press S or / to search in the book
Press ? to show this help
Press Esc to hide this help
from sqlalchemy import create_engine
dbname = 'test.db'
engine = create_engine('sqlite:///' + dbname)
result = engine.execute('SELECT COUNT(*) FROM person')
r = result.fetchone()[0]
print(r)
result.close()