def read_all(): klanten = [] sql = "SELECT Klantnummer, Naam, Type, Gemeente, Saldo FROM artemis.tblklanten" rows = Database.get_rows(sql) if not (rows is None): for row in rows: # mapping naar object klanten.append(KlantRepository.map_to_object(row)) return klanten
def read_all(): categories = [] sql = "SELECT Klantnummer, Naam, Type, Gemeente, Saldo FROM artemis.tblklanten" rows = Database.get_rows(sql) if rows is not None: for row in rows: # mapping naar object categories.append(KlantRepository.map_to_object(row)) return categories
def read_all(): categories = [] sql = "SELECT Categorienummer, Categorienaam, " sql += "Bijschrijving FROM artemis.tblcategorieen" rows = Database.get_rows(sql) if not (rows is None): for row in rows: # mapping naar object categories.append(CategorieRepository.map_to_object(row)) return categories
def read_all(): result = [] sql = "SELECT * FROM artemis.tblorderinformatie" rows = Database.get_rows(sql) if rows is not None: for row in rows: # mapping naar object result.append(OrderinformatieRepository.map_to_object(row)) return result
def read_all(): result = [] sql = "SELECT * FROM vliegtuigen.tblwerknemer" rows = Database.get_rows(sql) if rows is not None: for row in rows: # mapping naar object result.append(WerknemerRepository.map_to_object(row)) return result
def read_all(): result = [] sql = "SELECT * FROM vliegtuigen.tblhuidigeprijssetting" rows = Database.get_rows(sql) if rows is not None: for row in rows: # mapping naar object result.append(HuidigeprijssettingRepository.map_to_object(row)) return result
def read_all(): result = [] sql = "SELECT * FROM artemis.tblleveranciers" rows = Database.get_rows(sql) if rows is not None: for row in rows: # mapping naar object result.append(LeveranciersRepository.map_to_object(row)) return result
def read_all(): result = [] sql = "SELECT * FROM trein.bestemmingen" rows = Database.get_rows(sql) if rows is not None: for row in rows: # mapping naar object result.append(BestemmingenRepository.map_to_object(row)) return result
def read_voor_grafiek(sensorID): sql = "select i.time, i.waarde, s.eenheid from inlezingen as i left join sensors as s on i.sensorID = s.sensorID where i.sensorID = %s order by time desc limit 10" params = [sensorID] return Database.get_rows(sql, params)
def read_last_sensors_meeting(): sql = "select s.sensorID, s.name, i.waarde, s.eenheid, i.time from inlezingen as i join sensors as s on i.sensorID = s.sensorID where s.sensorID = 101 or s.sensorID = 102 or s.sensorID = 103 order by i.time desc limit 3;" return Database.get_rows(sql)