rtcom-eventlogger and sqlite3 question - maemo.org

Active Topics

TLS 1.2 for N9 is ready (29)
to MeeGo / Harmattan by smatkovi - 2 hrs, 55 mins ago
Error after installing Leste on sdcard (12)
to Maemo 7 / Leste by teroyk - 3 hrs, 42 mins ago
Camera phone competition March 2023 "Endless" (35)
to General by Maemish - 3 days, 12 hrs ago
Maemo repository (3)
to Community by torsen - 4 days, 4 hrs ago
Introducing ubiboot N9 (multiboot OS loader) (1,393)
to Alternatives by smatkovi - 6 days, 8 hrs ago
more...

Thread Tools

	omeriko9	2010-02-05 , 15:26
	Posts: 385 \| Thanked: 344 times \| Joined on Jan 2010 @ Israel	#1

Hi,

A few questions I couldn't find much info about in the wiki nor google:

1.How can I access the eventlogger from Python?

I've found this API reference:
http://maemo.org/api_refs/5.0/5.0-final/eventlogger/

and this Python code example to access Maemo API's without binding:
http://wiki.maemo.org/PyMaemo/Access...ython_bindings

But I can't seem to bind these two into a working code.

A code example would be wonderful.

2. I don't know how to view a DB schema in sqlite3 - I can use ".databases" to view all DB (can see "0 main" and "1 temp") but no knowledge on how to view it's schema (".schema" command is supposed to be followed by a table name, and since I don't know the tables names...)?

3. Are the event logger data kept in the some sqlite3 file?

Quote & Reply |

kovach	2010-02-05 , 16:06
Posts: 29 \| Thanked: 23 times \| Joined on Jan 2009 @ Macedonia	#2

1. No python binding yet, just use sqlite3
2. .tables
3. /home/user/.rtcom-eventlogger/el.db

Here is some sample python code:

Code:

import sqlite3
EL_PATH = "/home/user/.rtcom-eventlogger/el.db"
conn = sqlite3.connect(EL_PATH)
cur = conn.cursor()
cur.execute("select event_type_id, start_time, E.remote_uid, remote_name from Events E, Remotes R " +
			"where R.remote_uid=E.remote_uid and E.local_uid=R.local_uid and service_id = 1 " +
			"order by start_time desc")

for datarow in cur:
	//do something with datarow[0], datarow[1] etc..