Improvements to the DateTime comparison when using "orCreate" methods

In this release, we improve the comparison logic used by firstOrCreate, firstOrNew, and updateOrCreate methods to properly compare Luxon DateTime instances when finding or persisting a new row.

Commits

• Merge pull request #991 from adamcikado/develop 94b666a
• fix: compare DateTime in newUpIfMissing 669bdb3
• Merge pull request #1017 from adamcikado/feat/exports 92ed475
• fix: some typos (#1024) ba5961b
• chore: update postgresql version 7315d0e
• chore: update version & add cross-env 52906a5
• Merge pull request #1023 from MaximeMRF/fix/step-option-migrator b084678
• fix(migrator): step option 781c479
• feat: add missing exports 5d87cf8

What's Changed

• fix(migrator): step option by @MaximeMRF in #1023
• fix some typos by @TiBianMod in #1024
• feat: add missing exports by @adamcikado in #1017
• fix: compare DateTime in newUpIfMissing by @adamcikado in #991

New Contributors

• @TiBianMod made their first contribution in #1024
• @adamcikado made their first contribution in #1017

Full Changelog: v20.5.1...v20.6.0

Add clause variant to findBy method

Latest 20.5.0 was missing some commits.
This release is published only as a patch since 20.5.0 was released a few minutes ago.

• feat(base_model): add clause variant to findBy method (#1020) 059c472
• fix(base_model): correct typing for findManyBy c22f019
• Merge pull request #1013 from MaximeMRF/feat-step-option-migrator 196c97c
• feat(Migrator): add step option 4012129

v20.4.0...v20.5.1

Add step option to the migrator

What's Changed

• fix: omit double quotes from connection name by @pokedpeter in #983
• feat(base_model): add findManyBy method by @RomainLanz in #1010
• feat(Migrator): add step option by @MaximeMRF in #1013

Full Changelog: v20.3.1...v20.5.0

Add support for pretty printing debug queries and findMany helper method

Related documentation for few features

• https://lucid.adonisjs.com/docs/debugging#pretty-printing-debug-queries
• https://lucid.adonisjs.com/docs/crud-operations#findmanyby

Commits

• chore(release): 20.3.1 8e1f3a7
• style: remove unused imports f989fb6
• feat: add support for pretty print debug queries f3976b9
• Merge pull request #1010 from adonisjs/feat/findMany 4427c8d
• style: lint e0a2b03
• fix(base_model): execute the query in findManyBy deb0052
• feat(base_model): add findManyBy method ea41f57
• fix: omit double quotes from connection name (#983) 8c333e0
• chore: fix url in readme 67ba462
• fix(configure): correct call to logger.error 2754e5c

What's Changed

• fix: omit double quotes from connection name by @pokedpeter in #983
• feat(base_model): add findManyBy method by @RomainLanz in #1010

Full Changelog: v20.3.0...v20.4.0

Correct call to logger.error when configuring the package

• fix(configure): correct call to logger.error 2754e5c

v20.3.0...v20.3.1

Bug fixes and new API on BaseModel

This release fixes the dropAllTables implementation for SQLite so that we can drop tables even when unsafe mode is disabled.

Also, a new model method lockForUpdate has been added. This method refetches the model instance from the database and locks the row for update. This allows you to perform updates without running into race-conditions. For example:

// Assuming you already have a model instance.

const user = auth.user.lockForUpdate((newUser) => {
  // newUser is a fresh model instance and now row is locked inside the database
  newUser.email = newEmail
  await newUser.save()
  return newUser
})

Commits

• test: reset tables between tests 1b47ba7
• feat: add model.lockForUpdate method to lock the model row for updates 703e6b5
• chore(package): update dependencies 018c4ce
• refactor: change sqlite dropAllTables implementation (#1001) 5c18c76

What's Changed

• refactor: change sqlite dropAllTables implementation by @Julien-R44 in #1001

Full Changelog: v20.2.0...v20.3.0

Add `exists` and `unique` bindings to `VineNumber` & drop postgres domain

What's Changed

• fix(vinejs): add exists and unique bindings to VineNumber by @Tahul in #998
• Update database_provider.ts by @amir-mohammad-HP in #1002
• feat: drop postgres domain by @MaximeMRF in #981

New Contributors

• @Tahul made their first contribution in #998
• @amir-mohammad-HP made their first contribution in #1002

Full Changelog: v20.1.0...v20.2.0

Add DatabaseTestUtils

This release adds the DatabaseTestUtils class, which includes some helpers for writing tests that interacts your database, such as migration/seeding/truncating and global transactions to keep a clean state between each test.

See full documentation here : https://docs.adonisjs.com/guides/database-tests

Commits

• feat: add DatabaseTestUtils (#988) 9c845f6
• feat: add @adonisjs/lucid/migration submodule 629ca32

Full Changelog: v20.0.0...v20.1.0

Switch default naming strategy to camelCase and add support for nulls treatment in order by clause

Breaking change

• In this release we switch the naming strategy of the ORM and the Paginator to return camelCase output for the serialized object keys. This should have made its way in the last release, but somehow missed it. You can switch back to SnakeCase strategy by explicitly assigning it to the BaseModel. https://lucid.adonisjs.com/docs/model-naming-strategy

Switching back to snake_case naming strategy

If you like to keep using the old snake case naming strategy, then you can copy-paste the following code inside a service provider of your application.

import { SnakeCaseNamingStrategy } from '@adonisjs/lucid/orm'
import { BaseModel } from '@adonisjs/lucid/orm'

export default class AppProvider {
  async boot() {
     BaseModel.namingStrategy = new SnakeCaseNamingStrategy()
  }
}

New features

Add support for defining treatment of null values in orderBy method. For example:

orderBy([
  { column: 'expires_at', order: 'desc', nulls: 'last' },
  { column: 'last_used_at', order: 'desc', nulls: 'first' }
])

The above method calls will add compile to ORDER BY expires_at desc NULLS LAST and ORDER BY last_used_at desc NULLS FIRST sql statements

Commits

• feat: add support for nulls property for orderby method signature b4af593
• chore(package): update dependencies 4777edc
• chore: remove @types/pluralize from dependencies cee062c
• Merge pull request #986 from adonisjs/feat/serialize_to_camelcase d33b9b1
• refactor: use camelCase naming strategy with paginator also 7e35cc2
• fix: remove unused imports d327871
• feat: change naming strategy to output camelCase key names in serialized output c835376
• chore: update dependencies 718c68f
• fix(seeds): correct log for ignored seed 71708b8

What's Changed

• Breaking change - Switch ORM naming strategy to CamelCase by @thetutlage in #986
• chore: remove @types/pluralize from dependencies by @targos in #987

Full Changelog: v19.0.0...v20.0.0

Stable major release

Please consult the following releases to learn more about the breaking changes.

• Breaking changes - https://github.com/adonisjs/lucid/releases/tag/v19.0.0-0
• Breaking changes - https://github.com/adonisjs/lucid/releases/tag/v19.0.0-1
• Breaking changes - https://github.com/adonisjs/lucid/releases/tag/v19.0.0-5

Commits

• chore: publish under latest tag f664a07
• Merge pull request #982 from adonisjs/v6-next 24a14cf
• refactor: fix mess created by the merge 57d9ca7
• Merge branch 'develop' into v6-next 0ee3ee6
• refactor: export stubsRoot ae090bd
• chore(package): update dependencies 06422e1
• feat(QueryBuilder/where): add null type to where clause (#967) 2790fe9
• fix(migrator): set primary key for schema_versions table (#945) 0fac231
• Revert "fix(migrator): exception class expect two arguments" 498c308
• fix(migrator): exception class expect two arguments 947e851
• fix(migrator): await rollback when changing migration format 19dad5b
• fix: DateTime equality in $dirty (#929) f72c991
• fix(configure): change localhost to 127.0.0.1 0417d84
• chore(release): 18.4.1 14befae
• test(component): fix references to missing types upon compiling in tests (#951) 62ae085
• chore: add engines key c5a9f51
• feat(adonis-typings/relations.ts): typing support for nullable 1-1 relations (hasOne and belongsTo) (#944) b7ec9d4

What's Changed

• fix: correct path for exporting types by @RomainLanz in #955
• fix(provider): properly define the adapter for the base model by @RomainLanz in #956
• fix(configure): add commands to the rc file by @RomainLanz in #954
• fix(types): allow belongs to and has one to be null by @RomainLanz in #958
• fix(migrator): set primary key for schema_versions table by @RomainLanz in #957
• fix(datetime): check equalities properly by @RomainLanz in #959
• fix: DateTime equality in $dirty by @sadiqueWiseboxs in #929
• fix(configure): add missing luxon install by @RomainLanz in #964
• feat(errors): use new way to define exceptions by @RomainLanz in #966
• fix: correct a typo in the readme by @maevdb in #969
• fix(migrator): set primary key for schema_versions table by @RomainLanz in #945
• feat(QueryBuilder/where): add null type to where clause by @MaximeMRF in #967
• fix: release connection in provider shutdown by @Julien-R44 in #977
• refactor(orm): use naming strategy for computed field by @RomainLanz in #970
• Merge to develop for final release by @thetutlage in #982

New Contributors

• @sadiqueWiseboxs made their first contribution in #929
• @maevdb made their first contribution in #969
• @MaximeMRF made their first contribution in #967

Full Changelog: v18.4.1...v19.0.0