Wrap relationship where constraints to its own group

• docs(README): update docs url cf55342
• docs(README): use latest tag for npm badges 810ac07
• fix: raise exception when subprocess command fails 7a3bf85
• fix: quirks around grouping relationship where clauses e62dc5c
• improvement: wrap relationship where clause to its own group 6b55d5d
• fix: set belongsTo and hasOne relationship property to null or model instance 3f4973e

v13.0.0...v14.0.0

Add support for timestamps in many to many relationship

• refactor: do not set $extras when creating many to many via factory 7a98761
• feat: add support for timestamps in many to many relationship 36b7e4a
• feat: add support for passing custom pivot attributes during create/save calls 8a22b85
• refactor: remove checkExisting param from manyToMany create calls 33283a4
• feat: add withSchema method insert query builder c917fec
• test: add tests for serialization 656d483
• feat: export pagination related types 93250ca
• feat: expose pivotColumns from ManyToManyRelations c8138c6
• fix: pass preloads, sideloader values to a group limit query 9162b64
• refactor: rename allowNonExtraProperties to allowExtraProperties 9296214
• chore: update dependencies 92698f4
• fix: Dockerfile to reduce vulnerabilities (#669) dd8fa14
• chore: update dependencies 9a8e545
• fix: Dockerfile to reduce vulnerabilities (#668) 6d1ce0a

v12.0.0...v13.0.0

Upgrade to Knex 0.95.2 and bug fixes

• fix: use DateTime.isDateTime instead of instanceof DateTime f283738
• test: fix breaking tests d8ff269
• test: fix failing test 472d09e
• test: remove unused imports 37be23a
• test: remove flaky tests 5041fb5
• chore: update publish tag to latest a9d2a57
• chore: use tedious instead of mssql driver 96b78ca
• chore: update knex to 0.95.2 b80f2c3
• improvement: pass knex client to the reference builder 34df4fa
• fix: do not prefix already prefixed column names eca0669
• refactor: update template to use migrations.naturalSort option a72d8e6
• fix: .env file to use docker host 8aae1b9
• style: tabs -> spaces for template (#657) 2c8566b
• test: cover read/write replicas 47ea530

v11.0.1...v12.0.0

Update dependencies

• style: fix eslintrc config file a4f0fd8
• chore: update dependencies 0a974af
• refactor: update database config file to remove ORM config 22d2364
• docs: fix JSDoc comments in migration commands (#656) a9e13f7

v11.0.0...v11.0.1

Preparing for the next release

Features

• Add support for using naturalSort to sort the migration files. It will be enabled for all new projects. Not recommended for exisiting projects, since it may change the order in certain situations
• Add wherePivotNull method to add is null constraint in the pivot table.
• Add withAggregate to work along side withCount, but for all other aggregates like max, min, avg and so on.
• Add support to retrieve plain Javascript objects from a Model query using the pojo method. For example

  const posts = await Post.query().pojo()
  posts[0] // plain js object

• Add support for wrapping where clauses to its own group. It is an advanced API meant to be used by the global scopes in the future. Release blog post will cover this feature in-depth

Breaking changes

• Removed orm property from the config/database.ts file in favor of namingStrategy. It allows defining naming strategies for the models and pagination class.
• The queries with aggregates now returns a model instance, earlier it used to be a plain object. One can use the new pojo method to retain the old behavior

Deprecations

• deprecate model.preload in favor of model.load. The preload method doesn't fit the behavior, since we never preload a relationship from an existing model instance. For example:

  // Not really preloading 🤷‍♂️. Its infact post loading
  await user.preload('comments') 
  
  // New API
  await user.load('comments')

Commits

• chore: use the next tag for release 1b585b2
• test: fix test assertion f598460
• test: fix incorrect column type for test tables 653cfd5
• refactor: use the latest container api c0f495a
• feat: add preloader.load and deprecate model.preload method be4e0d2
• feat: add withAggregate query builder method d59ed5c
• feat: add support for custom naming strategy 5daba98
• improvement: improve typings for the model method afdb745
• chore: stale bot exempt issues with on hold label 6eb115f
• feat: add support for wherePivotNull variant b623f6b
• feat: add support to get pojo from model queries 4ef5592
• fix: model.refresh to use the existing transaction 7a37e08
• fix: do not double prefix the table name for many to many and has many through query 36f3717
• fix: wrap queries with aggregates inside model instances 21181a3
• ci: specify version for setup_remote_docker attribute 9896444
• ci: use recent version of ecr orb 964980d
• style: fix typescript errors 9478b46
• test: cover edge cases a581dd7
• ci: fix ci config to use docker d019f8f
• feat: add support for wrapping where clauses inside its own group d1055e4
• chore: remove unrequire dependency 0e0940b
• style: reformat source files 2eb23e4
• style: reformat source files ded208b
• chore: remove npm-audit in favor of synk 4c91220
• chore: update dependencies 6d5be45
• fix: 🐛 SerializeAs null ManyToMany Type File (#629) 435e8ae
• fix(instruction): add DB_CONNECTION to the instruction f756c02
• fix: set correct key for mssql connection (#643) 336ab7f
• chore: use synk for security audit and remove npm audit hook 17ee50b
• feat: add option to sort migrations with naturalSort option cbf0f3c

v10.0.0...v11.0.0

Bunch of new features, improvements and bug fixes

• feat: add ifDialect and unlessDialect methods bdf6f0b
• feat: add distinctOn method a909df3
• feat: add support for dropping all tables 0da7b3c
• feat(mssql): allow options object which is forwaded to mssql driver 8cb23be
• feat: allow serializing extras using toJSON and toObject 62e321b
• feat: add firstOrFail to the db querybuilder 86718b3
• improvement: add model.load is an expressive alias to model.preload 5e517b6
• refactor: pass debug flag down to preload queries 86a5b34
• test: add relationship delete test cases 0d83a8b
• feat: add "fetchOrCreateMany" and "updateOrCreateMany" to hasMany relationship 9b6b802
• feat: allow multiple unique keys for fetchOrCreateMany and updateOrCreateMany 2add5f4
• fix: set correct exit code for the commands 0047d5b
• chore: update dependencies 1ff032c
• chore(docker): remove 'restart: always' directive (#612) 11e5538
• chore: update dependencies 2baaa4f
• improvement: for model inheritance 22d1e86
• fix: typo for "up to date" (#623) df04e8b
• chore: update dependencies 77b1ea5
• chore: update dependencies a44672d
• Revert "feat: add updateOrCreateMany method to hasMany relation (#615)" (#618) e5776e2
• feat: add updateOrCreateMany method to hasMany relation (#615) 04a6f44

v9.0.3...v10.0.0

Fix for v9.0.2

• fix: self invoked instruction statement 44d8f67

v9.0.2...v9.0.3

Publish under alpha tag

• chore: update repo path 195b364
• chore: publish with alpha tag 0afb7a7
• chore: update dependencies c80297c
• refactor: improve installation instruction log 77600cc
• fix: instructions install correct sqlite package a4a29d0
• fix: instructions.md codeblocks 2334da4

v9.0.1...v9.0.2

Bug fixes and improvement to the pretty print output

• fix: execute fetch hooks when query type is select 28c453a
• chore: setup instructions.md file 1c8658b
• chore: remove unwanted packages 9c23007
• chore: update instruction bb5c8d9
• chore: update dependencies edf7d00
• improvement: improve queries pretty print output 6ac54a2
• refactor: remove preview note about the compiled code de09c43
• refactor: update log messages to be consistent ca895af
• refactor: fix types issues e99ecb1
• refactor: do not rely on @adonisjs/fold 08aa5bc
• feat: define types for events emitted by query builder 22cfe68
• test: add test for repl bindings 2bf5a10
• chore: update instructions a780ce8

v9.0.0...v9.0.1

Getting package ready for the beta version of core

• chore: use the next tag to publish the package 5b66c6c
• feat: implement provider shutdown method to cleanup database connections 12a8755
• refactor: do not register healthcheck & validator rules in REPL mode 37d63fa
• feat: define repl bindings 9b8f524
• feat: add types for container bindings e1f954c
• refactor: getting package ready for beta release of core 5e7b712

v8.5.0...v9.0.0