def test_dlr_xml_validate(self):
input_doc1 = minidom.parse('test1.xml')
input_doc2 = minidom.parse('test2.xml')
input_doc3 = minidom.parse('test3.xml')
input_doc4 = minidom.parse('test4.xml')
dealer1 = input_doc1.getElementsByTagName('dealer')
dealer2 = input_doc2.getElementsByTagName('dealer')
dealer3 = input_doc3.getElementsByTagName('dealer')
dealer4 = input_doc4.getElementsByTagName('dealer')
self.assertEqual(Assignment1.dlr_xml_validate(dealer1), [])
self.assertEqual(Assignment1.dlr_xml_validate(dealer2),
["Failure", "Not authorized"])
self.assertEqual(Assignment1.dlr_xml_validate(dealer3),
["Failure", "Not authorized"])
self.assertEqual(Assignment1.dlr_xml_validate(dealer4),
["Failure", "Not authorized"])
def test_addr_xml_validate(self):
input_doc1 = minidom.parse('test1.xml')
input_doc2 = minidom.parse('test2.xml')
input_doc3 = minidom.parse('test3.xml')
input_doc4 = minidom.parse('test4.xml')
address1 = input_doc1.getElementsByTagName('deliveryaddress')
address2 = input_doc2.getElementsByTagName('deliveryaddress')
address3 = input_doc3.getElementsByTagName('deliveryaddress')
address4 = input_doc4.getElementsByTagName('deliveryaddress')
self.assertEqual(Assignment1.addr_xml_validate(address1), [])
self.assertEqual(
Assignment1.addr_xml_validate(address2),
["Failure", "Invalid Order", "Invalid delivery address"])
self.assertEqual(
Assignment1.addr_xml_validate(address3),
["Failure", "Invalid Order", "Invalid delivery address"])
self.assertEqual(
Assignment1.addr_xml_validate(address4),
["Failure", "Invalid Order", "Invalid delivery address"])
# 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', '../ml-10M100K/ratings_small.dat', con);
# Doing Range Partition
print "Doing the Range Partitions"
# 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();
# 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"
import Assignment1
while True:
print("\n\n\n1.Access Character \n2.Concate String \n3.Find Substring \n4.Replace Substring \n0. Exit")
n = int(input("Enter your choice: "))
if n==1:
Assignment1.access_char()
elif n==2:
Assignment1.concate()
elif n==3:
Assignment1.sub_string()
elif n==4:
Assignment1.replace_substr()
elif n==0:
break
else:
print("You've entered wrong choice!")
def test_fizzbuzz(self):
self.assertEqual(a1.fizzbuzz(5), ['1', '2', 'Fizz', '4', 'Buzz'])
self.assertEqual(a1.fizzbuzz(17), [
"1", "2", "Fizz", "4", "Buzz", "Fizz", "7", "8", "Fizz", "Buzz",
"11", "Fizz", "13", "14", "FizzBuzz", "16", "17"
])
def test_calculator(self):
self.assertEqual(a1.calculator(3, 3, 'add'), 6)
self.assertEqual(a1.calculator(3, 3, 'subtract'), 0)
self.assertEqual(a1.calculator(3, 3, 'multiply'), 9)
self.assertEqual(a1.calculator(3, 3, 'divide'), 1)
self.assertEqual(a1.calculator(2, 6, 'add'), 8)
self.assertEqual(a1.calculator(2, 6, 'subtract'), -4)
self.assertEqual(a1.calculator(2, 6, 'multiply'), 12)
self.assertEqual(a1.calculator(2, 6, 'divide'), 1 / 3)
self.assertEqual(a1.calculator(-3, 4, 'add'), 1)
self.assertEqual(a1.calculator(-3, 4, 'subtract'), -7)
self.assertEqual(a1.calculator(-3, 4, 'multiply'), -12)
self.assertEqual(a1.calculator(-3, 4, 'divide'), -0.75)
def test_triangle_area(self):
self.assertEqual(a1.triangle_area(3, 4), 6)
self.assertEqual(a1.triangle_area(3.5, 4), 7.0)
self.assertEqual(a1.triangle_area(5, 12), 30)
self.assertEqual(a1.triangle_area(8, 15), 60)
def test_add(self):
self.assertEqual(a1.add(3, 3), 6)
self.assertEqual(a1.add(-1, 3), 2)
self.assertEqual(a1.add(-3, -4), -7)
# 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()
# 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"
def test_divide(self):
self.assertEqual(a1.divide(3, 3), 1)
self.assertEqual(a1.divide(-1, 3), -1/3)
self.assertEqual(a1.divide(-3, -4), 3/4)
def test_multiply(self):
self.assertEqual(a1.multiply(3, 3), 9)
self.assertEqual(a1.multiply(-1, 3), -3)
self.assertEqual(a1.multiply(-3, -4), 12)
def test_subtract(self):
self.assertEqual(a1.subtract(3, 3), 0)
self.assertEqual(a1.subtract(-1, 3), -4)
self.assertEqual(a1.subtract(-3, -4), 1)
if cursor:
cursor.close()
if __name__ == '__main__':
try:
# Creating Database
print "Creating Database named as " + DATABASE_NAME
createDB()
# Getting connection to the database
print "Getting connection from the " + DATABASE_NAME + " database"
con = getOpenConnection(dbname=DATABASE_NAME)
#Loading two tables ratings and movies
Assignment1.loadRatings('ratings', 'ratings.txt', con)
loadMovies('movies', 'movies.txt', con)
# Calling ParallelSort
print "Performing Parallel Sort"
Assignment3.ParallelSort('ratings', 'Rating',
'parallelSortOutputTable', con)
#Loading two tables ratings and movies
Assignment1.loadRatings('ratings', 'ratings.txt', con)
loadMovies('movies', 'movies.txt', con)
# Calling ParallelJoin
print "Performing Parallel Join"
Assignment3.ParallelJoin('ratings', 'movies', 'MovieId', 'MovieId1',
'parallelJoinOutputTable', con)
def test_mean_square_error(self):
self.assertEqual(a1.mean_square_error(3, 4), 0.5)
self.assertEqual(a1.mean_square_error(3.5, 4), 0.125)
self.assertEqual(a1.mean_square_error(-3.5, -3.5), 0)
self.assertEqual(a1.mean_square_error(3.5, -3.5), 24.5)
# 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.
