setting up the database...

1 files changed, 6 insertions, 2 deletions

diff --git a/cli/app/sql/common.py b/cli/app/sql/common.py
index cf819e1..fab324d 100644
--- a/cli/app/sql/common.py
+++ b/cli/app/sql/common.py
@@ -2,7 +2,7 @@ import os
 import glob
 import time
 
-import mysql.connector
+# import mysql.connector
 from sqlalchemy import create_engine
 from sqlalchemy.orm import sessionmaker
 from sqlalchemy.ext.declarative import declarative_base
@@ -21,13 +21,17 @@ from app.settings import app_cfg
 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.collection import Collection
+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