# Database utils for psycopg3
[dbutils](https://github.com/gonzalo123/dbutils)
## Install
```commandline
pip install dbutils3-gonzalo123
```
From github
```commandline
pip install -e git+https://github.com/gonzalo123/dbutils3#egg=dbutils-gonzalo123
```
### Run test
```commandline
pytest
```
Note: Set up your connection parameters within pytest.ini. I also provide one docker-compose.yml file with a PostgreSQL database ready for the testing.
```ini
[pytest]
python_files = tests.py test_*.py *_tests.py
env =
POSTGRES_HOST=localhost
POSTGRES_PASSWORD=password
POSTGRES_USER=username
POSTGRES_DB=gonzalo123
```
In this database ther's one table and one stored procedure:
```sql
CREATE TABLE users
(
email VARCHAR(256) UNIQUE NOT NULL,
"name" VARCHAR(256) NOT NULL
);
CREATE OR REPLACE FUNCTION hello(name varchar(100))
RETURNS VARCHAR AS
$$
BEGIN
RETURN 'Hello ' || name;
END;
$$
LANGUAGE plpgsql;
```
Raw data
{
"_id": null,
"home_page": "https://github.com/gonzalo123/dbutils3",
"name": "dbutils3-gonzalo123",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.5",
"maintainer_email": null,
"keywords": "psycopg3",
"author": "Gonzalo Ayuso",
"author_email": "gonzalo123@gmail.com",
"download_url": "https://files.pythonhosted.org/packages/4b/1f/513629865af9c1b0c9d02c2a9a866b0e2c06e17eb0c81ff8e9faa0748c52/dbutils3-gonzalo123-3.0.2.tar.gz",
"platform": null,
"description": "# Database utils for psycopg3\n\n[dbutils](https://github.com/gonzalo123/dbutils)\n\n## Install\n\n```commandline\npip install dbutils3-gonzalo123\n```\n\nFrom github\n```commandline\npip install -e git+https://github.com/gonzalo123/dbutils3#egg=dbutils-gonzalo123\n```\n\n### Run test\n```commandline\npytest\n```\n\nNote: Set up your connection parameters within pytest.ini. I also provide one docker-compose.yml file with a PostgreSQL database ready for the testing.\n\n```ini\n[pytest]\npython_files = tests.py test_*.py *_tests.py\nenv =\n POSTGRES_HOST=localhost\n POSTGRES_PASSWORD=password\n POSTGRES_USER=username\n POSTGRES_DB=gonzalo123\n```\n\nIn this database ther's one table and one stored procedure:\n\n```sql\nCREATE TABLE users\n(\n email VARCHAR(256) UNIQUE NOT NULL,\n \"name\" VARCHAR(256) NOT NULL\n);\n\nCREATE OR REPLACE FUNCTION hello(name varchar(100))\n RETURNS VARCHAR AS\n$$\nBEGIN\n RETURN 'Hello ' || name;\n\nEND;\n$$\n LANGUAGE plpgsql;\n```\n\n\n",
"bugtrack_url": null,
"license": "MIT",
"summary": "psycopg3 db utils",
"version": "3.0.2",
"project_urls": {
"Homepage": "https://github.com/gonzalo123/dbutils3"
},
"split_keywords": [
"psycopg3"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "835e7b98ce3ee351af577924e96417a57787945e00db49c25a941349b8fd8690",
"md5": "31833088951c50ac87ce2f1f69df836b",
"sha256": "0018ab24272a0e2ced6a23ebff31b2cc553a066df1ebe5d555ea36edb12d1bc7"
},
"downloads": -1,
"filename": "dbutils3_gonzalo123-3.0.2-py3-none-any.whl",
"has_sig": false,
"md5_digest": "31833088951c50ac87ce2f1f69df836b",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.5",
"size": 7044,
"upload_time": "2024-06-18T08:36:31",
"upload_time_iso_8601": "2024-06-18T08:36:31.757373Z",
"url": "https://files.pythonhosted.org/packages/83/5e/7b98ce3ee351af577924e96417a57787945e00db49c25a941349b8fd8690/dbutils3_gonzalo123-3.0.2-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "4b1f513629865af9c1b0c9d02c2a9a866b0e2c06e17eb0c81ff8e9faa0748c52",
"md5": "03fe60fb79b47c102b0467e32c85886a",
"sha256": "348dd94f9a7967eba91145d4de3036c67a00b31169ad49187899509342f8b4a8"
},
"downloads": -1,
"filename": "dbutils3-gonzalo123-3.0.2.tar.gz",
"has_sig": false,
"md5_digest": "03fe60fb79b47c102b0467e32c85886a",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.5",
"size": 6486,
"upload_time": "2024-06-18T08:36:44",
"upload_time_iso_8601": "2024-06-18T08:36:44.889086Z",
"url": "https://files.pythonhosted.org/packages/4b/1f/513629865af9c1b0c9d02c2a9a866b0e2c06e17eb0c81ff8e9faa0748c52/dbutils3-gonzalo123-3.0.2.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-06-18 08:36:44",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "gonzalo123",
"github_project": "dbutils3",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"requirements": [
{
"name": "bleach",
"specs": [
[
"==",
"6.0.0"
]
]
},
{
"name": "certifi",
"specs": [
[
"==",
"2023.7.22"
]
]
},
{
"name": "charset-normalizer",
"specs": [
[
"==",
"3.2.0"
]
]
},
{
"name": "docutils",
"specs": [
[
"==",
"0.20.1"
]
]
},
{
"name": "exceptiongroup",
"specs": [
[
"==",
"1.1.2"
]
]
},
{
"name": "idna",
"specs": [
[
"==",
"3.4"
]
]
},
{
"name": "importlib-metadata",
"specs": [
[
"==",
"6.8.0"
]
]
},
{
"name": "iniconfig",
"specs": [
[
"==",
"2.0.0"
]
]
},
{
"name": "jaraco.classes",
"specs": [
[
"==",
"3.3.0"
]
]
},
{
"name": "keyring",
"specs": [
[
"==",
"24.2.0"
]
]
},
{
"name": "markdown-it-py",
"specs": [
[
"==",
"3.0.0"
]
]
},
{
"name": "mdurl",
"specs": [
[
"==",
"0.1.2"
]
]
},
{
"name": "more-itertools",
"specs": [
[
"==",
"10.1.0"
]
]
},
{
"name": "packaging",
"specs": [
[
"==",
"23.1"
]
]
},
{
"name": "pkginfo",
"specs": [
[
"==",
"1.9.6"
]
]
},
{
"name": "pluggy",
"specs": [
[
"==",
"1.2.0"
]
]
},
{
"name": "psycopg",
"specs": [
[
"==",
"3.1.10"
]
]
},
{
"name": "Pygments",
"specs": [
[
"==",
"2.16.1"
]
]
},
{
"name": "pytest",
"specs": [
[
"==",
"7.4.0"
]
]
},
{
"name": "pytest-env",
"specs": [
[
"==",
"0.8.2"
]
]
},
{
"name": "readme-renderer",
"specs": [
[
"==",
"40.0"
]
]
},
{
"name": "requests",
"specs": [
[
"==",
"2.31.0"
]
]
},
{
"name": "requests-toolbelt",
"specs": [
[
"==",
"1.0.0"
]
]
},
{
"name": "rfc3986",
"specs": [
[
"==",
"2.0.0"
]
]
},
{
"name": "rich",
"specs": [
[
"==",
"13.5.2"
]
]
},
{
"name": "six",
"specs": [
[
"==",
"1.16.0"
]
]
},
{
"name": "tomli",
"specs": [
[
"==",
"2.0.1"
]
]
},
{
"name": "twine",
"specs": [
[
"==",
"4.0.2"
]
]
},
{
"name": "typing_extensions",
"specs": [
[
"==",
"4.7.1"
]
]
},
{
"name": "urllib3",
"specs": [
[
"==",
"2.0.4"
]
]
},
{
"name": "webencodings",
"specs": [
[
"==",
"0.5.1"
]
]
},
{
"name": "zipp",
"specs": [
[
"==",
"3.16.2"
]
]
}
],
"lcname": "dbutils3-gonzalo123"
}
JSON
