#!/bin/sh

DIR="/etc/elasticsearch/elasticsearch-jdbc-2.3.4.0"
bin=${DIR}/bin
lib=${DIR}/lib

echo '
{
    "type" : "jdbc",
    "jdbc" : {
        "url" : "jdbc:mysql://IP DATABASE MYSQL:3306/NOME DATABASE MYSQL",
        "statefile" : "statefile.json",
        "schedule" : "0 0-59 0-23 ? * *",
        "user" : "USERNAME DATABASE MYSQL",
        "password" : "PASSWORD DATABASE MYSQL",
        "sql" : [{
                "statement": "select * from TABELLA MYSQL",
                "parameter": []}
            ],
        "index" : "log_action",
        "type" : "actions",
        "metrics": {
            "enabled" : true
        },
        "elasticsearch" : {
             "cluster" : "elasticsearch",
             "host" : "172.17.0.2",
             "port" : "9300"
        }
    }
}
' | java \
    -cp "${lib}/*" \
    -Dlog4j.configurationFile=${bin}/log4j2.xml \
    org.xbib.tools.Runner \
    org.xbib.tools.JDBCImporter