Skip to content

The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.

3.4 KB
Raw Blame
import { expect, Page } from '@playwright/test'

import { createApiResponseWaiter, waitForTableToLoad } from './wait-for-response.js'

export function getFilterBarInput(page: Page) {
  return page.getByTestId('filter-bar-freeform-input')
}

export async function navigateToTable(page: Page, ref: string, tableName: string) {
  const gridWaiter = createApiResponseWaiter(page, 'pg-meta', ref, 'query?key=table-rows-')
  await page.getByRole('button', { name: `View ${tableName}`, exact: true }).click()
  await page.waitForURL(/\/editor\/\d+\?schema=public$/)
  await gridWaiter
}

export async function selectColumnFilter(page: Page, columnName: string) {
  const freeformInput = getFilterBarInput(page)
  await freeformInput.click()
  await freeformInput.fill(columnName)
  await expect(page.getByTestId(`filter-menu-item-${columnName}`)).toBeVisible()
  await page.keyboard.press('Enter')
  await expect(page.getByTestId(`filter-operator-${columnName}`)).toBeFocused()
}

export async function selectOperator(page: Page, columnName: string, operator: string) {
  await expect(page.getByTestId(`filter-menu-item-${operator}`)).toBeVisible()
  await page.keyboard.press('Enter')
  await expect(page.getByTestId(`filter-value-${columnName}`)).toBeFocused()
}

export async function addFilter(
  page: Page,
  ref: string,
  columnName: string,
  operator: string,
  value: string
) {
  await selectColumnFilter(page, columnName)
  await selectOperator(page, columnName, operator)
  const rowsWaiter = createApiResponseWaiter(page, 'pg-meta', ref, 'query?key=table-rows-')
  const valueInput = page.getByTestId(`filter-value-${columnName}`)
  await valueInput.fill(value)
  await page.keyboard.press('Enter')
  await rowsWaiter
}

export async function selectOperatorByClick(page: Page, columnName: string, operator: string) {
  await expect(page.getByTestId(`filter-menu-item-${operator}`)).toBeVisible()
  await page.getByTestId(`filter-menu-item-${operator}`).click()
  await expect(page.getByTestId(`filter-value-${columnName}`)).toBeFocused()
}

export async function addFilterWithDropdownValue(
  page: Page,
  ref: string,
  columnName: string,
  operator: string,
  optionValue: string
) {
  await selectColumnFilter(page, columnName)
  await selectOperatorByClick(page, columnName, operator)
  const rowsWaiter = createApiResponseWaiter(page, 'pg-meta', ref, 'query?key=table-rows-')
  await expect(page.getByTestId(`filter-menu-item-${optionValue}`)).toBeVisible()
  await page.getByTestId(`filter-menu-item-${optionValue}`).click()
  await rowsWaiter
}

export async function switchProperty(page: Page, currentColumnName: string, newColumnName: string) {
  const conditionEl = page.getByTestId(`filter-condition-${currentColumnName}`)
  await conditionEl
    .getByRole('button', { name: `Change property from ${currentColumnName}` })
    .click()

  const searchInput = page.getByTestId(`filter-property-search-${currentColumnName}`)
  await expect(searchInput).toBeVisible()

  await searchInput.fill(newColumnName)

  await expect(page.getByTestId(`filter-menu-item-${newColumnName}`)).toBeVisible()
  await page.getByTestId(`filter-menu-item-${newColumnName}`).click()

  await expect(page.getByTestId(`filter-condition-${newColumnName}`)).toBeVisible()
}

export async function setupFilterBarPage(page: Page, ref: string, editorUrl: string) {
  const loadPromise = waitForTableToLoad(page, ref)
  await page.goto(editorUrl)
  await loadPromise
}