Categories: S60 | Python | How To | Code Examples

This page was last modified 20:12, 14 October 2007.

From Forum Nokia Wiki

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).