[Kexi] Kexi python Scripting

[Sebastian Sauer]

Hi Rüdiger :)

Rüdiger Härtel wrote:
> Here is the kexi project.
> 
> Am Freitag 07 März 2008 14:03:45 schrieben Sie:
>> Rüdiger Härtel said the following, On 2008-03-07 13:52:
>> > I want to write a script to query some data from my db.
>> >
>> > the following works:
>> >
>> > cursor = connection.executeQueryString("SELECT * from emp where country
>> > = 'Germany'")
>> > ...
>> >
>> > but this does not work
>> >
>> > country = self.countries.get()
>> > sqlStmt = "SELECT * from emp where country = %s" % country
>> > cursor = connection.executeQueryString(sqlStmt)

probably the country variable does contain the wrong value. Following works 
fine with your testdb;

import kexiapp
keximainwindow = kexiapp.get("KexiAppMainWindow")
connection = keximainwindow.getConnection()
country="Germany"
sqlStmt = 'SELECT * from tabelle1 WHERE country = \'%s\';' % country
cursor = connection.executeQueryString(sqlStmt)
if not cursor:
	raise "No cursor"
while not cursor.eof():
	for i in range( cursor.fieldCount() ):
		print "%s %s" % (str(i), cursor.value(i))
	cursor.moveNext()