From 8a89054c2f1dfa06c6dfc744217b35e66b8a3661 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子li <15040126243@163.com>
Date: 星期三, 09 三月 2022 16:21:53 +0800
Subject: [PATCH] add 增加 oracle_test.sql 测试sql文件
---
ruoyi-admin/src/main/resources/application.yml | 316 +++++++++++++++++++++++++++++++++++++++++----------
1 files changed, 251 insertions(+), 65 deletions(-)
diff --git a/ruoyi-admin/src/main/resources/application.yml b/ruoyi-admin/src/main/resources/application.yml
index de574b4..5641fdb 100644
--- a/ruoyi-admin/src/main/resources/application.yml
+++ b/ruoyi-admin/src/main/resources/application.yml
@@ -1,19 +1,28 @@
# 椤圭洰鐩稿叧閰嶇疆
ruoyi:
# 鍚嶇О
- name: RuoYi
+ name: RuoYi-Vue-Plus
# 鐗堟湰
- version: 3.0.0
+ version: ${ruoyi-vue-plus.version}
# 鐗堟潈骞翠唤
- copyrightYear: 2019
+ copyrightYear: 2022
# 瀹炰緥婕旂ず寮�鍏�
demoEnabled: true
- # 鏂囦欢璺緞,浣跨敤jvm绯荤粺鍙橀噺,鍏煎windows鍜宭inux;
- profile: ${user.home}/ruoyi/uploadPath
# 鑾峰彇ip鍦板潃寮�鍏�
- addressEnabled: false
+ addressEnabled: true
+ # 缂撳瓨鎳掑姞杞�
+ cacheLazy: false
+
+captcha:
+ # 椤甸潰 <鍙傛暟璁剧疆> 鍙紑鍚叧闂� 楠岃瘉鐮佹牎楠�
# 楠岃瘉鐮佺被鍨� math 鏁扮粍璁＄畻 char 瀛楃楠岃瘉
- captchaType: math
+ type: MATH
+ # line 绾挎骞叉壈 circle 鍦嗗湀骞叉壈 shear 鎵洸骞叉壈
+ category: CIRCLE
+ # 鏁板瓧楠岃瘉鐮佷綅鏁�
+ numberLength: 1
+ # 瀛楃楠岃瘉鐮侀暱搴�
+ charLength: 4
# 寮�鍙戠幆澧冮厤缃�
server:
@@ -22,93 +31,177 @@
servlet:
# 搴旂敤鐨勮闂矾寰�
context-path: /
+ # undertow 閰嶇疆
undertow:
- # 璁剧疆IO绾跨▼鏁�, 瀹冧富瑕佹墽琛岄潪闃诲鐨勪换鍔�,瀹冧滑浼氳礋璐ｅ涓繛鎺�, 榛樿璁剧疆姣忎釜CPU鏍稿績涓�涓嚎绋�
- io-threads: 8
- # 闃诲浠诲姟绾跨▼姹�, 褰撴墽琛岀被浼約ervlet璇锋眰闃诲鎿嶄綔, undertow浼氫粠杩欎釜绾跨▼姹犱腑鍙栧緱绾跨▼,瀹冪殑鍊艰缃彇鍐充簬绯荤粺鐨勮礋杞�
- worker-threads: 256
+ # HTTP post鍐呭鐨勬渶澶уぇ灏忋�傚綋鍊间负-1鏃讹紝榛樿鍊间负澶у皬鏄棤闄愮殑
+ max-http-post-size: -1
# 浠ヤ笅鐨勯厤缃細褰卞搷buffer,杩欎簺buffer浼氱敤浜庢湇鍔″櫒杩炴帴鐨処O鎿嶄綔,鏈夌偣绫讳技netty鐨勬睜鍖栧唴瀛樼鐞�
# 姣忓潡buffer鐨勭┖闂村ぇ灏�,瓒婂皬鐨勭┖闂磋鍒╃敤瓒婂厖鍒�
buffer-size: 512
# 鏄惁鍒嗛厤鐨勭洿鎺ュ唴瀛�
direct-buffers: true
-
+ threads:
+ # 璁剧疆IO绾跨▼鏁�, 瀹冧富瑕佹墽琛岄潪闃诲鐨勪换鍔�,瀹冧滑浼氳礋璐ｅ涓繛鎺�, 榛樿璁剧疆姣忎釜CPU鏍稿績涓�涓嚎绋�
+ io: 8
+ # 闃诲浠诲姟绾跨▼姹�, 褰撴墽琛岀被浼約ervlet璇锋眰闃诲鎿嶄綔, undertow浼氫粠杩欎釜绾跨▼姹犱腑鍙栧緱绾跨▼,瀹冪殑鍊艰缃彇鍐充簬绯荤粺鐨勮礋杞�
+ worker: 256
# 鏃ュ織閰嶇疆
logging:
level:
- com.ruoyi: debug
+ com.ruoyi: @logging.level@
org.springframework: warn
+ config: classpath:logback.xml
# Spring閰嶇疆
spring:
+ application:
+ name: ${ruoyi.name}
# 璧勬簮淇℃伅
messages:
# 鍥介檯鍖栬祫婧愭枃浠惰矾寰�
basename: i18n/messages
- profiles:
- active: dev
+ profiles:
+ active: @profiles.active@
# 鏂囦欢涓婁紶
servlet:
- multipart:
- # 鍗曚釜鏂囦欢澶у皬
- max-file-size: 10MB
- # 璁剧疆鎬讳笂浼犵殑鏂囦欢澶у皬
- max-request-size: 20MB
+ multipart:
+ # 鍗曚釜鏂囦欢澶у皬
+ max-file-size: 10MB
+ # 璁剧疆鎬讳笂浼犵殑鏂囦欢澶у皬
+ max-request-size: 20MB
# 鏈嶅姟妯″潡
devtools:
restart:
# 鐑儴缃插紑鍏�
enabled: true
+ # 涓巚ue鏁村悎閮ㄧ讲浣跨敤
+ thymeleaf:
+ # 灏嗙郴缁熸ā鏉挎斁缃埌鏈�鍓嶉潰 鍚﹀垯浼氫笌 springboot-admin 椤甸潰鍐茬獊
+ template-resolver-order: 1
+ mvc:
+ pathmatch:
+ # 閫傞厤 boot 2.6 璺敱涓� springfox 鍏煎
+ matching-strategy: ANT_PATH_MATCHER
+ jackson:
+ # 鏃ユ湡鏍煎紡鍖�
+ date-format: yyyy-MM-dd HH:mm:ss
+ serialization:
+ # 鏍煎紡鍖栬緭鍑�
+ indent_output: false
+ # 蹇界暐鏃犳硶杞崲鐨勫璞�
+ fail_on_empty_beans: false
+ deserialization:
+ # 鍏佽瀵硅薄蹇界暐json涓笉瀛樺湪鐨勫睘鎬�
+ fail_on_unknown_properties: false
-# token閰嶇疆
-token:
- # 浠ょ墝鑷畾涔夋爣璇�
- header: Authorization
- # 浠ょ墝瀵嗛挜
- secret: abcdefghijklmnopqrstuvwxyz
- # 浠ょ墝鏈夋晥鏈燂紙榛樿30鍒嗛挓锛�
- expireTime: 30
+# Sa-Token閰嶇疆
+sa-token:
+ # token鍚嶇О (鍚屾椂涔熸槸cookie鍚嶇О)
+ token-name: Authorization
+ # token鏈夋晥鏈� 璁句负涓�澶� (蹇呭畾杩囨湡) 鍗曚綅: 绉�
+ timeout: 86400
+ # token涓存椂鏈夋晥鏈� (鎸囧畾鏃堕棿鏃犳搷浣滃氨杩囨湡) 鍗曚綅: 绉�
+ activity-timeout: 1800
+ # 鏄惁鍏佽鍚屼竴璐﹀彿骞跺彂鐧诲綍 (涓簍rue鏃跺厑璁镐竴璧风櫥褰�, 涓篺alse鏃舵柊鐧诲綍鎸ゆ帀鏃х櫥褰�)
+ is-concurrent: true
+ # 鍦ㄥ浜虹櫥褰曞悓涓�璐﹀彿鏃讹紝鏄惁鍏辩敤涓�涓猼oken (涓簍rue鏃舵墍鏈夌櫥褰曞叡鐢ㄤ竴涓猼oken, 涓篺alse鏃舵瘡娆＄櫥褰曟柊寤轰竴涓猼oken)
+ is-share: false
+ # 鏄惁灏濊瘯浠庤姹備綋閲岃鍙杢oken
+ is-read-body: false
+ # 鏄惁灏濊瘯浠巋eader閲岃鍙杢oken
+ is-read-head: true
+ # 鏄惁灏濊瘯浠巆ookie閲岃鍙杢oken
+ is-read-cookie: false
+ # token鍓嶇紑
+ token-prefix: "Bearer"
+ # token椋庢牸
+ token-style: uuid
+ # jwt绉橀挜
+ jwt-secret-key: abcdefghijklmnopqrstuvwxyz
+ # 鏄惁杈撳嚭鎿嶄綔鏃ュ織
+ is-log: true
-# MyBatis閰嶇疆
+# security閰嶇疆
+security:
+ # 鎺掗櫎璺緞
+ excludes:
+ - /login
+ - /logout
+ - /register
+ - /captchaImage
+ # 闈欐�佽祫婧�
+ - /*.html
+ - /**/*.html
+ - /**/*.css
+ - /**/*.js
+ # swagger 鏂囨。閰嶇疆
+ - /doc.html
+ - /swagger-resources/**
+ - /webjars/**
+ - /*/api-docs
+ # druid 鐩戞帶閰嶇疆
+ - /druid/**
+ # actuator 鐩戞帶閰嶇疆
+ - /actuator
+ - /actuator/**
+
+# 閲嶅鎻愪氦
+repeat-submit:
+ # 鍏ㄥ眬闂撮殧鏃堕棿(姣)
+ interval: 5000
+
+# MyBatisPlus閰嶇疆
+# https://baomidou.com/config/
mybatis-plus:
- mapper-locations: classpath*:mapper/**/*Mapper.xml
- #瀹炰綋鎵弿锛屽涓猵ackage鐢ㄩ�楀彿鎴栬�呭垎鍙峰垎闅�
+ # 涓嶆敮鎸佸鍖�, 濡傛湁闇�瑕佸彲鍦ㄦ敞瑙ｉ厤缃� 鎴� 鎻愬崌鎵寘绛夌骇
+ # 渚嬪 com.**.**.mapper
+ mapperPackage: com.ruoyi.**.mapper
+ # 瀵瑰簲鐨� XML 鏂囦欢浣嶇疆
+ mapperLocations: classpath*:mapper/**/*Mapper.xml
+ # 瀹炰綋鎵弿锛屽涓猵ackage鐢ㄩ�楀彿鎴栬�呭垎鍙峰垎闅�
typeAliasesPackage: com.ruoyi.**.domain
+ # 鍚姩鏃舵槸鍚︽鏌� MyBatis XML 鏂囦欢鐨勫瓨鍦紝榛樿涓嶆鏌�
+ checkConfigLocation: false
configuration:
- map-underscore-to-camel-case: true
- cache-enabled: true
+ # 鑷姩椹煎嘲鍛藉悕瑙勫垯锛坈amel case锛夋槧灏�
+ mapUnderscoreToCamelCase: true
+ # MyBatis 鑷姩鏄犲皠绛栫暐
+ # NONE锛氫笉鍚敤 PARTIAL锛氬彧瀵归潪宓屽 resultMap 鑷姩鏄犲皠 FULL锛氬鎵�鏈� resultMap 鑷姩鏄犲皠
+ autoMappingBehavior: PARTIAL
+ # MyBatis 鑷姩鏄犲皠鏃舵湭鐭ュ垪鎴栨湭鐭ュ睘鎬у鐞嗙瓥
+ # NONE锛氫笉鍋氬鐞� WARNING锛氭墦鍗扮浉鍏宠鍛� FAILING锛氭姏鍑哄紓甯稿拰璇︾粏淇℃伅
+ autoMappingUnknownColumnBehavior: NONE
+ # 鏇磋缁嗙殑鏃ュ織杈撳嚭 浼氭湁鎬ц兘鎹熻�� org.apache.ibatis.logging.stdout.StdOutImpl
+ # 鍏抽棴鏃ュ織璁板綍 (鍙崟绾娇鐢� p6spy 鍒嗘瀽) org.apache.ibatis.logging.nologging.NoLoggingImpl
+ # 榛樿鏃ュ織杈撳嚭 org.apache.ibatis.logging.slf4j.Slf4jImpl
+ logImpl: org.apache.ibatis.logging.nologging.NoLoggingImpl
global-config:
- banner: false
- #鍒锋柊mapper 璋冭瘯绁炲櫒
- refresh: true
- db-config:
- #涓婚敭绫诲瀷 0:"鏁版嵁搴揑D鑷", 1:"鐢ㄦ埛杈撳叆ID",2:"鍏ㄥ眬鍞竴ID (鏁板瓧绫诲瀷鍞竴ID)", 3:"鍏ㄥ眬鍞竴ID UUID";
- id-type: auto
- #瀛楁绛栫暐 0:"蹇界暐鍒ゆ柇",1:"闈� NULL 鍒ゆ柇"),2:"闈炵┖鍒ゆ柇"
- field-strategy: not_empty
- #椹煎嘲涓嬪垝绾胯浆鎹�
- db-column-underline: true
- #鏁版嵁搴撳ぇ鍐欎笅鍒掔嚎杞崲
- #capital-mode: true
- #搴忓垪鎺ュ彛瀹炵幇绫婚厤缃�
- #key-generator: com.baomidou.springboot.xxx
- #閫昏緫鍒犻櫎閰嶇疆
- logic-delete-value: 1
- logic-not-delete-value: 0
- #鏁版嵁搴撶被鍨�
- db-type: mysql
- #鑷畾涔塖QL娉ㄥ叆鍣�
- #sql-injector: com.baomidou.mybatisplus.mapper.LogicSqlInjector
- #鑷畾涔夊～鍏呯瓥鐣ユ帴鍙ｅ疄鐜�
- #meta-object-handler: com.baomidou.springboot.xxx
-
-# PageHelper鍒嗛〉鎻掍欢
-pagehelper:
- helperDialect: mysql
- reasonable: true
- supportMethodsArguments: true
- params: count=countSql
+ # 鏄惁鎵撳嵃 Logo banner
+ banner: true
+ # 鏄惁鍒濆鍖� SqlRunner
+ enableSqlRunner: false
+ dbConfig:
+ # 涓婚敭绫诲瀷
+ # AUTO 鑷 NONE 绌� INPUT 鐢ㄦ埛杈撳叆 ASSIGN_ID 闆姳 ASSIGN_UUID 鍞竴 UUID
+ idType: AUTO
+ # 琛ㄥ悕鏄惁浣跨敤椹煎嘲杞笅鍒掔嚎鍛藉悕,鍙琛ㄥ悕鐢熸晥
+ tableUnderline: true
+ # 澶у啓鍛藉悕,瀵硅〃鍚嶅拰瀛楁鍚嶅潎鐢熸晥
+ capitalMode: false
+ # 閫昏緫宸插垹闄ゅ��
+ logicDeleteValue: 2
+ # 閫昏緫鏈垹闄ゅ��
+ logicNotDeleteValue: 0
+ # 瀛楁楠岃瘉绛栫暐涔� insert,鍦� insert 鐨勬椂鍊欑殑瀛楁楠岃瘉绛栫暐
+ # IGNORED 蹇界暐 NOT_NULL 闈濶ULL NOT_EMPTY 闈炵┖ DEFAULT 榛樿 NEVER 涓嶅姞鍏� SQL
+ insertStrategy: NOT_NULL
+ # 瀛楁楠岃瘉绛栫暐涔� update,鍦� update 鐨勬椂鍊欑殑瀛楁楠岃瘉绛栫暐
+ updateStrategy: NOT_NULL
+ # 瀛楁楠岃瘉绛栫暐涔� select,鍦� select 鐨勬椂鍊欑殑瀛楁楠岃瘉绛栫暐鏃� wrapper 鏍规嵁鍐呴儴 entity 鐢熸垚鐨� where 鏉′欢
+ where-strategy: NOT_NULL
+ # 瀵� mysql 鐨勫瓧娈靛仛鏍煎紡鍖� 闃叉鍑虹幇绯荤粺鍏抽敭瀛�
+ column-format: "`%s`"
# Swagger閰嶇疆
swagger:
@@ -116,12 +209,105 @@
enabled: true
# 璇锋眰鍓嶇紑
pathMapping: /dev-api
+ # 鏍囬
+ title: '鏍囬锛�${ruoyi.name}鍚庡彴绠＄悊绯荤粺_鎺ュ彛鏂囨。'
+ # 鎻忚堪
+ description: '鎻忚堪锛氱敤浜庣鐞嗛泦鍥㈡棗涓嬪叕鍙哥殑浜哄憳淇℃伅,鍏蜂綋鍖呮嫭XXX,XXX妯″潡...'
+ # 鐗堟湰
+ version: '鐗堟湰鍙�: ${ruoyi-vue-plus.version}'
+ # 浣滆�呬俊鎭�
+ contact:
+ name: Lion Li
+ email: crazylionli@163.com
+ url: https://gitee.com/JavaLionLi/RuoYi-Vue-Plus
+ groups:
+ - name: 1.婕旂ず妗堜緥
+ basePackage: com.ruoyi.demo
+ - name: 2.绯荤粺妯″潡
+ basePackage: com.ruoyi.web
+ - name: 3.浠ｇ爜鐢熸垚妯″潡
+ basePackage: com.ruoyi.generator
+
+knife4j:
+ # 鏄惁寮�鍚疜nife4j澧炲己妯″紡
+ enable: true
+ # 鏄惁寮�鍚敓浜х幆澧冧繚鎶ょ瓥鐣�
+ production: @knife4j.production@
+ basic:
+ enable: true
+ username: ruoyi
+ password: 123456
+ # 鍓嶇Ui鐨勪釜鎬у寲閰嶇疆灞炴��
+ setting:
+ # 榛樿璇█
+ language: zh-CN
+ # 鏄惁鏄剧ずFooter
+ enableFooter: false
+ # 鏄惁寮�鍚姩鎬佸弬鏁拌皟璇曞姛鑳�
+ enableDynamicParameter: true
+ # 鏄惁鍦ㄦ瘡涓狣ebug璋冭瘯鏍忓悗鏄剧ず鍒锋柊鍙橀噺鎸夐挳
+ enableReloadCacheParameter: true
# 闃叉XSS鏀诲嚮
-xss:
+xss:
# 杩囨护寮�鍏�
enabled: true
# 鎺掗櫎閾炬帴锛堝涓敤閫楀彿鍒嗛殧锛�
- excludes: /system/notice/*
+ excludes: /system/notice
# 鍖归厤閾炬帴
urlPatterns: /system/*,/monitor/*,/tool/*
+
+# 鍏ㄥ眬绾跨▼姹犵浉鍏抽厤缃�
+thread-pool:
+ # 鏄惁寮�鍚嚎绋嬫睜
+ enabled: false
+ # 鏍稿績绾跨▼姹犲ぇ灏�
+ corePoolSize: 8
+ # 鏈�澶у彲鍒涘缓鐨勭嚎绋嬫暟
+ maxPoolSize: 16
+ # 闃熷垪鏈�澶ч暱搴�
+ queueCapacity: 128
+ # 绾跨▼姹犵淮鎶ょ嚎绋嬫墍鍏佽鐨勭┖闂叉椂闂�
+ keepAliveSeconds: 300
+ # 绾跨▼姹犲鎷掔粷浠诲姟(鏃犵嚎绋嬪彲鐢�)鐨勫鐞嗙瓥鐣�
+ # CALLER_RUNS_POLICY 璋冪敤鏂规墽琛�
+ # DISCARD_OLDEST_POLICY 鏀惧純鏈�鏃х殑
+ # DISCARD_POLICY 涓㈠純
+ # ABORT_POLICY 涓
+ rejectedExecutionHandler: CALLER_RUNS_POLICY
+
+--- # redisson 缂撳瓨閰嶇疆
+redisson:
+ cacheGroup:
+ # 鐢ㄤ緥: @Cacheable(cacheNames="groupId", key="#XXX") 鏂瑰彲浣跨敤缂撳瓨缁勯厤缃�
+ - groupId: redissonCacheMap
+ # 缁勮繃鏈熸椂闂�(鑴氭湰鐩戞帶)
+ ttl: 60000
+ # 缁勬渶澶х┖闂叉椂闂�(鑴氭湰鐩戞帶)
+ maxIdleTime: 60000
+ # 缁勬渶澶ч暱搴�
+ maxSize: 0
+ - groupId: testCache
+ ttl: 1000
+ maxIdleTime: 500
+
+--- # 鍒嗗竷寮忛攣 lock4j 鍏ㄥ眬閰嶇疆
+lock4j:
+ # 鑾峰彇鍒嗗竷寮忛攣瓒呮椂鏃堕棿锛岄粯璁や负 3000 姣
+ acquire-timeout: 3000
+ # 鍒嗗竷寮忛攣鐨勮秴鏃舵椂闂达紝榛樿涓� 30 姣
+ expire: 30000
+
+--- # Actuator 鐩戞帶绔偣鐨勯厤缃」
+management:
+ endpoints:
+ web:
+ # Actuator 鎻愪緵鐨� API 鎺ュ彛鐨勬牴鐩綍銆傞粯璁や负 /actuator
+ base-path: /actuator
+ exposure:
+ # 闇�瑕佸紑鏀剧殑绔偣銆傞粯璁ゅ�煎彧鎵撳紑 health 鍜� info 涓や釜绔偣銆傞�氳繃璁剧疆 * 锛屽彲浠ュ紑鏀炬墍鏈夌鐐广��
+ # 鐢熶骇鐜涓嶅缓璁斁寮�鎵�鏈� 鏍规嵁椤圭洰闇�姹傛斁寮�鍗冲彲
+ include: @endpoints.include@
+ endpoint:
+ logfile:
+ external-file: ./logs/sys-console.log
--
Gitblit v1.9.3