Python SELECT Exemples

Exemple #1

Fichier : test_select.py Projet : 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)

Exemple #2

Fichier : test_select.py Projet : 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)

Exemple #3

Fichier : test_select.py Projet : tli2/peloton-test

 def test_select_all(self):
     SQL = SELECT.create_sql_select_all()
     pgfile = dbop.sql_exe_pg_tofile('../peloton_test.conf', SQL, 'select_all.out')
     ptfile = dbop.sql_exe_pt_tofile('../peloton_test.conf', SQL, 'select_all.out')
     res = fileop.compare_results(pgfile, ptfile)
     self.assertTrue(res)

Exemple #4

Fichier : test_select.py Projet : cmu-db/peloton-test

def test_select_all():
    SQL = SELECT.create_sql_select_all()
    pgfile = dbop.sql_exe_pg_tofile('../peloton_test.conf', SQL, 'select_all.out')
    ptfile = dbop.sql_exe_pt_tofile('../peloton_test.conf', SQL, 'select_all.out')
    res = fileop.compare_results(pgfile, ptfile)
    assert(res == True)