initial site copied in

1 files changed, 33 insertions, 0 deletions

diff --git a/cli/app/sql/common.py b/cli/app/sql/common.py
new file mode 100644
index 0000000..cf819e1
--- /dev/null
+++ b/cli/app/sql/common.py
@@ -0,0 +1,33 @@
+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, 'swimmer.sqlite3'))
+
+engine = create_engine(connection_url, encoding="utf-8", pool_recycle=3600)
+
+Session = sessionmaker(bind=engine)
+Base = declarative_base()
+
+db = SQLAlchemy()
+
+from app.sql.models.collection import Collection
+from app.sql.models.upload import Upload