maemo.org - Talk - View Single Post - rtcom-eventlogger and sqlite3 question

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..

Quote & Reply |

The Following User Says Thank You to kovach For This Useful Post:
omeriko9