def main(argv):
if len(argv) < 3:
print("Usage: parse_questions.py file_to_parse database")
sys.exit()
engine = create_engine('sqlite:///%s' % (argv[2], ), echo=True)
metadata.create_all(engine)
with open(argv[1]) as f, engine.connect() as conn:
reader = csv.DictReader(f, delimiter='|')
conn.execute(questions.insert(), list(reader))
def dbe():
url = str(conf.DATABASE_URL)
engine = create_engine(url)
assert not database_exists(
url), 'Test database already exists. Aborting tests.'
create_database(url)
engine.execute(schema.CreateSchema(
conf.TOKEN_SCHEMA_NAME)) # create schema
metadata.create_all(engine) # Create tables.
yield engine
drop_database(url)
async def startup():
# logging
log_level = Settings().log_level.name
logging.basicConfig(level=log_level)
_logger.setLevel(level=log_level)
# database
if features.enable_persistence:
await database.connect()
engine = sqlalchemy.create_engine(DatabaseSettings().postgres_dsn)
metadata.create_all(engine)
# controller
controller.get_available_engines()
_logger.info(
f"starting up with features:\nrate limits - {features.rate_limits}\n"
f"persistence - {features.enable_persistence}\ngql - {features.enable_gql}"
)
from sqlalchemy import Column, Integer, String, Float
from db import Base, metadata, engine
class Position(Base):
__tablename__ = "positions"
id = Column(Integer, primary_key=True, index=True)
name = Column(String, index=True)
sort_value = Column(Float)
metadata.create_all(bind=engine)
positions = Position.__table__
import sqlalchemy as sa
from db import metadata
import os
file_name = "../views/base.sqlite"
data = "sqlite:///" + file_name
if os.path.exists(file_name):
print('File is ready...')
else:
engine = sa.create_engine(data)
metadata.create_all(engine)
print('*** Data is created ***')
def setUp(self) -> None:
metadata.create_all(memory_engine)
self.session = sessionmaker(bind=memory_engine)()
self.acl = Acl(self.session)
def create_all(create_db):
engine = create_engine(create_db["DB_URI"] + "/" +
create_db["DATABASE_NAME"])
metadata.bind = engine
metadata.create_all()
def setUp(self) -> None:
metadata.create_all(memory_engine)
self.session = sessionmaker(bind=memory_engine)()
self.repository = model.Repository(self.session)
def recreate_db():
with app.app_context():
metadata.drop_all()
metadata.create_all()
from db import metadata
if __name__ == '__main__':
metadata.create_all()
import logging
from sqlalchemy import create_engine
from sqlalchemy.pool import NullPool
from configuration import config
from db import metadata
from tasks import archive, update
from scheduler import scheduler
engine = create_engine(config.DATABASE_URL, echo=True, poolclass=NullPool)
metadata.bind = engine
metadata.create_all()
if __name__ == '__main__':
logging.basicConfig(level=logging.DEBUG)
scheduler.add_job(archive, trigger='cron', **config.CRON_SETTINGS['ARCHIVE'])
scheduler.add_job(update, trigger='cron', **config.CRON_SETTINGS['UPDATE'])
try:
scheduler.start()
except (KeyboardInterrupt, SystemExit):
pass
def setUp(self):
metadata.create_all(engine)
self._conn = engine.connect()
def recreate_db():
with app.app_context():
metadata.drop_all()
metadata.create_all()
