def perform_tests(pg_version, es_version):
""" Run tests against a single version of PostgreSQL """
success = True
show_status(
"Testing PostgreSQL {pg_version} with Elasticsearch {es_version}...".
format(pg_version=pg_version, es_version=es_version))
show_status("Testing read...")
if not show_result(pg_version, es_version, "read",
run_sql_test("read.sql")):
success = False
show_status("Testing nested read...")
if not show_result(pg_version, es_version, "nested-read",
run_sql_test("nested-read.sql")):
success = False
show_status("Testing query...")
if not show_result(pg_version, es_version, "query",
run_sql_test("query.sql")):
success = False
show_status("Testing query with quals...")
if not show_result(pg_version, es_version, "query-quals",
run_sql_test("query-quals.sql")):
success = False
show_status("Testing query with arrays...")
if not show_result(pg_version, es_version, "query-array",
run_sql_test("query-array.sql")):
success = False
return success
def main():
args = args_handle()
settings.QUIET = args.quiet
settings.LOCAL_ONLY = args.local
settings.DUREE = 0 if args.sec < 0 else args.sec
settings.PORT_SCAN = not args.no_port
if args.fichier is False:
out_file = sys.stdout
elif args.fichier is None:
out_file = "lowl.out"
c = 0
while os.path.exists(out_file):
out_file = "lowl.{}.out".format(c)
c += 1
else:
out_file = args.fichier
try:
if args.importf:
tools.info("Importation : {}".format(args.importf))
pc = jsondata.import_json(args.importf)
elif args.single_p:
pc = process.single_proc()
else:
pc = process.multi_proc()
tools.show_result(pc, out_file)
if args.exportf is not False:
jsondata.export_json(pc, args.exportf)
except KeyboardInterrupt:
print("Fermeture utilisateur")
exit(1)
def perform_tests(version):
success = True
show_status('Testing PostgreSQL {version}...'.format(version=version))
show_status('Testing read...')
if not show_result(version, 'read', run_sql_test('read.sql')):
success = False
show_status('Testing query...')
if not show_result(version, 'query', run_sql_test('query.sql')):
success = False
return success
def perform_tests(pg_version, es_version):
""" Run tests against a single version of PostgreSQL """
success = True
show_status(
"Testing PostgreSQL {pg_version} with Elasticsearch {es_version}...".
format(pg_version=pg_version, es_version=es_version))
show_status("Testing read...")
if not show_result(pg_version, es_version, "read",
run_sql_test("read.sql")):
success = False
show_status("Testing nested read...")
if not show_result(pg_version, es_version, "nested-read",
run_sql_test("nested-read.sql")):
success = False
show_status("Testing sorted read...")
if not show_result(pg_version, es_version, "sorted-read",
run_sql_test("sorted-read.sql")):
success = False
show_status("Testing query...")
if not show_result(pg_version, es_version, "query",
run_sql_test("query.sql")):
success = False
show_status("Testing json query...")
data, error = run_sql_test("json-query.sql")
if not show_result(pg_version, es_version, "json-query",
(data == "Portal Chess", error)):
success = False
show_status("Testing insert returning id...")
data, error = run_sql_test("insert-return-id.sql")
if not show_result(pg_version, es_version, "insert returning id",
(data == "1", error)):
success = False
show_status("Testing insert returning row...")
data, error = run_sql_test("insert-return-row.sql")
if not show_result(
pg_version,
es_version,
"insert returning row",
(data
== "2 | Test insert returning title | test insert returning body",
error),
):
success = False
show_status("Testing insert waiting for refresh...")
data, error = run_sql_test("insert-wait_for.sql")
if not show_result(
pg_version,
es_version,
"insert waiting for refresh",
(data == "3 | Test insert wait for title | test insert wait for body",
error),
):
success = False
show_status("Testing delete returning row...")
data, error = run_sql_test("delete-return-row.sql")
if not show_result(
pg_version,
es_version,
"delete returning row",
(data == "39357158 | Momo Thomas", error),
):
success = False
return success
