source : {
...
"extractType" : "Database",
"authentication" : {
"username" : "username",
"password" : "password"},
"database" : {
"databaseType" : "mysql",
"hostname" : "my.databaseserver.com",
"port" : "3306"
"databaseName" : "database",
"query" : "SELECT * FROM IncidentReport",
"deltaQuery" : "SELECT * FROM IncidentReport WHERE REPORTDATETIME >= (SELECT ADDDATE(CURDATE(),-7))",
"deleteQuery" : "",
"primaryKey" : "NID",
"title" : "CCN",
"snippet" : "OFFENSE",
"publishedDate" : "REPORTDATETIME"
},
"useExtractor" : "none",
...
} |