AdonisJS no default values for timestamps

Question

I have created basic schema with timestamps, but when I insert into table in seeder, column created_at and updated_at are null, but based on the Knex.js documentation I thought it should be current datetime if not specified.

Latest adonis libraries, database: mysql 5.7.

My Schema

'use strict'

const Schema = use('Schema')

class UserSchema extends Schema {
  up () {
    this.create('users', (table) => {
      table.increments()
      table.string('name')
      table.timestamps()
    })
  }

  down () {
    this.drop('users')
  }
}

module.exports = UserSchema

My Seeder

'use strict'

const Factory = use('Factory')
const Database = use('Database')

class UserSeeder {
  async run () {
    await Database.table('users').insert({
      name: 'JP',
    })
  }
}

module.exports = UserSeeder

score 3 · Accepted Answer · answered Aug 05 '18 at 01:08

3

Timestamps only works on LUCID ORM. You are using direct database. Set your json in the fields, it will work:

await Database.table('users').insert({
   name: 'JP',
   created_at,: Database.fn.now(),
   updated_at : Database.fn.now()
})

answered Aug 05 '18 at 01:08

Edson Mallet

54
1

score 2 · Answer 2 · answered Jul 30 '18 at 08:33

2

I have found that timestamps are default only when using models, but not when using database directly. This one is now covered in the documentation. Would be great if it was default on database level instead.

answered Jul 30 '18 at 08:33

Tomas Bruckner

718
2
10
22

score 1 · Answer 3 · answered Jun 15 '21 at 03:46

1

You should add the timestamps arguments like useTimestampType and makeDefaultNow:

table.timestamps(true, true)

answered Jun 15 '21 at 03:46

adrian cenizal

11
1

AdonisJS no default values for timestamps

3 Answers3