def put(self, id): now = datetime.now() data = request.get_json() sql = """update materi set uuid_kelas = %s, uuid_mapel = %s, materi = %s, isi = %s, link = %s, updated_at = %s where uuid = %s""" params = [data["uuid_kelas"], data["uuid_mapel"], data["materi"], data["isi"], data["link"], now, id] db.commit_data(sql, params)
def putBioUser(id, nama, jk, alamat, tanggal_lahir, tempat_lahir, hp, email, now): sql = """update bio_user set nama = %s, jk = %s, alamat = %s, tanggal_lahir = %s, tempat_lahir = %s, hp = %s, email = %s, updated_at = %s where uuid = %s""" params = [ nama, jk, alamat, tanggal_lahir, tempat_lahir, hp, email, now, id ] db.commit_data(sql, params)
def delete(self, id): sql = """delete from peminjam where id = %s""" if checkPengembalian(id) > exp: hasil = db.commit_data(sql, [id]) hasil['msg'] = 'Denda Rp.3000.00' return hasil return db.commit_data(sql, [id])
def put(self, id): data = request.get_json() if verifyPassword(id, data["password_lama"]): sql = """update user set password = %s where uuid = %s""" db.commit_data(sql, [sha256.hash(data["password_baru"]), id]) return {"msg": "Sukses"} else: return {"msg": "Maaf"}
def postSoal(uuid, uuid_kelas, uuid_mapel, materi, soal, kunci, skor, now, uuid_user): sql = """insert into soal values(0,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)""" params = [ uuid, uuid_kelas, uuid_mapel, materi, soal, kunci, skor, False, now, now, uuid_user ] db.commit_data(sql, params)
def put(self, uuid_materi): now = datetime.now() data = request.get_json() for i in data: updateSoal(i["uuid"], i["soal"], i["opsi"][0]["value"], now) db.commit_data("""delete from mc_soal where uuid_soal = %s""", [i["uuid"]]) for j in i["opsi"]: updateMC(i["uuid"], j["value"])
def put(self, id): data = request.get_json() if checkingUser(data["username"]): if verifyPassword(id, data["password"]): sql1 = """update user set username = %s where uuid = %s""" db.commit_data(sql1, [data["username"], id]) sql2 = """update bio_user set username = %s where uuid_user = %s""" db.commit_data(sql2, [data["username"], id]) return {"msg": "Sukses"} else: return {"msg": "Salah"} else: return {"msg": "Maaf"}
def post(self, uuid_materi): now = datetime.now() data = request.get_json() skor = 0 user = getUser(uuid_materi) for i in data["hasil"]: jawaban = cekJawaban(uuid_materi, i["uuid"], i["jawaban"]) if jawaban["jawaban"]: skor += jawaban["skor"] sql = """insert into skor values(0,%s,%s,%s,%s,%s,%s,%s,%s)""" params = [ str(uuid.uuid4()), data["uuid_siswa"], user["uuid_kelas"], user["uuid_mapel"], uuid_materi, user["uuid_user"], skor, now ] db.commit_data(sql, params)
def put(self,id): """ Mengganti buku """ data = request.get_json() sql = """update list_buku set kode = %s, judul = %s, genre = %s, penulis = %s, ringkasan = %s, penerbit = %s, isbn = %s, updated_at = %s where id = %s""" params = [data["kode"],data["judul"],data["genre"],data["penulis"],data["ringkasan"],data["penerbit"],data["isbn"],datetime.now(),id] return db.commit_data(sql,params)
def post(self, uuid_user): now = datetime.now() data = request.get_json() user = getUser(uuid_user) sql = """insert into materi values(0,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)""" params = [str(uuid.uuid4()), user["nama"], data["uuid_kelas"], data["uuid_mapel"], data["materi"], data["isi"], data["link"], now, now, uuid_user] return db.commit_data(sql, params)
def postBioUser(uuid, nama, username, jk, alamat, tempat_lahir, tanggal_lahir, hp, email, now, uuid_user): sql = """insert into bio_user values(0,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)""" params = [ uuid, nama, username, jk, alamat, tempat_lahir, tanggal_lahir, hp, email, now, now, uuid_user ] return db.commit_data(sql, params)
def post(self): data = request.get_json() sql = """insert into user values(0,%s,%s,%s,%s,%s,%s)""" return db.commit_data(sql, [ data['nama'], data['username'], sha256.hash(data['password']), data['alamat'], data['t_lahir'], data['jl'] ])
def put(self, id): now = datetime.now() data = request.get_json() sql = """select uuid_user from bio_user where uuid = %s""" id_user = db.get_one(sql, [id])["uuid_user"] tanggal_lahir = stringTime(data["tanggal_lahir"]) putBioUser(id, data["nama"], data["jk"], data["alamat"], tanggal_lahir, data["tempat_lahir"], data["hp"], data["email"], now) putUser(id_user, data["superadmin"], now) if len(data["ampu"]) > 0: db.commit_data("""delete from pengampu where uuid_user = %s""", [id_user]) for i in data["ampu"]: putPengampu(id_user, i["uuid_kelas"], i["uuid_mapel"], now) else: db.commit_data("""delete from pengampu where uuid_user = %s""", [id_user])
def post(self): """ Menambahkan buku """ now = datetime.now() data = request.get_json() sql = """insert into list_buku values(0,%s,%s,%s,%s,%s,%s,%s,%s,%s)""" params = [data["kode"],data["judul"],data["genre"],data["penulis"],data["ringkasan"],data["penerbit"],data["isbn"],now,now] return db.commit_data(sql,params)
def post(self): now = datetime.now() stor = now + exp data = request.get_json() if checkAnggota(int(data['no_anggota'])) == None and checkBuku( data['kode_buku']) == None: return { 'msg': 'Nomor anggota atau kode buku yang anda masukkan tidak terdaftar' } sql = """insert peminjam values (0,%s,%s,%s,%s,%s)""" params = [int(data["no_anggota"]), data["kode_buku"], stor, now, now] return db.commit_data(sql, params)
def post(self): datetime_now = datetime.now() data = request.get_json() try: if checkingUser(data["username"]) == None: sql = """insert user values (0, %s,%s,%s,%s,%s,%s)""" params = [ data["nama"], data["username"], data["email"], sha256.hash(data["password"]), datetime_now, datetime_now ] return db.commit_data(sql, params) return {"msg": "user exist"} except Exception as e: app.logger.error(e) return {"msg": "ups, something wrong"}, 500
def save_blacklist_token(jti): sql = """insert into black_list_token values(0,%s)""" return db.commit_data(sql, [jti])
def delete(self, uuid_kelas): sql = """delete from kelas where uuid = %s""" db.commit_data(sql, [uuid_kelas])
def put(self, uuid_kelas): data = request.get_json() sql = """update kelas set kelas = %s, label = %s where uuid = %s""" db.commit_data(sql, [data["kelas"], data["label"], uuid_kelas])
def post(self): data = request.get_json() uuid_kelas = str(uuid.uuid4()) sql = """insert into kelas values(0,%s, %s, %s)""" db.commit_data(sql, [uuid_kelas, data["kelas"], data["label"]])
def deletePengampu(id): sql = """delete from pengampu where uuid_user = %s""" db.commit_data(sql, [id])
def deleteBioUser(id): sql = """delete from bio_user where uuid = %s""" db.commit_data(sql, [id])
def putPengampu(uuid_user, uuid_kelas, uuid_mapel, now): sql = """insert into pengampu values(0,%s,%s,%s,%s)""" params = [uuid_user, uuid_kelas, uuid_mapel, now] return db.commit_data(sql, params)
def putUser(id_user, superadmin, now): sql = """update user set superadmin = %s, updated_at = %s where uuid = %s""" db.commit_data(sql, [superadmin, now, id_user])
def deleteSoal(uuid_soal): db.commit_data("""delete from soal where uuid = %s""", [uuid_soal])
def postUser(uuid_user, username, password, superadmin, now): sql = """insert into user values(0,%s,%s,%s,%s,%s,%s)""" params = [uuid_user, username, password, superadmin, now, now] return db.commit_data(sql, params)
def deleteMC(uuid_soal): db.commit_data("""delete from mc_soal where uuid_soal = %s""", [uuid_soal])
def saveBlacklistToken(jti): sql = """insert into blacklist_token values(0, %s)""" db.commit_data(sql, [jti])
def delete(self, id): sql = """delete from materi where uuid = %s""" db.commit_data(sql, [id])
def put(self, id): now = datetime.now() data = request.get_json() sql = """update peminjam set nama = %s, buku = %s, created_at = %s, updated_at = %s""" params = [data["nama"], data["buku"], now, now] return db.commit_data(sql, params)