A package parsing the PostgreSQL connection service file
Project description
pgserviceparser
A python package parsing the PostgreSQL connection service file.
>>> import pgserviceparser
Finding the PostgreSQL connection service file with conf_path
Returns the path found for the pg_service.conf on the system as string.
>>> pgserviceparser.conf_path()
'/home/dave/.pg_service.conf'
Listing all the services with service_names
Returns all service names in a list.
Optionally you can pass a config file path. Otherwise it gets it by conf_path
.
>>> pgserviceparser.service_names()
['srvce_wandplaene', 'ktn_solothurn', 'daves_bakery']
Receiving the configuration for a service with service_config
Returns the config from the given service name as a dict.
Optionally you can pass a config file path. Otherwise it gets it by conf_path
.
>>> pgserviceparser.service_config('daves_bakery')
{'host': 'localhost', 'port': '5432', 'dbname': 'bakery', 'user': 'dave', 'password': 'fischersfritz'}
Getting the full configuration with full_config
Returns full pgservice config as configparser.ConfigParser().
Optionally you can pass a config file path. Otherwise it gets it by conf_path
.
>>> pgserviceparser.full_config()
<configparser.ConfigParser object at 0x7f4c6d66b580>
Add a new service or remove one
Add a new service:
import pgserviceparser
new_srv_settings = {"host": "localhost", "dbname": "best_database_ever", "port": 5432, "user": "ro_gis_user"}
new_srv = pgserviceparser.write_service(service_name="gis_prod_ro", settings=new_srv_settings, create_if_not_found=True)
assert isinstance(new_srv, dict)
The PG service file has now:
[gis_prod_ro]
host=localhost
dbname=best_database_ever
port=5432
user=ro_gis_user
To remove it:
pgserviceparser.remove_service("gis_prod_ro")
Contribute
Test
pip install -e .
export PGSERVICEPARSER_SRC_DIR=$pwd
python -m unittest test.test_lib
Git hooks
pip install pre-commit
pre-commit install
Build documentation
pip install -e .[docs]
mkdocs build -f docs/mkdocs.yml
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for pgserviceparser-2.2.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3bd9f1941b5717ca48b1c7aa1126f1d7fdc2a320dffd1e17532d201d7f89937f |
|
MD5 | 97c975a732d72b595f76b33a8af85e5f |
|
BLAKE2b-256 | f2474b8ac0a37ebc69949b57128603b5b7609f18bad7d09ffc410625a3b8c45d |