knex.js - Knex 迁移时间戳没有时间戳

Question

exports.up = async function(knex) {
  knex.schema.alterTable('posts', (t) => {
    t.timestamps(true, true)
  })
}

exports.down = async function(knex) {
  knex.schema.alterTable('posts', (t) => {
    t.dropTimestamps()
  })
}

根据文档，这将创建一个created_at和updated_at列。

但事实并非如此。

您如何使用 Knex 创建这些列。

标签： knex.js

Answer 1

You are not executing your schema builder. Add await or return your schema builder from migration handler.

exports.up = async function(knex) {
  return knex.schema.alterTable('posts', (t) => {
    t.timestamps(true, true)
  })
}

exports.down = async function(knex) {
  return knex.schema.alterTable('posts', (t) => {
    t.dropTimestamps()
  })
}

Edit after @valem's comment

Code above is pretty much equivalent this, if async / await is not used:

exports.up = function(knex) {
  return Promise.resolve(knex.schema.alterTable('posts', (t) => {
    t.timestamps(true, true);
  }));
}

exports.down = function(knex) {
  return Promise.resolve(knex.schema.alterTable('posts', (t) => {
    t.dropTimestamps();
  }));
}