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)