# 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(1.5, 3.5, con, "./rangeResult.txt")
#Assignment2.RangeQuery(1,4,con, "./rangeResult.txt");
# Calling PointQuery
print("Performing Point Query")
Assignment2.PointQuery(4.5, con, "./pointResult.txt")
#Assignment2.PointQuery('2,con, "./pointResult.txt");
# Deleting All Tables
Assignment1.deleteTables('all', con)
if con:
con.close()
except Exception as detail:
print("Something bad has happened!!! This is the error ==> ", detail)
# 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);
Assignment2.RangeQuery('ratings',1,4,con);
# Calling PointQuery
print "Performing Point Query"
#Assignment2.PointQuery('ratings', 4.5, con);
Assignment2.PointQuery('ratings',2,con);
#Deleting All Tables
#Assignment1.deleteTables('all', con);
if con:
con.close()
except Exception as detail:
print "Something bad has happened!!! This is the error ==> ", detail
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)
if con:
con.close()
except Exception as detail:
print "Something bad has happened!!! This is the error ==> ", detail
print "Creating and Loading the ratings table"
Assignment1.loadRatings('ratings', 'test_data.dat', con)
# Doing Range Partition
print "Doing the Range Partitions"
Assignment1.rangePartition('ratings', 1, con)
# Doing Round Robin Partition
print "Doing the Round Robin Partitions"
Assignment1.roundRobinPartition('ratings', 1, 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', 0, 0, con)
# Calling PointQuery
print "Performing Point Query"
Assignment2.PointQuery('ratings', 5.0, con)
# Deleting All Tables
Assignment1.deleteTables('all', con)
if con:
con.close()
except Exception as detail:
print "Something bad has happened!!! This is the error ==> ", detail
