AQuickTutorial » History » Revision 7
Revision 6 (Aurynn Shaw, 01/22/2009 09:09 AM) → Revision 7/10 (Aurynn Shaw, 01/22/2009 09:10 AM)
= Simpycity in a Hurry =
And what to expect when you use it.
== Setup ==
First, set up Simpycity:
{{{
>>> from simpycity.core import Function
>>> from simpycity import config
>>> config.host = 'localhost'
>>> config.port = 5432
>>> config.user = 'user'
>>> config.password = 'password'
>>> config.database = 'dbname'
}}}
Then, create some basic functions.
{{{
>>> f = Function("get_row",['id'])
>>> f_all = Function("get_rows")
}}}
'''f_all''' maps to the stored procedure "get_rows", which takes no arguments.
'''f''', on the other hand, maps to the stored procedure "get_row", which takes a single argument, which we've named id.
To call f_all, it's a standard python function:
{{{
>>> all_results = f_all()
}}}
For get_row, it's the same Python call semantics, both positional and keyword arguments being supported
{{{
>>> result = f(1) # get id 1
>>> result = f(id=1) # also get id 1
}}}
The results (look kind of like) a result set from psycopg2, and can be iterated over as per normal:
{{{
>>> for row in all_result:
... # do row stuff
}}}
and in the case of a single result, you can also call .next() or .fetchone() and get the row object.
{{{
>>> row = result.next()
# or
>>> row = result.fetchone()
}}}