def hapusLomba(): with Lomba() as c_lomba: data = request.get_json() id_lomba = data["id_lomba"] res = c_lomba.hapusLomba(id_lomba) if res: return jsn(1,"") else: return jsn(0,"")
def getPendaftar(): with Lomba() as lomba: rj = request.get_json() resp, nama_lomba = lomba.getPendaftar(str(rj['id_lomba'])) list_info = [{ "id_adm": res[0], "id_ketua": res[1], "nama_tim": res[2] } for res in resp] return jsonify(list=list_info, id_lomba=rj['id_lomba'], nama_lomba=nama_lomba)
def getLombaSaya(): with Lomba() as c_lomba: data = request.get_json() id_user = data["id_anggota"] resp = c_lomba.getLombaSaya(id_user) list_lomba = [{ "id_adm": res[0], "id_lomba": res[1], "nama_lomba": res[2], "deadline": res[3], "nama_tim": res[4], "id_pembuat": res[5] } for res in resp] return jsonify(list_lomba)
def buatLomba(): with Lomba() as c_lomba: data = request.get_json() nama_lomba = data["nama_lomba"] deskripsi = data["deskripsi"] tanggal_dibuat = data["tanggal_dibuat"] tanggal_mulai = data["tanggal_mulai"] tanggal_ditutup = data["tanggal_ditutup"] tempat = data["tempat"] biaya = data["biaya"] id_user = data["id_user"] res = c_lomba.buatLomba(self, nama_lomba, deskripsi, tanggal_dibuat, tanggal_mulai, tanggal_ditutup, tempat, biaya, id_user) if res: return jsn(1,"") else: return jsn(0,"")
def buatLomba(): with Lomba() as c_lomba: data = request.get_json() nama_lomba = data["nama_lomba"] deskripsi = data["deskripsi"] tanggal_mulai = data["tanggal_mulai"] tanggal_ditutup = data["tanggal_ditutup"] tempat = data["tempat"] biaya = data["biaya"] max_anggota = data["max_anggota"] kategori = data["kategori"] id_user = data["id_user"] aturan = data["aturan"] hadiah = data["hadiah"] res = c_lomba.buatLomba(nama_lomba, deskripsi, tanggal_mulai, tanggal_ditutup, tempat, biaya, max_anggota, kategori, id_user, aturan, hadiah) return jsn(1, "sukses") if res == "sukses" else jsn(0, res)
def getLombaId(): with Lomba() as lomba: data = request.get_json() id_user = data["id_user"] resp = lomba.getLombaId(id_user) list_lomba = [{ "id_lomba": res[0], "nama_lomba": res[1], "deskripsi": res[2], "tanggal_dibuat": res[3], "tanggal_mulai": res[4], "tanggal_ditutup": res[5], "tempat": res[6], "biaya": res[7], "id_user": res[8], "max_anggota": res[9], "kategori": res[10], "aturan": res[11], "hadiah": res[12] } for res in resp] return jsonify(list_lomba)
def getLomba(): with Lomba() as lomba: resp = lomba.getLomba() list_lomba = [{ "id_lomba": res[0], "nama_lomba": res[1], "deskripsi": res[2], "tanggal_dibuat": res[3], "tanggal_mulai": res[4], "tanggal_ditutup": res[5], "tempat": res[6], "biaya": res[7], "id_user": res[8], "max_anggota": res[9], "kategori": res[10], "aturan": res[11], "hadiah": res[12], "nama_user": res[14], "email": res[16], "no_hp": res[22] } for res in resp] return jsonify(list_lomba)
def hapusLomba(): with Lomba() as c_lomba: res = c_lomba.hapusLomba(request.get_json()["id_lomba"]) return jsn(1, "sukses") if res == "sukses" else jsn(0, res[0])