equal
deleted
inserted
replaced
72 self.cnx.commit() |
72 self.cnx.commit() |
73 def add_keyword(self, name): |
73 def add_keyword(self, name): |
74 id = self.get_next_id('keywords') |
74 id = self.get_next_id('keywords') |
75 self.crs.execute(""" |
75 self.crs.execute(""" |
76 INSERT INTO keywords(id, name) |
76 INSERT INTO keywords(id, name) |
77 VALUES (%d, '%s')' |
77 VALUES (%d, '%s'); |
78 """ % (id, name)) |
78 """ % (id, name)) |
79 self.cnx.commit() |
79 self.cnx.commit() |
80 return id |
80 return id |
81 def get_keyword(self, id): |
81 def get_keyword(self, id): |
82 self.crs.execute(""" |
82 self.crs.execute(""" |
144 db_sequence.seq_name = '%s' FOR UPDATE; |
144 db_sequence.seq_name = '%s' FOR UPDATE; |
145 """ % (seq_name)) |
145 """ % (seq_name)) |
146 id = self.crs.fetchone()[0] |
146 id = self.crs.fetchone()[0] |
147 self.crs.execute(""" |
147 self.crs.execute(""" |
148 UPDATE db_sequence SET nextid = %d |
148 UPDATE db_sequence SET nextid = %d |
149 WHERE seq_name = 'bookmarks'; |
149 WHERE seq_name = '%s'; |
150 """ % (id+1,)) |
150 """ % (id+1, seq_name)) |
151 return id |
151 return id |
152 |
152 |
153 def connect(): |
153 def connect(): |
154 return MyDbConnexion() |
154 return MyDbConnexion() |