def read(): try: session = sessionFactory() for akun in session.query(AkunOrm).all(): print("ID = {}, Nama = {}, Password = {}, Email = {},".format( akun.id, akun.nama, akun.password, akun.email)) except Exception as e: print("Error -->", e)
def __init__(self, nama_nasabah, tanggal, jumlah_simpan, jumlah_pinjam): session = sessionFactory() self.nama_nasabah = nama_nasabah self.tanggal = tanggal self.jumlah_simpan = jumlah_simpan self.jumlah_pinjam = jumlah_pinjam session.add(self) session.commit() session.close()
def insert(self): try: session = sessionFactory() session.add(self) session.commit() session.close() except Exception as salah: print("Error -->", salah) else: print("Insert Berhasil")
def insertSimpanPinjam(self): try: session = sessionFactory() session.add(self) session.commit() session.close() except Exception as e: print("===>", e) else: print("Data telah Disimpan!")
def deleteBarang(id_barang): try: session = sessionFactory() session.query(BarangORM).filter_by(id_barang=id_barang).delete() session.commit() session.close() except Exception as e: print("===>", e) else: print("Data terlah terhapus!")
def deleteNasabah(id_nasabah): try: session = sessionFactory() session.query(NasabahORM).filter_by(id_nasabah=id_nasabah).delete() session.commit() session.close() except Exception as e: print("===>", e) else: print("Data terlah terhapus!")
def DataSupplier(): try: session = sessionFactory() for supplier in session.query(SupplierORM).all(): print( "Id supplier = {}\nNama = {}\nNo Telp = {}\nAlamat = {}\n====================" .format(supplier.id_supplier, supplier.nama_supplier, supplier.no_telp, supplier.alamat_supplier)) session.close() except Exception as e: print("===>", e)
def DataNasabah(): try: session = sessionFactory() for nasabah in session.query(NasabahORM).all(): print( "Id nasabah = {}\nNama = {}\nAlamat = {}\nNo Telp = {}\n====================" .format(nasabah.id_nasabah, nasabah.nama_nasabah, nasabah.alamat, nasabah.no_telp)) session.close() except Exception as e: print("===>", e)
def login(self): session = sessionFactory() query = session.query(AkunOrm).filter_by(nama=self.__userLogin).first() if query != None: print('suxxx') if query.nama == self.__userLogin and query.password == self.__passwordLogin: self.setStatusLogin(True) else: print('Email %s not found' % (self.__userLogin)) self.setStatusLogin(False) print(self.__statusLogin)
def insertBarang(self): try: session = sessionFactory() barang = BarangORM(self.nama_barang, self.__jumlah_barang, self.__harga_barang) session.add(barang) session.commit() session.close() except Exception as e: print("===>", e) else: print("Data telah Disimpan!")
def deleteSupplier(id_supplier): try: session = sessionFactory() session.query(SupplierORM).filter_by( id_supplier=id_supplier).delete() session.commit() session.close() except Exception as e: print("===>", e) else: print("Data terlah terhapus!")
def insertSupplier(self): try: session = sessionFactory() supplier = SupplierORM(self.__nama_supplier, self.__no_telp, self.__alamat_supplier) session.add(supplier) session.commit() session.close() except Exception as e: print("===>", e) else: print("Data telah Disimpan!")
def insertNasabah(self): try: session = sessionFactory() nasabah = NasabahORM(self.__nama_nasabah, self.__alamat, self.__no_telp) session.add(nasabah) session.commit() session.close() except Exception as e: print("===>", e) else: print("Data telah Disimpan!")
def updateSimpanPinjam(ID, newNama, newTanggal, newSimpan, newPinjam): session = sessionFactory() session.query(SimpanPinjamORM).filter_by(id_nasabah=ID).update( { SimpanPinjamORM.nama_nasabah: newNama, SimpanPinjamORM.tanggal: newTanggal, SimpanPinjamORM.jumlah_simpan: newSimpan, SimpanPinjamORM.jumlah_pinjam: newPinjam }, synchronize_session=False) session.commit() session.close() pass
def updateGudang(id_barang, newNama_produk, newJumlah_barang, newLokasi, newTanggal_masuk, newHarga_barang): session = sessionFactory() session.query(GudangORM).filter_by(id_barang=id_barang).update( { GudangORM.nama_produk: newNama_produk, GudangORM.jumlah_barang: newJumlah_barang, GudangORM.lokasi: newLokasi, GudangORM.tanggal_masuk: newTanggal_masuk, GudangORM.harga_barang: newHarga_barang, }, synchronize_session=False) session.commit() session.close() pass
def updateBarang(id_barang): try: newNama_produk = input("Masukkan Nama Produk : ") newJumlah_barang = input("Jumlah Barang : ") newHarga_barang = input("Harga Barang : ") session = sessionFactory() session.query(BarangORM).filter_by(id_barang=id_barang).update({ BarangORM.jumlah_barang: newJumlah_barang, BarangORM.nama_produk: newNama_produk, BarangORM.harga_barang: newHarga_barang }, synchronize_session=False) session.commit() session.close() except Exception as e: print("===>", e) else: print("Data telah Terupdate!")
def updateNasabah(id_nasabah): try: newNama = input("Nama Nasabah : ") newAlamat = input("Alamat Nasabah : ") newNotelp = input("No Telp Nasabah: ") session = sessionFactory() session.query(NasabahORM).filter_by(id_nasabah=id_nasabah).update( { NasabahORM.nama_nasabah: newNama, NasabahORM.alamat: newAlamat, NasabahORM.no_telp: newNotelp }, synchronize_session=False) session.commit() session.close() except Exception as e: print("===>", e) else: print("Data telah Terupdate!")
def updateSupplier(id_supplier): try: newNama = input("Nama Supplier : ") newNotelp = input("No Telp Supplier: ") newAlamat = input("Alamat Supplier : ") session = sessionFactory() session.query(SupplierORM).filter_by( id_supplier=id_supplier).update( { SupplierORM.nama_supplier: newNama, SupplierORM.no_telp: newNotelp, SupplierORM.alamat_supplier: newAlamat }, synchronize_session=False) session.commit() session.close() except Exception as e: print("===>", e) else: print("Data telah Terupdate!")
def updateSimpanPinjam(id_nasabah): try: newIdNasabah = input("Id Nasabah : ") newTanggal = input("Tanggal : ") newSimpan = input("Simpanan : ") newPinjam = input("Pinjaman : ") session = sessionFactory() session.query(SimpanPinjamORM).filter_by( id_nasabah=id_nasabah).update( { SimpanPinjamORM.id_nasabah: newIdNasabah, SimpanPinjamORM.tanggal: newTanggal, SimpanPinjamORM.jumlah_simpan: newSimpan, SimpanPinjamORM.jumlah_pinjam: newPinjam }, synchronize_session=False) session.commit() session.close() except Exception as e: print("===>", e) else: print("Data telah Terupdate!")
def delSijam(id): session = sessionFactory() session.query(SimpanPinjamORM).filter_by(id_nasabah=id).delete() session.commit() session.close()
def dataBarang(): session = sessionFactory() return session.query(BarangORM).all() session.close()
def showSijam(): session = sessionFactory() return session.query(SimpanPinjamORM).all()
def dataSijam(): session = sessionFactory() return session.query(SimpanPinjamORM).all() session.close()