if content: content = self.escape(content)
else: content = ''
self.dbcur.execute('INSERT INTO notes (uuid, label, content, revision, lastsync) VALUES ' +
- '(lower(hex(randomblob(16))), "' + label + '", "' + content +
+ '(lower(hex(randomblob(16))), "' + str(label) + '", "' + str(content) +
'", datetime(\'now\'), datetime(\'1970-01-01\'));')
else:
if content:
if label:
self.dbcur.execute('UPDATE notes SET label = "' + self.escape(label) +
'", revision = datetime(\'now\') WHERE uuid = "' + str(uuid) + '";')
- return self.dbcur.lastrowid
+
+ try:
+ self.dbcur.execute('SELECT uuid FROM notes WHERE seq = "' + str(self.dbcur.lastrowid) + '";')
+ return self.dbcur.fetchall()[0][0]
+ except: return 0
def delRecord(self, uuid):
"""