def runTest(): count = 0 q = wgdb.make_query(db, arglist=[(0,wgdb.COND_EQUAL,"ee")]) record = wgdb.fetch(db, q); while record is not None: count += 1 try: record = wgdb.fetch(db, q); except wgdb.error: record = None
def entry_upvote(entry_id): try: query = wgdb.make_query(g.wdb, arglist=[(0, wgdb.COND_EQUAL, entry_id)]) rec = wgdb.fetch(g.wdb, query) except Exception, e: rec = wgdb.create_record(g.wdb, 10) wgdb.set_field(g.wdb, rec, 0, entry_id)
def __get(self, key, field): l = wgdb.start_read(self.db) rec = wgdb.fetch(self.db, q) wgdb.end_read(self.db, l) wgdb.free_query(self.db, q) if not rec: return None return wgdb.get_field(self.db, rec, field)
def show_entry(entry_id): cur = g.db.execute('select id, title, text from entries where id=? order by id desc', (str(entry_id))) row = cur.fetchone() entry = dict(eid=row[0], title=row[1], text=row[2]) meta = dict(views=0, upvotes=0, downvotes=0) try: query = wgdb.make_query(g.wdb, arglist=[(0, wgdb.COND_EQUAL, entry_id)]) rec = wgdb.fetch(g.wdb, query) except Exception, e: rec = wgdb.create_record(g.wdb, 10) wgdb.set_field(g.wdb, rec, 0, entry_id)
def _set(self, key, stamp, value): l = wgdb.start_read(self.db) q = wgdb.make_query(self.db, arglist=[(0, wgdb.COND_EQUAL, key)]) rec = wgdb.fetch(self.db, q) wgdb.end_read(self.db, l) wgdb.free_query(self.db, q) l = wgdb.start_write(self.db) ## Transaction to Cache if not rec: rec = wgdb.create_record(self.db, 3) wgdb.set_field(self.db, rec, 0, key) wgdb.set_field(self.db, rec, 1, stamp) wgdb.set_field(self.db, rec, 2, value) wgdb.end_write(self.db, l)
def fetch(self, query): """Get next record from query result set.""" if self.locking: self.start_read() try: r = wgdb.fetch(self._db, query) except wgdb.error: r = None finally: if self.locking: self.end_read() if not r: return None return self._new_record(r)
def fetch(self, query): try: rec = wgdb.fetch(self.d, query) except wgdb.error: rec = None return rec