exit('请输入SQL文件路径')
dir = sys.argv[1]
try:
file = open(dir)
except IOError as err:
exit(err)
try:
# sql文件为GBK编码
content = file.read()
except OSError as err:
exit('文件读取失败:' + err)
finally:
file.close()
file_parser = FileParser()
# 将文件分离为每张表
table_list = file_parser.separatTable(content)
# 解析出表中表名及表详情
table_name = file_parser.parserTableName(table_list)
# 解析出每张表字段情况并与表名表详情组合
table_data = file_parser.parserColumn(table_list, table_name)
markdown_build = MarkDownBuild()
text = markdown_build.buildMarkdown(table_data)
file_name = os.path.basename(dir).split('.')[0] + '.md'
# 写文件
file_obj = ''
try:
file_obj = open(md_dir + file_name, 'w')
if (len(sys.argv) < 2):
exit('请输入SQL文件路径')
dir = sys.argv[1]
try:
file = open(dir)
except IOError, e:
exit(e)
try:
content = file.read()
except:
exit('文件读取失败')
finally:
file.close()
file_parser = FileParser()
# 将文件分离为每张表
table_list = file_parser.separatTable(content)
# 解析出表中表名及表详情
table_name = file_parser.parserTableName(table_list)
# 解析出每张表字段情况并与表名表详情组合
table_data = file_parser.parserColumn(table_list, table_name)
markdown_build = MarkDownBuild()
text = markdown_build.buildMarkdown(table_data)
file_name = os.path.basename(dir).split('.')[0] + '.md'
# 写文件
file_obj = ''
try:
file_obj = open(md_dir + file_name, 'w')