public / sequelize

* Manual eslint fixes in test

* Manual eslint fixes in lib

* 🔥 remove jshint

* eslint --fix

* 'clarifying the return value of findOrCreate'

The documentation of findOrCreate previously had no precise indication of what to expect findOrCreate to return. I added that it returns an array with two parts in the comments that had already existed in the examples.

* minor typo fixes

* Made some wording changes for tense

* Fix `showIndex()` query regexp

* [ci skip] changelog for #7492

* Added add, remove & show constraints feat

* Added showConstraintsQuery for postgres & mysql

* [ci skip] Added docs for constraints usage

* Added removeIndex support for mysql

* Added altering constraints to sqlite dialect

* Refactor onDelete, onUpdate to work in sqlite dialect

* Throw non existent constraints in removeConstraint query as UnknownConstraintError, improve test coverage

* Fix failing tests

* Removed dialect naming check in favor of dialect.supports feature check

* Improve code coverage, eslint fixes

* Review fixes

* Review fixes

* Renamed model, key to table, field for foreign key contraint definition

* run hooks during validation by default

* Revert "run hooks during validation by default"

This reverts commit da66b72bce4bc274f10745ec98cad86ccb1def20.

* hooks by default

* write validation sequence more cleanly and migrate instance validator integration tests to unit tests

* remove only

* ignore w30

* change log

* fix jshint error and use const

* jshint fix

* only validationFailed  hook when validation fails

* fix changelog

* fix changelog

* add integration tests back

* fix indentation

* and fix spacing

* final code review changes

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

* Added feature to alter tables on sync. Fixes #537

* Added an entry to future in changelog

* Added integration test for syncing with alter

* Fixed tests and model with sqlite and psql

* Updated docs and updated some code style

* Updated test.sync.js to use let instead of var

* Changed all vars to lets and replaced anonymous functions with arrow functions

* Added back some anonymous functions to use scope and fixed more coding style

* Updated code style again - removed binds and nested then's

* Updated changelog; renamed and improved tests; Added option to comment

* Changed debug vars to consts

* Switched changes to const

* Added some missing semi-colons

* issue # 7318

fixes issue # 7318 - https://github.com/sequelize/sequelize/issues/7318

* test and change log

* formatting

* changed message

* Update changelog.md

* Update removeAttribute.test.js

In generating the bulk insert query, the serials are stored in an
array. This array can potentially be up to size N, which is the number
of rows to be created.

When generating the tuples at a later stage, we walk through the
records one-by-one - O(N) iterations. However, in a single iteration,
we were performing a lookup in the serials array (indexOf costs O(N)),
leading to a O(N^2) runtime and poor performance for large number of
records inserted.

This patch converts the serials array into an object map instead, so
lookups cost O(1) time.

This fixes #6606

https://greenkeeper.io/

* Expose OptimisticLockError on Sequelize object (#6637)

* Future changelog entry

…chriso/validator.js/issues/618)

Small typo

* performance this Array.concat with for loop/push

for loop/push is much faster than Array.concat.
For the largest/ugliest queries, this can get
called hundreds of thousands of times, so the
performance difference does matter.

* add message to changelog.md

https://greenkeeper.io/

* Added unique indexes to rawAttributes

* Add changelog entry

* Added integration test to cover composite unique keys, review fixes

* Fixes failing tests

