from sqlalchemy import create_engine

from sqlalchemy.orm import scoped_session, sessionmaker

from sqlalchemy.ext.declarative import declarative_base

from flask_sqlalchemy import SQLAlchemy

import os

from config import basedir,SQLALCHEMY_DATABASE_URI

from datetime import datetime

db = SQLAlchemy()

engine = create_engine(SQLALCHEMY_DATABASE_URI, echo=True)

db_session = scoped_session(sessionmaker(autocommit=False,

autoflush=False,

bind=engine))

Base = declarative_base()

Base.query = db_session.query_property()

class Scan(Base):

db.DateTime, nullable=False)

sqlfilename = basedir + '/database.db'

if not os.path.exists(sqlfilename):

Base.metadata.create_all(bind=engine)