public / sequelize

…nd attributes as fields

Update dependencies

This commit updates bluebird, sql and validator. The latter one is
reported to be vulnerable:
https://nodesecurity.io/advisories/validator-isurl-denial-of-service

fix replication always use write host

Upsert

…verted properly to SQL. Closes #2077

MaraiaDB dialect DATE parsing fix

Now you can use bare database URIs with sqlite also

Before db-uri like sqlite://database.db didn't work with sqlite. This little change fixes it.

refactor update/insert query to support additional features

  - added logic to handle corner cases regarding autoIncrement values
  - added support for OUTPUT variables (mssql)
  - added support for identity wrapping (related to point 1)

fix hardcoded timezone test

This test was dependent on a test having up to ~50ms of latency, which
is not necessarily guaranteed. This allows it to differ up to the actual
elapsed query time.

Fix forIn rather than each for iterating on object

only enable RESTRICT fk constraint tests for supporting dialects

MSSQL doesn't support a RESTRICT fk constraint, so we need a way
to conditionally disable these tests. This change adds an extra
section to dialect.supports indicating support for RESTRICT
constraints. Also changed some cases where RESTRICT wasn't being
explicitly tested but used to test the ability to simply use
constraints (query-interface.test.js)

add dialect support checking to tests

this allows us to test for dialect features in tests, see
test/transaction.test.js for an example of checking for row locking
support before running a test

make abstract dialect more abstract

This fixes two problems in particular:
  - there was no existing way to access information about the model
    you were generating a limit and offset for, so the model has been
    added to the options
  - included where generation was done from raw SQL, making it impossible
    to support other dialects that don't support the same LIMIT syntax