: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 { DataVisualizationNode, NodeKind } from '~/queries/schema/schema-general'
import { ChartDisplayType } from '~/types'
import { applyExecuteSqlToolOutput, getExecuteSqlToolContext } from './maxSqlTool'
describe('maxSqlTool', () => {
const sourceQuery: DataVisualizationNode = {
kind: NodeKind.DataVisualizationNode,
source: {
kind: NodeKind.HogQLQuery,
query: 'SELECT count() FROM events WHERE {filters}',
filters: { dateRange: { date_from: '-30d' } },
response: { results: [] },
},
response: undefined,
}
it('passes a query node without response payloads as context', () => {
const context = getExecuteSqlToolContext('SELECT 1', sourceQuery)
expect(context.current_query).toEqual('SELECT 1')
expect(context.current_query_node).toEqual({
kind: NodeKind.DataVisualizationNode,
source: {
kind: NodeKind.HogQLQuery,
query: 'SELECT count() FROM events WHERE {filters}',
filters: { dateRange: { date_from: '-30d' } },
},
})
expect(context.connection_id).toBeNull()
})
it('passes the selected direct connection id as context', () => {
const context = getExecuteSqlToolContext('SELECT 1', {
...sourceQuery,
source: { ...sourceQuery.source, connectionId: 'conn-123' },
})
expect(context.connection_id).toEqual('conn-123')
})
it.each([
{
name: 'handles legacy string tool output',
toolOutput: 'SELECT event FROM events',
queryInput: 'SELECT count() FROM events',
expectedSourceQuery: null,
expectedSuggestedQueryInput: ['SELECT event FROM events', 'max_ai'],
},
{
name: 'applies filters from HogQL query tool output',
toolOutput: {
kind: NodeKind.HogQLQuery,
query: 'SELECT event FROM events WHERE {filters}',
filters: { dateRange: { date_from: '-90d' } },
},
queryInput: 'SELECT count() FROM events WHERE {filters}',
expectedSourceQuery: {
...sourceQuery,
source: {
...sourceQuery.source,
filters: { dateRange: { date_from: '-90d' } },
},
},
expectedSuggestedQueryInput: ['SELECT event FROM events WHERE {filters}', 'max_ai'],
},
{
name: 'applies display and chart settings from DataVisualizationNode tool output',
toolOutput: {
kind: NodeKind.DataVisualizationNode,
source: {
kind: NodeKind.HogQLQuery,
query: 'SELECT event, count() FROM events GROUP BY event',
},
display: ChartDisplayType.ActionsBar,
chartSettings: { xAxisLabel: 'Event name' },
},
queryInput: 'SELECT count() FROM events',
expectedSourceQuery: {
...sourceQuery,
display: ChartDisplayType.ActionsBar,
chartSettings: { xAxisLabel: 'Event name' },
},
expectedSuggestedQueryInput: ['SELECT event, count() FROM events GROUP BY event', 'max_ai'],
},
{
name: 'clears filters from empty backend filters payload',
toolOutput: {
kind: NodeKind.HogQLQuery,
query: 'SELECT count() FROM events WHERE {filters}',
filters: {},
},
queryInput: 'SELECT count() FROM events WHERE {filters}',
expectedSourceQuery: {
...sourceQuery,
source: {
...sourceQuery.source,
filters: {},
},
},
expectedSuggestedQueryInput: null,
},
])('$name', ({ toolOutput, queryInput, expectedSourceQuery, expectedSuggestedQueryInput }) => {
const setSourceQuery = jest.fn()
const setSuggestedQueryInput = jest.fn()
applyExecuteSqlToolOutput({
toolOutput,
queryInput,
sourceQuery,
setSourceQuery,
setSuggestedQueryInput,
})
if (expectedSourceQuery) {
expect(setSourceQuery).toHaveBeenCalledWith(expectedSourceQuery)
} else {
expect(setSourceQuery).not.toHaveBeenCalled()
}
if (expectedSuggestedQueryInput) {
expect(setSuggestedQueryInput).toHaveBeenCalledWith(...expectedSuggestedQueryInput)
} else {
expect(setSuggestedQueryInput).not.toHaveBeenCalled()
}
})
})