Advertisement
fdevibe

sequelize migration error with transactions

Feb 19th, 2015
364
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. $ sequelize db:migrate
  2.  
  3. Sequelize [Node: 0.10.33, CLI: 1.3.0, ORM: 2.0.3, sqlite3: ^3.0.5]
  4.  
  5. Loaded configuration file 'config\config.json'.
  6. Using environment 'development'.
  7. Note: When passing a callback to a transaction a promise chain is expected in return, the transaction will be committed or rejected based on the promise chain returned to the callback.
  8. Possibly unhandled Error: ,[object Statement]
  9.     at Promise._rejectUncheckedCheckError (C:\MinGW\msys\1.0\home\user\src\app\node_modules\sequelize\node_modules\bluebird\js\main\promise.js:815:68)
  10.     at Promise._settlePromiseAt (C:\MinGW\msys\1.0\home\user\src\app\node_modules\sequelize-cli\node_modules\bluebird\js\main\promise.js:528:21)
  11.     at Promise._settlePromises (C:\MinGW\msys\1.0\home\user\src\app\node_modules\sequelize-cli\node_modules\bluebird\js\main\promise.js:646:14)
  12.     at Async._drainQueue (C:\MinGW\msys\1.0\home\user\src\app\node_modules\sequelize-cli\node_modules\bluebird\js\main\async.js:79:16)
  13.     at Async._drainQueues (C:\MinGW\msys\1.0\home\user\src\app\node_modules\sequelize-cli\node_modules\bluebird\js\main\async.js:89:10)
  14.     at Async.drainQueues (C:\MinGW\msys\1.0\home\user\src\app\node_modules\sequelize-cli\node_modules\bluebird\js\main\async.js:14:14)
  15.     at process._tickCallback (node.js:419:13)
  16.  
  17.  
  18. migration file:
  19.  
  20. module.exports = {
  21.     up: function(migration, DataTypes, done) {
  22.         var sequelize = migration.sequelize;
  23.         sequelize.transaction(function (t) {
  24.             return sequelize.Promise.all([
  25.                 sequelize.query(
  26.                     'CREATE TABLE Bars (baz INTEGER)',
  27.                     {transaction: t}
  28.                 )
  29.             ]);
  30.         }).then(done);
  31.     },
  32.     down: function(migration, DataTypes, done) {
  33.         done();
  34.     }
  35. };
  36.  
  37. Result:
  38.  
  39. sqlite> .schema Bars
  40. CREATE TABLE Bars (baz INTEGER);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement