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()