--- /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