Beispiel #1
0
 def insert(self):
     query = "insert INTO recordings VALUES (NULL,%i,'%s',%i)" % (
         self.idcounter,
         self.date.strftime("%Y-%m-%d %H:%M:%S") + ".000",
         self.value,
     )
     id = DB.do_update(query)
     self.id = id
Beispiel #2
0
 def insert(self):
     query = "insert INTO counters VALUES (NULL,'%s')" % self.name
     id = DB.do_update(query)
     self.id = id
Beispiel #3
0
 def remove(self):
     if self.id is not None:
         query = "delete from recordings where id=%i" % self.id
         res = DB.do_update(query)
Beispiel #4
0
 def update(self):
     if self.id is not None:
         query = "update recordings SET value=%i where id=%i" % (self.value, self.id)
         DB.do_update(query)