DATABASE_NAME = 'dds_assignment' import Assignment1 as Assignment1 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"
# Order of output does not matter, only correctness will be checked. # Use discussion board extensively to clear doubts. # Sample output does not correspond to data in test_data.dat. # 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(dbname='ddsassignment2') # 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")
# Order of output does not matter, only correctness will be checked. # Use discussion board extensively to clear doubts. # Sample output does not correspond to data in test_data.dat. # 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")
# # Tester # 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(); # 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);