A Library to communicate with postgres from python
Project description
Postgres python
---------------
A simple api to read, write, delete and update in a postgres database
Installation : Linux/Mac
---------------
.. code-block:: bash
$ pip install pg_python
Server Initialization
---------------
.. code-block:: bash
$ from pg_python.pg_python import *
$ pgs = pg_server(db_name, username, password, host_address)
Schema Definition (Optional)(Not available)
---------------
.. code-block:: bash
$ schema_map = Schema()
$ pgs.add_schema(db_name, schema_map)
Read operation
---------------
Return value is a list of dictionaries.
Every dictionary is representative of the row that is fetched.
Each dictionary's key is the same as the column name fetched.
.. code-block:: bash
$ value_list = read(table_name, keys_to_get_dict, where_kv_dict, limit, order_by, order_type, operator_string)
Write operation
---------------
.. code-block:: bash
$ write(table_name, kv_dict)
Overwrite operation
---------------
.. code-block:: bash
$ write(table_name, kv_dict)
Update operation
---------------
.. code-block:: bash
$ update(table, update_kv_map, where_kv_map)
Delete operation
---------------
.. code-block:: bash
$ delete(table, where_kv_map, single_row)
---------------
A simple api to read, write, delete and update in a postgres database
Installation : Linux/Mac
---------------
.. code-block:: bash
$ pip install pg_python
Server Initialization
---------------
.. code-block:: bash
$ from pg_python.pg_python import *
$ pgs = pg_server(db_name, username, password, host_address)
Schema Definition (Optional)(Not available)
---------------
.. code-block:: bash
$ schema_map = Schema()
$ pgs.add_schema(db_name, schema_map)
Read operation
---------------
Return value is a list of dictionaries.
Every dictionary is representative of the row that is fetched.
Each dictionary's key is the same as the column name fetched.
.. code-block:: bash
$ value_list = read(table_name, keys_to_get_dict, where_kv_dict, limit, order_by, order_type, operator_string)
Write operation
---------------
.. code-block:: bash
$ write(table_name, kv_dict)
Overwrite operation
---------------
.. code-block:: bash
$ write(table_name, kv_dict)
Update operation
---------------
.. code-block:: bash
$ update(table, update_kv_map, where_kv_map)
Delete operation
---------------
.. code-block:: bash
$ delete(table, where_kv_map, single_row)
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
pg_python-1.17.tar.gz
(5.0 kB
view hashes)
Built Distribution
pg_python-1.17-py2.7.egg
(13.2 kB
view hashes)