Cli: changeColumn's primaryKey: Cannot read property '0' of undefined

Created on 30 Aug 2017  ·  3Comments  ·  Source: sequelize/cli

Model

import * as Sequelize from 'sequelize';
import sequelize from '../index';

const TradeStatModel = sequelize.define('tradeStat', {
  id: {
    primaryKey: true,
    type: Sequelize.UUID,
    required: true,
    defaultValue: Sequelize.UUIDV4,
    unique: true,
    allowNull: false
  },
  date: {
    type: Sequelize.DATE,
    required: true,
    allowNull: false,
    comment: '统计日期'
  },
  currency: {
    type: Sequelize.STRING,
    required: true,
    allowNull: false,
    comment: '交易的货币，默认base'
  },
  open: {
    type: Sequelize.FLOAT,
    required: true,
    allowNull: false,
    comment: '开盘价',
    validate: {
      min: 0
    }
  },
  close: {
    type: Sequelize.FLOAT,
    required: true,
    allowNull: false,
    comment: '收盘价',
    validate: {
      min: 0
    }
  },
  highest: {
    type: Sequelize.FLOAT,
    required: true,
    allowNull: false,
    comment: '最高价',
    validate: {
      min: 0
    }
  },
  lowest: {
    type: Sequelize.FLOAT,
    required: true,
    allowNull: false,
    comment: '最低价',
    validate: {
      min: 0
    }
  },
  amount: {
    type: Sequelize.FLOAT,
    required: true,
    allowNull: false,
    comment: '成交量',
    validate: {
      min: 0
    }
  },
  value: {
    type: Sequelize.FLOAT,
    required: true,
    allowNull: false,
    comment: '交易额 = 成交量 * 成交价',
    validate: {
      min: 0
    }
  },
  note: {
    type: Sequelize.STRING,
    required: false,
    allowNull: true,
    defaultValue: ''
  },
  active: {
    type: Sequelize.BOOLEAN,
    defaultValue: true,
    required: false,
    allowNull: true
  }
});

export default TradeStatModel;

Migration file

'use strict';

module.exports = {
  up: function(queryInterface, Sequelize) {
    /*
      Add altering commands here.
      Return a promise to correctly handle asynchronicity.

      Example:
      return queryInterface.createTable('users', { id: Sequelize.INTEGER });
    */
    queryInterface.changeColumn('tradeStats', 'id', {
      type: Sequelize.UUID,
      required: true,
      defaultValue: Sequelize.UUIDV4,
      allowNull: false
    });
    queryInterface.changeColumn('tradeStats', 'date', {
      type: Sequelize.DATE,
      primaryKey: true,
      unique: true,
      required: true,
      allowNull: false,
      comment: '统计日期'
    });
  },

  down: function(queryInterface, Sequelize) {
    /*
      Add reverting commands here.
      Return a promise to correctly handle asynchronicity.

      Example:
      return queryInterface.dropTable('users');
    */
    queryInterface.changeColumn('tradeStats', 'id', {
      primaryKey: true,
      type: Sequelize.UUID,
      required: true,
      defaultValue: Sequelize.UUIDV4,
      unique: true,
      allowNull: false
    });
    queryInterface.changeColumn('tradeStats', 'date', {
      type: Sequelize.DATE,
      required: true,
      allowNull: false,
      comment: '统计日期'
    });
  }
};

Stdout

Sequelize [Node: 6.11.0, CLI: 2.8.0, ORM: 4.7.5]

