diff -r 000000000000 -r a4c49a0c313b lib/bkmark.py --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/lib/bkmark.py Tue Sep 23 09:00:02 2003 -0400 @@ -0,0 +1,46 @@ +#!/usr/bin/python + +import time + +class Bookmark: + def __init__(self): + self.url = '' + self.name = '' + self.desc = '' + self.added = time.strftime('%Y-%m-%d') + def add_to_db(self, cnx): + id = cnx.query(""" + SELECT nextid FROM db_sequence WHERE + db_sequence.seq_name = 'bookmarks'; + """).getresult()[0][0] + res = cnx.query(""" + INSERT INTO bookmarks(id, url, name, ldesc, added) + VALUES (%d, '%s', '%s', '%s', '%s'); + """ % (id, self.url, self.name, self.desc, + self.added)) + cnx.query(""" + UPDATE db_sequence SET nextid = %d + WHERE seq_name = 'bookmarks'; + """ % (id+1,)) + return res + +def get_from_form(form): + bk = Bookmark() + bk.url = form["url"].value + bk.name = form["name"].value + bk.desc = form["desc"].value + return bk + +def get_from_id(cnx, id): + bk = Bookmark() + res = cnx.query(""" + SELECT url, name, ldesc, added + FROM bookmarks + WHERE id = %d; + """ % (id,)) + res = res.dictresult()[0] + bk.url = res['url'] + bk.name = res['name'] + bk.desc = res['ldesc'] + bk.added = res['added'] + return bk