将创建表字段语句快速转换成golang struct字段

news/2024/9/13 0:10:17

用网页jquery快速生成

本地建立 struct.html

<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>leo-转换</title>
<script src="https://cdn.staticfile.org/jquery/1.10.2/jquery.min.js"></script>
<script>
	$(document).ready(function(){
		$("#btn").on("click",function(){
		    var content = $("#content").val();
            var split_str = content.split('\n');
            var html = ''
            $.each(split_str,function(index,value){
                var item = value.trim();
                var vv = item.split(' ');
                var name1 = vv[0].replace('`','').replace('`','');
                var name2 = capitalizeFirstLetter(name1);
                var type = kuohao(vv[1])
                var type2 = types(type)
                var lable = vv[vv.length-1].replace("'",'').replace("'",'').replace(",",'');

                html += '<span>'+name2+' '+type2+' `json:"'+name1+'"'+' form:"'+name1+'"'+'  gorm:"column:'+name1+'"'+'  label:"'+lable+'"`'+'</span><br />'
//                console.log(name1,name2,type2)
            })
            $('#list').append(html)

        })
        function kuohao(string){
            var vv = string.split('(');
            return vv[0]
        }
        function capitalizeFirstLetter(string) {
            return string.charAt(0).toUpperCase() + string.slice(1);
        }
        function types(string) {
            if(string == "int" || string == "bigint" || string == "tinyint" ) {
                return 'int'
            }else if (string == "decimal" ) {
                return 'float64'
            }
            return 'string'
        }

	});
</script>
</head>
<body>
<button id="btn">转换</button>
<textarea placeholder="请输入内容" class="layui-textarea" style="width:100%;height:300px;" id="content"></textarea><br />

<div id="list">

</div>

</body>
</html>

网页打开

输入创建表字段描述行点击生成即可复制下面的描述放入golang struct中

效果如下