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
out of.
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
#
import RekallPYDBI
# 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 >=
?", [21])
# 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() :
values.append
(record[0])
# 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')
choice.setValues
(values)
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 (?, ?)",
['john',
'smith'])
cursor.execute("update users set firstname = ? where surname =
?", ['john',
'smith'])
