def post(self): fid = self.get_argument('fid') result = mysql.delete('faculty', {'fid': fid}) result2 = mysql.delete('password', {'fid': fid}) if result and result2: response = {'status': 'ok'} else: response = {'status': 'error'} self.write(json_encode(response))
def post(self): desk = json_decode(self.get_argument('desk')) desk = desk.upper() data.update_desk() if desk in data.desks: path = os.path.dirname(__file__) + '/static/desks/' + desk + '.png' os.remove(path) data.desks.remove(desk) mysql.delete('desks', {'desk': desk}) response = {'status': 'ok'} self.write(json_encode(response))
def delete(table, row): if table not in ('comment', 'order_history', 'customer_history', 'cook_history', 'diet_stat', 'cook_stat'): return False try: th = row['th'] r.lrem(table, 0, th) r.delete('%s:%s' % (table, th)) mysql.delete(table, row) return True except Exception, e: logging.error(e) return False
def post(self): fid = self.get_argument('fid') name = self.get_argument('name') passwd = self.get_argument('passwd') role = json_decode(self.get_argument('role')) role = ','.join(role) result = mysql.insert('faculty', {'fid': fid, 'name': name, 'role': role}) result2 = mysql.insert('password', {'fid': fid, 'passwd': passwd}) if result and result2: response = {'status': 'ok'} else: mysql.delete('faculty', {'fid': fid}) mysql.delete('password', {'fid': fid}) response = {'status': 'error'} self.write(json_encode(response))
def post(self): did = int(json_decode(self.get_argument('did'))) res = mysql.get('diet', {'did': did}) if res and res[0]: picture = res[0]['picture'] full_path = os.path.join(os.path.dirname(__file__), 'static/pictures/' + picture) os.remove(full_path) mysql.delete('diet', {'did': did}) data.diet = mysql.get_all('diet') response = {'status': 'ok'} self.finish(json_encode(response)) return response = {'status': 'err'} self.finish(json_encode(response))
def post(self): cid = self.get_argument('cid') result = mysql.delete('category', {'cid': cid}) if result: logic.category.pop(cid) response = {'status': 'ok'} else: response = {'status': 'error'} self.write(json_encode(response))
def post(self): fid = json_decode(self.get_argument('fid')) res = mysql.delete('faculty', {'fid': fid}) if res: response = {'status': 'ok'} else: response = {'status': 'ok'} self.finish(json_encode(response))
def post(self): cid = json_decode(self.get_argument('cid')) con = {'cid': int(cid)} res = mysql.delete('category', con) if res: response = {'status': 'ok'} data.category = mysql.get_all('category') else: response = {'status': 'err'} self.finish(json_encode(response))
def post(self): fid = self.get_cookie('fid') content = json_decode(self.get_argument('content')) mysql.delete('cook_do', {'fid': fid}) flag = False for did in content: if did == 'all': flag = True break if flag: rows = [{'fid': fid, 'did': 'all'}] else: rows = [] for did in content: rows.append({'fid': fid, 'did': did}) result = mysql.insert_many('cook_do', rows) if result: logic.cooks.get(fid).cookdo = content response = {'status': 'ok', 'cookdo': content} else: response = {'status': 'error'} self.write(json_encode(response))
def post(self): printer = self.get_argument('printer') result = mysql.delete('printers', {'name': printer}) if result: #path = os.path.join(logic.data_dir, 'desks/' + desk) #os.remove(path) if printer in logic.printers: logic.printers.pop(printer) response = {'status': 'ok'} else: response = {'status': 'error'} self.write(json_encode(response))
def ins(self, ins): if ins[0] == '+': did = ins[1] if did not in self.content: result = mysql.insert('mask', {'did': did}) if result: self.content.add(did) elif ins[0] == '-': did = ins[1] if did in self.content: result = mysql.delete('mask', {'did': did}) if result: self.content.remove(did) self.stamp = time.time() self.set_future()
def post(self): desk = self.get_argument('desk') desk = desk.upper() result = mysql.delete('desks', {'desk': desk}) if desk in logic.desks: logic.desks.remove(desk) if desk in logic.tables: logic.tables.pop(desk) if result: #path = os.path.join(logic.data_dir, 'desks/' + desk) #os.remove(path) response = {'status': 'ok'} else: response = {'status': 'error'} self.write(json_encode(response))
def post(self): did = self.get_argument('did') if did in logic.diet: logic.diet.pop(did) result = mysql.get('diet', {'did': did}) if result and result[0]: picture = result[0]['pic'] full_path = os.path.join(logic.data_dir, 'pictures/' + picture) if mysql.delete('diet', {'did': did}) and picture != '': if os.path.isfile(full_path): os.remove(full_path) response = {'status': 'ok'} self.finish(json_encode(response)) return response = {'status': 'error'} self.finish(json_encode(response))
def delete(table, row): if table in ('diet', 'category', 'faculty'): mysql.delete(table, row) else: myredis.delete(table, row)
def delete(self): ''' Delete the user form the db. ''' logging.debug("Deleting user: %s" % self.name) return Mysql.delete('users', self.id)
def delete(self): ''' Delete a rule from the database ''' logging.debug("Deleting rule: %s" % self.id) return Mysql.delete('inbound_rules', self.id)
def delete(table, con): if mysql.delete(table, con): return True return False
def delete(self): ''' Delete the alert form the db. ''' logging.debug("Deleting alert: %s" % self.id) return Mysql.delete('alerts', self.id)
def delete(self): ''' Delete the team form the db. ''' logging.debug("Deleting team: %s" % self.name) return Mysql.delete('teams', self.id)
import mysql print mysql.delete('category', {'cid': 1}).rowcount print mysql.delete_all('category').rowcount print mysql.delete('diet', {'did': 1}).rowcount print mysql.delete_all('diet').rowcount print mysql.delete_all('faculty').rowcount print mysql.delete_all('order_history').rowcount print mysql.delete_all('cook_history').rowcount print mysql.delete_all('feedback').rowcount print mysql.delete_all('stat_week').rowcount print mysql.delete_all('stat_month').rowcount
def delete(self): ''' Delete the notificaion form the db. ''' logging.debug("Deleting notification: %s" % self.id) return Mysql.delete('notifications', self.id)