DZone Snippets: series60 code

dbms database class

nerdcoder (Dan Larsen) — Tue, 03 Jul 2007 21:46:51 GMT

I'm at my first attempt at creating something for the PyS60 and I needed a simple sql wrapper class...
I'm an experienced programmer, but has never programmed in python for s60 and it's been a while since I've used Python... So I hope this will help somebody, not annoy ;-)



# Filename: db.py save in your Python dir

import e32db



class db:

    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 reset_counters(self):

	self.affected_rows = 0

	self.num_rows = 0

	self.__internal_counter = 0



    def query(self, sql):

	self.reset_counters()

	if sql.lower().startswith('select'):

	    self.dbv.prepare(self.db, unicode(sql))

	    self.dbv.first_line()

	    self.num_rows = self.dbv.count_line()

	else:

	    self.affected_rows = self.db.execute(unicode(sql))



    def next(self):

	row = {'id': 0}

	if self.num_rows < 1:

	    self.reset_counters()

	    raise StopIteration

	elif self.__internal_counter < self.num_rows:

	    self.dbv.get_line()

	    for i in range(self.dbv.col_count()):

		row[i] = self.dbv.col(i+1)

	    self.dbv.next_line()

	    self.__internal_counter += 1

	    return row

	else:

	    self.reset_counters()

	    raise StopIteration



    def __iter__(self):

	return self

Now to create and fill db, create a file in the same dir as the db.py with this content:



# Change __exec_path to the path of your python script dir

__exec_path = "E:\\Python\\"

dbname = "test"



import sys

sys.path.append(__exec_path)

from db import db



# This will open E:\\Python\test.db - it will be created first, if not existing

mydb = db(__exec_path+dbname+'.db')

mydb.query("create table testing (id counter, name varchar)")

mydb.query("insert into testing (name) values ('test 1')")

mydb.query("insert into testing (name) values ('test 2')")

Now go ahead and have fun:



# Again change __exec_path to the path of your python script dir

__exec_path = "E:\\Python\\"

dbname = "test"



import sys

sys.path.append(__exec_path)

from db import db



# Opens E:\\Python\test.db

mydb = db(__exec_path+dbname+'.db')

mydb.query("select * from testing")

for row in mydb:

    print "-> ",row[0]," ",row[1]," <-"

Have fun!
Dan

Calling a S60 Python function from Symbian C++

frumioj (John Kemp) — Thu, 12 Apr 2007 00:38:10 GMT

Calls the Python function 'foo' in the module 'Bar'.
A string value is passed to the Python function, and a string value is returned



    TInt retVal(KErrNone);



    // Create a Python interpreter

    CSPyInterpreter* it = CSPyInterpreter::NewInterpreterL();

    CleanupStack::PushL(it);



    // Save state of any current Python interpreter, and acquire the

    // interpreter lock

    PyEval_RestoreThread(PYTHON_TLS->thread_state);



    char *module_name = "Bar" ;

    char *foo = "foo" ;

    char *response = NULL ;



    TInt32 r_len = 0 ;



    PyObject *pModule = PyImport_ImportModule(module_name) ;



    if ( pModule != NULL )

    {

    LOG_WRITE_L("CSenPythonSession::loaded ServiceConnection");



    PyObject *module_dict = PyModule_GetDict(pModule);

    PyObject *expression = PyDict_GetItemString(module_dict, pre_handler);

    PyObject *arglist = Py_BuildValue("(s#)", aString.Ptr(),aString.Length()) ;



    PyObject *result = PyEval_CallObject(expression, arglist);



    response = PyString_AsString( result ) ;



    r_len = strlen( response ) ;

    }



    // Make a Symbian descriptor pointer to the char * response

    TPtrC8 symResponse((TUint8*)response, r_len ) ;



    // Clean-up, and restore thread state



    PyEval_SaveThread();

    CleanupStack::PopAndDestroy(it);

Nokia - User Agent

whitetiger () — Thu, 07 Dec 2006 05:10:21 GMT

// User Agent



Modello 3230

"Nokia3230/2.0 (5.0614.0) SymbianOS/7.0s Series60/2.1 Profile/MIDP-2.0

Configuration/CLDC-1.0"



Modello 6260

"Nokia6260/2.0 (3.0448.0) SymbianOS/7.0s Series60/2.1 Profile/MIDP-2.0

Configuration/CLDC-1.0"



Modello 6600

"Nokia6600/1.0 (5.27.0) SymbianOS/7.0s Series60/2.0 Profile/MIDP-2.0

Configuration/CLDC-1.0"



Modello 6620

"Nokia6620/2.0 (4.22.1) SymbianOS/7.0s Series60/2.1 Profile/MIDP-2.0

Configuration/CLDC-1.0"



Modello 6630

"Nokia6630/1.0 (5.03.08) SymbianOS/8.0 Series60/2.6 Profile/MIDP-2.0

Configuration/CLDC-1.1"



Modello 6670

"Nokia6670/2.0 (6.0540.0) SymbianOS/7.0s Series60/2.1 Profile/MIDP-2.0

