ES6 Updates

Utilizing es6 functions and classes to make code simpler and easier to read.

FIX: Float precision again

Now it should really be fixed - there was an inconsistency and issue with SQL Server.

FIX: Float precision

Float precision was way too low. Updated to largest precision available for SQL Server (53)

Fix: Wrong order in batch-parse Object.assign forced scripts to become bridges.

1.5.1

fix and version bump

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

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

Fix Schedule Batch Options

faec441 Fixed issue where schedule batch wasn't passing options of batch object to scripts or tot he bridges appropriately.

v1.4.2 - Try to Fix Oracle Mismatch Columns issue

Order column name query for dest/oracle by COLUMN_ID to try and fix the issue with oracle column mismatches. See #58

Hotfix: Oracle Destination when no Index Freeze

1.4.1

Merge branch 'fix/oracle-noindex'

TSV Source and Destination, Major Oracle Improvements, Mongo fixes and source

Breaking Changes

Due to issues with the way Oracle was loading, there was a relatively small cap on data. [#61] Initial attempts were incredibly slow. Moved to using Oracle's [sqlldr] which requires instant client 12.2.0.1.0 or higher including the "Tools" and "SDK" packages (sqlldr is in the tools package). See INSTALL.md for more info.

New Features

• Mongo source #26
• TSV (tab-separated values *.txt) destination and source #54

Fixes

• Oracle destination limits and speed improvements #61
• Mongo destination add index #15
• Mongo destination fix issues inserting only last column #56

Custom JS Scripts in Batches/Scheduler and Bugfixes

Added

• Append custom scripts to run during or after schedule or batch [#48]
• Node module require('databridge') documentation added to README [#35]

Changed

• Tests don't require user input - use timing and mock-stdin to simulate user input [#27]
• Added instructions at the end of setup.js for oracledb installation [#44]

Fixed

• Spinner stops on error in console [#49]
• Tests don't throw error when there are no batches in local installation [#38]