public / sequelize

…other DB errors (#6462)

Issue #5356

  - update query interface with option restartIdentity
  - add test for option restartIdentity
  - update documentation for option restartIdentity with truncate
  - add restartIdentity entry in changelog

Enables support of sql-template-strings

* feat(model): expose model to global hooks

* tweak(model): remove redundant reference

Add changelog entry

…sing hasMany simultaneously (v3 pull request) (#5996)

* Closes #5985 - Cannot query a custom-named field when offsetting, ordering and including hasMany simultaneously.

* Attempting to fix BOM marks

* Clone options

* Remove whitespace

https://greenkeeper.io/

* add(associations): make belongsTo getter batch friendly

* add(associations): make belongsTo getter batch friendly

* add(associations): make hasOne getter batch friendly

* variable

* readd scope for has one

* reintroduce options.limit = null to fix mssql

* Improve validation when dealing with non-strings

validator@5.0.0+ has stopped coercing input values as strings and since
version 4, the library has been printing deprecation notices everytime a
non-string is passed to it.

All `validate` functions now correctly handle theses cases by delegating
this work to lodash functions.

* Coerce number values when validating

* Remove unneccesary tests checking options object not modified

These tests are now performed universally by the tests support shim

* Tidy tests code

* Updating MSSQL version query to return semver compatible string

* Altering query builder to handle sql server 2008

Use TOP instead of LIMIT for queries against SQL server <11.0

* Refactor abstract query builder to support overriding select fragments

* Adding OFFSET support for simple queries in SQL Server 2008

Nested queries still fail due to how WITH() queries must be defined

* Altering OFFSET support for SQL Server 2008 to enable complex queries

* Updating Docker to Node v5

Adding shortcut for running integration tests in containers

* Updating legacy SQL server OFFSET query to support WHERE clauses

* Adding rebuild of WHERE clauses for OFFSET

* Add proper handling for nested ORDER BY for SQL Server

* Moving field includes to outer query for SQL server OFFSET

* Changing semver comparison

* Making semver.valid check before using version

* Extracting query orders and deleting duplicate code

* Fixing lint problems

* Adding unit tests and documentation for SQL limit/offset

* Fixing lint problems

* Tweaking query build loop and renaming sql fragment builder

fix(belongs-to-many): constraint cascading are now properly preserved 

https://greenkeeper.io/

Signed-off-by: J Huang <i@jhuang.me>

* test for DECIMAL parser and string default

* fixed test cases using Int value for decimal

https://greenkeeper.io/