# Clear the database existing tables
print "Delete tables"
Assignment1.deleteTables('all', con)
# Loading Ratings table
print "Creating and Loading the ratings table"
Assignment1.loadRatings('ratings', 'test_data.txt', con)
# Doing Range Partition
print "Doing the Range Partitions"
Assignment1.rangePartition('ratings', 5, con)
# Doing Round Robin Partition
print "Doing the Round Robin Partitions"
Assignment1.roundRobinPartition('ratings', 5, con)
# Deleting Ratings Table because Point Query and Range Query should not use ratings table instead they should use partitions.
Assignment1.deleteTables('ratings', con)
# Calling RangeQuery
print "Performing Range Query"
Assignment2.RangeQuery('ratings', 2, 3, con)
#Assignment2.RangeQuery('ratings',1,4,con);
# Calling PointQuery
print "Performing Point Query"
Assignment2.PointQuery('ratings', 4, con)
#Assignment2.PointQuery('ratings',2,con);
# Deleting All Tables
# Getting connection to the database
print "Getting connection from the ddsassignment2 database"
con = Assignment1.getOpenConnection();
# Loading Ratings table
print "Creating and Loading the ratings table"
Assignment1.loadRatings('ratings', 'ratings.dat', con);
# Doing Range Partition
print "Doing the Range Partitions"
Assignment1.rangePartition('ratings', 5, con);
# Doing Round Robin Partition
print "Doing the Round Robin Partitions"
Assignment1.roundRobinPartition('ratings', 5, con);
# Deleting Ratings Table because Point Query and Range Query should not use ratings table instead they should use partitions.
Assignment1.deleteTables('ratings', con);
# Calling RangeQuery
print "Performing Range Query"
Assignment2.RangeQuery('ratings', 1.5, 3.5, con);
# Calling PointQuery
print "Performing Point Query"
Assignment2.PointQuery('ratings', 4.5, con);
# Deleting All Tables
Assignment1.deleteTables('all', con);
