pg/python 1.0

pg/python is an open source project working toward the improvement of Python interfaces to PostgreSQL.<br /><br />Quick start:<br /><br />Fetch and Install pg_proboscis<br /><br />easy_install pg_proboscis<br /><br />Connect to a database with the frontend<br /><br />import postgresql.interface.proboscis.prime as pq<br />Con = pq.Connector(<br />user = 'root',<br />host = 'localhost',<br />port = 5432,<br />ssl = True, # Optional. Only set it to True if you want it.<br />database = 'pgsql',<br />)<br /># This creates a Connection *class*, it still needs to be instantiated.<br />C = Con()<br />C<br /><br /><br /># Let's query the database; your results may vary.<br />Q = C.Query("SELECT * FROM pg_proc WHERE proname = $1")<br />P = Q('byteain')<br />for x in P: print x<br />('byteain'::name, '11'::oid, '1'::int4, '12'::oid, False, False, True, False,<br />'i'::char, '1'::int2, '17'::oid, '2275'::oidvector, None, 'byteain'::text,<br />'-'::bytea, '{=X/pgsql}'::_aclitem)<br />print type(x)<br />(proname name, pronamespace oid, proowner int4, prolang oid, proisagg bool,<br />prosecdef bool, proisstrict bool, proretset bool, provolatile char, pronargs<br />int2, prorettype oid, proargtypes oidvector, proargnames _text, prosrc text,<br />probin bytea, proacl _aclitem,)<br /><br />print repr(x["proname"])<br />'byteain'::name<br />print repr(x[0])<br />'byteain'::name<br /><br />for y in x: print repr(y)<br /><br />'byteain'::name<br />'11'::oid<br />'1'::int4<br />'12'::oid<br />False<br />False<br />True<br />False<br />'i'::char<br />'1'::int2<br />'17'::oid<br />'2275'::oidvector<br />None<br />'byteain'::text<br />'-'::bytea<br />'{=X/pgsql}'::_aclitem<br /><br />print x["proacl"][0]<br />=X/pgsql<br /><br />Please be sure to see the documentation for more details.<br />

Requirements:	No special requirements
Platforms:	*nix, Linux
Keyword:	Bool,  Byteain,  False,  Improvement,  Interfaces,  Open,  Postgresql,  Print,  Project,  Proname,  Python,  Repr,  Source,  Text,  True,  Working
Users rating:	0/10