Fixes to factories and seeds commands

• fix: persist belongs to before persisting the parent model 380d684
• improvement: close connections after db:seed command daab588
• fix: use directories.seeds path over seedsPath directory fd2ce31

v8.2.0...v8.2.1

Adding support for factories and seeds

• chore: update validator 1a6ed3b
• refactor: register seeds typings bf1e082
• refactor: bind Adonis/Lucid/Factory to ioc container 7a0c370
• chore: update dependencies 1772663
• feat: add support for seeders a213661
• feat: allow defining custom handler for generating stub ids e755e2e
• feat: add fakerjs fe0febe
• feat: implement factory model hooks and add ids stub calls d494f13
• improvement: rename to 4563a00
• improvement: improve overall factories API 7d8398c
• fix: pivot table insert attributes 934c33d
• ci: add debug log 0952dcc
• improvement: cleanup factory relationships structure 80d63d7
• chore: fix linting issues 28dae25
• feat: implement core of the factories 5c65731
• test: add test for select statement 3d50f77
• fix(commands): correct typo in migration:status description 3141153
• fix(QueryBuilder): support falsy values in between pairs (#556) 2d2e7cb
• test: await the call to refresh ff9fb2e
• feat(Model): make refresh chainable d09e3b5
• improvement(Model): make merge, fill & save chainable (#554) 7a518d8
• feat: add toObject method to model fa8ae6e
• improvement: remove max listeners limit from transaction client 1b99bb8
• fix: cast page and limit to numbers, since paginate receives input from the HTTP request bd38a5d
• fix: use deep equal diff to find dirty values 5ebbc9e
• fix: transform query aliases to lowercase, since postgresql converts them to lowercase ccc1ca4
• test: update expose port in docker test file ecfb1c6
• test: skip dialect version check for now a1e9079
• test: add tests to ensure that relationship query builder handles groupLimit properly 4e5f262
• feat: implement groupLimit for relationship preloading def372c
• chore: update dependencies 76037a6
• refactor: move relationships persistance hydration to relation class e443b20

v8.1.1...v8.2.0

Adding pagination hooks and bug fixes

Pagination hooks

We have added ORM hooks for pagination too.

beforePaginate

class User extends BaseModel {
  @beforePaginate()
  public static someMethod ([countQuery, query]) {
  }
}

afterPaginate

class User extends BaseModel {
  @afterPaginate()
  public static someMethod (paginator) {
    console.log(paginator.all())
    console.log(paginator.total)
  }
}

Commits

• chore: update dependencies f7bd18f
• feat: add pagination hooks 1f9b1d3
• fix: re-compute dirty properties after initiating auto update columns b309acb
• chore: update dependencies ef3cf10
• fix(serialization): pick all fields when pick property is undefined fa0a214
• improvement: updateOrCreate and updateOrCreateMany can handle concurrent updates too 5bee648
• chore: update dependencies 4754a8c
• chore: update dependencies ed90d3a

v8.1.0...v8.1.1

Improving model serialization process by allowing fields to pick or omit

The serialization process accepts a tree of fields to pick and omit for the model and its relationships. Example:

const user = await User.find(1)
user.serialize({
  fields: ['username', 'email', 'id'],
})

// Verbose mode
user.serialize({
  fields: {
    pick: ['username', 'email', 'id'],
    omit: ['id']
  },
})

When pick and omit both have the same set of properties, the omit will win.

Relationships

Quite often you would want to also cherry pick fields for relationships as well.

user.serialize({
  fields: {
    pick: ['username', 'email', 'id'],
    omit: ['id']
  },
  relations: {
    posts: {
      fields: ['title', 'body', 'published_at']
    }
  }
})

Feels verbose?

Well, you will never type these fields to pick or omit manually. Usually, you will be following an API standard like JSONAPI, which allows the consumer of your API to specify the fields. There we will be a preprocessor in between the model.serialize the user defined query string options. That preprocessor will convert the query string to this tree.

Commits

• improvement: adding support to pick and omit fields during serialize process d3d4f92

v8.0.5...v8.1.0

Handful of bug fixes

• improvement: allow whereNot contraints for the unique and the exists rules 1bdf5e6
• feat: add useTransaction and useConnection methods 789f038
• improvement: making ddl queries compute the query method and not the pretty printer 7d40daf
• fix: update mysql config type to accept mysql2 as a client 2623e66
• fix: use for of loop to iterate over registered connections bfdf53a

v8.0.4...v8.0.5

Improvements to migrations dry run output

• fix: pretty sql queries with proper formatting 77f6043
• chore: update dependencies d0c5c80

v8.0.3...v8.0.4

Improvements to logging and some new additions

Bug Fixes

• Fix SimplePaginator.toJSON static type

Improvements

• Do not register health checker, until one or more connections have health checks enabled
• Improvements to the query debugging. Now debugging can be control globally, at connection level or at query level.

Additions

• Added findBy and findByOrFail methods to model

Commits

• improvement: serialize datetime to iso string 7091bab
• feat: query.delete method, it is an alias for the existing .del method ea7166c
• improvement: protect preload method to be called from a deleted instance eaff60a
• feat: add findBy and findByOrFail methods 3d3a8f4
• improvement: streamline query logging by disabling knex logger and user event emitter 21f01d6
• improvement: register health checker only when one or more connections are using it 117ec61
• chore: update dependencies 7611427
• fix(types): fix type returned by SimplePaginator.toJSON (#535) e386e94

v8.0.2...v8.0.3

Removing redundant log statement

• fix: remove redundant console.log statement 1c1dd25

v8.0.1...v8.0.2

Improvements to the sync method, along with some bug fixes

• improvement: improve sync method to not select all pivot rows 76ebf32
• fix: always set updatedAt when model is dirty d7e5672
• fix: Database.transaction accept callback to be passed to the query client 5e07ed8
• chore: update dependencies 072c794
• fix(types): correct type of Model.createMany values parameter (#533) 6727f8e

v8.0.0...v8.0.1

Solidifying Lucid with bunch of new features and bug fixes

Highlights

• Support for query scopes with proper intellisense
• Option to define hooks by decorating functions
• A standard way to listen for database query events using the Event module of AdonisJS.
• Helper function to pretty print SQL query logs
• Support for Pagination
• Support for Global transactions. Helpful during tests
• Added tests to run on MSSQL too.

Commits

• feat: allow defining hooks via decorators ae2f398
• style: fix after rebase c9b0e24
• improvement: use toSQL method directly, since knex has added it to their types b3f9917
• chore: cleanup dependencies f697a38
• style: improve log message in migrations command 2a0db32
• improvement: raise error when trying to merge or fill extra properties to model 003f1c4
• improvement: raise error when trying to merge or fill extra properties to model 1167b54
• refactor: use mustache syntax for stubs ebee5fb
• chore: update dependencies b20776a
• feat: accept custom data to set set on query event e9f944b
• refactor: pass model name to query reporter for updates, deletes and inserts 87f9599
• fix: return ModelQuery builder for update and deletes 4a6f165
• refactor: re-organize code f09f4f6
• fix: use fromSQL method to convert sql date times to luxon instances 40d528d
• chore: update database config template to drop Contract from config types f058141
• refactor: depreciate "debug" config property b536acc
• refactor: cleaning up migration commands b6dc1ce
• refactor: nest transaction queries inside profiler row 06f361a
• feat: add querylogs pretty printer 4281d1f
• feat: emit db queries 1466b31
• test: fix breaking test 297acd1
• fix: provider to export orm config 6bddf84
• feat: expose SimplePaginator on database object for manual construction f533fe5
• feat(paginator): add getUrlsForRange method 8cac552
• feat: add first and firstOrFail as static model methods 05f2422
• refactor: drop Contract keyword from everything except implmentable interfaces b5302d5
• refactor: extract Model.defineScope to its own helper method 5c150b8
• feat: implement fetch and find hooks 5e125f9
• refactor: serialize dates to ISODate string by default be8a9f8
• chore: update .env file d07d5ca
• feat: implement relationships onQuery hook 9b58684
• feat: implement query scopes 88cf86b
• refactor: huge cleanup to simplify things all around f268dea
• WIP 6c44456
• refactor: cleanup query builder types 0096e76
• test: add tests for clone method 6286276
• feat: implement standard offset,limit based pagination d3584fe
• feat(QueryBuilder): add clearLimit and clearOffset methods 6ba940f
• test: add tests for union queries 6293d2f
• refactor: add connection name to the query log messages a3a494b
• feat: add schema.raw to get an instance of knex query builder 5570d10
• test: use client.context over client._context after recent change in knex 2686a5c
• fix: having method signature after knex upgrade 9ba7f89
• chore: update dependencies f13f503
• refactor: update code to work consistently with mssql 6874d59
• fix: add missing dev dependency mssql d338c93
• test: update tests to work cross database servers 8fa6cce
• refactor: fixing import case 8cd21d6
• chore: add support for running tests on mssql server 5c35853
• feat: add getAllTables method to get a list of all table names as an array e48709f
• feat: extend validator by adding unique and exists rules 4768c3c
• feat: add support for self managed transactions 0e2f6ee
• chore: update dependencies 3398653

v7.6.3...v8.0.0