def readDb(): con = mdb.connect("localhost", "root", "ion", "RankClassifier") cur = con.cursor() dept = rcm.branch("Electronics Engineering") cur.execute("Select rank from Students where dept=%d and year=2010 order by rank asc;" % dept) data = cur.fetchall() return data
try: # Open the Dataset file f = open("Dataset.csv") # Read all the lines in the file data = f.readlines() # Connect to database and create cursor con = mdb.connect("localhost", "root", "ion", "RankClassifier") cur = con.cursor() # For all the data entries, get the corresponding values and put in database for i in range(len(data)): tup = data[i].split(",") dept = RCM.branch(tup[3]) # Store numerical value of branch insti = RCM.institute("") # Store numerical value of institute # Get the Z value for the values passed z = RCM.getZValue(int(tup[1]), dept, insti) # Insert values into Students database cur.execute("Insert into Students values (%d, %d, %d, %d, %d)" % (z, int(tup[1]), dept, insti, int(tup[2]))) # cur.execute("Select * from Students") # values = cur.fetchall() # print len(values) # for i in range(5): # print values[i]