Configuration/CLDC-1.0"



Modello 6680

"Nokia6680/1.0 (4.04.07) SymbianOS/8.0 Series60/2.6 Profile/MIDP-2.0

Configuration/CLDC-1.1"



Modello 6681

"Nokia6681/2.0 (5.37.01) SymbianOS/8.0 Series60/2.6 Profile/MIDP-2.0

Configuration/CLDC-1.1"



Modello 9300

"Mozilla/4.0 (compatible; MSIE 5.0; Series80/2.0 Nokia9300/05.22

Profile/MIDP-2.0 Configuration/CLDC-1.1)"



Modello 9500

"Mozilla/4.0 (compatible; MSIE 5.0; Series80/2.0 Nokia9500/4.51

Profile/MIDP-2.0 Configuration/CLDC-1.1)"

PyS60 - BabelFish

whitetiger () — Tue, 28 Nov 2006 04:35:55 GMT

// Translate from language A to language B
// code not complete but it works



import urllib



####################################################################################### 

class BabelFish(object):

    

    def translate(self, lang, message):

        

        try:

            url = urllib.URLopener()

        

            query = urllib.urlencode({

                                      'doit':'done',

                                      'intl':'1',

                                      'lp':lang,

                                      'tt':'urltext',

                                      'urltext':message

                                      })

        

            responde = url.open('http://babelfish.altavista.com/tr', query).read()

        

            start = responde.find('') + 25

            stop = responde.find('', start)

        

            return responde[start:stop]

        

        except Exception, error:

            return '-' + str(error)

####################################################################################### 



####################################################################################### 

from graphics import *



import appuifw

import e32



class BabelFishUI(object):

    

    def __init__(self):

        

        self.__lock = e32.Ao_lock()

        self.__img = Image.new((176, 144))

        self.__language = 'it_en'

        self.__textUI = None

        

        appuifw.app.exit_key_handler = lambda:self.__lock.signal()

        

        appuifw.app.title = u'BabelFish v1.0'

        appuifw.app.body = self.__canvas = appuifw.Canvas(redraw_callback=self.updateScreen)

        

        appuifw.app.menu = [(u'Translate', lambda:self.__translateUI()), (u'About', lambda:appuifw.note(u'BabelFish: v1.0", "Created by\nWhite Tiger\n', 'info')), (u'Exit', lambda:self.__lock.signal)]

        

        self.updateScreen(None)

        

        self.__menuMain = appuifw.app.menu

        self.__bgMain = appuifw.app.body

        

        self.__lock.wait()

    

    def updateScreen(self, rect):

        

        self.__canvas.blit(self.__img)

    

    def __back(self):

        

        appuifw.app.menu = self.__menuMain

        appuifw.app.body = self.__bgMain

        

        appuifw.app.set_tabs([u'Back'], lambda x:None)

    

    def __translateUI(self):

        

        self.__textUI = appuifw.Text()

                

        appuifw.app.menu = [(u'Translate', lambda:self.__translate()), (u'Language', lambda:self.__setLanguage()), (u'Clear', lambda:self.__textUI.clear()), (u'Back', lambda:self.__back())]

                   

        appuifw.app.body = self.__textUI

                

    def __setLanguage(self):

        

        resp = appuifw.selection_list([u'italiano-inglese', u'inglese-italiano', u'inglese-francese', u'francese-inglese', u'inglese-tedesco', u'tedesco-inglese',

                                       u'francese-italiano', u'italiano-francese'], 1)

        

        if resp == 0:

            self.__language = 'it_en'

        elif resp == 1:

            self.__language = 'en_it'

        elif resp == 2:

            self.__language = 'en_fr'

        elif resp == 3:

            self.__language = 'fr_en'

        elif resp == 4:

            self.__language = 'en_de'

        elif resp == 5:

            self.__language = 'de_en'

        elif resp == 6:

            self.__language = 'fr_it'

        elif resp == 7:

            self.__language = 'it_fr'

            

    def __translate(self):

        

        babel = BabelFish()

        

        resp = babel.translate(self.__language, self.__textUI.get())

        

        if resp[0] == '-':

            self.__textUI.set(unicode(resp[1:]))

        else:

            self.__textUI.set(unicode(': ' +self.__textUI.get() + '\n: ' + resp))

                

        appuifw.note(u'Translate', 'conf')

####################################################################################### 



if __name__ == '__main__':

    

    BabelFishUI()

Python - eggs

whitetiger () — Fri, 29 Sep 2006 22:21:57 GMT

1)

import __hello__

2)

from __future__ import braces

Get mobile cpu speed

korakot (Korakot Chaovavanich) — Sun, 19 Mar 2006 18:51:35 GMT



import miso

print miso.get_hal_attr(11)  # 104000 for my 6600

Get LAST_INSERT_ID from Symbian DBMS

korakot (Korakot Chaovavanich) — Mon, 13 Mar 2006 17:23:21 GMT



# table schema

# CREATE TABLE person (id COUNTER, name VARCHAR)



