Sequelize Migration: relation does not exi

2019-08-18 22:43发布

站内问答 / 前端开发

1723 1 6

Anthone

女 | 书童

私信

I'm working through an Author hasMany Books example and am attempting to run a sequelize-cli migration, but am getting the following issue when I run the following migration:

ERROR: relation "authors" does not exist

This is the first migration to create an author:

'use strict';
module.exports = {
  up: (queryInterface, Sequelize) => {
    return queryInterface.createTable('Authors', {
      id: {
        allowNull: false,
        autoIncrement: true,
        primaryKey: true,
        type: Sequelize.INTEGER
      },
      firstName: {
        type: Sequelize.STRING
      },
      lastName: {
        type: Sequelize.STRING
      },
      dateOfBirth: {
        type: Sequelize.DATEONLY
      },
      dateOfDeath: {
        type: Sequelize.DATEONLY
      },
      createdAt: {
        allowNull: false,
        type: Sequelize.DATE
      },
      updatedAt: {
        allowNull: false,
        type: Sequelize.DATE
      }
    });
  },
  down: (queryInterface, Sequelize) => {
    return queryInterface.dropTable('Authors');
  }
};

The second migration to create a book:

'use strict';
module.exports = {
  up: (queryInterface, Sequelize) => {
    return queryInterface.createTable('Books', {
      id: {
        allowNull: false,
        autoIncrement: true,
        primaryKey: true,
        type: Sequelize.INTEGER
      },
      title: {
        type: Sequelize.STRING
      },
      summary: {
        type: Sequelize.STRING
      },
      isbn: {
        type: Sequelize.STRING
      },
      createdAt: {
        allowNull: false,
        type: Sequelize.DATE
      },
      updatedAt: {
        allowNull: false,
        type: Sequelize.DATE
      }
    });
  },
  down: (queryInterface, Sequelize) => {
    return queryInterface.dropTable('Books');
  }
};

The migration to create the relationship between Author and Book:

'use strict';

module.exports = {
  up: (queryInterface, Sequelize) => {
    return queryInterface.addColumn(
      'Books', // name of source model
      'AuthorId',
      {
        type: Sequelize.INTEGER,
        references: {
          model: 'authors',
          key: 'id'
        },
        onUpdate: 'CASCADE',
        onDelete: 'SET NULL'
      }
    )
  },

  down: (queryInterface, Sequelize) => {
    return queryInterface.removeColumn(
      'Books',
      'AuthorId'
    )
  }
};

And these are my models:

author.js:

'use strict';
module.exports = (sequelize, DataTypes) => {
  var Author = sequelize.define('Author', {
    firstName: { type: DataTypes.STRING, allowNull: false, len: [2, 100] },
    lastName: { type: DataTypes.STRING, allowNull: false },
    dateOfBirth: { type: DataTypes.DATEONLY },
    dateOfDeath: { type: DataTypes.DATEONLY }
  }, {});
  Author.associate = function (models) {
    // associations can be defined here
    Author.hasMany(models.Book);
  };
  return Author;
};

book.js:

'use strict';
module.exports = (sequelize, DataTypes) => {
  var Book = sequelize.define('Book', {
    title: { type: DataTypes.STRING, allowNull: false, len: [2, 100], trim: true },
    summary: { type: DataTypes.STRING, allowNull: false },
    isbn: { type: DataTypes.STRING, allowNull: false }
  }, {});

  Book.associate = function (models) {
    // associations can be defined here
    Book.belongsTo(models.Author);
  };
  return Book;
};

I've tried all sorts of things to no avail. My guess would be that it is attempting to alter the table in an asynchronous manner, but the previous migrations ran and finished:

I'm using the following:

"pg": "^7.4.3"
"sequelize": "^4.37.10"
"sequelize-cli": "^4.0.0"
 "express": "~4.16.0"

I'm very new to sequelize and any help would be appreciated!

标签： postgresql sequelize.js sequelize-cli

举报

1条回答

对你真心纯属浪费

2楼-- · 2019-08-18 23:16

You have created Authors table but referencing it with a small a. It should be like

references: {
  model: 'Authors',
  key: 'id'
},

查看更多

0人赞 添加讨论(0) 举报

•  加载中...

登录 后发表回答

相关问题

• Django distinct is not working
• PostgreSQL: left outer join syntax
• Connecting Python to a Heroku PostgreSQL DB?
• PostgreSQL - Deleting data that are older than an
• Does PLV8 support making http calls to other serve

查看全部

相关文章

• postgresql 关于使用between and 中是字符串的问题
• postgresql 月份差计算问题
• Using boolean expression in order by clause
• Table valued Parameter Equivalent in Postgresql
• in redshift postgresql can I skip columns with the
• Oracle equivalent of PostgreSQL INSERT…RETURNING *
• PostgreSQL field data type for IPv4 addresses
• Using prepared statement in stored function

查看全部

收藏的人(6)

• 
• 
• 
• 
• 
• 

×关闭

采纳回答

向帮助了您的知道网友说句感谢的话吧!

非常感谢!

确 认