def urun_katagori():
#https://stackoverflow.com/questions/3286525/return-sql-table-as-json-in-python
firma = current_user.firma
cur = query_db(
"select deger as katagori from firma_data where anahtar='menu_katagori' and firma=?",
(firma, ), True) or {}
return success_request('urun katagori listesi', dict(cur))
def menu_item(id):
firma = current_user.firma
data = query_db('select * from "urun" where firma=? and urun= ?',
(firma, id), True) or {}
return success_request('Urun bilgisi.', dict(data))
def menu_items():
firma = current_user.firma
data = query_db('select * from "urun" where firma=?', (firma, )) or {}
return success_request('Urun listesi', [dict(ixd) for ixd in data])
def personel(id):
firma = current_user.firma
data = query_db('select * from "uye" where firma=? and uye= ?',
(firma, id), True) or {}
return success_request('Personel bilgisi.', dict(data))
def personeller():
firma = current_user.firma
data = query_db('select * from "uye" where firma=?', (firma, )) or {}
return success_request('Personel listesi', [dict(ixd) for ixd in data])
def menu_item():
firma = current_user.firma
data = query_db('select * from "urun" where firma=?', (firma, )) or {}
return success_request(
'urun listesi',
[dict(ix) for ix in data] if isinstance(data, list) else [dict(data)])