def delete(audioFileType,id): """[Function which delete item form the table] Returns: [Json]: [Item id and type] """ try: mydb = sql_connection() #Calling function to connecting the datbase mydb = sql_connection() #creating cursor to upload data into the database myCursor = mydb.cursor() #executing, commiting and closing all the objects myCursor.execute("DELETE FROM {} where ID = {}".format(audioFileType,id)) myCursor.close() mydb.close() x = { "requestType":"Delete", "response":"200 ok", "audioFileType": audioFileType, "ID": id } return x except Exception as e: return str(e)
def search(): """[Adding new batch_time] Returns: [str]: [normal string] """ #Caling function to connecting database mydb = sql_connection() try: if request.method == "POST": StudentBatchData = request.get_json() StudentID = StudentBatchData["STUDENTID"] print(StudentBatchData) mycursor = mydb.cursor() mycursor.execute( "SELECT* FROM student_data_ineuron WHERE STUDENT_ID = {}". format(StudentID)) print("select* from student_data_ineuron where STUDENT_ID = {}". format(StudentID)) studentFullData = {"studentFullData": mycursor.fetchall()[0]} mycursor.close() mydb.close() except Exception as e: return str(e) return studentFullData
def add_batch_time(): """[Adding new batch_time] Returns: [str]: [normal string] """ #Caling function to connecting database mydb = sql_connection() try: if request.method == "POST": StudentBatchData = request.get_json() Time = StudentBatchData["TIME"] MONDAY = StudentBatchData["MONDAY"] TUESDAY = StudentBatchData["TUESDAY"] WEDNESDAY = StudentBatchData["WEDNESDAY"] THURSDAY = StudentBatchData["THURSDAY"] FRIDAY = StudentBatchData["FRIDAY"] print(StudentBatchData) mycursor = mydb.cursor() add_student_query = "INSERT INTO student_batch_time (BTIME, MONDAY,TUESDAY,WEDNESDAY,THRUSDAY,FRIDAY) VALUES (%s,%s,%s,%s,%s,%s)" add_student_data = (Time, MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY) mycursor.execute(add_student_query, add_student_data) mydb.commit() mycursor.close() mydb.close() except Exception as e: return e return StudentBatchData
def topper(): """[showing batch_time] Returns: [str]: [normal string] """ #Caling function to connecting database mydb = sql_connection() try: if request.method == "GET": toperNameList = [] mycursor = mydb.cursor() mycursor.execute( "select STUDENT_NAME from student_data_ineuron where STUDENT_ID = (select STUDENT_ID from student_id_marks where ME = (select max(ME) from student_id_marks))" ) toperNameList.append(mycursor.fetchall()[0][0]) mycursor.close() mycursor = mydb.cursor() mycursor.execute( "select STUDENT_NAME from student_data_ineuron where STUDENT_ID = (select STUDENT_ID from student_id_marks where CSE = (select max(CSE) from student_id_marks))" ) toperNameList.append(mycursor.fetchall()[0][0]) mycursor.close() mycursor = mydb.cursor() mycursor.execute( "select STUDENT_NAME from student_data_ineuron where STUDENT_ID = (select STUDENT_ID from student_id_marks where civil = (select max(civil) from student_id_marks))" ) toperNameList.append(mycursor.fetchall()[0][0]) mycursor.close() studentTopperData = {"Topper": toperNameList} print(studentTopperData) mycursor.close() mydb.close() except Exception as e: return str(e) return studentTopperData
def viewOne(audioFileType,id): """[Function having ability to show tha data compounding to request] Returns: [type]: [description] """ try: if audioFileType == "songs": name = "songname" elif audioFileType == "podcastname": name = "podcast" elif audioFileType == "audiobook": name = "title" #Calling function to connecting the datbase mydb = sql_connection() #creating cursor to upload data into the database myCursor = mydb.cursor() #executing, commiting and closing all the objects myCursor.execute("SELECT {} FROM {} WHERE ID = {}".format(name,audioFileType,id)) #Storing all the data into list names = "" for i in myCursor: names = i[0] myCursor.close() mydb.close() x = { "requestType":"View", "response":"200 ok", "audioFileType": audioFileType, "Audio": names, "Audio ID": id } return x except Exception as e: return str(e)
def add_student(): """[Adding new student on the the class] Returns: [str]: [added stundent name] """ #Caling function to connecting database mydb = sql_connection() try: if request.method == "POST": StudentData = request.get_json() StudentName = StudentData["NAME"] StudentId = StudentData["ID"] Batch = StudentData["BATCH"] Branch = StudentData['BRANCH'] print(StudentData) mycursor = mydb.cursor() add_student_query = "INSERT INTO student_data_ineuron (STUDENT_ID, STUDENT_NAME, BRANCH,BATCH) VALUES (%s, %s, %s, %s)" add_student_data = (StudentId, StudentName, Branch, Batch) mycursor.execute(add_student_query, add_student_data) mydb.commit() mycursor.close() #Adding Student_Id For marks updating mycursor = mydb.cursor() add_student_id_for_marks_query = "INSERT INTO student_id_marks (STUDENT_ID) VALUES (%s)" add_student_id_for_marks_data = (StudentId, ) mycursor.execute(add_student_id_for_marks_query, add_student_id_for_marks_data) mydb.commit() mycursor.close() mydb.close() except Exception as e: return e return StudentData
def batchTime(): """[showing batch_time] Returns: [str]: [normal string] """ #Caling function to connecting database mydb = sql_connection() try: if request.method == "GET": mycursor = mydb.cursor() mycursor.execute("SELECT* FROM student_batch_time") #print("select* from student_data_ineuron where STUDENT_ID = {}".format(StudentID)) studentBatchTimeData = { "studentBatchTimeData": mycursor.fetchall() } mycursor.close() mydb.close() except Exception as e: return str(e) return studentBatchTimeData
def student_name(): print("------------------------------------") """[finding all the student having perticular batch] Returns: [list]: [list of all the student name] """ #Caling function to connecting database mydb = sql_connection() try: if request.method == "POST": StudentData = request.get_json() StudentBATCH = StudentData["BATCH"] print(StudentData) mycursor = mydb.cursor() add_student_query = "SELECT STUDENT_NAME FROM student_data_ineuron WHERE BATCH = %s" add_student_data = (StudentBATCH, ) mycursor.execute(add_student_query, add_student_data) RetriveStudentName = {} NameList = [] for i in mycursor: NameList.append(i[0]) RetriveStudentName["NAME"] = NameList print(RetriveStudentName) mycursor.close() mydb.close() #SuccessReturn = (StudentName +" Is added into the system having ID = "+StudentId+" ,Brach = "+Branch+" and batch = "+Batch) except Exception as e: return e return RetriveStudentName
def update(audioFileType,audioID,audioMeta): """[summary] Returns: [type]: [description] """ try: #Calling function to connecting the datbase mydb = sql_connection() #creating cursor to upload data into the database myCursor = mydb.cursor() #condition for various type of audio file if audioFileType == "songs": #converting upcoming string into json(dict) audioMeta = json.loads(audioMeta) id = audioMeta["id"] songName = audioMeta["songname"] duration = audioMeta["duration"] dateTime = datetime.datetime.utcnow() formatted_date = dateTime.strftime('%Y-%m-%d %H:%M:%S') #Query by which data inserted into data base query = "UPDATE {} SET songname = %s, duration = %s, uploadtime = %s WHERE ID = %s".format(audioFileType) #variable that holds data, which going to the database table data = (songName,duration,formatted_date,id) elif audioFileType == "podcast": #converting upcoming string into json(dict) audioMeta = json.loads(audioMeta) id = audioMeta["id"] podcastName = audioMeta["podcastname"] duration = audioMeta["duration"] hostName = audioMeta["hostname"] participents = audioMeta["participents"] dateTime = datetime.datetime.utcnow() formatted_date = dateTime.strftime('%Y-%m-%d %H:%M:%S') #Query by which data inserted into data base query = "UPDATE {} SET podcastname = %s , duration = %s, uploadtime = %s, hostname = %s, participents = %s WHERE ID = %s".format(audioFileType); #variable that holds data, which going to the database table data = (podcastName,duration,formatted_date,hostName,participents,id) elif audioFileType == "audiobook": #converting upcoming string into json(dict) audioMeta = json.loads(audioMeta) id = audioMeta["id"] title = audioMeta["title"] author = audioMeta["author"] narrator = audioMeta["narrator"] duration = audioMeta["duration"] dateTime = datetime.datetime.utcnow() formatted_date = dateTime.strftime('%Y-%m-%d %H:%M:%S') print(audioFileType,audioID) #Query by which data inserted into data base query = "UPDATE {} SET title = %s, author = %s, narrator = %s, duration = %s, uploadtime = %s WHERE ID = %s".format(audioFileType) #variable that holds data, which going to the database table data = (title,author,narrator,duration,formatted_date,id) #executing, commiting and closing all the objects myCursor.execute(query,data) mydb.commit() myCursor.close() mydb.close() #returning data and 200 Ok after successfully inserted data return "200 ok" except Exception as e: return str(e)
def upload(audioFileType,audioMeta): """[uploading audio type into database] Args: audioFileType ([type]): [string] audioMeta ([type]): [string] """ try: #variable that hold all the data comming from query string """x = { "response":"200 Ok", "id":id, "songName":songName, "duration":duration, "dateTime":formatted_date }""" #Calling function to connecting the datbase mydb = sql_connection() #creating cursor to upload data into the database myCursor = mydb.cursor() #condition for various type of audio file if audioFileType == "songs": #converting upcoming string into json(dict) audioMeta = json.loads(audioMeta) id = audioMeta["id"] songName = audioMeta["songname"] duration = audioMeta["duration"] dateTime = datetime.datetime.utcnow() formatted_date = dateTime.strftime('%Y-%m-%d %H:%M:%S') #Query by which data inserted into data base query = "INSERT INTO {} (ID, songname, duration, uploadtime) values (%s,%s,%s,%s)".format(audioFileType) #variable that holds data, which going to the database table data = (id,songName,duration,formatted_date) elif audioFileType == "podcast": #converting upcoming string into json(dict) audioMeta = json.loads(audioMeta) id = audioMeta["id"] podcastName = audioMeta["podcastname"] duration = audioMeta["duration"] hostName = audioMeta["hostname"] participents = audioMeta["participents"] dateTime = datetime.datetime.utcnow() formatted_date = dateTime.strftime('%Y-%m-%d %H:%M:%S') #Query by which data inserted into data base query = "INSERT INTO {} (ID, podcastname, duration, uploadtime,hostname,participents) values (%s,%s,%s,%s,%s,%s)".format(audioFileType) #variable that holds data, which going to the database table data = (id,podcastName,duration,formatted_date,hostName,participents) elif audioFileType == "audiobook": #converting upcoming string into json(dict) audioMeta = json.loads(audioMeta) id = audioMeta["id"] title = audioMeta["title"] author = audioMeta["author"] narrator = audioMeta["narrator"] duration = audioMeta["duration"] dateTime = datetime.datetime.utcnow() formatted_date = dateTime.strftime('%Y-%m-%d %H:%M:%S') #Query by which data inserted into data base query = "INSERT INTO {} (ID,title,author,narrator,duration,uploadtime) values (%s,%s,%s,%s,%s,%s)".format(audioFileType) #variable that holds data, which going to the database table data = (id,title,author,narrator,duration,formatted_date) #executing, commiting and closing all the objects myCursor.execute(query,data) mydb.commit() myCursor.close() mydb.close() #returning data and 200 Ok after successfully inserted data return "200 ok" except Exception as e: return str(e)