若依框架完美适配达梦数据库的代码生成改造

最新推荐文章于 2025-04-21 18:50:40 发布

纳里莫奈

最新推荐文章于 2025-04-21 18:50:40 发布

阅读量516

点赞数 3

文章标签：数据库 sql

本文链接：https://blog.youkuaiyun.com/weixin_44685382/article/details/145013152

版权

一、GenTableColumnMapper
1个方法

    <select id="selectDbTableColumnsByName" parameterType="String" resultMap="GenTableColumnResult">
    select t3.COLUMN_NAME                     as column_name,
           (CASE
                WHEN (t3.NULLABLE = 'N' and t4.CONSTRAINT_TYPE !='P') THEN '1'
                ELSE NULL END)
                                              as is_required,
           IF(t4.CONSTRAINT_TYPE = 'P', 1, 0) as is_pk,
           t3.COLUMN_ID                       as sort,
           t5.COMMENTS                        as column_comment,
           (  CASE
                  WHEN (t3.TYPE = 'INT' OR t3.TYPE = 'INTEGER' OR t3.TYPE = 'BIGINT' OR t3.TYPE = 'TINYINT' OR
                        t3.TYPE = 'SMALLINT') and t4.CONSTRAINT_TYPE = 'P' THEN '1'
                  ELSE '0' END