# 更新日志
- 第一版
- 添加数据时,表名称加入双引号,避免跟关键字冲突
- `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"
}