import sqlalchemy as sa
 
import atma.model as model
 
select = model.select
join = model.join
outerjoin = model.outerjoin
 
import classes.config as config
 
engine = sa.create_engine(config.connectionURI)
metadata = sa.BoundMetaData(engine)
 
sa.Table('user', metadata,
    sa.Column('id', sa.Integer, primary_key=True),
    sa.Column('name', sa.String(16), nullable=False, unique=True),
    sa.Column('rfc2617_realm', sa.String(120), nullable=False),     # authentication realm
    sa.Column('rfc2617_a1_md5', sa.String(40), nullable=False),     # authentication A1 variable (according to RFC2617)
    sa.Column('email', sa.String(60), nullable=False),
    sa.Column('email2', sa.String(60)),
    quote=True
)
 
##
 
_tmp = {}
for i in metadata.tables:
    _tmp[i] = metadata.tables[i]
locals().update(_tmp)
 
##
 
metadata.create_all()