Skip to main content

Sqlite3Helper

一个不安全的 sqlite3 包装库

介绍

因本人总是记不住 SQLite 的那些 SQL 语法,在 Python 里使用 sqlite3 这个库的时候每次都得去查语法,甚是烦躁,于是就编写了这个包装库,把常用的数据库操作都封装成了函数。

说这个库不安全,是因为这个库没有处理 SQL 注入攻击的问题。本来也就是自己用一用,注入攻击这么复杂的问题,还是先放一放吧。

安装

pip install Sqlite3Helper

安装可选的加密功能

需 2.2.6 版本以上,2.2.6 版本之前是强制安装的

pip install Sqlite3Helper[crypto]

示例

点击 这里 查看基本使用。

Release files for Sqlite3Helper 2.3.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for Sqlite3Helper 2.3.0
File Size Uploaded
sqlite3helper-2.3.0.tar.gz 23.8 kB Details

Built distribution (wheel)

Table of built distributions (wheels) for Sqlite3Helper 2.3.0
File Interpreter ABI Platform
Sqlite3Helper-2.3.0-py3-none-any.whl Python 3 none any Details

Total release size: 46.3 kB

Release files / sqlite3helper-2.3.0.tar.gz

Download URL sqlite3helper-2.3.0.tar.gz
Size 23.8 kB
Tags Source
SHA-256 checksum
How to use checksums
951519a7690d508cc9a0ddb5bf2d792a0cfb29d4c7ed783be95ec0c72a44f12e
BLAKE2b-256 checksum
How to use checksums
616170f2758600424af2d7a201c36a774e7ef7562cc2aaa73eb546a604b5ea5d
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/5.1.1 CPython/3.11.9

Release files / Sqlite3Helper-2.3.0-py3-none-any.whl

Download URL Sqlite3Helper-2.3.0-py3-none-any.whl
Size 22.5 kB
Tags Python 3
SHA-256 checksum
How to use checksums
11abc98111aed1c97cc79d8bcd6f385b4d65a7220102da840f70ff992f0f8513
BLAKE2b-256 checksum
How to use checksums
5fca793b77cb135240b06af22bd8f27eaee16f39d11f4f104960e68d8c7201f9
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/5.1.1 CPython/3.11.9

Release history Release notifications | RSS feed

This release

2.3.0 This release

2 release files

2.2.6

2 release files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page