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"