The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
TypeScript aialternativeauthdatabasedenoembeddingsexamplefirebasenextjsoauth2pgvectorpostgispostgrespostgresqlpostgrestrealtimesupabasevectorswebsockets
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
}