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
