# [result, e] = testHelper.testrangeinsert(MyAssignment, RATINGS_TABLE, 100, 2, 3, conn, '2')
# [result, e] = testHelper.testrangeinsert(MyAssignment, RATINGS_TABLE, 100, 2, 4.5, conn, '4')
# [result, e] = testHelper.testrangeinsert(MyAssignment, RATINGS_TABLE, 100, 2, 4, conn, '3')
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:
print "roundrobininsert function pass!"
choice = raw_input('Press enter to Delete all tables? ')
if choice == '':
testHelper.deleteAllPublicTables(conn)
except Exception as detail:
traceback.print_exc()
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')
[result, e] = testHelper.testroundrobininsert(MyAssignment, RATINGS_TABLE, 100, 1, 3, conn, '3')
[result, e] = testHelper.testroundrobininsert(MyAssignment, RATINGS_TABLE, 100, 1, 3, conn, '4')
[result, e] = testHelper.testroundrobininsert(MyAssignment, RATINGS_TABLE, 200, 1, 3, conn, '0')
[result, e] = testHelper.testroundrobininsert(MyAssignment, RATINGS_TABLE, 100, 2, 3, conn, '1')
[result, e] = testHelper.testroundrobininsert(MyAssignment, RATINGS_TABLE, 100, 3, 3, conn, '2')
[result, e] = testHelper.testroundrobininsert(MyAssignment, RATINGS_TABLE, 100, 4, 3, conn, '3')
[result, e] = testHelper.testroundrobininsert(MyAssignment, RATINGS_TABLE, 100, 5, 3, conn, '4')
if result :
print "roundrobininsert function pass!"
choice = raw_input('Press enter to Delete all tables? ')
if choice == '':
testHelper.deleteAllPublicTables(conn)
