with testHelper.getOpenConnection(dbname=DATABASE_NAME) as conn:
conn.set_isolation_level(psycopg2.extensions.ISOLATION_LEVEL_AUTOCOMMIT)
testHelper.deleteAllPublicTables(conn)
[result, e] = testHelper.testloadratings(MyAssignment, RATINGS_TABLE, INPUT_FILE_PATH, conn, ACTUAL_ROWS_IN_INPUT_FILE)
if result :
print("loadratings function pass!")
[result, e] = testHelper.testrangepartition(MyAssignment, RATINGS_TABLE, 5, conn, 0, ACTUAL_ROWS_IN_INPUT_FILE)
if result :
print("rangepartition function pass!")
# ALERT:: Use only one at a time i.e. uncomment only one line at a time and run the script
[result, e] = testHelper.testrangeinsert(MyAssignment, RATINGS_TABLE, 100, 2, 3, conn, '2')
# [result, e] = testHelper.testrangeinsert(MyAssignment, RATINGS_TABLE, 100, 2, 0, conn, '0')
if result:
print("rangeinsert function pass!")
testHelper.deleteAllPublicTables(conn)
MyAssignment.loadRatings(RATINGS_TABLE, INPUT_FILE_PATH, conn)
[result, e] = testHelper.testroundrobinpartition(MyAssignment, RATINGS_TABLE, 5, conn, 0, ACTUAL_ROWS_IN_INPUT_FILE)
if result :
print("roundrobinpartition function pass!")
[result, e] = testHelper.testroundrobininsert(MyAssignment, RATINGS_TABLE, 100, 1, 3, conn, '0')
# [result, e] = testHelper.testroundrobininsert(MyAssignment, RATINGS_TABLE, 100, 1, 3, conn, '1')
# [result, e] = testHelper.testroundrobininsert(MyAssignment, RATINGS_TABLE, 100, 1, 3, conn, '2')
if result:
INPUT_FILE_PATH, conn,
ACTUAL_ROWS_IN_INPUT_FILE)
if result:
print("loadratings function pass!")
[result,
e] = testHelper.testrangepartition(MyAssignment, RATINGS_TABLE, 5,
conn, 0,
ACTUAL_ROWS_IN_INPUT_FILE)
if result:
print("rangepartition function pass!")
# ALERT:: Use only one at a time i.e. uncomment only one line at a time and run the script
#[result, e] = testHelper.testrangeinsert(MyAssignment, RATINGS_TABLE, 100, 2, 3, conn, '2')
[result,
e] = testHelper.testrangeinsert(MyAssignment, RATINGS_TABLE, 100,
2, 0, conn, '0')
if result:
print("rangeinsert function pass!")
testHelper.deleteAllPublicTables(conn)
MyAssignment.loadRatings(RATINGS_TABLE, INPUT_FILE_PATH, conn)
[result, e
] = testHelper.testroundrobinpartition(MyAssignment,
RATINGS_TABLE, 5, conn, 0,
ACTUAL_ROWS_IN_INPUT_FILE)
if result:
print("roundrobinpartition function pass!")
[result,
e] = testHelper.testroundrobininsert(MyAssignment, RATINGS_TABLE,
100, 1, 3, conn, '0')