Python sql_exe_pt Examples

Example #1

File: test_select.py Project: tli2/peloton-test

 def test_select_where_withoutfile(self):
     SQL = SELECT.create_sql_select_where()
     pgres = dbop.sql_exe_pg('../peloton_test.conf', SQL)
     ptres = dbop.sql_exe_pt('../peloton_test.conf', SQL)
     selt.assertTrue(pgres)

Example #2

File: test_in.py Project: cmu-db/peloton-test

def test_in_noanyindex():
    SQL = IN.create_sql_in_noanyindex()
    pgfile = dbop.sql_exe_pg('../peloton_test.conf', SQL, 'in_noanyindex.out')
    ptfile = dbop.sql_exe_pt('../peloton_test.conf', SQL, 'in_noanyindex.out')
    res = fileop.compare_results(pgfile, ptfile)
    assert(res == True)

Example #3

File: test_select.py Project: cmu-db/peloton-test

def test_select_where_withoutfile():
    SQL = SELECT.create_sql_select_where()
    pgres = dbop.sql_exe_pg('../peloton_test.conf', SQL)
    ptres = dbop.sql_exe_pt('../peloton_test.conf', SQL)
    assert(pgres == ptres)

Example #4

def test_in_noanyindex():
    SQL = IN.create_sql_in_noanyindex()
    pgfile = dbop.sql_exe_pg('../peloton_test.conf', SQL, 'in_noanyindex.out')
    ptfile = dbop.sql_exe_pt('../peloton_test.conf', SQL, 'in_noanyindex.out')
    res = fileop.compare_results(pgfile, ptfile)
    assert(res == True)