dbutils3-gonzalo123

Name	dbutils3-gonzalo123 JSON
Version	3.0.1 JSON
	download
home_page	https://github.com/gonzalo123/dbutils3
Summary	psycopg3 db utils
upload_time	2023-08-07 14:29:05
maintainer
docs_url	None
author	Gonzalo Ayuso
requires_python	>=3.5
license	MIT
keywords	psycopg3
VCS
bugtrack_url
requirements	No requirements were recorded.
Travis-CI	No Travis.
coveralls test coverage	No coveralls.

            # 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": "",
    "docs_url": null,
    "requires_python": ">=3.5",
    "maintainer_email": "",
    "keywords": "psycopg3",
    "author": "Gonzalo Ayuso",
    "author_email": "gonzalo123@gmail.com",
    "download_url": "https://files.pythonhosted.org/packages/c2/18/deae4b0180e4cdb4b1ac5072985e5160a022bf3cd8d7dd70dae35d8fd440/dbutils3-gonzalo123-3.0.1.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.1",
    "project_urls": {
        "Homepage": "https://github.com/gonzalo123/dbutils3"
    },
    "split_keywords": [
        "psycopg3"
    ],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "d8534647b7d6c658927992a7329e3567c1649404e4651e0eb27536c48843aace",
                "md5": "62b0ef05ed09c43cfaab21565f235c20",
                "sha256": "6188a3df0cb7e71db96a7dc54a5496b55ab2b6241c8e8f6de30b4b7291940c1a"
            },
            "downloads": -1,
            "filename": "dbutils3_gonzalo123-3.0.1-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "62b0ef05ed09c43cfaab21565f235c20",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": ">=3.5",
            "size": 6960,
            "upload_time": "2023-08-07T14:29:04",
            "upload_time_iso_8601": "2023-08-07T14:29:04.461399Z",
            "url": "https://files.pythonhosted.org/packages/d8/53/4647b7d6c658927992a7329e3567c1649404e4651e0eb27536c48843aace/dbutils3_gonzalo123-3.0.1-py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "c218deae4b0180e4cdb4b1ac5072985e5160a022bf3cd8d7dd70dae35d8fd440",
                "md5": "8b8a9c47f17192b748a69ce300bfc1c8",
                "sha256": "0a246f11de3c0d96e92935a1e61810c6823b08890b80f4e329331d624dbb52ee"
            },
            "downloads": -1,
            "filename": "dbutils3-gonzalo123-3.0.1.tar.gz",
            "has_sig": false,
            "md5_digest": "8b8a9c47f17192b748a69ce300bfc1c8",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": ">=3.5",
            "size": 6323,
            "upload_time": "2023-08-07T14:29:05",
            "upload_time_iso_8601": "2023-08-07T14:29:05.772862Z",
            "url": "https://files.pythonhosted.org/packages/c2/18/deae4b0180e4cdb4b1ac5072985e5160a022bf3cd8d7dd70dae35d8fd440/dbutils3-gonzalo123-3.0.1.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2023-08-07 14:29:05",
    "github": true,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "github_user": "gonzalo123",
    "github_project": "dbutils3",
    "travis_ci": false,
    "coveralls": false,
    "github_actions": false,
    "requirements": [],
    "lcname": "dbutils3-gonzalo123"
}