public / sequelize

add ability to test for dialect transaction support

…nd attributes as fields

Transaction support is currently very limited in the MSSQL dialect,
this allows us to conditionally skip transaction related tests for
a given dialect. I imagine it's also a nice feature to have when
adding a new dialect, so you don't have to solve all one thousand
errors at the same time

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)