def createCourseInfoTable(): myDB = "RPICourseTrends" db = Database.CourseDb("Ruijie", "gengruijie123", "142.93.59.116", myDB) table_name = "courseInfo" element = [["id", "varchar(35)"], ["courseName", "varchar(35)"], ["department", "varchar(5)"], ["courseCode", "varchar(10)"], ["professor", "varchar(35)"], ["max", "int"], ["time", "varchar(5)"], ["comment1", "varchar(30)"]] key = "id" db.create_tables(table_name, element, key)
temp["currect"] = [num] temp["professor"] = course_name[8:] temp["courseName"] = course_name[0:8] temp["startDate"] = "{}-{}-{}".format( first_date.year, first_date.month, first_date.day) curr_num_in_crs[course_name[0:8]] = temp return curr_num_in_crs # print(a) # a = datetime.datetime.now().date() if __name__ == '__main__': myDB = "RPICourseTrends" db = Database.CourseDb("Ruijie", "xxxxxxxxx", "142.93.59.116", myDB) # ========================show tables in database========================= # data = np.array(db.show_tables(myDB) ) # data = data[:] # print(data) # ======================================================================== table_name = "courseInfo" # course_info = get_info(table_name,db) # course_info = json.dumps(course_info) # with open('identity_v2.json', 'w') as outfile: # json.dump(course_info, outfile) # ======================== write current course number==================== # table_name = "CSCI"
temp["currect"] = [num] temp["professor"] = course_name[8:] temp["courseName"] = course_name[0:8] temp["startDate"] = "{}-{}-{}".format( first_date.year, first_date.month, first_date.day) curr_num_in_crs[course_name[0:8]] = temp return curr_num_in_crs # print(a) # a = datetime.datetime.now().date() if __name__ == '__main__': myDB = "RPICourseTrends" db = Database.CourseDb("Ruijie", "gengruijie123", "142.93.59.116", myDB) # ========================show tables in database========================= # data = np.array(db.show_tables(myDB) ) # data = data[:] # print(data) # ======================================================================== table_name = "courseInfo" # course_info = get_info(table_name,db) # course_info = json.dumps(course_info) # with open('identity_v2.json', 'w') as outfile: # json.dump(course_info, outfile) # ======================== write current course number==================== # table_name = "CSCI"
# if semester does not create, the function will create semester table. url = get_url(db, year) # create info table and insert all the course info into the table # if this step is done before, the function will skip this step automatic insert_course_info(db, year, url) # create course tables for each department create_course_table(db, url, year) if __name__ == '__main__': # define parameter in this program DB_NAME = "RPICourseTrends2" year = "S19" db = Database.CourseDb("Ruijie", "XXXXXXXX", "142.93.59.116", DB_NAME) # =================================================================================== # drop all the tables in specific year # =================================================================================== helper.drop_tables(db, year) # =================================================================================== # =========================== setup the database ================================ # =================================================================================== # input URL, create course_info table and insert course info, create department table # and insert course into department table setup_db(db, year) # =================================================================================== # ================== insert course data number of student =======================
if course.getKey() in courses: courses[course.getKey()] = courses[course.getKey()] + course else: courses[course.getKey()] = course data.clear() count = 0 professor = [] if createIdentity == True: db.drop_table() createCourseInfoTable() storeCourseInfoTable(courses, db) for key, value in sorted(courses.items()): professor.append(key) # print(key) # courses.clear() data.clear() count = 0 return department, courses if __name__ == '__main__': myDB = "RPICourseTrends2" db = Database.CourseDb("Ruijie", "12345678", "142.93.59.116", myDB) # table_name = "courseInfo" # db.setTable(table_name) # # db.drop_table(table_name) # get_professor(db, True)