''' ''' 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