def change_customer_passcode(change_passcode, user): conn, cursor = config.connect_to_database() userid = get_any_value(user, "cid") sql = "update accounts SET passcode='%s' where c_id='%s'" % ( change_passcode, userid) conn, cursor = config.connect_to_database() try: cursor.execute(sql) conn.commit() return "11" except: conn.rollback() return "0" finally: conn.close()
def add_visitor(visitor_id, profile_id): conn, cursor = config.connect_to_database() rownum, howmanytimes = count_visits(visitor_id, profile_id) rownum = int(rownum) howmanytimes = int(howmanytimes) if rownum == 0 and howmanytimes == 0: sql_visit = "Insert into profile_visit(ProfileID,PersonID) values('%s','%s')" % ( profile_id, visitor_id) else: howmanytimes += 1 sql_visit = "Update profile_visit SET HowManyTimes='%s' where ProfileID='%s' and PersonID='%s'" % ( howmanytimes, profile_id, visitor_id) try: cursor.execute(sql_visit) conn.commit() obj_inst = institute_and_job.institute_and_job() obj_inst.institute_details(conn, cursor, profile_id) inst_impression = obj_inst.inst_impressions inst_impression = int(inst_impression) inst_impression += 1 sql_inst = "Update Institutes SET Impression='%s' where ID='%s'" % ( inst_impression, profile_id) try: cursor.execute(sql_inst) conn.commit() print("11") except: conn.rollback() print("Server is taking too load..") except: conn.rollback() print("Server is taking too load..")
def reload_chats(user_id, email_id): conn, cursor = config.connect_to_database() sql = "select * from chats where from_id='%s' or to_id='%s' ORDER BY created_time ASC" % ( user_id, user_id) reload_mess = "" try: cursor.execute(sql) results = cursor.fetchall() for row in results: chat_id = "chat_%s" % row[0] from_id = row[1] to_id = row[2] text = row[3] datetime = row[4] time = datetime.strftime('%H : %M') name = customer_details.get_any_value(email_id, "username") profile_pic = customer_details.get_any_document( name, "profile_pic") if int(to_id) != 0 or from_id == 0: reload_mess += """<li id='%s' class="mess"><div><img src="images/jon-cart.jpg" alt="You" style="width:100%%;"><p class="text-left">%s</p><br/><span class="time-right">%s</span></div></li><br/>""" % ( chat_id, text, time) else: reload_mess += """<li id='%s' class='mess'><div><img src="%s" alt="Jon" class="right" style="height:50px;"><p class="text-right">%s</p><br/><span class="time-left">%s</span></div></li><br/>""" % ( chat_id, profile_pic, text, time) return reload_mess except: return "error"
def accept_offer(candid, instid, jobid, role): conn, cursor = config.connect_to_database() num = count_rows(instid, candid, jobid) num = int(num) if num == 1: sql = "update chat SET role='%s' where FromUser='******' and ToUserID='%s' and Text='%s'" % ( role, instid, candid, jobid) try: cursor.execute(sql) conn.commit() mess = instid save_history.enter_history(conn, cursor, mess, candid, role) obj_job = institute_and_job.institute_and_job() obj_job.job_details(conn, cursor, jobid) job_impressions = obj_job.job_impressions job_impressions = int(job_impressions) job_impressions += 10 sql_job = "UPDATE jobs set job_impressions='%s' where job_id='%s'" % ( job_impressions, jobid) try: cursor.execute(sql_job) conn.commit() print("1") except: conn.rollback() print("-1") except: conn.rollback() print("-1") else: print("-1") conn.close()
def impressions_total_count(inst_id): conn, cursor = config.connect_to_database() obj_inst = institute_and_job.institute_and_job() obj_inst.institute_details(conn, cursor, inst_id) inst_impression = obj_inst.inst_impressions print("%s" % inst_impression) conn.close()
def remove_question(queid, testid): conn, cursor = config.connect_to_database() sql = "Delete from Questions where ID='%s'" % (queid) try: cursor.execute(sql) sql2 = "Select Total_num from Tests where ID='%s'" % (testid) try: cursor.execute(sql2) results = cursor.fetchone() num = results[0] n = int(num) n -= 1 sql3 = "Update Tests SET Total_num='%s' where ID='%s'" % (n, testid) try: cursor.execute(sql3) conn.commit() print("1") except: conn.rollback() print("-1") except: conn.rollback() print("-1") except: conn.rollback() print("-1") conn.close()
def que_reload(testid, cu_id): conn, cursor = config.connect_to_database() sql = "Select ID,Time,Question,A1,A2,A3,A4 FROM Questions where TestID='%s'" % ( testid) try: cursor.execute(sql) results = cursor.fetchall() i = 0 for row in results: divid = row[0] time = row[1] datetime = time.strftime('%H : %M') que = row[2] a1 = row[3] a2 = row[4] a3 = row[5] a4 = row[6] i += 1 que_id = "question%s" % i error = "error%s" % i ans1 = "name='%s' value='1'" % (divid) ans2 = "name='%s' value='2'" % (divid) ans3 = "name='%s' value='3'" % (divid) ans4 = "name='%s' value='4'" % (divid) print( """<div id="%s" class="panel-body" style="line-height:30px;"><div id='question'>%s. <strong>%s</strong></div><div id='mcqs' class="form-group"><div><input type='radio' %s /> %s</div><div><input type='radio' %s /> %s</div><div><input type='radio' %s /> %s</div><div><input type='radio' %s /> %s</div><div id="%s"></div></div></div><hr style="border-width:2px;border-color:rgbs(180,180,180,1.00);"/>""" % (que_id, i, que, ans1, a1, ans2, a2, ans3, a3, ans4, a4, error)) print( """<div id="controls"><button class="btn btn-sm btn-primary" type="button" onclick="check_answers()">Submit</button></div>""" ) except: conn.rollback() print("-1") conn.close()
def change_customer_details(field,value,user): column_value=['postal_add','username','contact',"passcode","password"] conn,cursor=config.connect_to_database() if field=="username" or field=="contact": sql="select email from customers where %s='%s'"%(field,value) try: cursor.execute(sql) if cursor.rowcount!=0: row=cursor.fetchone() if user!=row[0]: return -11 except: return -99 if field=="passcode": cid=customer_details.get_any_value(user,"cid") table_name="accounts" condition="c_id='%s'"%cid else: table_name="customers" condition="email='%s'"%user sql="update %s SET %s='%s' where %s"%(table_name,field,value,condition) try: cursor.execute(sql) conn.commit() return 1 except: conn.rollback() return -99 finally: conn.close()
def customer_details(self, userid): sql = "select * from customers where cid='%s'" % userid conn, cursor = config.connect_to_database() try: cursor.execute(sql) results = cursor.fetchall() for row in results: self.cid = row[0] self.username = row[1] self.fname = row[2] self.lname = row[3] self.email = row[4] self.password = row[5] self.contact = row[6] self.postal_add = row[7] self.perm_add = row[8] self.city = row[9] self.state = row[10] self.country = row[11] self.middle_name = row[12] self.pincode = row[13] self.dob = row[14] self.gender = row[15] self.created_time = row[17] self.jon = row[18] self.hasAcc = row[19] except: print("Error") conn.close()
def reload_visits(inst_id): conn, cursor = config.connect_to_database() sql_visits = "select VisitID,PersonID,VisitedTime,HowManyTimes from profile_visit where ProfileID='%s'" % ( inst_id) try: cursor.execute(sql_visits) results = cursor.fetchall() rownum = cursor.rowcount if rownum == 0: no_found.no_found("Profile visits(0)") else: for row in results: divid = row[0] personid = row[1] time = row[2] howmanytimes = row[3] obj_cand = candidate_details.candidate() obj_cand.candidate_details(conn, cursor, personid) cand_id = obj_cand.cand_id cand_name = obj_cand.cand_name cand_image = obj_cand.cand_image cand_email = obj_cand.cand_email cand_contact = obj_cand.cand_contact filename = obj_cand.filename print( """<div style="margin:20px;padding:20px;background-color:white;border-left:3px solid rgba(23,139,158,1.00);border-top:2px solid rgba(23,139,158,1.00);box-shadow: 5px 5px 5px #aaaaaa;"> <div class="row" style=""><div class="col-md-9"></div><div class="col-md-3 pull-right">%s</div></div> <hr style="border-width:2px;border-color:rgbs(180,180,180,1.00);"/> <div class="row"><div class="col-md-9"><div class="media"><div class="media-left"><img class="img-circle" style="height:60px;" src="%s" /></div><div class="media-body" style="line-height: 25px;"><div id='%s' class='cand_id'><strong>%s</strong> visited <span class="badge">%s</span> times</div></div></div></div><div class="col-md-3"><a href="#" onclick='delete_visit("%s")' class="close" data-dismiss="alert" aria-label="close">×</a></div></div></div><br/>""" % (time, filename, cand_id, cand_name, howmanytimes, divid)) except: conn.rollback() print("Server is taking too load...") conn.close()
def make_transaction(from_acc_no, to_acc_no, amount): conn, cursor = config.connect_to_database() trans_id = 2179516709 sql = "insert into transactions(from_acc,to_acc,amount) values('%s','%s','%s')" % ( from_acc_no, to_acc_no, amount) try: cursor.execute(sql) flag = transaction_happened(cursor, from_acc_no, to_acc_no, amount) if flag != 11: return flag conn.commit() sql = "SELECT t_id FROM transactions ORDER BY t_id DESC LIMIT 1;" try: cursor.execute(sql) row = cursor.fetchone() t_id = row[0] t_id = int(t_id) trans_id += t_id return "11<table class='myTable'><tr><td><span style='color:rgba(32,78,148,1);'>Transactions id</span></td><td>#%s</td></tr><tr><td>From Account Number</td><td>%s</td></tr><tr><td>To Account Number</td><td>%s</td></tr><tr><td>Amount</td><td>Rs. %s</td></tr></table>" % ( trans_id, from_acc_no, to_acc_no, amount) except: return -99 except: conn.rollback() return -999 finally: conn.close()
def get_last_transaction_without_html_tags(acc_no, n): conn, cursor = config.connect_to_database() trans_id = 2179516709 sql = "SELECT t_id,from_acc,to_acc,amount FROM transactions where from_acc='%s' or to_acc='%s' ORDER BY t_id DESC LIMIT %s;" % ( acc_no, acc_no, n) try: cursor.execute(sql) results = cursor.fetchall() num = cursor.rowcount num_str = str(num).zfill(2) response = """Last %s Transactions""" % (num_str) i = int(n) + 1 for row in results: t_id = row[0] t_id = int(t_id) from_acc_no = row[1] to_acc_no = row[2] trans_id += t_id amount = row[3] i -= 1 response += """\n-----%s----\nTransactions id: #%s\nFrom Account Number: %s\nTo Account Number: %s\nAmount: Rs. %s""" % ( i, trans_id, from_acc_no, to_acc_no, amount) return response except: return -99 finally: conn.close()
def show_tests(postedby): conn, cursor = config.connect_to_database() sql = "Select ID,Time,Title,Total_num,Course,Subjects FROM Tests where Postedby='%s'" % ( postedby) try: cursor.execute(sql) results = cursor.fetchall() for row in results: divid = row[0] time = row[1] datetime = time.strftime('%H : %M') title = row[2] num = row[3] course = row[4] str_sub = row[5] subjects = str_sub.split("|") if len(subjects) == 1: sub_string = str_sub.strip() else: sub_string = "<ol>" for i in subjects: sub_string += "<li>" + i.strip() + "</li>" sub_string += "</ol>" print( """<div id="%s" class='style_prevu_kit test_div' style="padding:10px;"><div class="row"><div class="col-sm-6"><button class="btn btn-link" onclick="show_questions(%s)" ><h3>%s</h3></button><span class="pull-right"><form action="edit_test.php" method="post" ><input type="hidden" name="test_id" value="%s" /><button class="btn btn-sm btn-primary" type="submit" >Edit <span class="glyphicon glyphicon-pencil"></span></button></form></span><span class="pull-right"><button class="btn btn-sm btn-danger" onclick="remove_test(%s)" >Delete <span class="glyphicon glyphicon-trash"></span></button></span></div><div class="col-sm-6"><span class="glyphicon glyphicon-time"></span> Posted on %s</div></div><hr /><div class="row"><div class="col-sm-6">Total Questions</div><div class="col-sm-6">%s</div></div><div class="row"><div class="col-sm-6">Course</div><div class="col-sm-6">%s</div></div><div class="row"><div class="col-sm-6">Subjects</div><div class="col-sm-6">%s</div></div></div><hr/><hr/>""" % (divid, divid, title, divid, divid, time, num, course, sub_string)) except: conn.rollback() print("-1") conn.close()
def verify_card_request(r_id,acc_id,status): sql="update requests SET status_bit='%s' where r_id='%s'"%(status,r_id) user=customer_details.get_account_by_acc_id(acc_id,"email") if type(status)!=int: status=int(status) sub="Verification of your card request" if status==1: bit=create_card(acc_id) bit=str(bit) if bit=="-99": return "-99" elif bit=="-22": return "-22" cont="""<h1>Lennox</h1>,<br/><p>Your card request has been approved for banking and use of our services.</p>"""; else: cont="""<h1>Lennox</h1>,<br/><p>We are sorry to hear that</p><br/></p><p>Your account is rejected.</p>"""; conn,cursor=config.connect_to_database() try: cursor.execute(sql) m=send_mail.Mail() st=m.send_mail(user,sub,cont) conn.commit() return "11" except: conn.rollback() return "-99" finally: conn.close()
def verify_customer(userid,user,status): sql="update customers SET hasAcc='%s' where cid='%s'"%(status,userid) if type(status)!=int: status=int(status) sub="Verification of your Ryder account" if status==1: bit=create_bank_account_details(userid) bit=str(bit) if bit=="-99": return "-99" elif bit=="-22": return "-22" cont="""<h1>Lennox</h1>,<br/><p>Your account has been approved for banking and use of our services.</p>"""; else: cont="""<h1>Lennox</h1>,<br/><p>We are sorry to hear that</p><br/></p><p>Your account is rejected.</p>"""; conn,cursor=config.connect_to_database() try: cursor.execute(sql) m=send_mail.Mail() st=m.send_mail(user,sub,cont) st=str(st) if st=="11": conn.commit() return "11" else: conn.rollback() return "-99" except: conn.rollback() return "-99"
def reload_history(c_id1): conn, cursor = config.connect_to_database() sql = "SELECT ID,`Time`,Field FROM History where UserID='%s' and role='Institute' ORDER BY Time DESC" % ( c_id1) try: cursor.execute(sql) results = cursor.fetchall() rownum = cursor.rowcount if rownum == 0: no_found.no_found("History(0)") else: for row in results: divid = row[0] time = row[1] datetime = time.strftime('%H : %M') field = row[2] fdiv = "You have updated <strong> %s</strong> at %s" % ( field, datetime) print( """<div id="%s" class="alert alert-info alert-dismissable fade in" ><a href="#" onclick='delete_hist("%s")' class="close" data-dismiss="alert" aria-label="close">×</a> %s </div><br/>""" % (divid, divid, fdiv)) except: conn.rollback() print("Try again !") conn.close()
def add_question(testid, que, a1, a2, a3, a4, ans): conn, cursor = config.connect_to_database() testid = int(testid) sql = "Insert into Questions(Question,A1,A2,A3,A4,TestID,Ans) values('%s','%s','%s','%s','%s','%s','%s')" % ( que, a1, a2, a3, a4, testid, ans) try: cursor.execute(sql) conn.commit() testid = int(testid) sql2 = "Select Total_num from Tests Where ID='%s'" % (testid) try: cursor.execute(sql2) results = cursor.fetchone() num = results[0] n = int(num) n += 1 sql3 = "Update Tests SET Total_num='%s' where ID='%s'" % (n, testid) try: cursor.execute(sql3) conn.commit() print("1") except: conn.rollback() print("-1") except: conn.rollback() print("-1") except: conn.rollback() print("-1") conn.close()
def reload_all(inst_id, role_div): conn, cursor = config.connect_to_database() sql = "Select ID,role,Time,ToUserID,Text,FromUser from chat where %s ORDER BY Time DESC" % ( role_div) try: cursor.execute(sql) results = cursor.fetchall() rownum = cursor.rowcount if rownum == 0: no_found.no_found("Inbox(0)") else: for row in results: role = row[1] divid = row[0] time = row[2] datetime = time.strftime('%H : %M') if role == "Offer" or role == "Accepted": fromuser = row[3] jobid = row[4] obj_cand = candidate_details.candidate() obj_cand.candidate_details(conn, cursor, fromuser) obj_job = institute_and_job.institute_and_job() obj_job.job_details(conn, cursor, jobid) if role == "Offer": status_header = "<span style='color:#FFAE00;'><strong><h4>Job Sent</h4></strong></span>" status_div = """<h4>Job <span class='job_id' id='%s'><b>%s</b> offer sent to <span style='cursor:pointer;' class="show_candidate_link"><span id='%s' class='cand_id'><b>%s</b></span></span></span></h4>""" % ( obj_job.job_id, obj_job.job_name, obj_cand.cand_id, obj_cand.cand_name) elif role == "Accepted": status_header = "<span style='color:green;'><strong><h4>Job Accepted</h4></strong></span>" status_div = """<h4>Job <span class='job_id' id='%s'><b>%s</b> accepted by <span style='cursor:pointer;' class="show_candidate"><span id='%s' class='cand_id'><b>%s</b></span></span></span></h4>""" % ( obj_job.job_id, obj_job.job_name, obj_cand.cand_id, obj_cand.cand_name) print( """<div style="margin:20px;padding:20px;background-color:white;border-left:3px solid rgba(23,139,158,1.00);border-top:2px solid rgba(23,139,158,1.00);box-shadow: 5px 5px 5px #aaaaaa;"> <div class="row" style=""><div class="col-md-9">%s</div><div class="col-md-3 pull-right">%s</div></div> <hr style="border-width:2px;border-color:rgbs(180,180,180,1.00);"/> <div class="row"><div class="col-md-9"><div class="media"><div class="media-left"><img class="img-circle" style="height:60px;" src="%s" /></div><div class="media-body" style="line-height: 25px;"><div id='status_div'>%s</div></div></div></div><div class="col-md-3"><a href="#" onclick='delete_mes("%s")' class="close" data-dismiss="alert" aria-label="close">×</a></div></div></div><br/>""" % (status_header, time, obj_cand.filename, status_div, divid)) else: fromuser = row[5] text = row[4] if fromuser == "Admin": if text == "verified": print( """<div style="margin:20px;padding:20px;background-color:white;border-left:3px solid rgba(23,139,158,1.00);border-top:2px solid rgba(23,139,158,1.00);box-shadow: 5px 5px 5px #aaaaaa;"><div class="row"><div class="col-md-9"><h4>Verification <span class="glyphicon glyphicon-ok-sign" style="color:green;"><span></h4></div><div class="col-md-3"><a href="#" onclick='delete_mes("%s")' class="close" data-dismiss="alert" aria-label="close">×</a></div></div><hr style="border-width:2px;border-color:rgbs(180,180,180,1.00);"/> <div class="row" style="margin-bottom:20px;"><div class="col-md-9"><div id="%s" class="alert-dismissable fade in"><strong>%s </strong> : Hurray!!Your profile is varified successfully.</div></div><div class="col-md-3 pull-right">%s</div></div></div><br/>""" % (divid, divid, fromuser, time)) elif text == "rejected": print( """<div style="margin:20px;padding:20px;background-color:white;border-left:3px solid rgba(23,139,158,1.00);border-top:2px solid rgba(23,139,158,1.00);box-shadow: 5px 5px 5px #aaaaaa;"><div class="row"><div class="col-md-9"><h4>Verification <span class="glyphicon glyphicon-remove" style="color:red;"><span></h4></div><div class="col-md-3"><a href="#" onclick='delete_mes("%s")' class="close" data-dismiss="alert" aria-label="close">×</a></div></div><hr style="border-width:2px;border-color:rgbs(180,180,180,1.00);"/> <div class="row" style="margin-bottom:20px;"><div class="col-md-9"><div id="%s" class="alert-dismissable fade in"><strong>%s </strong> : We are sorry!!Your profile is rejected.</div></div><div class="col-md-3 pull-right">%s</div></div></div><br/>""" % (divid, divid, fromuser, time)) except: conn.rollback() print("Try again !") print('<script type="text/javascript" src="js/show_cand.js"></script>') conn.close()
def check_service(user): conn, cursor = config.connect_to_database() sql = "select jon from customers where email='%s'" % (user) try: cursor.execute(sql) row = cursor.fetchone() return int(row[0]) except: return "-99"
def check_request_exist(acc_id): conn, cursor = config.connect_to_database() sql = "select r_id from requests where acc_id='%s'" % (acc_id) try: cursor.execute(sql) return cursor.rowcount except: return -99 finally: conn.close()
def jon_service(bit, user): conn, cursor = config.connect_to_database() sql = "update customers SET jon='%s' where email='%s'" % (bit, user) try: cursor.execute(sql) conn.commit() return "11" except: conn.rollback() return "0"
def provides_requests(): conn, cursor = config.connect_to_database() sql = "select * from requests ORDER BY created_time DESC" try: cursor.execute(sql) results = cursor.fetchall() num_row = int(cursor.rowcount) if num_row != 0: i = 0 requests = """<div class="row" style="margin:20px;"><caption><h2>Requests <button class="btn btn-primary" id="request_refresh"><span class="glyphicon glyphicon-refresh"></span></button></h2></caption><table class='customerTable table-striped'><tr><td><b>Index no.</b></td><td><b>Account Number</b></td><td><b>Account Name</b></td><td><b>Requesting</b></td><td><b>Time</b></td></tr>""" for row in results: r_id = row[0] acc_id = row[1] acc_no = customer_details.get_account_by_acc_id( acc_id, "acc_no") acc_name = customer_details.get_account_by_acc_id( acc_id, "acc_name") c_id = customer_details.get_account_by_acc_id(acc_id, "c_id") req = row[2] status = row[3] time = row[4] i += 1 profile_link = """<a class='btn btn-link' id='profile_link'>%s</a>""" % acc_name requests += """<tr class='clickable-row' id='%s' style="cursor:pointer;"><td>%s</td><td id='%s' class='c_id'>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>""" % ( r_id, i, c_id, acc_no, profile_link, req, time) requests += "</table></div>" requests += """<script> var get_table_of_details=function(flag) { $.ajax({ type: 'POST', url: 'admin_interface.py', data: 'flag='+flag, success : function (data) { $("#show_here").empty(); $("#show_here").html(data); } }); }; $("#request_refresh").click(function(){ get_table_of_details("new_requests"); }); $(".clickable-row").click(function() { var r_id=$(this).attr("id"); var c_id=$(this).children("td.c_id").attr("id"); $(this).append("<form action='customer_profile.php' id='show_customer' method='post'><input type='hidden' name='request_id' value='"+r_id+"' /><input type='hidden' name='customer_id' value='"+c_id+"' /></form>"); $("#show_customer").submit(); }); </script>""" else: requests = no_found.no_found("We have not got any feedbacks, yet.") return requests except: return "-99"
def customer_card_exists(userid, card_no): conn, cursor = config.connect_to_database() sql = "select card_id from cards where card_no='%s' and c_id='%s'" % ( card_no, userid) try: cursor.execute(sql) return cursor.rowcount except: return -99 finally: conn.close()
def remove_test(testid): conn, cursor = config.connect_to_database() sql = "Delete from Tests where ID='%s'" % (testid) try: cursor.execute(sql) conn.commit() return "1" except: conn.rollback() return "-1" conn.close()
def delete_all_mess(c_id1): conn, cursor = config.connect_to_database() sql = "DELETE FROM chat where ToUserID='%s' and role='Institute'" % (c_id1) try: cursor.execute(sql) conn.commit() print("1") except: conn.rollback() print("-1") conn.close()
def delete_all_history(c_id1): conn, cursor = config.connect_to_database() sql = "DELETE FROM History where UserID='%s'" % (c_id1) try: cursor.execute(sql) conn.commit() print("1") except: conn.rollback() print("-1") conn.close()
def update_password(user, new_password): conn, cursor = config.connect_to_database() sql = "Update customers SET password='******' where email='%s'" % ( new_password, user) try: cursor.execute(sql) conn.commit() return "11" except: conn.rollback() return "0"
def delete_message(c_id1): conn, cursor = config.connect_to_database() sql = "DELETE FROM chat where ID='%s'" % (c_id1) try: cursor.execute(sql) conn.commit() print("1") except: conn.rollback() print("-1") conn.close()
def delete_offer_cand(c_id,inst_id,j_id,role): conn,cursor=config.connect_to_database() sql="delete from chat where FromUser='******' and ToUserID='%s' and Text='%s' and role='%s'"%(inst_id,c_id,j_id,role) try: cursor.execute(sql) conn.commit() print("11") except: conn.rollback() print("00") conn.close()
def remove_questions_of_test(testid): conn, cursor = config.connect_to_database() sql = "Delete from Questions where TestID='%s'" % (testid) try: cursor.execute(sql) conn.commit() print("1") except: conn.rollback() print("-1") conn.close()