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)
