blob: fab324daddf79654435fcf32834e9725560e64d4 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
|
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'))
print(connection_url)
engine = create_engine(connection_url, encoding="utf-8", pool_recycle=3600)
Session = sessionmaker(bind=engine)
Base = declarative_base()
Base.metadata.bind = engine
db = SQLAlchemy()
from app.sql.models.tile import Tile
from app.sql.models.page import Page
from app.sql.models.graph import Graph
from app.sql.models.upload import Upload
|
