# Do not hard code values in your program for ratings.
# table name and input file name.
# Do not close con objects in your program.
# Invalid ranges will not be tested.
# 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")
# 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.txt.
#
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"
#!/usr/bin/python2.7
#
# 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.
