This library provides functions for querying the latest partitions of MySQL database partition tables and creating table partitions.
Project description
说明[tips]
提供mysql数据库的分区表最新分区查询,支持分区字段为DATE或TO_DAYS(date_str)类型的数据表新建分区,依赖库包括:"pandas", "pymysql", "sqlalchemy".
[Provide the latest partition query for the partition table of MySQL database, supporting partition fields of DATE or TO_ Create new partitions for DAYS (date str) type data tables, with dependency libraries including "pandas", "pymysql", and "sqlalchemy".]
安装[install]
pip install mysql-partition
使用[use]
在使用之前请准备好数据库连接字典db_info [Please prepare the database connection dictionary db_info before use.]
db_info = {
"host": "127.0.0.1",
"port": 3306,
"username": "root",
"password": "lytcreate",
"database": "yt_zz"
}
1.获取指定数据库所有分区表的表名及最新分区[Obtain the table names and latest partitions of all partition tables in the specified database.]
import mysql_partition
res = mysql_partition.show(db_info) // return mysql partition dict.
2.创建指定数据库的所有分区表至指定分区日期,不指定日期则默认为执行当天[Create all partition tables for the specified database until the specified partition date. If no date is specified, it defaults to the execution day.]
import mysql_partition
mysql_partition.create(db_info, "2023-01-01") // Create all partition tables until January 1, 2023
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for mysql_partition-1.0.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e063297a37bd4d9359548876c68f27cc7ed7296cdd1c3bb416f4a900ec1ee3e9 |
|
MD5 | 624939f5f81f2110c21ee93ec9abcc95 |
|
BLAKE2b-256 | 26a1ca1006bf81e3ffb7a3b41a5b8d014dc760734d0b8bdc77b7c5497911cf20 |