General SQL
Sql 生成器工具
通用格式 处理不同数据库的数据 可根据 Template(模板) 进行自定义扩展
可参考 db/Jmysql.py
已支持数据库
- mysql 安装
pip install mysql-connector
使用示例
各种方法详细使用设计
GeneralSQL 中目前有2种主要对象
SeniorDB数据库对象set_conf()设置数据库对象的配置(连接配置)get_conf()获取配置信息connect()数据库连接close()关闭连接
SeniorSQLsql 对象Add(*args, **kwargs) -> sql添加数据方法 返回 sql 对象Del(*args, **kwargs) -> sql删除数据方法 返回 sql 对象Up(*args, **kwargs) -> sql更新数据方法 返回 sql 对象Sel(*args, **kwargs) -> sql查询数据方法 返回 sql 对象
- sql 对象方法
set_join(*args, **kwargs)设置连表查询set_where(*args, **kwargs)设置条件set_group(*args, **kwargs)设置分组set_order(*args, **kwargs)设置排序set_limit(*args, **kwargs)设置分页data_decode(*args, **kwargs)数据解码format_sql(*args, **kwargs)格式化数据format_data(*args, **kwargs)格式化数据
Metadata
Release files for GeneralSQL 1.1.3
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | Actions |
|---|---|---|---|---|
| GeneralSQL-1.1.3.tar.gz | 47.0 kB | Without provenance | Details for GeneralSQL-1.1.3.tar.gz |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Actions Reset |
|---|---|---|---|---|
| GeneralSQL-1.1.3-py3-none-any.whl | Python 3 | none | any | Details for GeneralSQL-1.1.3-py3-none-any.whl |
Total release size: 69.2 kB
Release files / GeneralSQL-1.1.3.tar.gz
| Download URL | GeneralSQL-1.1.3.tar.gz |
|---|---|
| Size | 47.0 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
72d00c74c46fab782ad85e38e15319942cbe5a04a7e9ee04a5c494d931ff345d
|
|
BLAKE2b-256 checksum How to use checksums |
cf51eadfd010e6298caaad5227f65a25dc2c0b39a91c254f8507da1785357aa0
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.11.6
|
Release files / GeneralSQL-1.1.3-py3-none-any.whl
| Download URL | GeneralSQL-1.1.3-py3-none-any.whl |
|---|---|
| Size | 22.2 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
1ca33573bc7034e6fd6df9ff5acac4c07dc8f0b9d9bb43b2ac6bc4c44d83a155
|
|
BLAKE2b-256 checksum How to use checksums |
541953576b3adbae25889c75597929d9c9ae779cd9a7019ba5e08cb9a6f7cf5c
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/4.0.2 CPython/3.11.6
|
Security for GeneralSQL 1.1.3
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.