# 更新日志
- 第一版
- 添加数据时，表名称加入双引号，避免跟关键字冲突
- `getfv`方法中也补充双引号，避免冲突
- 修复BUG，fetchone返回None时不应该进行`dict转换`
- 工资的随机数进行向上取证，比如9800=10000、8278=8500
- 工资的随机数最低为3000
# 连接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/d0/bf/5a175cf0f97fb14032fb66362fa899317638030d9db543dd4fec5dd5c6d0/pgman-0.0.6.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- \u5de5\u8d44\u7684\u968f\u673a\u6570\u8fdb\u884c\u5411\u4e0a\u53d6\u8bc1\uff0c\u6bd4\u59829800=10000\u30018278=8500\n- \u5de5\u8d44\u7684\u968f\u673a\u6570\u6700\u4f4e\u4e3a3000\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.6",
"project_urls": {
"Homepage": "https://github.com/markadc/wauo"
},
"split_keywords": [
"python",
" db",
" postgresql"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "d0bf5a175cf0f97fb14032fb66362fa899317638030d9db543dd4fec5dd5c6d0",
"md5": "12d5032e1767a0facba6a38abef8c7a0",
"sha256": "eb531918576d5c7b74bf266d2f61b3c763d3374068ff9e01fc8a876eb8a2338d"
},
"downloads": -1,
"filename": "pgman-0.0.6.tar.gz",
"has_sig": false,
"md5_digest": "12d5032e1767a0facba6a38abef8c7a0",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 3990,
"upload_time": "2024-10-05T16:01:48",
"upload_time_iso_8601": "2024-10-05T16:01:48.270561Z",
"url": "https://files.pythonhosted.org/packages/d0/bf/5a175cf0f97fb14032fb66362fa899317638030d9db543dd4fec5dd5c6d0/pgman-0.0.6.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-10-05 16:01:48",
"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"
}
JSON
