Skip to content

Data typing improved, XLSX and JSON source/destinations, truncate

Choose a tag to compare

View all tags
@psalmody psalmody released this 12 May 00:57
· 46 commits to master since this release
1.5.0
25bae7e

Features:

  • #68 Truncate option (-n or "truncate": true) allows for truncating SQL database tables and uploading new data so other table-related data isn't lost.
  • #25 XLSX source and destinations added (requires 0.10.0+ from SheetJS/xlsx)
  • #60 JSON source added

Improved:

  • #66 Output oracle sqlldr log and bad files if errors happen for easier debugging.
  • #59 Data typing improved dramatically. Now samples about 100 rows and tries to guess if the values are floats or dates. Can override with column names having _DEC or _DATE or TIMESTAMP in the name.

Fixes:

  • #57 Using require.main.require in databridge/local folder that is outside the install folder. No longer need to install packages in the local folder.
  • #67 Oracle destination quits properly on error
  • #69 Fixed dest/mysql dates not entering
Assets 2
Loading