I had posted and emailed various places, to find a tutorial or example of
how to write my own scripts in Rekall to access Postgresql. Someone was kind
enough to send me the following example, so I want to share it with anyone who
may be interested in using Rekall as a front end to Postgresql.
I strongly feel that Rekall developers should assemble and make available
such tutorials, because it will help to promote the popularity of Rekall and
increase the user base. There are many people like me, who are clever enough
to learn from good examples and become productive, but are lost without
examples and tutorials.
If I can become even somewhat productive with Rekall, I will certainly
purchase the product and/or support ... its not that I want everything for free. I
just want to know that I am purchasing something I make work and get some use
If anyone else has some Rekall examples they would like to share, please
email me directly, if you like, typing80wpm (at) aol (dot) com
Or, if you know of an email listserve or a forum where I could find such
help, examples, tutorials, code snippets.
Thanks for your help!
> What I REALLY NEED right now is a working example of a REKALL python
> script which could do SQL pass through to the Postgres engine which is now
> working on the P2P. I really like Rekall, but it is frustrating that there
> are no examples.
Here's a little examle. Its the "onclick" event function for a button,
and it loads a choice control with surnames taken from a table called users:
def eventFunc(button) :
# Load the RekallPYDBI module. This provides direct access to the database
# begind Rekall
# Get a "cursor". We do this by connecting to the database: the
# (button,"") arguments just connect to the database that the form is
# running in.
cursor = RekallPYDBI.connect (button, '').cursor()
# Execute a query. This only gets people whose ages are 21 or above.
# This is the important bit, we are accessing the database directly.
cursor.execute ("select surname from users where age >= ?", )
# Assemble a list of surnames. Create an empty list, then for each record
# returned by the cursor, append the first item in the record (the
# surname) to the list
values = 
for record in cursor.fetchall() :
# Load the choice control. This is for a control called "people" in the
# same block as the button (".." moves from the button up into its block,
# then "people" find the people choice control.
choice = button.getNamedCtrl('../people')
The key is getting the "cursor". Once you have a cursor you can do inserts,
updates and deletes, like
cursor.execute("delete from customers where balance < 0.01")
cursor.execute("insert into users (firstname, surname) values (?, ?)",
cursor.execute("update users set firstname = ? where surname = ?", ['john',
pgsql-odbc by date
|Next:||From: Karsten Hilbert||Date: 2005-05-02 09:56:05|
|Subject: Python DB-API 2.0 oddity (was: I receieved an example of Rekall script)|
|Previous:||From: Typing80wpm||Date: 2005-04-30 23:55:19|
|Subject: Postgresql and small office p2p networks & ODBC|
pgsql-general by date
|Next:||From: Harry Jackson||Date: 2005-05-01 22:15:08|
|Subject: libpq and PQexecPrepared|
|Previous:||From: CSN||Date: 2005-05-01 20:13:09|
|Subject: Can't compile plphp|