4 from pyPgSQL import PgSQL
6 if __name__ == '__main__':
7 db = PgSQL.connect(user = 'anondispense', host = 'dispense', database = 'dispense')
9 user = os.environ['USER']
12 # We have a request. Pass it to dispense by calling
13 # SELECT do_request(username, service, params as array)
20 paramstr = paramstr.rstrip(',') + ']'
23 cursor.execute('SELECT do_request(%%s, %%s, %s)'%paramstr, [user, service]+params)
24 result = cursor.fetchone()[0]
30 cursor.execute('SELECT * FROM get_services(%s)', user)
31 print '%-10s %-50s %-10s %s' % ('Provider', 'Item', 'Cost', 'Stock')
32 print '-------------------------------------------------------------------------------'
33 for item in cursor.fetchall():
34 print '%10s '%item[0],
37 print '%-50s'%(item[1]+' '+item[3]),
41 print '%-10d' % int(item[2]),
45 cursor.execute('SELECT * FROM get_balance(%s)', user);
46 [_, cents,bytes] = cursor.fetchone()
47 print user, 'has', int(cents), 'cents and', int(bytes), 'bytes'