--- a/lib/bkmark.py Tue Sep 23 10:26:16 2003 -0400
+++ b/lib/bkmark.py Tue Sep 23 10:26:35 2003 -0400
@@ -8,39 +8,5 @@
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