public / sequelize

* Add relative and full path support for sqlite

If the dialect is 'sqlite', then we parse host+pathname as a file path.
sqlite documentation suggests that this is the right way to parse them:
https://sqlite.org/c3ref/open.html#urifilenameexamples

If the "storage" option is provided, then that wil take precedence.

Examples:
sqlite:subfolder/dbname.db => subfolder/dbname.db
sqlite:/home/abs/dbname.db => /home/abs/dbname.db

* Add dialect check for the unit tests

* Update docs and changelog

* Amplify docs for "import" instruction

Signed-off-by: Martin H. Bramwell <martinhbramwell@gmail.com>

* Uses markdown correctly.  Grammar fixed.

Signed-off-by: Martin H. Bramwell <martinhbramwell@gmail.com>

Introduces dialectOptions.foundRows configuration option that can be set to bring back
update behavior from before this commit https://github.com/sequelize/sequelize/commit/4f95f176eba4a7ad7c71108dd48955884d16eb6b

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

* Add `isSoftDeleted` helper method to model instances

Since users can rename the `deletedAt` field when creating a model it
is helpful to have a `isSoftDeleted` so other users of the DB don't
have to hard code the custom `deletedAt` field name throughout their
codebase.

Addresses: https://github.com/sequelize/sequelize/issues/7408

* Update `isSoftDeleted` to check for dates in the future

If the soft-delete property (default is `deleted_at`) is set, but it's
set to a date in the future, then `isSoftDeleted` should return `false`.

* Update `isSoftDeleted` to return `true` if `deletedAt` is now

* Rename variable `isNotSet` to `isSet` and inverse logic

This helps with readability and understanding.

* [MSSQL] Format isolation level as tedious isolation level

* [ci skip] Added changelog entry

* Added unit test that stubs beginTransaction method

* Fixes jshint error

* Explicitly pass tedious lib instance

http://docs.sequelizejs.com/en/v3/docs/getting-started/ link is not active. Thanks

* Indent Markdown by 2 spaces

Consistent with most examples and our codebase

* Use ES6 (as supported by Node 4) in docs

Add Yarn installation scripts to getting started documentation. With many developers making use of Yarn as of late, providing quick copy/paste scripts will prevent developers from having to type the scripts manually.

* Two birds with one stone.  Adds support for ordering by JSON columns and removes vulnerability for injections on JSON attributes.

* Updates the changelog for the addition of json attributes.

* Fixes lint error with prefer arrow.

* Removes specific error because it may change depending on dialect and engine version.

* Removed duplicate tests and moved location of SQL injection test and find order test.

* Optimizes item.split performance by only performing the split once.

* Fixes test for sqlite dialect json.  JSON is handled differently in sqlite where the json value is extracted from a path.  If the path doesn't exist sqlite returns null instead of throwing an error like postgres.

* Removes support for $raw

* Removes interpretation of where array as a literal with replacements.

* Updates documentation to remove where object with literal replacements.

* Fixes some of the integration tests.

* Fixes integration tests and encapsulate subquery join where in a plain object.

* Adds unit tests for nested arrays in where object

* This should cover the rest of the diff.

* [ci skip] add BC break note to changelog

* Fixes changelog typo and removed the ternary because I edit in an abstract fashion.

* Fix upsert behavior to update all _changed_ fields by default

* Update changelog

* slice the options argument if the logging is set to console.log

* added test case to check if the options object is available for custom logging function, this test case has been added for the pull request 'slice the options argument if the logging is set to console.log (#7555)'

Previous one was giving 404.

* docs: first esdoc steps

* remove: deprecated articles

* fix: a bit of indentation

* add: router with redirects for surge

* fix: small css fixes (hide docs links). fix docs command

* add domain to travis.yml

* chore(package): remove unused packages, add esdoc

* fix: lint

* fix: links in /docs + other small changes

* shields

* remove eslint comments. Add back UnknownConstraintError

* 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