#!/usr/bin/env python
#-*- coding: utf-8 -*-
import sys
from collorg.controller.controller import Controller
if sys.version_info.major < 3:
input = raw_input
db = Controller().db
table = db.table
data_types = table('collorg.core.data_type')
for dt in data_types:
try:
table(dt.fqtn_.value)
except Exception as err:
print("{}: {}".format(dt.fqtn_, err))
ok = input('Remove entry from database [N/y] ? ')
if ok.upper() == 'Y':
dt._rev_field_.delete()
dt.delete()
db.raw_sql('drop table {}'.format(
db._fqtn_2_sql_fqtn(dt.fqtn_.value)))
#!/usr/bin/env python
#-*- coding: utf-8 -*-
from collorg.controller.controller import Controller
import sys
db = Controller().db
table = db.table
alter_table = """
alter table {} add column cog_from timestamp(0);
alter table {} add column cog_to timestamp(0);
"""
alter_inh = """
alter table {} inherit "collorg.time".duration;
"""
if __name__ == '__main__':
fqtn = sys.argv[1]
obj = table(fqtn)
if 'collorg.time.duration' in obj._cog_fqtn_inherits:
sys.stderr.write('Already inherited!')
sql_cmd = alter_table.format(obj.sql_fqtn, obj.sql_fqtn)
if len(sys.argv) > 2:
sql_cmd += alter_inh.format(obj.sql_fqtn)
db.raw_sql(sql_cmd)
db.commit()
