def db_table_all(self):
    crt_task_info = 'CREATE TABLE IF NOT EXISTS task_info (\n                taskId INT, testTaskName TEXT, optType int,scriptId INT,scriptUrl TEXT,\n                startDate int, endDate int, exeBeginTime TEXT, exeEndTime TEXT,\n                exeType int, interval int, iterationNum int, startIterationNumber int\n                );'
    crt_scripts = 'CREATE TABLE IF NOT EXISTS scripts (\n                scriptId INT, scriptName TEXT, scriptType int,scriptUrl TEXT,\n                uploadDate int, scriptMaxRunTime int, scriptVersion int,\n                scriptCacheUrl TEXT\n                );'
    crt_apps = 'CREATE TABLE IF NOT EXISTS apps (\n                scriptId INT, appCheck int, appPackageName TEXT, appUrl TEXT, appMd5 TEXT,\n                appVersion TEXT, appVersionCode TEXT, appLastUpdateTime TEXT, appCacheUrl TEXT\n                );'
    run_tasks = 'CREATE TABLE IF NOT EXISTS run_tasks (\n                taskId INT, testTaskName TEXT, optType int,scriptId INT,scriptUrl TEXT,\n                startDate int, endDate int, exeBeginTime TEXT, exeEndTime TEXT,\n                exeType int, interval int, iterationNum int, startIterationNumber int\n                );'
    create_dic = []
    create_dic.append(crt_task_info)
    create_dic.append(crt_scripts)
    create_dic.append(crt_apps)
    create_dic.append(run_tasks)
    self.create_dic = create_dic
def db_table_all(self):
    crt_task_info = 'CREATE TABLE IF NOT EXISTS task_info (\n                taskId INT, testTaskName TEXT, optType int,scriptId INT,scriptUrl TEXT,\n                startDate int, endDate int, exeBeginTime TEXT, exeEndTime TEXT,\n                exeType int, interval int, iterationNum int, startIterationNumber int\n                );'
    crt_scripts = 'CREATE TABLE IF NOT EXISTS scripts (\n                scriptId INT, scriptName TEXT, scriptType int,scriptUrl TEXT,\n                uploadDate int, scriptMaxRunTime int, scriptVersion int,\n                scriptCacheUrl TEXT\n                );'
    crt_apps = 'CREATE TABLE IF NOT EXISTS apps (\n                scriptId INT, appCheck int, appPackageName TEXT, appUrl TEXT, appMd5 TEXT,\n                appVersion TEXT, appVersionCode TEXT, appLastUpdateTime TEXT, appCacheUrl TEXT\n                );'
    run_tasks = 'CREATE TABLE IF NOT EXISTS run_tasks (\n                taskId INT, testTaskName TEXT, optType int,scriptId INT,scriptUrl TEXT,\n                startDate int, endDate int, exeBeginTime TEXT, exeEndTime TEXT,\n                exeType int, interval int, iterationNum int, startIterationNumber int\n                );'
    create_dic = []
    create_dic.append(crt_task_info)
    create_dic.append(crt_scripts)
    create_dic.append(crt_apps)
    create_dic.append(run_tasks)
    self.create_dic = create_dic