| Name | Sqlite3Helper JSON |
| Version |
2.3.0
JSON |
| download |
| home_page | None |
| Summary | 一个不安全的 sqlite3 包装库 |
| upload_time | 2024-09-04 17:16:41 |
| maintainer | None |
| docs_url | None |
| author | None |
| requires_python | >=3.10 |
| license | None |
| keywords |
|
| VCS |
 |
| bugtrack_url |
|
| requirements |
No requirements were recorded.
|
| Travis-CI |
No Travis.
|
| coveralls test coverage |
No coveralls.
|
# Sqlite3Helper
一个不安全的 sqlite3 包装库
## 介绍
因本人总是记不住 SQLite 的那些 SQL 语法，在 Python 里使用 sqlite3 这个库的时候每次都得去查语法，甚是烦躁，于是就编写了这个包装库，把常用的数据库操作都封装成了函数。
说这个库不安全，是因为这个库没有处理 SQL 注入攻击的问题。本来也就是自己用一用，注入攻击这么复杂的问题，还是先放一放吧。
## 安装
```sh
pip install Sqlite3Helper
```
### 安装可选的加密功能
> 需 2.2.6 版本以上，2.2.6 版本之前是强制安装的
```sh
pip install Sqlite3Helper[crypto]
```
## 示例
点击 [这里](https://github.com/JulianFreeman/Sqlite3Helper/blob/main/docs/basic_usage.md) 查看基本使用。
Raw data
{
"_id": null,
"home_page": null,
"name": "Sqlite3Helper",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.10",
"maintainer_email": null,
"keywords": null,
"author": null,
"author_email": "Julian Freeman <freemanjulian372@gmail.com>",
"download_url": "https://files.pythonhosted.org/packages/61/61/70f2758600424af2d7a201c36a774e7ef7562cc2aaa73eb546a604b5ea5d/sqlite3helper-2.3.0.tar.gz",
"platform": null,
"description": "# Sqlite3Helper\r\n\r\n\u4e00\u4e2a\u4e0d\u5b89\u5168\u7684 sqlite3 \u5305\u88c5\u5e93\r\n\r\n## \u4ecb\u7ecd\r\n\r\n\u56e0\u672c\u4eba\u603b\u662f\u8bb0\u4e0d\u4f4f SQLite \u7684\u90a3\u4e9b SQL \u8bed\u6cd5\uff0c\u5728 Python \u91cc\u4f7f\u7528 sqlite3 \u8fd9\u4e2a\u5e93\u7684\u65f6\u5019\u6bcf\u6b21\u90fd\u5f97\u53bb\u67e5\u8bed\u6cd5\uff0c\u751a\u662f\u70e6\u8e81\uff0c\u4e8e\u662f\u5c31\u7f16\u5199\u4e86\u8fd9\u4e2a\u5305\u88c5\u5e93\uff0c\u628a\u5e38\u7528\u7684\u6570\u636e\u5e93\u64cd\u4f5c\u90fd\u5c01\u88c5\u6210\u4e86\u51fd\u6570\u3002\r\n\r\n\u8bf4\u8fd9\u4e2a\u5e93\u4e0d\u5b89\u5168\uff0c\u662f\u56e0\u4e3a\u8fd9\u4e2a\u5e93\u6ca1\u6709\u5904\u7406 SQL \u6ce8\u5165\u653b\u51fb\u7684\u95ee\u9898\u3002\u672c\u6765\u4e5f\u5c31\u662f\u81ea\u5df1\u7528\u4e00\u7528\uff0c\u6ce8\u5165\u653b\u51fb\u8fd9\u4e48\u590d\u6742\u7684\u95ee\u9898\uff0c\u8fd8\u662f\u5148\u653e\u4e00\u653e\u5427\u3002\r\n\r\n## \u5b89\u88c5\r\n\r\n```sh\r\npip install Sqlite3Helper\r\n```\r\n\r\n### \u5b89\u88c5\u53ef\u9009\u7684\u52a0\u5bc6\u529f\u80fd\r\n\r\n> \u9700 2.2.6 \u7248\u672c\u4ee5\u4e0a\uff0c2.2.6 \u7248\u672c\u4e4b\u524d\u662f\u5f3a\u5236\u5b89\u88c5\u7684\r\n\r\n```sh\r\npip install Sqlite3Helper[crypto]\r\n```\r\n\r\n\r\n## \u793a\u4f8b\r\n\r\n\u70b9\u51fb [\u8fd9\u91cc](https://github.com/JulianFreeman/Sqlite3Helper/blob/main/docs/basic_usage.md) \u67e5\u770b\u57fa\u672c\u4f7f\u7528\u3002\r\n",
"bugtrack_url": null,
"license": null,
"summary": "\u4e00\u4e2a\u4e0d\u5b89\u5168\u7684 sqlite3 \u5305\u88c5\u5e93",
"version": "2.3.0",
"project_urls": {
"Changelog": "https://github.com/JulianFreeman/Sqlite3Helper/blob/main/CHANGELOG.md",
"Homepage": "https://github.com/JulianFreeman/Sqlite3Helper",
"Repository": "https://github.com/JulianFreeman/Sqlite3Helper.git"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "5fca793b77cb135240b06af22bd8f27eaee16f39d11f4f104960e68d8c7201f9",
"md5": "6e8894b4177c6eb3030f68883d489bf4",
"sha256": "11abc98111aed1c97cc79d8bcd6f385b4d65a7220102da840f70ff992f0f8513"
},
"downloads": -1,
"filename": "Sqlite3Helper-2.3.0-py3-none-any.whl",
"has_sig": false,
"md5_digest": "6e8894b4177c6eb3030f68883d489bf4",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.10",
"size": 22452,
"upload_time": "2024-09-04T17:16:40",
"upload_time_iso_8601": "2024-09-04T17:16:40.410646Z",
"url": "https://files.pythonhosted.org/packages/5f/ca/793b77cb135240b06af22bd8f27eaee16f39d11f4f104960e68d8c7201f9/Sqlite3Helper-2.3.0-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "616170f2758600424af2d7a201c36a774e7ef7562cc2aaa73eb546a604b5ea5d",
"md5": "fe867194ea551b10f052c25d5753d861",
"sha256": "951519a7690d508cc9a0ddb5bf2d792a0cfb29d4c7ed783be95ec0c72a44f12e"
},
"downloads": -1,
"filename": "sqlite3helper-2.3.0.tar.gz",
"has_sig": false,
"md5_digest": "fe867194ea551b10f052c25d5753d861",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.10",
"size": 23821,
"upload_time": "2024-09-04T17:16:41",
"upload_time_iso_8601": "2024-09-04T17:16:41.717306Z",
"url": "https://files.pythonhosted.org/packages/61/61/70f2758600424af2d7a201c36a774e7ef7562cc2aaa73eb546a604b5ea5d/sqlite3helper-2.3.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-09-04 17:16:41",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "JulianFreeman",
"github_project": "Sqlite3Helper",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"lcname": "sqlite3helper"
}
