Namespaces

Variants
Actions

Please note that as of October 24, 2014, the Nokia Developer Wiki will no longer be accepting user contributions, including new entries, edits and comments, as we begin transitioning to our new home, in the Windows Phone Development Wiki. We plan to move over the majority of the existing entries. Thanks for all your past and future contributions.

Revision as of 22:24, 13 August 2009 by the86hitman (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Archived:Complete SQL database guide for PySymbian

From Wiki
Jump to: navigation, search

Introduction

There are two database interfaces in PyS60, e32Dbm and e32Db.

e32Dbm is required for dictionary functions only (code example here Database in PyS60). Whereas, e32db allows further SQL processing as will be shown here.


import e32db
 
#initiate database objects
db=e32db.Dbms()
dbv=e32db.Db_view()
#open database, if not exist, then create the file
db.open(u"e:\\data\\python\\test.db","c")
 
#to create ur table
db.execute(u"create table table1 (id count,forename varchar, surname varchar)")
#contains three fields
 
#to insert data
db.execute(u"insert into table values(1,'joe','bloggs')")
#notice, the 1 is required to increment the key!
 
#to fetch the whole dataset
dbv.prepare(db,u"select * from table1")
 
for i in range(1,dbv.count_line()+1): #1 to number of rows
dbv.get_line() #grabs data from the currently selected row
for i in range(1,self.dbv.col_count()+1):
print dbv.col(i) #prints each column data
dbv.next_line() #selects the next row
  • use db.execute(unicode(sql statement)) to perform insert/update/delete
  • use dbv.prepare(db,unicode(sql statement)) to fetch data


This is only a framework for you to use. There are many ready-to-use classes available on other sites, if you prefer, but its less erroronous if you understand the code yourself.


If you need more help, you can post to this thread [1]

Related link

48 page views in the last 30 days.
×