×
Namespaces

Variants
Actions

Archived:Complete SQL database guide for PySymbian

From Nokia Developer Wiki
Jump to: navigation, search

Archived.pngAquivado: Este artigo foi arquivado, pois o conteúdo não é mais considerado relevante para se criar soluções comerciais atuais. Se você achar que este artigo ainda é importante, inclua o template {{ForArchiveReview|escreva a sua justificativa}}.

All PySymbian articles have been archived. PySymbian is no longer maintained by Nokia and is not guaranteed to work on more recent Symbian devices. It is not possible to submit apps to Nokia Store.

Article Metadata
Tested with
Devices(s): E71
Compatibility
Platform(s): S60 2nd Edition, S60 3rd Edition
Article
Keywords: e32db, e32dbm
Created: the86hitman (13 Aug 2009)
Last edited: hamishwillee (08 May 2013)

Introduction

There are two database interfaces in PySymbian, e32dbm and e32db.

e32dbm is required for dictionary functions only (code example at Archived:Database in PySymbian). Whereas, e32db allows further SQL processing as will be shown here.

Source code

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 table which contains three fields
db.execute(u"create table table1 (id count,forename varchar, surname varchar)")
# for value types see http://pys60.garage.maemo.org/doc/s60/node100.html
 
#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, if you prefer, but its less erroneous if you understand the code yourself.


If you need more help, you can post to this thread.

Related Links

This page was last modified on 8 May 2013, at 08:54.
94 page views in the last 30 days.
×