default to empty object for sqlite text field with JSON mode

How can I default a

mode: 'json'

mode: 'json'

mode: 'json'

mode: 'json' text type to an empty object in sqlite?

The following in a

sqliteTable

sqliteTable

sqliteTable

sqliteTable definition results in a literal string of

([object Object])

([object Object])

([object Object])

([object Object]):

  data: text('data', { mode: 'json' }).notNull().default({}),

  data: text('data', { mode: 'json' }).notNull().default({}),

  data: text('data', { mode: 'json' }).notNull().default({}),

  data: text('data', { mode: 'json' }).notNull().default({}),

default(sql

default(sql

default(sql

default(sql'{}'

)

) (with backticks around the single quotes, I can't get the to show up in Discord markdown) or

default('{}')

default('{}')

default('{}')

default('{}') defaults it to a literal

'{}'

'{}'

'{}'

'{}', and querying that gives an error:

SyntaxError: Unexpected token ''', "'{}'" is not valid JSON
    at JSON.parse (<anonymous>)
    at SQLiteTextJson.mapFromDriverValue

SyntaxError: Unexpected token ''', "'{}'" is not valid JSON
    at JSON.parse (<anonymous>)
    at SQLiteTextJson.mapFromDriverValue

SyntaxError: Unexpected token ''', "'{}'" is not valid JSON
    at JSON.parse (<anonymous>)
    at SQLiteTextJson.mapFromDriverValue

SyntaxError: Unexpected token ''', "'{}'" is not valid JSON
    at JSON.parse (<anonymous>)
    at SQLiteTextJson.mapFromDriverValue

I'm using drizzle-orm": v0.30.9 and Turso/libsql.

Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.

No replies yetBe the first to reply to this messageJoin