Function insertDefaultJSONDataSet

test/node/src/test-setup.ts:670–716

(
  ctx: JSONTestContext,
)

}

export async function insertDefaultJSONDataSet(
  ctx: JSONTestContext,
): Promise<void> {
  await insertDefaultDataSet(ctx as any)

  const people = await ctx.db
    .selectFrom('person')
    .select(['id', 'first_name', 'last_name'])
    .execute()

  await ctx.db
    .insertInto('person_metadata')
    .values(
      people
        .filter((person) => person.first_name && person.last_name)
        .map((person, index) => ({
          person_id: person.id,
          website: JSON.stringify({
            url: `https://www.${person.first_name!.toLowerCase()}${person.last_name!.toLowerCase()}.com`,
          }),
          nicknames: JSON.stringify([
            `${person.first_name![0]}.${person.last_name![0]}.`,
            `${person.first_name} the Great`,
            `${person.last_name} the Magnificent`,
          ]),
          profile: JSON.stringify({
            tags: ['awesome'],
            auth: {
              roles: ['contributor', 'moderator'],
              last_login: {
                device: 'android',
              },
              login_count: 12 + index,
              is_verified: true,
            },
            avatar: null,
          }),
          experience: JSON.stringify([
            {
              establishment: 'The University of Life',
            },
          ]),
          schedule: JSON.stringify([[[{ name: 'Gym', time: '12:15' }]]]),
        })),
    )
    .execute()
}

export async function clearJSONDatabase(ctx: JSONTestContext): Promise<void> {
  await ctx.db.deleteFrom('person_metadata').execute()