'''
'''
pass
if __name__ == "__main__":
import sessionManager
myconstr='oracle://devdb10/cms_xiezhen_dev'
authpath='/afs/cern.ch/user/x/xiezhen'
#myconstr='sqlite_file:test.db'
svc=sessionManager.sessionManager(myconstr,authpath=authpath,debugON=False)
session=svc.openSession(isReadOnly=False,cpp2sqltype=[('unsigned int','NUMBER(10)'),('unsigned long long','NUMBER(20)')])
schema=session.nominalSchema()
session.transaction().start(False)
tables=createTables(schema)
if len(tables)==0:
dropTables(schema,nameDealer.schemaV2Tables())
else:
dropTables(schema,tables)
dropTables(schema,nameDealer.commonTables())
#createUniqueConstraints(schema)
#session.transaction().commit()
#print 'droped new '
session.transaction().start(False)
tables=createOldSchema(schema)
oldToNew(schema)
print('created old ',tables)
session.transaction().commit()
del session
def dropLumi(dbsession):
print 'droping lumi db2 schema...'
dbsession.transaction().start(False)
schema=dbsession.nominalSchema()
lumidbDDL.dropTables(schema,nameDealer.schemaV2Tables())
dbsession.transaction().commit()
from . import sessionManager
myconstr = 'oracle://devdb10/cms_xiezhen_dev'
authpath = '/afs/cern.ch/user/x/xiezhen'
#myconstr='sqlite_file:test.db'
svc = sessionManager.sessionManager(myconstr,
authpath=authpath,
debugON=False)
session = svc.openSession(isReadOnly=False,
cpp2sqltype=[('unsigned int', 'NUMBER(10)'),
('unsigned long long', 'NUMBER(20)')
])
schema = session.nominalSchema()
session.transaction().start(False)
tables = createTables(schema)
if len(tables) == 0:
dropTables(schema, nameDealer.schemaV2Tables())
else:
dropTables(schema, tables)
dropTables(schema, nameDealer.commonTables())
#createUniqueConstraints(schema)
#session.transaction().commit()
#print 'droped new '
session.transaction().start(False)
tables = createOldSchema(schema)
oldToNew(schema)
print('created old ', tables)
session.transaction().commit()
del session
