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
