Metadata-Version: 2.4
Name: tablesqlconverter
Version: 1.2.0
Summary: Convert table schema between MySQL, Hive, and string formats
Home-page: https://github.com/huangjie155/tablesqlconverter
Author: HuangJie
Author-email: huangjie155@msn.cn
Classifier: Programming Language :: Python :: 3
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: OS Independent
Requires-Python: >=3.6
Description-Content-Type: text/markdown
License-File: LICENSE
Dynamic: author
Dynamic: author-email
Dynamic: classifier
Dynamic: description
Dynamic: description-content-type
Dynamic: home-page
Dynamic: license-file
Dynamic: requires-python
Dynamic: summary

## TableSQLConverter V1.2

&#x20;      TableSQLConverter是为了方便将数据库表的基本元信息 以表格形式如excel的批量转换成Mysql建表或HiveSQL的建表语句。也能够根据SQL的 创表语句，提取出基本字段信息形成表格，或者SQL创表语句向Hive创表语句的转换。

![](README_md_files/d529b390-3ec7-11f1-9ab7-9942491d0aa8.jpeg?v=1&type=image)

&#x20;                                                                             图1 TableSQlConverter V1架构图

```
pip install tablesqlconverter
from tablesqlconverter import Converter
myCvt=Converter()
```

### schema 结构

```
{"<tbname>":[{"colname":"","type":"","comment":""},]}
```

## 示例

tbl数据间隔符号是”\t“,换行符号是"\n"

案例见test.py

