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)])