def initializeDB(self, metadata, engine): taskInfos = TaskInfo.dbDesign(metadata) inputFiles = InputFile.dbDesign(metadata) outputFiles = OutputFile.dbDesign(metadata) arguments = Argument.dbDesign(metadata) gridTasks = GridTask.dbDesign(metadata) hosts = Host.dbDesign(metadata) taskGroups = TaskGroup.dbDesign(metadata) metadata.create_all(engine)
engine = create_engine('mysql://'+base.dbUser+':'+base.dbPassword+'@localhost', echo=False)
try:
engine.execute("CREATE DATABASE DistributedController") #create db
except:
print ("database already exists")
engine.execute("USE DistributedController") # select new db
mySessionClass = sessionmaker(bind=engine)
mySession = mySessionClass()
metadata = MetaData()
taskInfos = TaskInfo.dbDesign(metadata)
inputFiles = InputFile.dbDesign(metadata)
outputFiles = OutputFile.dbDesign(metadata)
arguments = Argument.dbDesign(metadata)
gridTasks = GridTask.dbDesign(metadata)
taskGroups = TaskGroup.dbDesign(metadata)
metadata.create_all(engine)
#create task group
