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)