| 123456789101112131415161718192021222324252627282930313233343536 |
- default:
- sqlite_config:
- url: sqlite:/tmp/test.db
- lookup:
- cache: true
- cacheTtl: 600
- cacheMissingKey: true
- sqlserver_config:
- url: sqlserver://username:password@140.210.204.147/testdb
- internalSqlQueryCfg:
- table: Student
- limit: 10
- indexField: id
- indexValue: 1000
- # indexFieldType: "DATETIME"
- # dateTimeFormat: "YYYY-MM-dd HH:mm:ssSSS"
- # select top 10 * from Student where id > 1010 order by id ASC
- mysql_config:
- url: mysql://user:test@140.210.204.147/user?parseTime=true
- lookup:
- cache: true
- cacheTtl: 600
- cacheMissingKey: true
- template_config:
- interval: 10000
- url: mysql://user:test@140.210.204.147/user?parseTime=true
- templateSqlQueryCfg:
- TemplateSql: "select * from table where entry_date > '{{.entry_date}}'"
- indexField: entry_date
- indexValue: "2022-04-13 06:22:32.233"
- indexFieldType: "DATETIME"
- dateTimeFormat: "YYYY-MM-dd HH:mm:ssSSS"
|
