handle json fields correctly about sequelize-fixtures HOT 11 CLOSED

On testing it seems that sequelize handles json fields correctly on postgres without any changes. Why are people having a problem then? Maybe using JSON sequelize datatype with mysql/sqlite

from sequelize-fixtures.

if anyone has a problem with JSON, please let me know

from sequelize-fixtures.

Have troubles with sqlite

from sequelize-fixtures.

i think sqlite does not support json fields, its postgres only

from sequelize-fixtures.

Well, yes, but this exception comes when I trying to load something to json field. Like it trying to retrieve what it stores and where statement becomes unreadable for sqlite:

     SequelizeDatabaseError: SQLITE_ERROR: unrecognized token: "#"
      at [object Object].Query.formatError (node_modules/sequelize/lib/dialects/sqlite/query.js:242:14)
      at node_modules/sequelize/lib/dialects/sqlite/query.js:47:29
      at replacement (node_modules/sqlite3/lib/trace.js:20:31)
      at Statement.errBack (node_modules/sqlite3/lib/sqlite3.js:16:21)

It puts data correctly (as I see), but crashes on fetch.

from sequelize-fixtures.

looks like sequelize generates invalid sql for sqlite in this case. Then technically it's a sequelize problem, not sequelize-fixtures

from sequelize-fixtures.

Looks like ;-( Need to file issue there. I don't have much info about the problem. Seems like as well as you are? ;-D

from sequelize-fixtures.

As a workaround: We can declare keys (https://github.com/domasx2/sequelize-fixtures#detect-duplicates-based-on-select-fields) explicitly to prevent filtering on json fields.

from sequelize-fixtures.

+1 for this workaround.

from sequelize-fixtures.

could you please support sequelize-json ( https://github.com/Growmies/sequelize-json ) or in general provide a better support for plugins which add hooks to the model instances?

from sequelize-fixtures.

set() is now supported with 844fc5e, sequelize-json shouldwork

from sequelize-fixtures.