begin restructuring

[sql.git] / lib / python / mitsql / db.py

from elixir import Entity, Field, String, Text, Integer, DateTime, options, metadata, setup_all, session
from sqlalchemy import create_engine, func
options.options_defaults['shortnames'] = True

class Backup(Entity):
    db = Field(String(256), primary_key=True)
    skip_reason = Field(String(256), nullable=True)
    skip_date = Field(DateTime(), nullable=True)
    dump_path = Field(String(512), nullable=True)
    dump_errnum = Field(Integer(4), nullable=True)
    dump_errstr = Field(Text(), nullable=True)
    dump_date = Field(DateTime(), nullable=True)

metadata.bind = create_engine('mysql://sql.mit.edu/mitsql?read_default_group=mysql', pool_recycle=True)

if __name__ == '__main__':
    setup_all(True)
else:
    setup_all()
session.flush()