public / sequelize

* Enabled filtered indexes for SQL Server

* [ci skip] Added filtered indexes to docs/migrations.md

* add failing unit test

* use .slice instead of .splice to get arguments for scope functions

* add message to changelog.md

* fix: use paranoid with groupedLimit.on association

* logging and unstable test

* eslint changes

* Update belongs-to-many.js

https://greenkeeper.io/

* added validation checks for findall

* unittest input validations checking code for findall

* es6 changes function to =>

* trailing whitespace

* remove unnecessary use of bind given es6 => funcs

* update changelog and fix jshint errors

* fix changelog

* add test to make sure findall calls input validation function

* remove only from test

* remove generic invalid option support and only apply for model attributes

* Add missing period.

* Remove extra "here"

* rewrite logic for finding associations

* update and add new error messgaes and change existing tests to match

* remove comments

* tighten up code for getting associations and keep support for node4

* create SequelizeEagerLoadingError

* remove spaces

* added some happy path unit tests for _getIncludedAssociation

* updated the change log

* remove only

* associations with duplicate aliases are not allowed

* add semi-colon

* place hasAlias in more sensible locatio

* added hasAlias tests

* added association tests for duplicate aliases

* remove unused require

* update changeload

* small formatting changes

* add missing parameter

* remove some basic setup from each association and add to constructor

* add regression tests for improperly constructed belongsToMany associations

* use single quote strings and small const fix

* eslint fixes

* small refactor

* jshint promise expception added

* [MSSQL] MERGE statement foreignKey violation is formatted as ForeignKeyConstraintError, Closes #7011

* Added changelog entry

* Alter changelog entry

* [ci skip] link to issue

* rewrite logic for finding associations

* update and add new error messgaes and change existing tests to match

* remove comments

* tighten up code for getting associations and keep support for node4

* create SequelizeEagerLoadingError

* remove spaces

* added some happy path unit tests for _getIncludedAssociation

* updated the change log

* remove only

* [MSSQL] Uses crypto randomBytes to generate 20 character trasaction identifier, enabled trasaction tests for mssql dialect

* Added missing break, changelog entry

* Added READ_COMMITTED_SNAPSHOT ON script for tests, fixes skipped tests, transaction savepoints, uses sequelize_test as default database on appveyor

* Added sqlcmd database query to appveyor-setup.ps1

* Added sequelize_test as default db in test/config/config for MSSQL dialect

* Moved READ_COMMITTED_SNAPSHOT ON query to appveyor ps script

* Replaced lodash includes with startsWith, review fixes, closes #6954

* try catch block added for formatting parameters process

* new line space added before braces

* query function processing wrapped to Promise.try

* processQuery method removed from var

* binding context changed to arrow function

* promise.try chaining added

* extra Promise.resolve removed code refactored

* space added

* test cases for 'query' method updated with respect to new rejection structure instead of throwing error

* it block messages corrected

* return added and code structured

* line space added

* line space added

* code style fixed

* Update hooks.js

Fixed error where `return` was called inside of a for loop. 
This prevented execution of more than one synchronous hook.

* Added tests for before/afterInit and before/afterDefine hooks

* sooo many new lines 🔥

* fixes for MSSQL bulkInsetQuery unit test edge cases and add large integration test

* put back es6project.js

* Revert "temporary fork to add upsert to mssql until we upgrade sequelize"

This reverts commit 14d73a0a958efd981d51a9439579fd2b00698cfa.

* update changelog

* fix up changelog

* space - review comment

* use const in master

* es6 updates

* more es6 updates

* quotes

* issue #5756 correct PKs with describeTable

* #5756 FIXED

* #5756 FIXED describeTable

* #5736 fixed

* #5736 test & fixes (describeTable PK)

* #5756  hash and link

* Fixed: 6310

* Added: test

* Fixed: 6310

* Added: test

https://greenkeeper.io/

* fix: no value in built-in/custom validator

* using call rather than bind

* [ci skip] changelog

* Implement optimistic locking

* Update unit tests

* Add sqlite support

* Add MSSQL support

* Add optimistic locking tests

* Update changelog

* Fix some tests

* Fix lint errors

* Updated SQL Server query implementation

* Update documentation

* Trigger rebuild

* Add eventually to promise test

* Updates from PR feedback

* Add another optimistic locking test for update()

* Update changelog.

* Update error name

* Add optimistic locking documentation section

* Use ES6 style in tests

* Updated documentation

* Code formatting

* Fixes MSSQL Limit in update query, closes #6636

* Fixes failing unit test

* Moved unit test to test/unit/sql folder

* Added sqlite case to unit test

* Added MSSQL dialect specific updateQuery

* Removed .call from super.updateQuery

* using internal utils to deprecate / warn

* update to validator@6.2.0

* updated wkx@0.4.1

Closes #6714 Fixes #6703

* fix: custom msg not used for notNull validations

* [ci skip] changelog

https://greenkeeper.io/

Because the query type was not properly set when doing a soft delete, Sequelize tried to format the result in the wrong format.

* feat: set/add/create through model with options.through

* docs: options.through for set/add/create N:M

* [ci skip] changelog

* Update to uuid@3.x package.

The node-uuid package is deprecated.

The new 3.x version drops the parse and unparse methods which were used in instance integration tests. Tests were updated to use uuid-validate package to validate UUID generation.

* Update changelog Future for PR #6919 - update uuid package.

right now this is basically impossible to track down the root. this PR adds a more informative error message so you actually know what caused the error.

Before:

```
TypeError: sql.replace is not a function
        at Object.format (/Users/contra/Projects/staeco/node_modules/sequelize/lib/sql-string.js:87:14)
        at Object.format (/Users/contra/Projects/staeco/node_modules/sequelize/lib/utils.js:119:20)
        at Object.getWhereConditions (/Users/contra/Projects/staeco/node_modules/sequelize/lib/dialects/abstract/query-generator.js:2303:24)
```

After:

```js
Error: Invalid SQL string provided: ST_Intersects(123)
        at Object.format (/Users/contra/Projects/staeco/node_modules/sequelize/lib/sql-string.js:87:14)
        at Object.format (/Users/contra/Projects/staeco/node_modules/sequelize/lib/utils.js:119:20)
        at Object.getWhereConditions (/Users/contra/Projects/staeco/node_modules/sequelize/lib/dialects/abstract/query-generator.js:2303:24)
```

https://github.com/sequelize/sequelize/issues/6666

Makes it possible to pass condition objects (e.g. {foo: 'bar'}) to Sequelize.fn(), Sequelize.cast().
This makes it easy to use conditional counts in Sequelize queries, e.g.

Sequelize.fn('sum', {name: 'Fred'}) which results in SUM(`name` = 'Fred') which can be used in attribute definition
to count entities for which the condition matches.

* Failing testcase for findAll with nested include and inner join on m:n association

* Added insert queries to test

* Changed generateThroughJoin join identifier

* Improve code style