equal
deleted
inserted
replaced
6 def __init__(self): |
6 def __init__(self): |
7 self.url = '' |
7 self.url = '' |
8 self.name = '' |
8 self.name = '' |
9 self.desc = '' |
9 self.desc = '' |
10 self.added = time.strftime('%Y-%m-%d') |
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 |
11 |
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 |
12 |
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 |
|