def login(self, nama, email, password): connection = DBConnect() query = "SELECT * from "+self.table + \ " WHERE nama= '%s' and email= '%s' and password = '******'" % ( nama, email, password) result = connection.executeRead(query) if not result: return True else: return False
def order(self, table, col, urutan): if urutan == 1: x = 'ASC' else: x = 'DESC' connection = DBConnect() query = "SELECT * from " + table + " ORDER BY " + col + ' ' + x # print(query) result = connection.executeRead(query) print(result)
def __init__(self, inputEmail=None): super().__init__("santri", [ "nama", "email", "password", "alamat", "no_hp", "perguruan_tinggi", "prodi", "kamar_id"]) # variable privet if inputEmail == None: pass else: self.__email = inputEmail connection = DBConnect() query = "SELECT password FROM " + self.table + \ " WHERE email='%s'" % (self.__email) result = connection.executeRead(query) self.__password = result[0][0]
def jadwalDewe(self, ustad_id): connection = DBConnect() query = "SELECT * from " + "jadwal" + \ " WHERE ustad_id= '%s'" % (ustad_id) result = connection.executeRead(query) # print(result) p = PrettyTable() x = [] x.append('id') for column in self.column: x.append(column) p.field_names = x for row in result: listRow = list(row) listRow.pop(len(listRow)-1) listRow.pop(len(listRow)-1) p.add_row(listRow) print(p)
def read(self, role=None): connection = DBConnect() query = "SELECT * from " + self.table result = connection.executeRead(query) p = PrettyTable() x = [] if role == None: x.append('id') for column in self.column: x.append(column) p.field_names = x for row in result: listRow = list(row) listRow.pop(len(listRow) - 1) listRow.pop(len(listRow) - 1) if role != None: listRow.pop(0) p.add_row(listRow) print(p)
def search(self, value): connection = DBConnect() query = "SELECT * from " + self.table + " WHERE " for i in range(len(self.column)): query += self.column[ i] + " LIKE " + "'" + "%" + value + "%" + "'" + " OR " query = query[:-3] # print(query) result = connection.executeRead(query) p = PrettyTable() x = [] x.append('id') for column in self.column: x.append(column) p.field_names = x for row in result: listRow = list(row) listRow.pop(len(listRow) - 1) listRow.pop(len(listRow) - 1) p.add_row(listRow) print(p)
def getID(self, email): connection = DBConnect() query = "SELECT * from " + self.table + " WHERE email= '%s'" % (email) result = connection.executeRead(query) return result[0][0]
def __call__(self, email): connection = DBConnect() query = "SELECT * from santri WHERE email= '%s'" % (email) result = connection.executeRead(query) print("Kamar dengan ID", str(result[0][8]), "Telah Melakukan Absen Jaga Pos")
def getID(cls, email): connection = DBConnect() query = "SELECT * from santri WHERE email= '%s'" % (email) result = connection.executeRead(query) # print(result) return str(result[0][8])
def getID(self): connection = DBConnect() query = "SELECT * from "+self.table + \ " WHERE email= '%s'" % (self.__email) hasil = connection.executeRead(query) return hasil[0][0]
def getID(judul): connection = DBConnect() query = "SELECT * from kitab WHERE judul= '%s'" % (judul) result = connection.executeRead(query) return result[0][0]