:hedgehog: PostHog is the leading platform for building self-driving products. Our developer tools – AI observability, analytics, session replay, flags, experiments, error tracking, logs, and more – capture all the context agents need to diagnose problems, uncover opportunities, and ship fixes. Steer it all from Slack, web, desktop, or the MCP.
Python ab-testingai-analyticsanalyticscdpdata-warehouseexperimentsfeature-flagsjavascriptproduct-analyticspythonreactsession-replaysurveystypescriptweb-analytics
import { Page } from '@playwright/test'
import { SqlInsight } from '../page-models/insights/sqlInsight'
import { expect, test, PlaywrightWorkspaceSetupResult } from '../utils/workspace-test-base'
async function dismissQuickStart(page: Page): Promise<void> {
await page
.getByRole('button', { name: 'Minimize' })
.click({ timeout: 1000 })
.catch(() => {})
}
async function goToSqlEditor(page: Page): Promise<void> {
await page.addInitScript(() => {
;(window as any).__PERF_MONACO_HOOK__ = true
})
await page.goto('/sql')
await expect(page).toHaveURL(/\/sql(?:[?#].*)?$/)
await expect(page.getByTestId('editor-scene')).toBeVisible({ timeout: 60000 })
await expect(page.getByTestId('hogql-query-editor')).toBeVisible()
await expect(page.getByText('Loading...', { exact: true })).toHaveCount(0, { timeout: 60000 })
await dismissQuickStart(page)
}
async function runQueryAndWaitForResults(page: Page, query: string = 'SELECT 1 AS result'): Promise<void> {
const sqlInsight = new SqlInsight(page)
const runButton = page.getByTestId('sql-editor-run-button')
await sqlInsight.writeQuery(query)
await sqlInsight.run()
await expect(runButton).toContainText('Cancel')
await expect(runButton).toContainText('Run', { timeout: 60000 })
await expect(page.getByRole('columnheader', { name: /result/i })).toBeVisible()
await expect(page.getByRole('gridcell', { name: '1' })).toBeVisible()
await expect(page.getByText('Showing one row')).toBeVisible()
}
test.describe('SQL Editor', () => {
test.describe.configure({ mode: 'serial' })
test.setTimeout(120000)
let workspace: PlaywrightWorkspaceSetupResult | null = null
test.beforeAll(async ({ playwrightSetup }) => {
workspace = await playwrightSetup.createWorkspace({
skip_onboarding: true,
use_current_time: true,
})
})
test.describe('Basic flow', () => {
test.beforeEach(async ({ page, playwrightSetup }) => {
await playwrightSetup.loginAndNavigateToTeam(page, workspace!)
await goToSqlEditor(page)
})
test('Add source link', async ({ page }) => {
// Add source opens the new-source page in a new browser tab
const popupPromise = page.context().waitForEvent('page')
await page.getByTestId('sql-editor-add-source').click()
const newSourceTab = await popupPromise
await expect(newSourceTab).toHaveURL(/.*\/data-warehouse\/new-source/)
})
test('Run, save and materialize a view', async ({ page }) => {
await expect(page.getByTestId('sql-editor-output-pane-empty-state')).toBeVisible()
await runQueryAndWaitForResults(page)
await dismissQuickStart(page)
await expect(page.getByTestId('sql-editor-save-options-button')).toBeEnabled()
await page.getByTestId('sql-editor-save-options-button').click()
await page.getByText('Save as view', { exact: true }).click()
const uniqueViewName = `materialized_test_view_${test.info().repeatEachIndex}_${Date.now()}`
const nameInput = page.getByTestId('sql-editor-input-save-view-name')
const saveViewModal = page.getByRole('dialog', { name: 'Save as view' })
await expect(nameInput).toBeVisible()
await nameInput.fill(uniqueViewName)
await page.getByRole('button', { name: 'Submit' }).click()
await expect(saveViewModal).not.toBeVisible({ timeout: 60000 })
await expect(page.locator('.scene-name h1 span').getByText(uniqueViewName, { exact: true })).toBeVisible({
timeout: 60000,
})
await dismissQuickStart(page)
await page.getByTestId('sql-editor-materialization-button').click({ force: true })
await expect(page.getByTestId('sql-editor-sidebar-query-info-pane')).toBeVisible()
})
test('Format query', async ({ page }) => {
const sqlInsight = new SqlInsight(page)
const oneLineQuery =
"select event, count() as total from events where event = '$pageview' group by event order by total desc limit 10"
const formattedQuery = [
'select',
' event,',
' count() as total',
'from',
' events',
'where',
" event = '$pageview'",
'group by',
' event',
'order by',
' total desc',
'limit',
' 10',
].join('\n')
const readEditorText = (): Promise<string> =>
page.evaluate(
() => (window as any).__monacoEditors?.at(-1)?.getModel()?.getValue().replace(/\r\n/g, '\n') ?? ''
)
const editorArea = page.getByTestId('hogql-query-editor')
await test.step('the keyboard shortcut reflows the query', async () => {
await sqlInsight.writeQuery(oneLineQuery)
await editorArea.click()
await page.keyboard.press('Shift+Alt+F')
await expect.poll(readEditorText).toEqual(formattedQuery)
})
await test.step('the context menu command reflows the query', async () => {
await sqlInsight.writeQuery(oneLineQuery)
await editorArea.locator('.view-lines').click({ button: 'right' })
const menuItem = page.getByRole('menuitem', { name: 'Format Document' })
await expect(menuItem).toBeVisible()
await page.waitForTimeout(250)
await menuItem.click()
await expect.poll(readEditorText).toEqual(formattedQuery)
})
await test.step('a query that does not parse keeps its text', async () => {
await sqlInsight.writeQuery('select ) from events')
await editorArea.click()
await page.keyboard.press('Shift+Alt+F')
await expect(page.getByText("Couldn't format this query.", { exact: false })).toBeVisible()
await expect.poll(readEditorText).toEqual('select ) from events')
})
})
test('Query variables pane', async ({ page }) => {
await page.getByTestId('sql-editor-variables-button').click()
await expect(page.getByPlaceholder('Search variables')).toBeVisible({ timeout: 60000 })
await expect(page.getByText('No variables found', { exact: true })).toBeVisible({ timeout: 60000 })
await expect(page.getByText('Manage SQL variables', { exact: true })).toBeVisible({ timeout: 60000 })
})
})
})