* Add quotes around column names for unique constraints in sqlite (fixes #4407)

* Changelog linked to issue

* fix error when connect to Postgres 8.2.0

* Update sequelize.md

* separating version check for clean code

* changelog: properly state oids for postgres

* Adds JSON support for sqlite

* Add JSON support to sqlite query-generator

* add integration test for sqlite json

* add unit test for sqlite json

* fix inaccurate test for json from postgres

* Fix failing test spec in postgres

* Change accroding to review

- Change MySqlQueryGenerator to AbstractQueryGenerator (sqlite)
- Move parseConditionObject method to the AbstractQueryGenerator (sqlite, postgres)
- Remove unnecessary module require
- Remove extra lines

* Fix failing test with sequelize static reference

* Add JSONB type alias to sqlite data types

* Update changelog.md

* Update jsdoc for JSON datatype

* Updates from PR feedback

- Convert es5 syntax to es6 for sqlite query-generator

* Fix parenthesis with single parameter

* Fix deleteQuery condition with JSON field

* Update integration/data-types.test.js

* Add JSON injection preventation code for sqlite

- Add checkValidJsonStatement method to sqlite query-generator
- Add injection tests for sqlite

* Update sqlite JSON query-generator

* Move common json DAO tests to abstract/dao.test.js

- Add support for json property accessors (sqlite, postgres)

* Fix wrong indentation in abstract/query-generator.js

* Update query-generator.js to use common json method

* Fix inconsistent postgres cast syntax

* Update JSON test specs

- Add injection test for postgres/query-generators.js
- Replace default sql test expectation with specific dialect (postgres)
- Update expectsql from test/support.js to throw error when no default expectation

* Fix failing postgres test with cast

* Fix postgres casting syntax

* Fix failing test for postgres

* Revert indentation of postgres query-generator

* Cleanup unnecessarily added code

update jsdoc of jsonPathExtractionQuery to match the exact function arguments

* Move integration/dialects/abstract/dao.test.js to integration/json.test.js

* Rewrite unit tests for json query-generator in unit/sql/json.test.js

* Capitalize AND operator while generating json query via condition object

* Fix failed tests

Spelling correction.

* Fixes setAssociation with scope

* Fixes style

* Refactored support for ORDER BY clause so SQL injection is not possible.

* Adds sublime text files to gitignore.
Modified changelog to accurately represent changes to the order property.
Fixed lint issues.

* Added rejection with error where Order must be type of Array or instance of sequelize literal.

* Removed support for options.order accepting strings.
@TODO Look into plain objects with property raw
@TODO Update documentation and tests

* Removed all direct lodash and replaced them with Utils.
ie. `_.isPlainObject` is now `Utils._.isPlainObject`
find: `(?s)(?<!Utils\.)_\.`
replace : `Utils._.`

* Updates documentation for findAll order.

* Added removeTicks to addTicks in quoteIdentifier for each dialect.

* Added documentation for order by only an array.

* Added breaking change to changelog and renamed error to be more general.

@TODO: TESTS!

* Fixes bad code when checking if the order is valid.

* Updated unit tests.

* Should incorporate all integration tests.

* Update changelog.md capitalize Sequelize

* Changes everything in query generator to use lodash outside of utils.

* Instead of checking if the order object is an instance of a Utils member we just see if `_.isSequelizeMethod` is truthy.

* Removing escapeId because it is no longer used.

* Instead of removing ticks, we should escape them.

* Instead of removing ticks, we should escape them. (reverted from commit e4dade0a18be85dfaf8f91f1210bc0b5bedcb31a)

* Removes support for `._isSequelizeMethod` because it can be spoofed.  Instead, use instanceof.

* Refactored support for ORDER BY clause so SQL injection is not possible.

* Adds sublime text files to gitignore.
Modified changelog to accurately represent changes to the order property.
Fixed lint issues.

* Added rejection with error where Order must be type of Array or instance of sequelize literal.

* Removed support for options.order accepting strings.
@TODO Look into plain objects with property raw
@TODO Update documentation and tests

* Removed all direct lodash and replaced them with Utils.
ie. `_.isPlainObject` is now `Utils._.isPlainObject`
find: `(?s)(?<!Utils\.)_\.`
replace : `Utils._.`

* Updates documentation for findAll order.

* Added removeTicks to addTicks in quoteIdentifier for each dialect.

* Added documentation for order by only an array.

* Added breaking change to changelog and renamed error to be more general.

@TODO: TESTS!

* Fixes bad code when checking if the order is valid.

* Updated unit tests.

* Should incorporate all integration tests.

* Update changelog.md capitalize Sequelize

* Changes everything in query generator to use lodash outside of utils.

* Instead of checking if the order object is an instance of a Utils member we just see if `_.isSequelizeMethod` is truthy.

* Removing escapeId because it is no longer used.

* Instead of removing ticks, we should escape them.

* Instead of removing ticks, we should escape them. (reverted from commit e4dade0a18be85dfaf8f91f1210bc0b5bedcb31a)

* (docs/docs/associations.md) punctuation fix - added comma

* (docs/docs/associations.md) punctuation fix - added comma

* (docs/docs/associations.md) grammar correction