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