Loaded configuration file "config/config.json".
Using environment "development".
== 20170830041648-tradeStat-date-migration: migrating =======
Unhandled rejection TypeError: Cannot read property '0' of undefined
    at query.catch.then.then.queryResult (/home/axetroy/gpm/github.com/axetroy/duomi-nodejs/node_modules/sequelize/lib/dialects/postgres/query.js:112:17)
    at tryCatcher (/home/axetroy/gpm/github.com/axetroy/duomi-nodejs/node_modules/bluebird/js/release/util.js:16:23)
    at Promise._settlePromiseFromHandler (/home/axetroy/gpm/github.com/axetroy/duomi-nodejs/node_modules/bluebird/js/release/promise.js:512:31)
    at Promise._settlePromise (/home/axetroy/gpm/github.com/axetroy/duomi-nodejs/node_modules/bluebird/js/release/promise.js:569:18)
    at Promise._settlePromise0 (/home/axetroy/gpm/github.com/axetroy/duomi-nodejs/node_modules/bluebird/js/release/promise.js:614:10)
    at Promise._settlePromises (/home/axetroy/gpm/github.com/axetroy/duomi-nodejs/node_modules/bluebird/js/release/promise.js:693:18)
    at Async._drainQueue (/home/axetroy/gpm/github.com/axetroy/duomi-nodejs/node_modules/bluebird/js/release/async.js:133:16)
    at Async._drainQueues (/home/axetroy/gpm/github.com/axetroy/duomi-nodejs/node_modules/bluebird/js/release/async.js:143:10)
    at Immediate.Async.drainQueues (/home/axetroy/gpm/github.com/axetroy/duomi-nodejs/node_modules/bluebird/js/release/async.js:17:14)
    at runCallback (timers.js:672:20)
    at tryOnImmediate (timers.js:645:5)
    at processImmediate [as _immediateCallback] (timers.js:617:5)
Unhandled rejection SequelizeDatabaseError: relation "date_unique_idx" already exists
    at Query.formatError (/home/axetroy/gpm/github.com/axetroy/duomi-nodejs/node_modules/sequelize/lib/dialects/postgres/query.js:351:16)
    at query.catch.err (/home/axetroy/gpm/github.com/axetroy/duomi-nodejs/node_modules/sequelize/lib/dialects/postgres/query.js:86:18)
    at tryCatcher (/home/axetroy/gpm/github.com/axetroy/duomi-nodejs/node_modules/bluebird/js/release/util.js:16:23)
    at Promise._settlePromiseFromHandler (/home/axetroy/gpm/github.com/axetroy/duomi-nodejs/node_modules/bluebird/js/release/promise.js:512:31)
    at Promise._settlePromise (/home/axetroy/gpm/github.com/axetroy/duomi-nodejs/node_modules/bluebird/js/release/promise.js:569:18)
    at Promise._settlePromise0 (/home/axetroy/gpm/github.com/axetroy/duomi-nodejs/node_modules/bluebird/js/release/promise.js:614:10)
    at Promise._settlePromises (/home/axetroy/gpm/github.com/axetroy/duomi-nodejs/node_modules/bluebird/js/release/promise.js:689:18)
    at Async._drainQueue (/home/axetroy/gpm/github.com/axetroy/duomi-nodejs/node_modules/bluebird/js/release/async.js:133:16)
    at Async._drainQueues (/home/axetroy/gpm/github.com/axetroy/duomi-nodejs/node_modules/bluebird/js/release/async.js:143:10)
    at Immediate.Async.drainQueues (/home/axetroy/gpm/github.com/axetroy/duomi-nodejs/node_modules/bluebird/js/release/async.js:17:14)
    at runCallback (timers.js:672:20)
    at tryOnImmediate (timers.js:645:5)
    at processImmediate [as _immediateCallback] (timers.js:617:5)
== 20170830041648-tradeStat-date-migration: migrated (0.022s)
picture axetroy

Most helpful comment

@sushantdhiman
Thanks, I will try agian.

Can you specify the dependencies version in README.md?

$ npm install --save sequelize

# And one of the following:
$ npm install --save pg pg-hstore # required [email protected], @[email protected]
$ npm install --save mysql2
$ npm install --save sqlite3
$ npm install --save tedious // MSSQL
picture axetroy on 30 Aug 2017
👍6

All 3 comments

Sequelize doesn't support [email protected] use [email protected] for now

sushantdhiman picture sushantdhiman on 30 Aug 2017
👍3 😕2

@sushantdhiman
Thanks, I will try agian.

Can you specify the dependencies version in README.md?

$ npm install --save sequelize

# And one of the following:
$ npm install --save pg pg-hstore # required [email protected], @[email protected]
$ npm install --save mysql2
$ npm install --save sqlite3
$ npm install --save tedious // MSSQL
axetroy picture axetroy on 30 Aug 2017
👍6

this is still an issue in postgres 10

ajbeach2 picture ajbeach2 on 9 Mar 2018
Was this page helpful?
0 / 5 - 0 ratings

Related issues

f1nnix picture f1nnix  ·  4Comments
papb picture papb  ·  5Comments
gotrevor picture gotrevor  ·  5Comments
KaltZK picture KaltZK  ·  5Comments
TangMonk picture TangMonk  ·  3Comments