update 增加 mysql 字段格式化处理 防止关键字问题
| | |
| | | updateStrategy: NOT_NULL |
| | | # 字段验证策略之 select,在 select 的时候的字段验证策略既 wrapper 根据内部 entity 生成的 where 条件 |
| | | where-strategy: NOT_NULL |
| | | # 对 mysql 的字段做格式化 防止出现系统关键字 |
| | | column-format: "`%s`" |
| | | |
| | | # Swagger配置 |
| | | swagger: |
| | |
| | | package com.ruoyi.common.core.domain.entity; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.TableField; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import com.fasterxml.jackson.annotation.JsonInclude; |
| | |
| | | * 路由参数 |
| | | */ |
| | | @ApiModelProperty(value = "路由参数") |
| | | @TableField("`query`") |
| | | private String query; |
| | | |
| | | /** |
| | |
| | | </resultMap> |
| | | |
| | | <select id="selectMenuListByUserId" parameterType="SysMenu" resultMap="SysMenuResult"> |
| | | select distinct m.menu_id, m.parent_id, m.menu_name, m.path, m.component, m.`query`, m.visible, m.status, |
| | | select distinct m.menu_id, m.parent_id, m.menu_name, m.path, m.component, m.query, m.visible, m.status, |
| | | m.perms, m.is_frame, m.is_cache, m.menu_type, m.icon, m.order_num, m.create_time |
| | | from sys_menu m |
| | | left join sys_role_menu rm on m.menu_id = rm.menu_id |
| | |
| | | m.menu_name, |
| | | m.path, |
| | | m.component, |
| | | m.`query`, |
| | | m.query, |
| | | m.visible, |
| | | m.status, |
| | | m.perms, |