Can not bulk_update object when it has the json field with sqlite

[ponytailer]

error:

sqlite3.InterfaceError: Error binding parameter 8 - probably unsupported type.

the real sql was UPDATE item_config SET created_at=?, updated_at=?, sid=?, item_id=?, title=?, pic_url=?, on_sale_timestamp=?, hot=?, pairs=? WHERE item_config.id = ? !!!! [1641890802, 1641890802, '123', '1', 'test-1', '', 0, 0, ['2', '3'], 1]
the pairs is the json type.

But item.update(pairs=["1"]) can work

[collerek]

I need something I can reproduce.
Can you provide model and update code you use?

[ponytailer]

sorry, my mistake.

DB: sqlite 3.28.0

import ormar

class ItemConfig(ormar.Model):
    class Meta(BaseMeta):
        tablename = "item_config"

    id: Optional[int] = ormar.Integer(primary_key=True)
    item_id: str = ormar.String(max_length=32, index=True)
    pairs: List[str] = ormar.JSON(default=[])

items = await ItemConfig.objects.filter(ItemConfig.id > 1).all()

for item in items:
     item.pairs = ["1"]

await ItemConfig.objects.bulk_update(items)

[collerek]

Fixed in 0.10.24