db = e32db.Dbms()

db.begin()  # begin transaction (lock other inserts)

db.execute(u"INSERT INTO person(name) VALUES 'korakot' ") # insert a new row



dbv = e32db.Db_view()

dbv.prepare(db, u"SELECT id FROM person ORDER BY id DESC")

dbv.first_line()

dbv.get_line()

last_id = dbv.col(1)  # get it!



db.commit()  # commit the transaction

Keep light on using thread

korakot (Korakot Chaovavanich) — Sat, 11 Mar 2006 08:44:31 GMT

Copy-paste version



import e32, miso, thread

running = 1

def lighton():

  while running:

    miso.reset_inactivity_time()

    e32.ao_sleep(5)



thread.start_new_thread(lighton, ())

# end by set running = 0

2 functions (lighton, lightoff) version.



import e32

import miso

import thread



flag = 1

def _lighton():

    while flag:

        miso.reset_inactivity_time()

        e32.ao_sleep(5)



def lighton():

    thread.start_new_thread(_lighton, ())



def lightoff():

    global flag

    flag = 0

PyS60 - Gallery Thumbnail Ver. 2

whitetiger () — Sat, 11 Mar 2006 05:36:17 GMT

// Versione riveduta e corretta di Gallery Thumbnail postata da korakot ^_^



import appuifw

import e32

import graphics

import key_codes

import os



class FlickrS60Error(Exception): pass



class FlickrS60Thumb:



	def __init__(self, path):



		self.path = unicode(path)

		self.listFile = []

		self.ldivx = 0

		self.ldivy = 0

		self.lock = e32.Ao_lock()

		self.canvas = None

		self.img = graphics.Image.new((176, 144))

		self.img_tmp = graphics.Image.new((42, 36))

		self.x, self.y = 0, 0

		self.p = 0

		self.pages = 0

		self.currpages = 0

		self.mpath = 0



	def OnRun(self):



		appuifw.app.exit_key_handler = self.lock.signal

	

		self._createList()

		

		self.canvas = appuifw.Canvas(redraw_callback=self.OnUpdate)

		appuifw.app.body = self.canvas



		self.canvas.bind(key_codes.EKeyRightArrow, lambda: self.move(1, 0))

		self.canvas.bind(key_codes.EKeyLeftArrow, lambda: self.move(-1, 0))

		self.canvas.bind(key_codes.EKeyUpArrow, lambda: self.move(0, -1))

		self.canvas.bind(key_codes.EKeyDownArrow, lambda: self.move(0, 1))

		self.canvas.bind(key_codes.EKeySelect, self.IMG)



		self._drawIMG()

		

		self.lock.wait()



	def OnUpdate(self, rect):



		self.canvas.blit(self.img)

		self.canvas.rectangle([(self.p+(42*self.x), 36*self.y), (self.p+(42*self.x)+42, (36*self.y)+36)], width=2, outline=0x123456)



	def move(self, x, y):



		self.x = (self.x+x)%4

		self.y = (self.y+y)



		if x == 1: self.p = (self.p+2)%8

		if x == -1: self.p = (self.p-2)%8



		if self.y == 4:

			if self.currpages < self.pages-1:

				self.y = 0

				self.currpages += 1

				self._drawIMG(start=self.currpages)

			else:

				self.y = 3

			

		if self.y == -1:

			if self.currpages > 0:

				self.y = 3

				self.currpages -= 1

				self._drawIMG(start=self.currpages)

			else:

				self.y = 0

	

		self.mpath = (4*self.y + self.x)+(16*self.currpages)

		

		self.OnUpdate(None)

	

	def IMG(self):



		try:

			m = self.listFile[self.mpath].replace('_PalbTN\\', '')

			appuifw.Content_handler().open(m)

		except:

			pass

		

	def _drawIMG(self, start=0):



		self.img.clear(0xffffff)

		z = 0

		

		for id in range(start*16, (start+1)*16):

			j, i = divmod(id-(start*16), 4)

			try:

				self.img_tmp.load(self.listFile[id])

				self.img.blit(self.img_tmp, target=(z+(42*i)+(z+1), 36*j))

				z = (z+1)%4

			except:

				break



		self.OnUpdate(None)



	def _createList(self):



		try:

			for id in os.listdir(self.path):

				self.listFile.append(self.path + id)



			self.ldivx, self.ldivy = divmod(len(self.listFile), 16)



			self.pages = self.ldivx

			if self.ldivy <> 0: self.pages += 1

		except:

			raise FlickrS60Error('Errore nella creazione della lista.')



if __name__ == '__main__':



	FlickrS60Thumb('E:\\Images\\_PalbTN\\').OnRun()

Create a primary key with autoincrement in Symbian DBMS

korakot (Korakot Chaovavanich) — Fri, 10 Mar 2006 16:17:05 GMT



CREATE TABLE person (id COUNTER, name VARCHAR)

CREATE UNIQUE INDEX id_index ON person(id)

COUNTER is UNSIGNED INTEGER with Autoincrement.
You still need a UNIQUE INDEX as well.