-
Notifications
You must be signed in to change notification settings - Fork 0
/
app_settings.py
27 lines (21 loc) · 1.08 KB
/
app_settings.py
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
import os
import oedialect # noqa pylint: disable=unused-import
from configobj import ConfigObj
from sqlalchemy import create_engine
import sqlahelper
from wam import settings # pylint: disable=import-error
# add local config file
fred_config = ConfigObj(os.path.join(settings.BASE_DIR, 'WAM_APP_FRED', 'config', 'fred_app.cfg'))
OEP_ACCESS = fred_config['WAM_APP_FRED']['OEP_ACCESS']
LOCAL_TESTING = fred_config['WAM_APP_FRED'].as_bool('LOCAL_TESTING')
wam_config = settings.config['DATABASES'][OEP_ACCESS]
# ##########################################SQLAlchemy ENGINE#######################################
if not LOCAL_TESTING:
# db connection string for sqlalchemy-engine
if OEP_ACCESS == 'OEP':
DB_URL = '{ENGINE}://{USER}:{PASSWORD}@{HOST}:{PORT}/{NAME}'.format(**wam_config)
elif OEP_ACCESS == 'OEP_DIALECT':
DB_URL = '{ENGINE}://{USER}:{TOKEN}@{HOST}'.format(**wam_config)
engine = create_engine(DB_URL)
sqlahelper.add_engine(engine, 'oep_engine')
# ##################################################################################################