from sqlalchemy.orm import Session from sqlalchemy import create_engine engine = create_engine('sqlite:///example.db') session = Session(bind=engine) # Execute a SELECT statement result_proxy = session.execute("SELECT * FROM users") results = result_proxy.fetchall() print(results) # Execute an UPDATE statement session.execute("UPDATE users SET active=1 WHERE id=1") session.commit()
from sqlalchemy.orm import Session from sqlalchemy import create_engine engine = create_engine('sqlite:///example.db') session = Session(bind=engine) # Execute a parameterized INSERT statement stmt = "INSERT INTO users (name, email) VALUES (:name, :email)" values = {'name': 'John Doe', 'email': '[email protected]'} session.execute(stmt, values) session.commit()The `execute()` method is part of SQLAlchemy's Core package.