the missing step to overwrite default RDBMS configuration in the extension.

[ksdperera]

Description:
In the README missing the step to overwrite default RDBMS configuration in the extension.

If the user wishes to overwrite default RDBMS configuration in the extension, In the deployment yaml file has to be inserted in the following manner (properties set are optional).

siddhi: 
  extensions: 
    extension: 
      name: store
      namespace: rdbms
      properties: 
        mysql.batchEnable: true
        mysql.batchSize: 1000
        mysql.indexCreateQuery: "CREATE INDEX {{TABLE_NAME}}_INDEX ON {{TABLE_NAME}} ({{INDEX_COLUMNS}})"
        mysql.maxVersion: ~
        mysql.minVersion: ~
        mysql.recordDeleteQuery: "DELETE FROM {{TABLE_NAME}} {{CONDITION}}"
        mysql.recordExistsQuery: "SELECT 1 FROM {{TABLE_NAME}} {{CONDITION}} LIMIT 1"
        mysql.recordInsertQuery: "INSERT INTO {{TABLE_NAME}} VALUES ({{Q}})"
        mysql.recordSelectQuery: "SELECT * FROM {{TABLE_NAME}} {{CONDITION}}"
        mysql.recordUpdateQuery: "UPDATE {{TABLE_NAME}} SET {{COLUMNS_AND_VALUES}} {{CONDITION}}"
        mysql.stringSize: 254
        mysql.tableCheckQuery: "CREATE TABLE {{TABLE_NAME}} ({{COLUMNS, PRIMARY_KEYS}})"
        mysql.tableCreateQuery: "CREATE TABLE {{TABLE_NAME}} ({{COLUMNS, PRIMARY_KEYS}})"
        mysql.typeMapping.binaryType: BLOB
        mysql.typeMapping.booleanType: TINYINT(1)
        mysql.typeMapping.doubleType: DOUBLE
        mysql.typeMapping.floatType: FLOAT
        mysql.typeMapping.integerType: INTEGER
        mysql.typeMapping.longType: BIGINT
        mysql.typeMapping.stringType: VARCHAR
 

[karanlik]

Hi,

I've just posted a question about the very same issue on stackoverflow:

https://stackoverflow.com/questions/49648777/wso2-siddhi-rdbms-store-extension-how-to-set-batchenable-to-false

I'm quite interested about this "config guide".

best regards,

[niveathika]

If the siddhi extension is used as a Java library, System properties can be set through inMemoryconfigmanager

[niveathika]

Closing this as this is a duplicate of wso2/product-sp#472.