效果
源码
#!/usr/bin/env python
# -*- coding: utf-8 -*-
from tkinter import *
import hashlib
import re
import time
LOG_LINE_NUM = 0
jdbctype_javatype_map = {
'BIT(1)': 'Boolean',
'BIT': 'byte[]',
'TINYINT': 'Integer',
'TINYINT(1)': 'Boolean',
'BOOLEAN': 'Boolean',
'BOOL': 'Integer',
'SMALLINT': 'Integer',
'MEDIUMINT': 'Integer',
'INT,INTEGER': 'Integer',
'BIGINT': 'Long',
'FLOAT': 'Float',
'DOUBLE': 'jDouble',
'DECIMAL': 'BigDecimal',
'DATE': 'Date',
'DATETIME': 'Timestamp',
'TIMESTAMP': 'Timestamp',
'TIME': 'Time',
'YEAR': 'Short',
'CHAR': 'String ',
'VARCHAR': 'String',
'BINARY': 'byte[]',
'VARBINARY': 'byte[]',
'TINYBLOB': 'byte[]',
'TINYTEXT': 'String',
'BLOB': 'byte[]',
'TEXT': 'String',
'MEDIUMBLOB': 'byte[]',
'MEDIUMTEXT': 'String',
'LONGBLOB': 'byte[]',
'LONGTEXT': 'String',
'ENUM': 'String',
'SET': 'String'
}
# sql2md_req_match = re.compile("(\w+)\s*((\w)(?:\w+)\(?(\d*,?\d*)\)?)(?:\s*\w*)*'(.*)'.*", re.M)
sql2md_req_match = re.compile("(?P<column>\w+)\s*(?P<type>(?P<type_head>\w)(?:\w+)\(?(?P<type_length>\d*,?\d*)\)?)(?:\s*\w*)*'?(?P<comment>.*)'?.*")
# sql2md_req_match = re.compile(r"(\w+)\s* ((\w)(?:\w+) \(?(\d*,?\d*)\)?) (?:\s*\w*)*'(.*)'.*", re.M)
# sql2md_req_des = r"|{0}|-|String|{1}{2}|√|{3}|"
sql2md_req_des = r"|{column}|-|{type}|{type_head}{type_length}|√|{comment}|"
md_table_req_head = "|字段名称|父节点名称|字段类型|长度|必填|备注|\n|:-----:|:---------|:-----:|:--|:-:|:--|\n"
sql2md_res_match = sql2md_req_match
sql2md_res_des = r"|{column}|-|{type}|{comment}|"
md_table_res_head = "|字段名称|父节点名称|字段类型|备注|\n|-------|:--------|:-------|:--|\n"
md2javabean_req_match = re.compile("\|(?P<field>\w+)\|(?:\w*-*)\|(?P<java_type_head>\w)(?P<java_type_body>\w+<?\w*>?)\|\w*\-*\d*\,?.?\d*\|.*\|(?P<comment>.*)\|")
md2javabean_req_des = "\r\n\t/**\r\n\t*{comment}\r\n\t**/\r\n\tprivate {java_type_head}{java_type_body} {field};"
md2javabean_res_match = re.compile("\|(?P<field>\w+)\|(?:\w*-*)\|(?P<java_type_head>\w)(?P<java_type_body>\w+<?\w*>?)\|(?P<comment>.*)\|")
md2javabean_res_des = "\r\n\t/**\r\n\t*{comment}\r\n\t**/\r\n\tprivate {java_type_head}{java_type_body} {field};"
to_java_feild_type_match = re.compile("_(\w)")
class MY_GUI():
def __init__(self, init_window_name):
self.init_window_name = init_window_name
# 设置窗口
def set_init_window(self):
self.init_window_name.title("Markdown 小工具_v1.1") # 窗口名
# self.init_window_name.geometry('320x160+10+10') #290 160为窗口大小，+10 +10 定义窗口弹出时的默认展示位置
self.init_window_name.geometry('1068x681+10+10')
# self.init_window_name["bg"] = "pink" #窗口背景色，其他背景色见：blog.csdn.net/chl0000/article/details/7657887
# self.init_window_name.attributes("-alpha",0.9) #虚化，值越小虚化程度越高
# 标签
self.init_data_label = Label(self.init_window_name, text="待处理数据")
self.init_data_label.grid(row=0, column=0)
self.result_data_label = Label(self.init_window_name, text="输出结果")
self.result_data_label.grid(row=0, column=14)
self.log_label = Label(self.init_window_name, text="日志")
self.log_label.grid(row=12, column=0)
# 文本框
self.init_data_Text = Text(self.init_window_name, width=67, height=35) # 原始数据录入框
self.init_data_Text.grid(row=1, column=0, rowspan=10, columnspan=10)
self.result_data_Text = Text(self.init_window_name, width=70, height=49) # 处理结果展示
self.result_data_Text.grid(row=1, column=14, rowspan=15, columnspan=10)
self.log_data_Text = Text(self.init_window_name, width=66, height=9) # 日志框
self.log_data_Text.grid(row=13, column=0, columnspan=10)
# 按钮 2 md5
self.column_to_md_button = Button(self.init_window_name, text="转md5", bg="lightblue", width=10,
command=self.str_trans_to_md5) # 调用内部方法 加()为直接调用
# self.column_to_md_button.grid(row=1, column=11)
# 按钮 2 md table
self.sql_ddl_2_md_table_button = Button(self.init_window_name, text="ddl转md表格", bg="lightblue", width=20,
command=self.DB_column_to_md) # 调用内部方法 加()为直接调用
self.sql_ddl_2_md_table_button.grid(row=2, column=11)
# 按钮 2 java table
self.md_table_to_java_field_button = Button(self.init_window_name, text="md 转java field", bg="lightblue",
width=20,
command=self.md_table_to_java_field) # 调用内部方法 加()为直接调用
self.md_table_to_java_field_button.grid(row=3, column=11)
self.style = StringVar()
self.style.set('req')
self.req = Radiobutton(self.init_window_name, text='请求样式', variable=self.style, value='req')
self.req.grid(row=4, column=11)
self.res = Radiobutton(self.init_window_name, text='响应样式', variable=self.style, value='res')
self.res.grid(row=4, column=12)
def DB_column_to_md(self):
src = self.init_data_Text.get(1.0, END).strip()
if src:
style = self.style.get()
template = sql2md_req_des
matcher = sql2md_req_match
md_table_head = md_table_req_head
if style == 'res':
template = sql2md_res_des
matcher = sql2md_res_match
md_table_head = md_table_res_head
src.replace('`', '')
result = self.conversion(src, matcher, template, md_table_head=md_table_head)
self.result_data_Text.insert(3.0, result + '\n')
self.write_log_to_Text("INFO:trans success")
else:
self.write_log_to_Text("ERROR:input is none")
def md_table_to_java_field(self):
src = self.init_data_Text.get(1.0, END).strip()
if src:
style = self.style.get()
template = md2javabean_req_des
matcher = md2javabean_req_match
if style == 'res':
template = md2javabean_res_des
matcher = md2javabean_res_match
result = self.conversion(src, matcher, template, False)
self.result_data_Text.insert(1.0, result + '\n')
self.write_log_to_Text("INFO:trans success")
else:
self.write_log_to_Text("ERROR:input is none")
def conversion(self, src, matcher, template, to_md=True, md_table_head=None):
try:
result = ''
line_context = src.split("\n")
self.result_data_Text.delete(1.0, END)
if to_md:
self.result_data_Text.insert(1.0, md_table_head)
for i, context in enumerate(line_context):
sources_match = matcher.fullmatch(context.strip())
if sources_match:
match_dic = sources_match.groupdict()
if to_md:
self.mapping_java_type(match_dic)
des = template.format_map(match_dic)
# 输出到界面
result = result+des+"\n"
return result
except:
self.result_data_Text.delete(1.0, END)
self.write_log_to_Text.insert(1.0, "trans fail")
def mapping_java_type(self, match_dic):
type = match_dic.get("type")
java_type = jdbctype_javatype_map.get(type.upper())
if java_type is None:
type_matcher = re.findall("[a-zA-Z]+", type.strip().upper())
if type_matcher:
java_type = jdbctype_javatype_map.get(type_matcher[0])
match_dic["type"] = java_type
column = match_dic.get("column")
column = re.sub("_(?P<value>\w)", self.to_head_up, column)
match_dic["column"] = column
def str_trans_to_md5(self):
"""
String to MD5
:return:
"""
src = self.init_data_Text.get(1.0, END).strip().replace("\n", "").encode()
# print("src =",src)
if src:
try:
myMd5 = hashlib.md5()
myMd5.update(src)
myMd5_Digest = myMd5.hexdigest()
# print(myMd5_Digest)
# 输出到界面
self.result_data_Text.delete(1.0, END)
self.result_data_Text.insert(1.0, myMd5_Digest)
self.write_log_to_Text("INFO:str_trans_to_md5 success")
except:
self.result_data_Text.delete(1.0, END)
self.result_data_Text.insert(1.0, "字符串转MD5失败")
else:
self.write_log_to_Text("ERROR:str_trans_to_md5 failed")
@staticmethod
def to_head_up(matched):
return matched.group('value').upper()
# 获取当前时间
def get_current_time(self):
current_time = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(time.time()))
return current_time
# 日志动态打印
def write_log_to_Text(self, logmsg):
global LOG_LINE_NUM
current_time = self.get_current_time()
logmsg_in = str(current_time) + " " + str(logmsg) + "\n" # 换行
if LOG_LINE_NUM <= 7:
self.log_data_Text.insert(END, logmsg_in)
LOG_LINE_NUM = LOG_LINE_NUM + 1
else:
self.log_data_Text.delete(1.0, 2.0)
self.log_data_Text.insert(END, logmsg_in)
def gui_start():
init_window = Tk() # 实例化出一个父窗口
ZMJ_PORTAL = MY_GUI(init_window)
# 设置根窗口默认属性
ZMJ_PORTAL.set_init_window()
init_window.mainloop() # 父窗口进入事件循环，可以理解为保持窗口运行，否则界面不展示
gui_start()
##pyinstaller -n Markdownkit预览版-1.1 -w -F tk_test1.py
Loading Comments...