: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 useSize from '@react-hook/size'
import clsx from 'clsx'
import { useActions, useValues } from 'kea'
import { useRef, useState } from 'react'
import { IconRevert } from '@posthog/icons'
import { LemonButton, LemonTag } from '@posthog/lemon-ui'
import { SkeletonLog } from 'lib/components/ActivityLog/ActivityLog'
import { CodeSnippet, Language } from 'lib/components/CodeSnippet'
import MonacoDiffEditor from 'lib/components/MonacoDiffEditor'
import { TZLabel } from 'lib/components/TZLabel'
import { ProfilePicture } from 'lib/lemon-ui/ProfilePicture'
import { fullName } from 'lib/utils/strings'
import { InsightModel } from '~/types'
import { editorSceneLogic } from './editorSceneLogic'
import { InsightQueryVersion, insightHistoryLogic } from './insightHistoryLogic'
import { sqlEditorLogic, toDataVisualizationNode } from './sqlEditorLogic'
interface VersionRowShellProps {
createdAt: string
authorName: string
email?: string | null
isSystem?: boolean
tags?: JSX.Element
onRestore?: () => void
children: React.ReactNode
}
function VersionRowShell({
createdAt,
authorName,
email,
isSystem,
tags,
onRestore,
children,
}: VersionRowShellProps): JSX.Element {
const [isExpanded, setIsExpanded] = useState(false)
return (
<div className={clsx('flex flex-col rounded border', isExpanded ? 'border-primary' : 'border-transparent')}>
<div
className="flex items-center gap-3 px-2 py-2 rounded cursor-pointer hover:bg-surface-secondary group"
onClick={() => setIsExpanded(!isExpanded)}
>
<div className="flex-grow min-w-0">
<div className="flex items-center gap-2">
<span className="font-semibold">
<TZLabel time={createdAt} formatDate="MMMM D" formatTime="h:mm A" />
</span>
{tags}
</div>
<div className="flex items-center gap-1.5 text-secondary text-xs mt-0.5">
<ProfilePicture
showName={false}
user={{
first_name: isSystem ? authorName : undefined,
email: email ?? undefined,
}}
type={isSystem ? 'system' : 'person'}
size="xs"
/>
<span>{authorName}</span>
</div>
</div>
{onRestore && (
<LemonButton
size="small"
icon={<IconRevert />}
className="opacity-0 group-hover:opacity-100"
tooltip="Load this version into the editor to review and restore"
data-attr="sql-editor-insight-history-restore"
onClick={(e) => {
e.stopPropagation()
onRestore()
}}
>
Restore
</LemonButton>
)}
</div>
{isExpanded && <div className="px-2 pb-2">{children}</div>}
</div>
)
}
function EditVersionRow({ version, isCurrent }: { version: InsightQueryVersion; isCurrent: boolean }): JSX.Element {
const { setSuggestedQueryInput } = useActions(sqlEditorLogic)
const { closeHistoryModal } = useActions(editorSceneLogic)
return (
<VersionRowShell
createdAt={version.createdAt}
authorName={version.authorName}
email={version.email}
isSystem={version.isSystem}
tags={
isCurrent ? (
<LemonTag type="primary" size="small">
Current version
</LemonTag>
) : undefined
}
onRestore={
isCurrent
? undefined
: () => {
setSuggestedQueryInput(version.afterSql, 'query_history')
// Close the modal so the restore diff in the editor is visible
closeHistoryModal()
}
}
>
<div className="text-xs text-secondary mb-1">Changes compared to the previous version</div>
<SqlDiffViewer before={version.beforeSql} after={version.afterSql} />
</VersionRowShell>
)
}
function OriginalVersionRow({
insight,
sql,
isCurrent,
}: {
insight: InsightModel
sql: string
isCurrent: boolean
}): JSX.Element {
const { setSuggestedQueryInput } = useActions(sqlEditorLogic)
const { closeHistoryModal } = useActions(editorSceneLogic)
return (
<VersionRowShell
createdAt={insight.created_at}
authorName={insight.created_by ? fullName(insight.created_by) : 'Unknown'}
email={insight.created_by?.email}
tags={
<>
<LemonTag size="small">Original</LemonTag>
{isCurrent && (
<LemonTag type="primary" size="small">
Current version
</LemonTag>
)}
</>
}
onRestore={
isCurrent
? undefined
: () => {
setSuggestedQueryInput(sql, 'query_history')
closeHistoryModal()
}
}
>
<CodeSnippet language={Language.SQL} compact>
{sql}
</CodeSnippet>
</VersionRowShell>
)
}
function SqlDiffViewer({ before, after }: { before: string; after: string }): JSX.Element {
const containerRef = useRef<HTMLDivElement>(null)
const [width] = useSize(containerRef)
return (
<div ref={containerRef} className="flex flex-col w-full">
<MonacoDiffEditor
original={before}
modified={after}
language="hogQL"
width={width}
options={{
renderOverviewRuler: false,
scrollBeyondLastLine: false,
renderGutterMenu: false,
scrollbar: {
alwaysConsumeMouseWheel: false,
},
}}
/>
</div>
)
}
export function InsightHistory({ insight }: { insight: InsightModel | null }): JSX.Element {
return insight ? (
<InsightHistoryContent insight={insight} />
) : (
// The insight itself is still loading — the tab shows immediately, the content follows
<InsightHistorySkeleton />
)
}
function InsightHistorySkeleton(): JSX.Element {
return (
<div className="deprecated-space-y-2 p-2">
<SkeletonLog />
<SkeletonLog />
<SkeletonLog />
</div>
)
}
function InsightHistoryContent({ insight }: { insight: InsightModel }): JSX.Element {
const logic = insightHistoryLogic({ insightId: insight.id })
const { versions, activityPageLoading, historyComplete } = useValues(logic)
if (activityPageLoading) {
return <InsightHistorySkeleton />
}
// The state the insight was created with: what the oldest recorded edit started from,
// or the current query if the SQL has never been edited. Only trustworthy when the
// full activity log was fetched — otherwise the oldest loaded edit is not the creation state.
const originalSql =
historyComplete && versions.length
? versions[versions.length - 1].beforeSql
: versions.length === 0
? (toDataVisualizationNode(insight.query)?.source.query ?? '')
: ''
return (
<div className="flex flex-col gap-1 p-2 max-w-200">
{versions.map((version, index) => (
<EditVersionRow key={version.id ?? index} version={version} isCurrent={index === 0} />
))}
{originalSql.trim() !== '' && (
<OriginalVersionRow insight={insight} sql={originalSql} isCurrent={versions.length === 0} />
)}
{!historyComplete && (
<div className="p-2 text-secondary text-xs">
This insight has a very long history — older versions are not shown.
</div>
)}
</div>
)
}