4 import pysqlite2.dbapi2 as dbapi
5 import SimpleXMLRPCServer
10 sql = dbapi.connect('noteDB.sqlite').cursor()
13 sql.execute('CREATE TABLE meta (key TEXT, value TEXT, UNIQUE (uuid));')
14 sql.execute('INSERT INTO meta (key, value) VALUES ("version", "1.6db");')
15 sql.execute('CREATE TABLE notes (uuid TEXT PRIMARY KEY, seq INTEGER, label TEXT, ' +
16 'content TEXT, revision DATETIME, UNIQE (uuid));')
27 Return sanitized string for use in SQL-Statements
31 if c == '"': ret += '""'
36 sql.execute('SELECT uuid, revision FROM notes')
40 sql.excute('DELETE FROM notes WHERE uuid = "' + escape(uuid) + '";')
42 def setRecord(uuid, seq, label, content, revision):
46 content = escape(content)
47 revision = escape(revision)
49 sql.execute('INSERT INTO notes (uuid, seq, label, content, revision) VALUES ' +
50 '"' + uuid + '", ' + seq + ', "' + label + '", "' + content +
51 '", datetime(\'' + revision + '\')')
53 sql.execute('UPDATE notes SET seq = ' + seq + ', label = "' + label + '", content = "' + content +
54 '", revision = "' + revision + '" WHERE uuid = datetime(\'' + revision + '\');')
58 sql.execute('SELECT uuid, seq, label, content, revision FROM notes WHERE uuid = "' + uuid + '";')
60 rpc = SimpleXMLRPCServer.CGIXMLRPCRequestHandler()
61 rpc.register_function(quickIndex)
62 rpc.register_function(setRecord)
63 rpc.register_function(getRecord)
64 rpc.register_function(delRecord)