README.md in embulk-input-mysql-0.4.0 vs README.md in embulk-input-mysql-0.5.0

- old
+ new

@@ -29,10 +29,20 @@ - Internally, `useCursorFetch=false` is used and `java.sql.Statement.setFetchSize` is set to Integer.MIN_VALUE. - If this value is set to -1: - It uses a client-side built statement and fetches all rows at once. This may cause OutOfMemoryError. - Internally, `useCursorFetch=false` is used and `java.sql.Statement.setFetchSize` is not set. - **options**: extra JDBC properties (hash, default: {}) +- **default_timezone**: If the sql type of a column is `date`/`time`/`datetime` and the embulk type is `string`, column values are formatted int this default_timezone. You can overwrite timezone for each columns using column_options option. (string, default: `UTC`) +- **column_options**: advanced: a key-value pairs where key is a column name and value is options for the column. + - **value_type**: embulk get values from database as this value_type. Typically, the value_type determines `getXXX` method of `java.sql.PreparedStatement`. + (string, default: depends on the sql type of the column. Available values options are: `long`, `double`, `float`, `decimal`, `boolean`, `string`, `date`, `time`, `timestamp`) + - **type**: Column values are converted to this embulk type. + Available values options are: `boolean`, `long`, `double`, `string`, `timestamp`). + By default, the embulk type is determined according to the sql type of the column (or value_type if specified). + - **timestamp_format**: If the sql type of the column is `date`/`time`/`datetime` and the embulk type is `string`, column values are formatted by this timestamp_format. And if the embulk type is `timestamp`, this timestamp_format will be used in the output plugin. (string, default : `%Y-%m-%d` for `date`, `%H:%M:%S` for `time`, `%Y-%m-%d %H:%M:%S` for `timestamp`) + - **timezone**: If the sql type of the column is `date`/`time`/`datetime` and the embulk type is `string`, column values are formatted in this timezone. +(string, value of default_timezone option is used by default) ## Example ```yaml in: @@ -58,9 +68,27 @@ query: | SELECT t1.id, t1.name, t2.id AS t2_id, t2.name AS t2_name FROM table1 AS t1 LEFT JOIN table2 AS t2 ON t1.id = t2.t1_id +``` + +Advanced configuration: + +```yaml +in: + type: mysql + host: localhost + user: myuser + password: "" + database: my_database + table: "my_table" + select: "col1, col2, col3" + where: "col4 != 'a'" + column_options: + col1: {type: long} + col3: {type: string, timestamp_format: "%Y/%m/%d", timezone: "+0900"} + ``` ## Build ```