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)
