def updatePasien(idPasien):
try:
newNama = input("Masukkan Nama Baru: ")
newalamat = input("Masukkan Alamat Baru: ")
newjenisKelamin = input("Masukkan Jenis Kelamin Baru: ")
newNoTelp = input("Masukkan No Telp Baru: ")
newnoKk = input("Masukkkan noKK Baru")
newNoKtp = input("Masukkan No KTP")
session = sessionFactory()
session.query(PasienOrm).filter_by(id=idPasien).update(
{
PasienOrm.namaPasien: newNama,
PasienOrm.alamatPasien: newalamat,
PasienOrm.jenisKelamin: newjenisKelamin,
PasienOrm.noTelpPasien: newNoTelp,
PasienOrm.noKk: newnoKk,
PasienOrm.noKtp: newNoKtp
},
synchronize_session=False)
session.commit()
session.close()
except Exception as e:
print("===>", e)
else:
print("Data Berhasil DiUpdate!")
def insertDokter(dokter):
session = sessionFactory()
dokterOrm = DokterOrm(dokter.nama, dokter.alamat, dokter.jenisKelamin,
dokter.noTelp, dokter.tglLahir, dokter.spesialis)
session.add(dokterOrm)
session.commit()
session.close()
def insertApoteker(apoteker):
session = sessionFactory()
apotekerOrm = ApotekerOrm(apoteker.nama, apoteker.alamat,
apoteker.jenisKelamin, apoteker.noTelp,
apoteker.tglLahir, apoteker.nip)
session.add(apotekerOrm)
session.commit()
session.close()
def findHakAkses(username):
try:
session = sessionFactory()
for user in session.query(UserOrm).filter_by(username=username):
return user.hak_akses
session.close()
except Exception as e:
print("===>", e)
def insertPasien(pasien):
session = sessionFactory()
pasienOrm = PasienOrm(pasien.nama, pasien.alamat, pasien.jenisKelamin,
pasien.noTelp, pasien.tglLahir, pasien.noKK,
pasien.noKtp)
session.add(pasienOrm)
session.commit()
session.close()
def deleteObat(idObat):
try:
session = sessionFactory()
session.query(ObatOrm).filter_by(id=idObat).delete()
session.commit()
session.close()
except Exception as e:
print("===>", e)
else:
print("Data Berhasil Dihapus!")
def deleteDokter(idApoteker):
try:
session = sessionFactory()
session.query(ApotekerOrm).filter_by(id=idApoteker).delete()
session.commit()
session.close()
except Exception as e:
print("===>", e)
else:
print("Data Berhasil Dihapus!")
def showObat():
try:
session = sessionFactory()
for obat in session.query(ObatOrm).all():
print(
"Id Obat = {}\nJenis Obat = {}\nNama Obat = {}\n=============="
.format(obat.id, obat.jenisObat, obat.namaObat))
session.close()
except Exception as e:
print("===>", e)
def deleteUser(username):
try:
session = sessionFactory()
session.query(UserOrm).filter_by(username=username).delete()
session.commit()
session.close()
except Exception as e:
print("===>", e)
else:
print("Data Berhasil Dihapus!")
def deleteBuku(buku):
try:
session = sessionFactory()
session.query(buku).filter_by(id_buku=buku).delete()
session.commit()
session.close()
except Exception as k:
print("->", k)
else:
print("buku berhasih dihapus!!!")
def showDokterIdNama():
try:
session = sessionFactory()
result = []
for dokter in session.query(DokterOrm).all():
result.append([str(dokter.id), str(dokter.namaDokter)])
return result
session.close()
except Exception as e:
print("===>", e)
def showInventarisObat():
try:
session = sessionFactory()
for inv in session.query(InventarisObatOrm).all():
print(
"Id = {}\nId Obat = {}\nStock = {}\nTgl Exp = {}\nHarga = {}\nLokasi Obat = {}"
.format(inv.id, inv.idObat, inv.stockObat, inv.expObat,
inv.hargaObat, inv.lokasi))
except Exception as e:
print("===>", e)
def showPasienIdNama():
try:
session = sessionFactory()
result = []
for pasien in session.query(PasienOrm).all():
result.append([str(pasien.id), str(pasien.namaPasien)])
return result
session.close()
except Exception as e:
print("===>", e)
def insertInvenObat(inventarisObat):
session = sessionFactory()
inventarisObatOrm = InventarisObatOrm(inventarisObat.idobat,
inventarisObat.stockObat,
inventarisObat.expObat,
inventarisObat.hargaObat,
inventarisObat.lokasi)
session.add(inventarisObatOrm)
session.commit()
session.close()
def showPasien():
try:
session = sessionFactory()
for bpjs in session.query(BpjsOrm).all():
print("No Kartu = {}\nKelas Fasilitas = {}\nNama Peserta = {}"
"\n====================".format(bpjs.kodeKartu,
bpjs.kelasFasilitas,
bpjs.namaPeserta))
session.close()
except Exception as e:
print("===>", e)
def verifyUser(username, password) -> bool:
try:
session = sessionFactory()
if ((session.query(UserOrm).filter_by(
username=username, password=password).count()) == 1):
return True
else:
return False
session.close()
except Exception as e:
print("===>", e)
def updateUserPass(idUser):
try:
newPassword = input("Masukkan Password Baru: ")
session = sessionFactory()
session.query(UserOrm).filter_by(id=idUser).update(
{UserOrm.password: newPassword}, synchronize_session=False)
session.commit()
except Exception as e:
print("===>", e)
else:
print("Data Berhasil DiUpdate!")
def verifyPeserta(kodeKartu) -> bool:
try:
session = sessionFactory()
if ((session.query(BpjsOrm).filter_by(
kodeKartu=kodeKartu).count()) == 1):
return True
else:
return False
session.close()
except Exception as e:
print("===>", e)
def insertRekamMedis(RekamMedis, idPasien, idPenyakit, idResep):
try:
session = sessionFactory()
rekamMedis = RekamMedisOrm(RekamMedis.tglRekamMedis, idPasien,
idPenyakit, idResep)
session.add(rekamMedis)
session.commit()
session.close()
except Exception as e:
print("===>", e)
else:
print("Data Berhasil Disimpan!")
def showPenyakit():
try:
session = sessionFactory()
for penyakit in session.query(PenyakitOrm).all():
print(
"Id Penyakit = {}\nKode Penyakit = {}\nKelompok Penyakit = {}"
"\nNama Penyakit= {}\nGejala = {}\n===================="
.format(penyakit.id, penyakit.kodePenyakit, penyakit.kelompokPenyakit,
penyakit.namaPenyakit, penyakit.gejala))
session.close()
except Exception as e:
print("===>", e)
def insertTransaksi(Transaksi, idResep):
try:
session = sessionFactory()
transaksiOrm = TransaksiOrm(Transaksi.tglTransaksi,
Transaksi.besarTransaksi, idResep)
session.add(transaksiOrm)
session.commit()
session.close()
except Exception as e:
print("===>", e)
else:
print("Data Berhasil Disimpan!")
def showTransaksi():
try:
session = sessionFactory()
for transaksi in session.query(TransaksiOrm).all():
print(
"Id Obat = {}\nTgl Transaksi = {}\nBesar Transaksi = {}\n"
"Id Resep = {}\n==============".format(
transaksi.id, transaksi.tglTransaksi,
transaksi.besarTransaksi, transaksi.idResep))
session.close()
except Exception as e:
print("===>", e)
def insertPasien(bpjs):
try:
session = sessionFactory()
bpjsOrm = BpjsOrm(bpjs.kodeKartu, bpjs.kelasFasilitas,
bpjs.namaPeserta)
session.add(bpjsOrm)
session.commit()
session.close()
except Exception as e:
print("===>", e)
else:
print("Data Berhasil Disimpan!")
def insertPenyakit(penyakit):
try:
session = sessionFactory()
penyakitOrm = PenyakitOrm(penyakit.kodePenyakit, penyakit.kelompokPenyakit,
penyakit.namaPenyakit, penyakit.gejala)
session.add(penyakitOrm)
session.commit()
session.close()
except Exception as e:
print("===>", e)
else:
print("Data Berhasil Disimpan!")
def showPasien():
try:
session = sessionFactory()
for pasien in session.query(PasienOrm).all():
print(
"Id Pasien = {}\nNama = {}\nAlamat = {}\nJenis Kelamin= {}\nNo Telp = {}\nTgl Lahir = {}"
"\nNo KK = {}\nNo KTP = {}\n====================".format(
pasien.id, pasien.namaPasien, pasien.alamatPasien,
pasien.jenisKelamin, pasien.noTelpPasien,
pasien.tglLahir, pasien.noKk, pasien.noKtp))
session.close()
except Exception as e:
print("===>", e)
def showDokter():
try:
session = sessionFactory()
for dokter in session.query(DokterOrm).all():
print(
"Id Pasien = {}\nNama = {}\nAlamat = {}\nJenis Kelamin= {}"
"\nNo Telp = {}\nTgl Lahir = {}\nSpesialis = {}\n===================="
.format(dokter.id, dokter.namaDokter, dokter.alamatDokter,
dokter.jenisKelamin, dokter.noTepDokter,
dokter.tglLahir, dokter.spesialis))
session.close()
except Exception as e:
print("===>", e)
def showRekamMedis():
try:
session = sessionFactory()
for rekamMedis in session.query(RekamMedisOrm).all():
print("Id Obat = {}\nTgl RekamMedis = {}\nid Pasien = {}\n"
"Id Penyakit = {}\nId Resep = {}"
"\n==============".format(rekamMedis.id,
rekamMedis.tglRekamMedis,
rekamMedis.idPasien,
rekamMedis.idPenyakit,
rekamMedis.idResep))
session.close()
except Exception as e:
print("===>", e)
def showApoteker():
try:
session = sessionFactory()
for apoteker in session.query(ApotekerOrm).all():
print(
"Id Apoteker = {}\nNama = {}\nAlamat = {}\nJenis Kelamin= {}\n"
"No Telp = {}\nTgl Lahir = {}\nNIP = {}\n===================="
.format(apoteker.id, apoteker.namaApeteker,
apoteker.alamatApoteker, apoteker.jenisKelamin,
apoteker.noTelpApoteker, apoteker.tglLahir,
apoteker.NIP))
session.close()
except Exception as e:
print("===>", e)
def showUser():
try:
session = sessionFactory()
result = []
for user in session.query(UserOrm).all():
result.append([
str(user.id),
str(user.username),
str(user.password),
str(user.hak_akses)
])
return result
session.close()
except Exception as e:
print("===>", e)
def updateObat(idObat):
try:
newJenisObat = input("Masukkan jenis Obat Baru: ")
newnamaObat = input("Masukkan nama Obat Baru: ")
session = sessionFactory()
session.query(ObatOrm).filter_by(id=idObat).update(
{
ObatOrm.jenisObat: newJenisObat,
ObatOrm.namaObat: newnamaObat
},
synchronize_session=False)
session.commit()
session.close()
except Exception as e:
print("===>", e)
else:
print("Data Berhasil DiUpdate!")
