Python runSQLScript示例

示例#1

文件： common.py 项目： danielc518/dbsys

def checkQuery(testcase, name):
 # Run the query
 script = name + '.todo.sql'
 actual = runSQLScript(dbName, script)
 # Compare to correct 
 csv = os.path.join(correctDir, name + '.csv')
 with open(csv, 'r') as f:
   expected =f.read().strip()
   testcase.assertEqual(actual, expected, 'Query "%s" produced incorrect output' % name)

示例#2

def checkQuery(testcase, name):
    # Run the query
    script = name + '.todo.sql'
    actual = runSQLScript(dbName, script)
    # Compare to correct
    csv = os.path.join(correctDir, name + '.csv')
    with open(csv, 'r') as f:
        expected = f.read().strip()
        testcase.assertEqual(actual, expected,
                             'Query "%s" produced incorrect output' % name)

示例#3

def setupDb():
    runCommand('rm -f %s' % dbName)
    runSQLScript(dbName, 'schema.sql')
    runSQLScript(dbName, 'import.sql')

示例#4

文件： common.py 项目： danielc518/dbsys

def setupDb():
  runCommand('rm -f %s' % dbName)
  runSQLScript(dbName, 'schema.sql')
  runSQLScript(dbName, 'import.sql')