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!")