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