techhero-project-track-local.yml

#数据源
rdsdatasource:
  type: com.alibaba.druid.pool.DruidDataSource
  url: jdbc:oracle:thin:@119.96.87.17:1521:orcl
#   url: jdbc:oracle:thin:@119.96.85.104:1521:orcl
  username: SJGZV1
  password: SJGZV1
  driver-class-name: oracle.jdbc.OracleDriver
  initialSize: 5                                  #初始化提供的连接数
  minIdle: 5                                      #数据库连接池的最小维持连接数
  maxActive: 20                                   #最大的连接数
  maxWait: 60000
  timeBetweenEvictionRunsMillis: 60000            #空闲时间超过minEvictableIdleTimeMillis的连接则释放
  minEvictableIdleTimeMillis: 300000              #等待连接获取的最大超时时间
  validationQuery: SELECT 1 FROM DUAL             #启动开启检查连接性
  filters: stat,slf4j                             #监控配置
  connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000  # 通过connectProperties属性来打开mergeSql功能；慢SQL记录
  useGlobalDataSourceStat: true                   # 合并多个DruidDataSource的监控数据
  filter:
    commons-log:
      statement-log-enabled: true
      statement-executable-sql-log-enable: true

jckdatasource:
  type: com.alibaba.druid.pool.DruidDataSource
  url: jdbc:oracle:thin:@119.96.85.104:1521:orcl
  username: jcsjv2
  password: jcsjv2
  driver-class-name: oracle.jdbc.OracleDriver
  initialSize: 5                                  #初始化提供的连接数
  minIdle: 5                                      #数据库连接池的最小维持连接数
  maxActive: 20                                   #最大的连接数
  maxWait: 60000
  timeBetweenEvictionRunsMillis: 60000            #空闲时间超过minEvictableIdleTimeMillis的连接则释放
  minEvictableIdleTimeMillis: 300000              #等待连接获取的最大超时时间
  validationQuery: SELECT 1 FROM DUAL             #启动开启检查连接性
  filters: stat,slf4j                             #监控配置
  connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000  # 通过connectProperties属性来打开mergeSql功能；慢SQL记录
  useGlobalDataSourceStat: true                   # 合并多个DruidDataSource的监控数据
  filter:
    commons-log:
      statement-log-enabled: true
      statement-executable-sql-log-enable: true
      
#数据源
yjzhdatasource:
  type: com.alibaba.druid.pool.DruidDataSource
  url: jdbc:oracle:thin:@119.96.85.104:1521:orcl
  username: yjzh
  password: yjzh
  driver-class-name: oracle.jdbc.OracleDriver
  initialSize: 5                                  #初始化提供的连接数
  minIdle: 5                                      #数据库连接池的最小维持连接数
  maxActive: 20                                   #最大的连接数
  maxWait: 60000
  timeBetweenEvictionRunsMillis: 60000            #空闲时间超过minEvictableIdleTimeMillis的连接则释放
  minEvictableIdleTimeMillis: 300000              #等待连接获取的最大超时时间
  validationQuery: SELECT 1 FROM DUAL             #启动开启检查连接性
  filters: stat,slf4j                             #监控配置
  connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000  # 通过connectProperties属性来打开mergeSql功能；慢SQL记录
  useGlobalDataSourceStat: true                   # 合并多个DruidDataSource的监控数据
  filter:
    commons-log:
      statement-log-enabled: true
      statement-executable-sql-log-enable: true
 
 #数据源
statisdatasource:
  type: com.alibaba.druid.pool.DruidDataSource
  url: jdbc:oracle:thin:@119.96.87.17:1521:orcl
  username: SJGZ
  password: SJGZ
  driver-class-name: oracle.jdbc.OracleDriver
  initialSize: 9                                  #初始化提供的连接数
  minIdle: 9                                      #数据库连接池的最小维持连接数
  maxActive: 20                                   #最大的连接数
  maxWait: 60000
  timeBetweenEvictionRunsMillis: 60000            #空闲时间超过minEvictableIdleTimeMillis的连接则释放
  minEvictableIdleTimeMillis: 300000              #等待连接获取的最大超时时间
  validationQuery: SELECT 1 FROM DUAL             #启动开启检查连接性
  filters: stat,slf4j                             #监控配置
  connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000  # 通过connectProperties属性来打开mergeSql功能；慢SQL记录
  useGlobalDataSourceStat: true                   # 合并多个DruidDataSource的监控数据
  filter:
    commons-log:
      statement-log-enabled: true
      statement-executable-sql-log-enable: true

#基础数据
jcsjdatasource:
  type: com.alibaba.druid.pool.DruidDataSource
  url: jdbc:oracle:thin:@119.96.85.104:1521:orcl
  username: jcsjv2
  password: jcsjv2
  driver-class-name: oracle.jdbc.OracleDriver
  initialSize: 5                                  #初始化提供的连接数
  minIdle: 5                                      #数据库连接池的最小维持连接数
  maxActive: 20                                   #最大的连接数
  maxWait: 60000
  timeBetweenEvictionRunsMillis: 60000            #空闲时间超过minEvictableIdleTimeMillis的连接则释放
  minEvictableIdleTimeMillis: 300000              #等待连接获取的最大超时时间
  validationQuery: SELECT 1 FROM DUAL             #启动开启检查连接性
  filters: stat,slf4j                             #监控配置
  connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000  # 通过connectProperties属性来打开mergeSql功能；慢SQL记录
  useGlobalDataSourceStat: true                   # 合并多个DruidDataSource的监控数据
  filter:
    commons-log:
      statement-log-enabled: true
      statement-executable-sql-log-enable: true
      
spring:
  influx:
    openurl: http://119.96.99.9:18087 # 链接地址
    password: ""   # 密码
    username: ""  # 用户名
    dataBaseName: device_report  # 数据库名称


      
oss:
  bucketName: jyksy-gjjybzh
  httpEndpoint: ctyoss.chutianyun.gov.cn:8060
  httpsEndpoint: https://ctyoss.chutianyun.gov.cn:10443
  accessKey: L3B7SA05OXT0V9WKD02N
  secretKey: D0O4yTDqBCteH0p5dAgRibxZ8rNSLg0PShFF94IL
      
      
file:
  extraFile:
    tempFilePath: /temp/
template:
    download:
        smartLabelTemplatePath: /Users/cnnoter/Data/TempData/smartLabelTemplate.xlsx
        handTerminalTemplatePath: /Users/cnnoter/Data/TempData/handTerminalTemplate.xlsx
        
getByTerNoAndPlanCode: SELECT * FROM TB_GPS WHERE "terminalNumber" = {0} AND "planCode" = {1}  AND "terminalType" = {2}  ORDER BY "time" DESC  LIMIT 1

selevtTerminalHistory: SELECT * FROM TB_GPS WHERE "terminalNumber" = {0} AND "planCode" = {1} AND "terminalType" = {2} ORDER BY "time" ASC LIMIT 1000