easybd 0.1.2

大数据工具包

A common utils to use

db utils

table info export to excel

from easybd.db import Mysql
mysql = Mysql("192.168.3.204", "3306", "root", "Mysql@2023", "cs", ["t_a", "t_b"])
mysql.table_info_to_excel("demo.xlsx")

excel utils

depend on above export excel to output some code,like : ddl, json files

from easybd.db.ddl import DDLType
from easybd.excel import Excel


e = Excel("demo.xlsx")
table = e.get_table("t_cs")

def test_ddl2pg():
    r = e.to_ddl(DDLType.PgSql, table.table_info)
    print(r)

def test_to_json_array():
    e.to_json_array(table)