代码之家  ›  专栏  ›  技术社区  ›  Alexander McNulty

sequelizedatabaseerror-缺少列-一对多关联

  •  0
  • Alexander McNulty  · 技术社区  · 8 年前

    我将遵循以下教程 here

    一切顺利 Listing todo-items inside todos

    向服务器发出GET请求时,我有以下错误报告:

    {"name":"SequelizeDatabaseError","parent":{"name":"error","length":104,"severity":"ERROR","code":"42703","position":"440","file":"parse_relation.c","line":"2743","routine":"errorMissingColumn","sql":"SELECT \"ItemSet\".\"id\", \"ItemSet\".\"title\", \"ItemSet\".\"createdAt\", \"ItemSet\".\"updatedAt\", \"items\".\"id\" AS \"items.id\", \"items\".\"content\" AS \"items.content\", \"items\".\"complete\" AS \"items.complete\", \"items\".\"createdAt\" AS \"items.createdAt\", \"items\".\"updatedAt\" AS \"items.updatedAt\", \"items\".\"itemSetId\" AS \"items.itemSetId\", \"items\".\"itemId\" AS \"items.itemId\" FROM \"ItemSets\" AS \"ItemSet\" LEFT OUTER JOIN \"Items\" AS \"items\" ON \"ItemSet\".\"id\" = \"items\".\"itemId\";"},"original":{"name":"error","length":104,"severity":"ERROR","code":"42703","position":"440","file":"parse_relation.c","line":"2743","routine":"errorMissingColumn","sql":"SELECT \"ItemSet\".\"id\", \"ItemSet\".\"title\", \"ItemSet\".\"createdAt\", \"ItemSet\".\"updatedAt\", \"items\".\"id\" AS \"items.id\", \"items\".\"content\" AS \"items.content\", \"items\".\"complete\" AS \"items.complete\", \"items\".\"createdAt\" AS \"items.createdAt\", \"items\".\"updatedAt\" AS \"items.updatedAt\", \"items\".\"itemSetId\" AS \"items.itemSetId\", \"items\".\"itemId\" AS \"items.itemId\" FROM \"ItemSets\" AS \"ItemSet\" LEFT OUTER JOIN \"Items\" AS \"items\" ON \"ItemSet\".\"id\" = \"items\".\"itemId\";"},"sql":"SELECT \"ItemSet\".\"id\", \"ItemSet\".\"title\", \"ItemSet\".\"createdAt\", \"ItemSet\".\"updatedAt\", \"items\".\"id\" AS \"items.id\", \"items\".\"content\" AS \"items.content\", \"items\".\"complete\" AS \"items.complete\", \"items\".\"createdAt\" AS \"items.createdAt\", \"items\".\"updatedAt\" AS \"items.updatedAt\", \"items\".\"itemSetId\" AS \"items.itemSetId\", \"items\".\"itemId\" AS \"items.itemId\" FROM \"ItemSets\" AS \"ItemSet\" LEFT OUTER JOIN \"Items\" AS \"items\" ON \"ItemSet\".\"id\" = \"items\".\"itemId\";"}
    

    我对教程做了一些小修改:

    • 我用 ItemSet 而不是 ToDo
    • 我用 Item 而不是 ToDoItem

    理想情况下,我希望返回如下内容: enter image description here

    我的代码在这里提供: https://github.com/AlexanderMcNulty/seq

    1 回复  |  直到 8 年前
        1
  •  1
  •   AbhinavD    8 年前

    我想问题是 itemId 定义于 ItemSet 模型。

    ItemSet.associate = function(models) {
        ItemSet.hasMany(models.Item, {
          foreignKey: 'itemId',
          as: 'items',
        });
      };
    

    我想你还没有定义 项目 在任何地方

    推荐文章