public / sequelize

* 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/

Closes #5387

…e mssql dialect's describeTableQuery (#5852)

* added failing test case for LIKE ANY parentheses issue

* wrap ANY arguments with parentheses when using LIKE + ANY

* changelog entry for #5736

No instances in params for bulk commands; see https://github.com/sequelize/sequelize/blob/master/lib/hooks.js#L58

https://greenkeeper.io/

https://greenkeeper.io/

https://greenkeeper.io/

* Fixing associations doc

* Updating to nest where and attributes back under include

plus minor edit

https://greenkeeper.io/

* docs(datatype): add a note about BIGINT datatype conversion to string

This helps users to understand the reason to this conversion and avoid more open issues to Sequelize like these:
- https://github.com/sequelize/sequelize/issues/1774
- https://github.com/sequelize/sequelize/issues/4550

* docs(datatype): add documentation to source code

As described in https://github.com/sequelize/sequelize/issues/3302#issuecomment-199238449

* Refactor type validation on value escape

* Fix type validation for a list of values

* Fix type validation for incomplete UUIDs

Useful for instance for fuzzy searching (e.g. the LIKE comparator),
where anything that isn't the complete UUID would otherwise fail. Accept
strings as incomplete UUIDs for those scenarios.

* Enable type validation for all queries

https://greenkeeper.io/

http://greenkeeper.io/

* fix example

* use get method

* chore(package): update lodash to version 4.11.1

http://greenkeeper.io/

* chore(package): Work around issues with lodash.merge cloning