def findById(id): query = "select * from counters where id=%i" % id res = DB.do_select(query) if len(res) != 1: raise Exception("Issue while requesting counter id=%i ; got %i results" % (id, len(res))) c = Counter(res[0][1]) c.id = res[0][0] return c
def findAll(): query = "select * from counters" res = DB.do_select(query) allc = [] for (id, name) in res: c = Counter(name) c.id = id allc.append(c) return allc
def findByIdCounter(idcounter): query = "select * from recordings where idcounter=%i" % idcounter res = DB.do_select(query) allr = [] for (id, idcounter, date, value) in res: d = datetime.datetime.strptime(date[:-4], "%Y-%m-%d %H:%M:%S") r = Recording(idcounter, d, value) r.id = id allr.append(r) return allr
def findAll(): query = "select * from recordings" res = DB.do_select(query) allr = [] for (id, idcounter, date, value) in res: # the date is recorded as a string with trailing millisecondes; see insert() d = datetime.datetime.strptime(date[:-4], "%Y-%m-%d %H:%M:%S") r = Recording(idcounter, d, value) r.id = id allr.append(r) return allr
def findById(id): query = "select * from recordings where id=%i" % id res = DB.do_select(query) allr = [] if len(res) != 1: raise Exception("Not enough or too many results !!") (id, idcounter, date, value) = res[0] d = datetime.datetime.strptime(date[:-4], "%Y-%m-%d %H:%M:%S") r = Recording(idcounter, d, value) r.id = id return r