Skip to content

Instantly share code, notes, and snippets.

@bulkan
Last active August 29, 2015 14:11
Show Gist options
  • Save bulkan/aedcf0eec50d097b6d55 to your computer and use it in GitHub Desktop.
Save bulkan/aedcf0eec50d097b6d55 to your computer and use it in GitHub Desktop.
1) [POSTGRES Specific] DAO should be able update a field with type ARRAY(JSON):
SequelizeDatabaseError: invalid input syntax for type json
at module.exports.Query.formatError (/Users/bulkan/src/javascript/sequelize/lib/dialects/postgres/query.js:283:16)
at null.<anonymous> (/Users/bulkan/src/javascript/sequelize/lib/dialects/postgres/query.js:64:21)
at emit (events.js:95:17)
at NativeQuery.handleError (/Users/bulkan/src/javascript/sequelize/node_modules/pg/lib/native/query.js:69:10)
at Connection.<anonymous> (/Users/bulkan/src/javascript/sequelize/node_modules/pg/lib/native/index.js:182:31)
at Connection.emit (events.js:95:17)
From previous event:
at new Promise (/Users/bulkan/src/javascript/sequelize/node_modules/bluebird/js/main/promise.js:84:37)
at new SequelizePromise (/Users/bulkan/src/javascript/sequelize/lib/promise.js:28:17)
at module.exports.Query.run (/Users/bulkan/src/javascript/sequelize/lib/dialects/postgres/query.js:55:19)
at /Users/bulkan/src/javascript/sequelize/lib/sequelize.js:671:20
at Promise._settlePromiseAt (/Users/bulkan/src/javascript/sequelize/lib/promise.js:66:18)
From previous event:
at Promise$catch (/Users/bulkan/src/javascript/sequelize/node_modules/bluebird/js/main/promise.js:135:14)
at /Users/bulkan/src/javascript/sequelize/lib/instance.js:601:81
at Promise._settlePromiseAt (/Users/bulkan/src/javascript/sequelize/lib/promise.js:66:18)
From previous event:
at /Users/bulkan/src/javascript/sequelize/lib/instance.js:578:25
at Promise._settlePromiseAt (/Users/bulkan/src/javascript/sequelize/lib/promise.js:66:18)
From previous event:
at module.exports.Instance.save (/Users/bulkan/src/javascript/sequelize/lib/instance.js:500:23)
at module.exports.Instance.updateAttributes (/Users/bulkan/src/javascript/sequelize/lib/instance.js:710:17)
at /Users/bulkan/src/javascript/sequelize/test/dialects/postgres/dao.test.js:55:29
at Promise._settlePromiseAt (/Users/bulkan/src/javascript/sequelize/lib/promise.js:66:18)
From previous event:
at module.exports.Instance.save (/Users/bulkan/src/javascript/sequelize/lib/instance.js:500:23)
at module.exports.Model.create (/Users/bulkan/src/javascript/sequelize/lib/model.js:1053:8)
at Context.<anonymous> (/Users/bulkan/src/javascript/sequelize/test/dialects/postgres/dao.test.js:49:24)
at callFn (/Users/bulkan/src/javascript/sequelize/node_modules/mocha/lib/runnable.js:250:21)
at Test.Runnable.run (/Users/bulkan/src/javascript/sequelize/node_modules/mocha/lib/runnable.js:243:7)
at Runner.runTest (/Users/bulkan/src/javascript/sequelize/node_modules/mocha/lib/runner.js:373:10)
at /Users/bulkan/src/javascript/sequelize/node_modules/mocha/lib/runner.js:451:12
at next (/Users/bulkan/src/javascript/sequelize/node_modules/mocha/lib/runner.js:298:14)
at /Users/bulkan/src/javascript/sequelize/node_modules/mocha/lib/runner.js:308:7
at next (/Users/bulkan/src/javascript/sequelize/node_modules/mocha/lib/runner.js:246:23)
at /Users/bulkan/src/javascript/sequelize/node_modules/mocha/lib/runner.js:270:7
at done (/Users/bulkan/src/javascript/sequelize/node_modules/mocha/lib/runnable.js:206:5)
at /Users/bulkan/src/javascript/sequelize/node_modules/mocha/lib/runnable.js:226:9
at /Users/bulkan/src/javascript/sequelize/test/dialects/postgres/dao.test.js:30:9
at Promise._settlePromiseAt (/Users/bulkan/src/javascript/sequelize/lib/promise.js:66:18)
at process._tickFromSpinner (node.js:394:15)
From previous event:
at module.exports.Model.sync (/Users/bulkan/src/javascript/sequelize/lib/model.js:385:20)
at Context.<anonymous> (/Users/bulkan/src/javascript/sequelize/test/dialects/postgres/dao.test.js:29:17)
at Hook.Runnable.run (/Users/bulkan/src/javascript/sequelize/node_modules/mocha/lib/runnable.js:217:15)
at next (/Users/bulkan/src/javascript/sequelize/node_modules/mocha/lib/runner.js:258:10)
at Object._onImmediate (/Users/bulkan/src/javascript/sequelize/node_modules/mocha/lib/runner.js:275:5)
From previous event:
at new Promise (/Users/bulkan/src/javascript/sequelize/node_modules/bluebird/js/main/promise.js:84:37)
at new SequelizePromise (/Users/bulkan/src/javascript/sequelize/lib/promise.js:28:17)
at ConnectionManager.releaseConnection (/Users/bulkan/src/javascript/sequelize/lib/dialects/abstract/connection-manager.js:205:10)
at /Users/bulkan/src/javascript/sequelize/lib/sequelize.js:673:39
at Object.finallyHandler (/Users/bulkan/src/javascript/sequelize/node_modules/bluebird/js/main/finally.js:64:23)
at Promise._settlePromiseAt (/Users/bulkan/src/javascript/sequelize/lib/promise.js:66:18)
From previous event:
at new Promise (/Users/bulkan/src/javascript/sequelize/node_modules/bluebird/js/main/promise.js:84:37)
at new SequelizePromise (/Users/bulkan/src/javascript/sequelize/lib/promise.js:28:17)
at module.exports.Query.run (/Users/bulkan/src/javascript/sequelize/lib/dialects/postgres/query.js:55:19)
at /Users/bulkan/src/javascript/sequelize/lib/sequelize.js:671:20
at Promise._settlePromiseAt (/Users/bulkan/src/javascript/sequelize/lib/promise.js:66:18)
From previous event:
at Promise$catch (/Users/bulkan/src/javascript/sequelize/node_modules/bluebird/js/main/promise.js:135:14)
at /Users/bulkan/src/javascript/sequelize/lib/instance.js:601:81
at Promise._settlePromiseAt (/Users/bulkan/src/javascript/sequelize/lib/promise.js:66:18)
From previous event:
at /Users/bulkan/src/javascript/sequelize/lib/instance.js:578:25
at Promise._settlePromiseAt (/Users/bulkan/src/javascript/sequelize/lib/promise.js:66:18)
From previous event:
at module.exports.Instance.save (/Users/bulkan/src/javascript/sequelize/lib/instance.js:500:23)
at module.exports.Instance.updateAttributes (/Users/bulkan/src/javascript/sequelize/lib/instance.js:710:17)
at /Users/bulkan/src/javascript/sequelize/test/dialects/postgres/dao.test.js:55:29
at Promise._settlePromiseAt (/Users/bulkan/src/javascript/sequelize/lib/promise.js:66:18)
From previous event:
at module.exports.Instance.save (/Users/bulkan/src/javascript/sequelize/lib/instance.js:500:23)
at module.exports.Model.create (/Users/bulkan/src/javascript/sequelize/lib/model.js:1053:8)
at Context.<anonymous> (/Users/bulkan/src/javascript/sequelize/test/dialects/postgres/dao.test.js:49:24)
at callFn (/Users/bulkan/src/javascript/sequelize/node_modules/mocha/lib/runnable.js:250:21)
at Test.Runnable.run (/Users/bulkan/src/javascript/sequelize/node_modules/mocha/lib/runnable.js:243:7)
at Runner.runTest (/Users/bulkan/src/javascript/sequelize/node_modules/mocha/lib/runner.js:373:10)
at /Users/bulkan/src/javascript/sequelize/node_modules/mocha/lib/runner.js:451:12
at next (/Users/bulkan/src/javascript/sequelize/node_modules/mocha/lib/runner.js:298:14)
at /Users/bulkan/src/javascript/sequelize/node_modules/mocha/lib/runner.js:308:7
at next (/Users/bulkan/src/javascript/sequelize/node_modules/mocha/lib/runner.js:246:23)
at /Users/bulkan/src/javascript/sequelize/node_modules/mocha/lib/runner.js:270:7
at done (/Users/bulkan/src/javascript/sequelize/node_modules/mocha/lib/runnable.js:206:5)
at /Users/bulkan/src/javascript/sequelize/node_modules/mocha/lib/runnable.js:226:9
at /Users/bulkan/src/javascript/sequelize/test/dialects/postgres/dao.test.js:30:9
at Promise._settlePromiseAt (/Users/bulkan/src/javascript/sequelize/lib/promise.js:66:18)
at process._tickFromSpinner (node.js:394:15)
From previous event:
at module.exports.Model.sync (/Users/bulkan/src/javascript/sequelize/lib/model.js:385:20)
at Context.<anonymous> (/Users/bulkan/src/javascript/sequelize/test/dialects/postgres/dao.test.js:29:17)
at Hook.Runnable.run (/Users/bulkan/src/javascript/sequelize/node_modules/mocha/lib/runnable.js:217:15)
at next (/Users/bulkan/src/javascript/sequelize/node_modules/mocha/lib/runner.js:258:10)
at Object._onImmediate (/Users/bulkan/src/javascript/sequelize/node_modules/mocha/lib/runner.js:275:5)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment