Skip to main content

General SQL

Sql 生成器工具

通用格式 处理不同数据库的数据 可根据 Template(模板) 进行自定义扩展

可参考 db/Jmysql.py

已支持数据库

  • mysql 安装 pip install mysql-connector

使用示例

各种方法详细使用设计

GeneralSQL 中目前有2种主要对象

  • SeniorDB 数据库对象
    • set_conf() 设置数据库对象的配置(连接配置)
    • get_conf() 获取配置信息
    • connect() 数据库连接
    • close() 关闭连接
  • SeniorSQL sql 对象
    • 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.4.2

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

Source distribution (sdist)

Source distribution for GeneralSQL 1.4.2
File Size Uploaded Provenance Actions
generalsql-1.4.2.tar.gz 49.6 kB Without provenance Details for generalsql-1.4.2.tar.gz

Built distribution (wheel)

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

Total release size: 89.7 kB

Release files / generalsql-1.4.2.tar.gz

Download URL generalsql-1.4.2.tar.gz
Size 49.6 kB
Tags Source
SHA-256 checksum
How to use checksums
434f3fe3fe5a2135510a6cd3cea44c83a95abe3b7bfd1ef86b50f1a6781b23c5
BLAKE2b-256 checksum
How to use checksums
60547fedb70cc96826cc706ba474c524a3137bde1249aacc7a0182752432d477
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/6.0.1 CPython/3.12.8

Release files / GeneralSQL-1.4.2-py3-none-any.whl

Download URL GeneralSQL-1.4.2-py3-none-any.whl
Size 40.0 kB
Tags Python 3
SHA-256 checksum
How to use checksums
fbd6067e7d3129d9ab12734a75d9b94c7f99add884aad6e137654c3772b7911f
BLAKE2b-256 checksum
How to use checksums
5fec2926d9c88d0b2f8aa2671495b9fc5cf350e26770ebda0a75cb4a855fd6b0
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/6.0.1 CPython/3.12.8

Security for GeneralSQL 1.4.2

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.

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