Function createTestTables

packages/db-collection-e2e/src/fixtures/test-schema.ts:38–57

(
  dbClient: { query: (sql: string) => Promise<void> },
  tableNames: {
    users: string
    posts: string
    comments: string
  },
)

 * Helper to create all test tables
 */
export async function createTestTables(
  dbClient: { query: (sql: string) => Promise<void> },
  tableNames: {
    users: string
    posts: string
    comments: string
  },
): Promise<void> {
  await dbClient.query(`
    CREATE TABLE IF NOT EXISTS ${tableNames.users} (${USERS_TABLE_SCHEMA});
  `)

  await dbClient.query(`
    CREATE TABLE IF NOT EXISTS ${tableNames.posts} (${POSTS_TABLE_SCHEMA});
  `)

  await dbClient.query(`
    CREATE TABLE IF NOT EXISTS ${tableNames.comments} (${COMMENTS_TABLE_SCHEMA});
  `)
}

/**
 * Helper to drop all test tables