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.1.3

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.1.3
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)

Table of built distributions (wheels) for GeneralSQL 1.1.3
File Interpreter ABI Platform Actions
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.

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