1 #!/usr/bin/python

     2 

     3 import time

     4 

     5 class Bookmark:

     6 	def __init__(self):

     7 		self.url = ''

     8 		self.name = ''

     9 		self.desc = ''

    10 		self.added = time.strftime('%Y-%m-%d')

    11 	def add_to_db(self, cnx):

    12 		id = cnx.query("""

    13 			SELECT nextid FROM db_sequence WHERE

    14 			db_sequence.seq_name = 'bookmarks';

    15 			""").getresult()[0][0]

    16 		res = cnx.query("""

    17 			INSERT INTO bookmarks(id, url, name, ldesc, added)

    18 			VALUES (%d, '%s', '%s', '%s', '%s');

    19 			""" % (id, self.url, self.name, self.desc,

    20 			self.added))

    21 		cnx.query("""

    22 			UPDATE db_sequence SET nextid = %d

    23 			WHERE seq_name = 'bookmarks';

    24 			""" % (id+1,))

    25 		return res

    26 

    27 def get_from_form(form):

    28 	bk = Bookmark()

    29 	bk.url = form["url"].value

    30 	bk.name = form["name"].value

    31 	bk.desc = form["desc"].value

    32 	return bk

    33 

    34 def get_from_id(cnx, id):

    35 	bk = Bookmark()

    36 	res = cnx.query("""

    37 		SELECT url, name, ldesc, added

    38 		FROM bookmarks

    39 		WHERE id = %d;

    40 		""" % (id,))

    41 	res = res.dictresult()[0]

    42 	bk.url = res['url']

    43 	bk.name = res['name']

    44 	bk.desc = res['ldesc']

    45 	bk.added = res['added']

    46 	return bk