summary |
shortlog |
log |
commit | commitdiff |
tree
raw |
patch |
inline | side by side (from parent 1:
6507e31)
svn path=/trunk/; revision=5
for c in string:
if c == '"': ret += '""'
else: ret += c
for c in string:
if c == '"': ret += '""'
else: ret += c
def allRecords(self):
"""
def allRecords(self):
"""
if content: content = self.escape(content)
else: content = ''
self.dbcur.execute('INSERT INTO notes (uuid, label, content, revision, lastsync) VALUES ' +
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:
'", 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) + '";')
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):
"""
def delRecord(self, uuid):
"""