DBMS is the native format for database on Symbian platform. Python for S60 provides a 'e32db' module to access dbms.
import e32db
db = e32db.Dbms()
dbv = e32db.Db_view()
db.open(u'C:\\system\\data\\bookmarks1.db') # open database file
# search and retrieve from a row
def select_row(query):
dbv.prepare(db, unicode(query))
dbv.first_line()
dbv.get_line()
result = []
for i in range(dbv.col_count()):
result.append(dbv.col(i+1))
return result
# search and retrieve from a column
def select_col(query):
dbv.prepare(db, unicode(query))
dbv.first_line()
result = []
for i in range(dbv.count_line()):
dbv.get_line()
result.append(dbv.col(1))
dbv.next_line()
return result
def select_all(query):
dbv.prepare(db, unicode(query))
dbv.first_line()
rows = []
for i in range(dbv.count_line()):
dbv.get_line()
result = []
for i in range(dbv.col_count()):
try:
result.append(dbv.col(i+1))
except: # in case coltype 16
result.append(None)
rows.append(result)
dbv.next_line()
return rows
Now you can simply call
select_row('SELECT * FROM Favourites') # 1 row
select_all('SELECT * FROM Favourites') # all rows
# For non-select SQL, you can simply use db.execute(query).
No related wiki articles found