concentric
==========
a connection manager for python for connecting to various databases.
supported databases:
* oracle
* netsuite
* mssql
* mysql
* vertica
* redshift
* postgres
* db2 i-series
overview
--------
concentric is based off of `waddle <https://pypi.org/project/waddle/>`_ for secrets
management, which means it is strongly coupled to aws kms for its key management.
quick start
-----------
#. create a waddle configuration file
.. code-block::
oracle:
host: localhost
user: scott
password: tiger
sid: xe
#. waddle in the password for security
.. code-block::
waddle add-secret -f /path/to/config.yml oracle.password
#. use it
.. code-block::
from concentric.managers import setup_concentric
from concentric.managers import CachingConnectionManager as ccm
setup_concentric('/path/to/waddle_config.yml', '/path/to/another_config.yml')
conn = ccm.connect('oracle')
with conn.cursor() as cursor:
cursor.execute('select sysdate as dt from dual')
results = cursor.fetchall()
contributing
------------
Sample configuration files:
#. `db2 <./concentric/example_config/db2.yml>`_
#. `hp3000 <./concentric/example_config/hp3000.yml>`_
#. `mysql <./concentric/example_config/mysql.yml>`_
#. `netsuite <./concentric/example_config/netsuite.yml>`_
#. `oracle <./concentric/example_config/oracle_sid.yml>`_
#. `postgres <./concentric/example_config/postgres.yml>`_
#. `redshift <./concentric/example_config/redshift.yml>`_
#. `snowflake <./concentric/example_config/snowflake.yml>`_
#. `sql server <./concentric/example_config/sql_server.yml>`_
#. `vertica <./concentric/example_config/vertica.yml>`_
Raw data
{
"_id": null,
"home_page": "https://bitbucket.org/dbuy/concentric",
"name": "concentric",
"maintainer": null,
"docs_url": null,
"requires_python": null,
"maintainer_email": null,
"keywords": null,
"author": "Preetam Shingavi",
"author_email": "p.shingavi@yahoo.com",
"download_url": "https://files.pythonhosted.org/packages/7f/f3/38a49bb538295d4d596d6bef88324df1f9d1351edfcce33e30d50ee243ee/concentric-1.2.tar.gz",
"platform": null,
"description": "concentric\n==========\n\na connection manager for python for connecting to various databases.\n\nsupported databases:\n\n* oracle\n* netsuite\n* mssql\n* mysql\n* vertica\n* redshift\n* postgres\n* db2 i-series\n\noverview\n--------\n\nconcentric is based off of `waddle <https://pypi.org/project/waddle/>`_ for secrets\nmanagement, which means it is strongly coupled to aws kms for its key management.\n\n\nquick start\n-----------\n\n#. create a waddle configuration file\n\n .. code-block::\n\n oracle:\n host: localhost\n user: scott\n password: tiger\n sid: xe\n\n#. waddle in the password for security\n\n .. code-block::\n\n waddle add-secret -f /path/to/config.yml oracle.password\n\n#. use it\n\n .. code-block::\n\n from concentric.managers import setup_concentric\n from concentric.managers import CachingConnectionManager as ccm\n\n setup_concentric('/path/to/waddle_config.yml', '/path/to/another_config.yml')\n conn = ccm.connect('oracle')\n with conn.cursor() as cursor:\n cursor.execute('select sysdate as dt from dual')\n results = cursor.fetchall()\n\n\ncontributing\n------------\n\nSample configuration files:\n\n#. `db2 <./concentric/example_config/db2.yml>`_\n#. `hp3000 <./concentric/example_config/hp3000.yml>`_\n#. `mysql <./concentric/example_config/mysql.yml>`_\n#. `netsuite <./concentric/example_config/netsuite.yml>`_\n#. `oracle <./concentric/example_config/oracle_sid.yml>`_\n#. `postgres <./concentric/example_config/postgres.yml>`_\n#. `redshift <./concentric/example_config/redshift.yml>`_\n#. `snowflake <./concentric/example_config/snowflake.yml>`_\n#. `sql server <./concentric/example_config/sql_server.yml>`_\n#. `vertica <./concentric/example_config/vertica.yml>`_\n",
"bugtrack_url": null,
"license": "BSD",
"summary": "a simple connection manager for connecting to various rdbms (mostly legacy)",
"version": "1.2",
"project_urls": {
"Homepage": "https://bitbucket.org/dbuy/concentric"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "7ff338a49bb538295d4d596d6bef88324df1f9d1351edfcce33e30d50ee243ee",
"md5": "5fa3dddd0fab8d7a126fb9a1e6687a11",
"sha256": "6728c773f4dfa6c935083ccf5cd4090ba0cef9ae26fc2310d2d29043856e7558"
},
"downloads": -1,
"filename": "concentric-1.2.tar.gz",
"has_sig": false,
"md5_digest": "5fa3dddd0fab8d7a126fb9a1e6687a11",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 14258,
"upload_time": "2024-11-07T02:59:52",
"upload_time_iso_8601": "2024-11-07T02:59:52.868371Z",
"url": "https://files.pythonhosted.org/packages/7f/f3/38a49bb538295d4d596d6bef88324df1f9d1351edfcce33e30d50ee243ee/concentric-1.2.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-11-07 02:59:52",
"github": false,
"gitlab": false,
"bitbucket": true,
"codeberg": false,
"bitbucket_user": "dbuy",
"bitbucket_project": "concentric",
"lcname": "concentric"
}
JSON