Sqlalchemy declarative example.

sqlalchemy.py

# coding=utf-8

from sqlalchemy import Column, String, Integer, create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker, scoped_session

engine = create_engine('mysql://root@localhost/test')
Base = declarative_base()


class SomeClass(Base):
    __tablename__ = 'test'
    id = Column(Integer, primary_key=True)
    name =  Column(String(50))

session_factory = sessionmaker(bind=engine)
Session = scoped_session(session_factory)
session = Session()

record = session.query(SomeClass).filter(SomeClass.id == 4).first()
print record

session.delete(record)
session.flush()

has_record = session.query(SomeClass).filter(SomeClass.id == 4).first()

print has_record