Simpycity

= 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()

1. or

row = result.fetchone()

}}}