def initdb(): """Init/reset database.""" try: db.drop_all() except sqlalchemy.exc.OperationalError: URI = app.config['SQLALCHEMY_DATABASE_URI'][:app.config['SQLALCHEMY_DATABASE_URI'].rfind('/')] engine = sqlalchemy.create_engine(URI) engine.execute("CREATE DATABASE fbone") db.create_all() admin = User( name=u'admin', fullname=u'Agador Spartacus', email=u'*****@*****.**', password=u'123456', role_code=ADMIN, status_code=ACTIVE, gender_code=MALE, bio=u'FSU Grad. Go Noles!') db.session.add(admin) db.session.commit()
def initdb(): """Init/reset database.""" try: db.drop_all() except sqlalchemy.exc.OperationalError: URI = app.config[ 'SQLALCHEMY_DATABASE_URI'][:app.config['SQLALCHEMY_DATABASE_URI']. rfind('/')] engine = sqlalchemy.create_engine(URI) engine.execute("CREATE DATABASE fbone") db.create_all() admin = User(name=u'admin', fullname=u'Agador Spartacus', email=u'*****@*****.**', password=u'123456', role_code=ADMIN, status_code=ACTIVE, gender_code=MALE, bio=u'FSU Grad. Go Noles!') db.session.add(admin) db.session.commit()
def teardown(): _db.drop_all() os.unlink(os.path.join(INSTANCE_FOLDER_PATH, 'test.sqlite'))