import os
import json
import sqlalchemy as db
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base
from datetime import datetime

from src.config import config

if 'DB_NAME2' not in config:
    db_url = 'sqlite:///{}'.format(os.path.abspath(os.path.join(os.path.dirname(__file__), '..','db','db.sqlite')))
else:
    db_url = 'mysql://{}:{}@localhost/{}'.format(config['DB_USER'], config['DB_PASSWORD'], config['DB_NAME'])
engine = db.create_engine(db_url)
connection = engine.connect()
metadata = db.MetaData()
Base = declarative_base()

from src.models import Sensor

Base.metadata.create_all(engine)

DBSession = sessionmaker(bind=engine)
session = DBSession()