xonstat/models.py

   1 import transaction
   2
   3 from sqlalchemy import Column
   4 from sqlalchemy import Integer
   5 from sqlalchemy import Unicode
   6
   7 from sqlalchemy.exc import IntegrityError
   8 from sqlalchemy.ext.declarative import declarative_base
   9
  10 from sqlalchemy.orm import scoped_session
  11 from sqlalchemy.orm import sessionmaker
  12
  13 from zope.sqlalchemy import ZopeTransactionExtension
  14
  15 DBSession = scoped_session(sessionmaker(extension=ZopeTransactionExtension()))
  16 Base = declarative_base()
  17
  18 def initialize_sql(engine):
  19     DBSession.configure(bind=engine)
  20     Base.metadata.bind = engine
  21     Base.metadata.create_all(engine)