From 3cf70771cb45cc16ec33ffe44e7a1a4799d8f395 Mon Sep 17 00:00:00 2001 From: Jules Laplace Date: Tue, 23 Jun 2020 23:18:07 +0200 Subject: adding web app base --- animism-align/cli/app/sql/common.py | 35 +++++++++++++++++++++++++++++++++++ 1 file changed, 35 insertions(+) create mode 100644 animism-align/cli/app/sql/common.py (limited to 'animism-align/cli/app/sql/common.py') diff --git a/animism-align/cli/app/sql/common.py b/animism-align/cli/app/sql/common.py new file mode 100644 index 0000000..6f3586b --- /dev/null +++ b/animism-align/cli/app/sql/common.py @@ -0,0 +1,35 @@ +import os +import glob +import time + +# import mysql.connector +from sqlalchemy import create_engine +from sqlalchemy.orm import sessionmaker +from sqlalchemy.ext.declarative import declarative_base + +from flask_sqlalchemy import SQLAlchemy + +from app.settings import app_cfg + +# connection_url = "mysql+mysqlconnector://{}:{}@{}/{}?charset=utf8mb4".format( +# os.getenv("DB_USER"), +# os.getenv("DB_PASS"), +# os.getenv("DB_HOST"), +# os.getenv("DB_NAME") +# ) + +os.makedirs(app_cfg.DIR_DATABASE, exist_ok=True) + +connection_url = "sqlite:///{}".format(os.path.join(app_cfg.DIR_DATABASE, 'animism.sqlite3')) + +engine = create_engine(connection_url, encoding="utf-8", pool_recycle=3600) + +Session = sessionmaker(bind=engine) +Base = declarative_base() +Base.metadata.bind = engine + +db = SQLAlchemy() + +# include the models in reverse dependency order, so relationships work +from app.sql.models.timestamp import Timestamp +from app.sql.models.upload import Upload -- cgit v1.2.3-70-g09d2