pgman

Name	pgman JSON
Version	0.0.4 JSON
	download
home_page	https://github.com/markadc/wauo
Summary	Python操作PostgreSQL
upload_time	2024-07-15 07:03:51
maintainer	None
docs_url	None
author	WangTuo
requires_python	None
license	MIT
keywords	python db postgresql
VCS
bugtrack_url
requirements	fake_useragent loguru requests
Travis-CI	No Travis.
coveralls test coverage	No coveralls.

            # 更新日志

- 第一版
- 添加数据时，表名称加入双引号，避免跟关键字冲突
- `getfv`方法中也补充双引号，避免冲突
- 修复BUG，fetchone返回None时不应该进行`dict转换`

# 连接PostgreSQL

```python
from pgman import PostgreSQL

pg = PostgreSQL(db="test", user="wauo", password="123456")

name = "people"
pg.make_table(name)

res = pg.exe_sql("select * from people limit 10", query_all=True)
print(res)
```

            

Raw data

            {
    "_id": null,
    "home_page": "https://github.com/markadc/wauo",
    "name": "pgman",
    "maintainer": null,
    "docs_url": null,
    "requires_python": null,
    "maintainer_email": null,
    "keywords": "Python, DB, PostgreSQL",
    "author": "WangTuo",
    "author_email": "markadc@126.com",
    "download_url": "https://files.pythonhosted.org/packages/5b/a0/37a8be1ab8aa4a9ddd5e708f703e927fb2e07cd5095c2fa6391f0d2ffa23/pgman-0.0.4.tar.gz",
    "platform": null,
    "description": "# \u66f4\u65b0\u65e5\u5fd7\n\n- \u7b2c\u4e00\u7248\n- \u6dfb\u52a0\u6570\u636e\u65f6\uff0c\u8868\u540d\u79f0\u52a0\u5165\u53cc\u5f15\u53f7\uff0c\u907f\u514d\u8ddf\u5173\u952e\u5b57\u51b2\u7a81\n- `getfv`\u65b9\u6cd5\u4e2d\u4e5f\u8865\u5145\u53cc\u5f15\u53f7\uff0c\u907f\u514d\u51b2\u7a81\n- \u4fee\u590dBUG\uff0cfetchone\u8fd4\u56deNone\u65f6\u4e0d\u5e94\u8be5\u8fdb\u884c`dict\u8f6c\u6362`\n\n# \u8fde\u63a5PostgreSQL\n\n```python\nfrom pgman import PostgreSQL\n\npg = PostgreSQL(db=\"test\", user=\"wauo\", password=\"123456\")\n\nname = \"people\"\npg.make_table(name)\n\nres = pg.exe_sql(\"select * from people limit 10\", query_all=True)\nprint(res)\n```\n",
    "bugtrack_url": null,
    "license": "MIT",
    "summary": "Python\u64cd\u4f5cPostgreSQL",
    "version": "0.0.4",
    "project_urls": {
        "Homepage": "https://github.com/markadc/wauo"
    },
    "split_keywords": [
        "python",
        " db",
        " postgresql"
    ],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "5ba037a8be1ab8aa4a9ddd5e708f703e927fb2e07cd5095c2fa6391f0d2ffa23",
                "md5": "3cd2ebb0714faf37f6b0d5465727d2b8",
                "sha256": "adea691d87fee30391e1f9435eaff561b82343127657dcfd94561b1051431af2"
            },
            "downloads": -1,
            "filename": "pgman-0.0.4.tar.gz",
            "has_sig": false,
            "md5_digest": "3cd2ebb0714faf37f6b0d5465727d2b8",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 3876,
            "upload_time": "2024-07-15T07:03:51",
            "upload_time_iso_8601": "2024-07-15T07:03:51.315106Z",
            "url": "https://files.pythonhosted.org/packages/5b/a0/37a8be1ab8aa4a9ddd5e708f703e927fb2e07cd5095c2fa6391f0d2ffa23/pgman-0.0.4.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2024-07-15 07:03:51",
    "github": true,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "github_user": "markadc",
    "github_project": "wauo",
    "travis_ci": false,
    "coveralls": false,
    "github_actions": false,
    "requirements": [
        {
            "name": "fake_useragent",
            "specs": [
                [
                    "==",
                    "0.1.11"
                ]
            ]
        },
        {
            "name": "loguru",
            "specs": [
                [
                    "==",
                    "0.5.3"
                ]
            ]
        },
        {
            "name": "requests",
            "specs": [
                [
                    "==",
                    "2.28.1"
                ]
            ]
        }
    ],
    "lcname": "pgman"
}