Function initJSONTest

test/node/src/test-setup.ts:603–653

(
  ctx: Mocha.Context,
  dialect: D,
)

export type JSONTestContext = Awaited<ReturnType<typeof initJSONTest>>

export async function initJSONTest<D extends DialectDescriptor>(
  ctx: Mocha.Context,
  dialect: D,
) {
  const testContext = await initTest(ctx, dialect)

  let db = testContext.db.withTables<{
    person_metadata: {
      person_id: number
      website: JSONColumnType<{ url: string }>
      nicknames: JSONColumnType<string[]>
      profile: JSONColumnType<{
        auth: {
          roles: string[]
          last_login?: { device: string }
          is_verified: SqlBool
          login_count: number
        }
        avatar: string | null
        tags: string[]
      }>
      experience: JSONColumnType<
        {
          establishment: string
        }[]
      >
      schedule: JSONColumnType<{ name: string; time: string }[][][]>
    }
  }>()

  if (dialect.sqlSpec === 'sqlite') {
    db = db.withPlugin(new ParseJSONResultsPlugin())
  }

  const jsonColumnDataType = resolveJSONColumnDataType(dialect)
  const notNull = (cb: ColumnDefinitionBuilder) => cb.notNull()

  await db.schema
    .createTable('person_metadata')
    .addColumn('person_id', 'integer', (cb) =>
      cb.primaryKey().references('person.id'),
    )
    .addColumn('website', jsonColumnDataType, notNull)
    .addColumn('nicknames', jsonColumnDataType, notNull)
    .addColumn('profile', jsonColumnDataType, notNull)
    .addColumn('experience', jsonColumnDataType, notNull)
    .addColumn('schedule', jsonColumnDataType, notNull)
    .execute()

  return { ...testContext, db }
}

export function resolveJSONColumnDataType(
  dialect: DialectDescriptor,