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()
