A simple, flexible and testable active-record powered by SQLAlchemy.
pip install chemist
from chemist import (
Model, db, MetaData,
get_or_create_engine,
)
metadata = MetaData()
engine = get_or_create_engine('sqlite:///example.db')
class BlogPost(Model):
table = db.Table('blog_post',metadata,
db.Column('id', db.Integer, primary_key=True),
db.Column('title', db.Unicode(200), nullable=False),
db.Column('content', db.UnicodeText, nullable=False),
)
post1 = BlogPost.create(title='Hello World', content='\n'.join([
'Introduction...',
'Supporting Theory 1...',
'Supporting Theory 2...',
'Supporting Theory 3...',
'Conclusion',
]))
for post in BlogPost.all():
print(post.title, post.id)