import Assignment1 as Assignment1
import Assignment2_Interface as Assignment2
if __name__ == '__main__':
try:
#Creating Database ddsassignment2
print "Creating Database named as ddsassignment2"
Assignment1.createDB();
# Getting connection to the database
print "Getting connection from the ddsassignment2 database"
con = Assignment1.getOpenConnection();
# 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.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);
import Interface as Assignment2
import traceback
if __name__ == '__main__':
try:
#Creating Database ddsassignment2
print "Creating Database named as " + DATABASE_NAME
Assignment1.createDB(DATABASE_NAME)
# Getting connection to the database
print "Getting connection from the " + DATABASE_NAME + " database"
con = Assignment1.getOpenConnection(dbname=DATABASE_NAME)
# 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)
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);
if con:
con.close()
