def query(self, statement):
self.db_view = e32db.Db_view()
self.db_view.prepare(self.db, unicode(statement))
no_of_rows = self.db_view.count_line()
self.db_view.first_line()
data = []
for row_no in xrange(no_of_rows):
self.db_view.get_line()
line = []
# Will contain col_type, col_raw, col_rawtime, format_rawtime
misc_testdata = []
for column_no in xrange(1, self.db_view.col_count() + 1):
line.append(self.db_view.col(column_no))
column_type = self.db_view.col_type(column_no)
misc_testdata.append(column_type)
if not self.db_view.is_col_null(column_no):
misc_testdata.append(self.db_view.col_length(column_no))
if column_type != 15:
misc_testdata.append(repr(self.db_view.col_raw(column_no)))
if column_type == 10:
misc_testdata.append(
repr(self.db_view.col_rawtime(column_no)))
misc_testdata.append(repr(e32db.format_rawtime(
self.db_view.col_rawtime(column_no))))
data.append(tuple(line))
self.db_view.next_line()
del self.db_view
return data, misc_testdata
def __init__(self, db, id=None, **kw):
self.db = db
self.dbv = e32db.Db_view()
if id is None:
self.id = self._insert(**kw)
else:
self.id = id
def __init__(self,butterfly_app,db):
self.butterfly_app = butterfly_app
self.listbox = None
self.ListID = []
self.db = db
self.dbv = e32db.Db_view()
self.selected = 0
def __init__(self, dbpath):
self.db = e32db.Dbms()
self.dbv = e32db.Db_view()
self.reset_counters()
try:
self.db.open(unicode(dbpath))
except:
self.db.create(unicode(dbpath))
self.db.open(unicode(dbpath))
def __init__(self,butterfly_app, db):
self.butterfly_app = butterfly_app
self.listbox = None
self.ListID = []
self.db = db
self.fname = u'e:\\butterfly_data\\traps.xml'
self.selected = 0
self.viewby = 'date Desc'
self.child_db =[] # this must be set from outside
self.dbv = e32db.Db_view()
self.parent_dict = {}
def get_all_entries(self):
dbv = e32db.Db_view()
dbv.prepare(self.native_db, u"SELECT * from events ORDER BY date DESC")
dbv.first_line()
results = []
for i in range(dbv.count_line()):
dbv.get_line()
e = SportsDiaryEntry(dbv)
results.append(e)
dbv.next_line()
return results
def select(cls, db, where=None, orderby=None):
q = 'SELECT id FROM '+ cls.__name__
if where:
q += ' WHERE '+where
if orderby:
q += ' ORDER BY '+orderby
dbv = e32db.Db_view() # need its own cursor
dbv.prepare(db, unicode(q))
dbv.first_line()
for i in range(dbv.count_line()):
dbv.get_line()
yield cls(db, dbv.col(1))
dbv.next_line()
def _query(self, statement):
"""Execute a query and return results."""
#print "Executing query: %s"%statement
DBV = e32db.Db_view()
DBV.prepare(self.db, unicode(statement))
n = DBV.count_line()
DBV.first_line()
data = []
for i in xrange(n):
DBV.get_line()
line = []
for j in xrange(DBV.col_count()):
line.append(DBV.col(1 + j))
data.append(tuple(line))
DBV.next_line()
del DBV
return data
def query(db, statement):
DBV = e32db.Db_view()
DBV.prepare(db, unicode(statement))
n = DBV.count_line()
DBV.first_line()
data = []
for i in xrange(n):
DBV.get_line()
line = []
for j in xrange(DBV.col_count()):
line.append(DBV.col(1 + j))
t = DBV.col_type(1 + j)
print "Column type: %d" % t
if t != 15:
print "Raw value: %s" % repr(DBV.col_raw(1 + j))
if t == 10:
print "Raw time: %s" % repr(DBV.col_rawtime(1 + j))
print "Formatted: %s" % e32db.format_rawtime(
DBV.col_rawtime(1 + j))
data.append(tuple(line))
DBV.next_line()
del DBV
return data
def gen_view(self, command):
view = e32db.Db_view()
view.prepare(self.db, command)
return view
