initializedb.py
2.61 KB
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
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
import os
import sys
import transaction
from opensipkd.base import Base
from opensipkd.base.scripts.initializedb import alembic_run, restore_csv
from opensipkd.models import DBSession
from opensipkd.base.scripts.initializedb import create_schema
from pyramid.paster import (
get_appsettings,
setup_logging,
)
from sqlalchemy import engine_from_config
from .. import (
PjdlReklameNilaiStrategis, PjdlReklamePasang, PjdlReklameLokasi,
PjdlReklameStatus, PjdlReklameSudutPandang, PjdlReklameKelasJalan,
PjdlReklameNilaiKelasJalan, PjdlReklameCahaya)
def get_file(filename):
base_dir = os.path.split(__file__)[0]
fullpath = os.path.join(base_dir, 'data', filename)
return open(fullpath)
def usage(argv):
pass
def main(argv=sys.argv):
if len(argv) != 2:
usage(argv)
config_uri = argv[1]
setup_logging(config_uri)
settings = get_appsettings(config_uri)
bin_path = os.path.split(sys.executable)[0]
# pjdl_engine = engine_from_config(settings, 'sqlalchemy.')
# ModuleDBSession.configure(bind=pjdl_engine)
# ModuleBase.metadata.bind = pjdl_engine
# ModuleBase.metadata.create_all()
# init_model()
# reset_sequences()
engine = engine_from_config(settings, 'sqlalchemy.')
DBSession.configure(bind=engine)
Base.metadata.bind = engine
create_schema(engine, "pad")
Base.metadata.create_all(bind=engine)
# ModuleBase.metadata.create_all()
alembic_run(config_uri, 'alembic_pjdl')
print('>>Append Table')
# restore_csv(PjdlReklameStatus,
# 'rk_status.csv', get_file, DBSession)
# restore_csv(PjdlReklameKelasJalan,
# 'rk_kelas_jalan.csv', get_file, DBSession)
# restore_csv(PjdlReklameNilaiStrategis,
# 'nilai_strategis.csv', get_file, DBSession)
# restore_csv(PjdlReklameCahaya,
# 'rk_cahaya.csv', get_file, DBSession)
# restore_csv(PjdlReklamePasang,
# 'rk_pasang.csv', get_file, DBSession)
# restore_csv(PjdlReklameLokasi,
# 'rk_lokasi.csv', get_file, DBSession)
# restore_csv(PjdlReklameSudutPandang,
# 'rk_sp.csv', get_file, DBSession)
# restore_csv(PjdlReklameNilaiKelasJalan,
# 'rk_nilai_kj.csv', get_file, DBSession)
transaction.commit()
print('>>Appended')
print('****PJDL Models CREATED****')
def migrate(argv=sys.argv):
if len(argv) != 2:
usage(argv)
config_uri = argv[1]
setup_logging(config_uri)
alembic_run(config_uri, 'alembic_pjdl')
transaction.commit()
print('>>Migrated')
print('****PJDL Models Migrated****')
main(argv)