Skip to content

: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.

4.0 KB
Raw Blame
import { useLayoutEffect, useRef } from 'react'

import { LemonTable, LemonTableColumns } from '@posthog/lemon-ui'

import { cn } from 'lib/utils/css-classes'

import { DatabaseSchemaTable } from '~/queries/schema/schema-general'

import { TablePreviewExtraColumn } from './types'

export interface TablePreviewProps {
    table: DatabaseSchemaTable | undefined
    emptyMessage: string
    previewData?: Record<string, any>[]
    loading?: boolean
    selectedKey?: string | null
    extraColumns?: TablePreviewExtraColumn[]
    bordered?: boolean
    className?: string
}

const SELECTED_COLUMN_CLASS = 'TablePreview__selected-column'

export function TablePreview({
    table,
    emptyMessage,
    previewData = [],
    loading = false,
    selectedKey = null,
    extraColumns = [],
    bordered = false,
    className,
}: TablePreviewProps): JSX.Element {
    const containerRef = useRef<HTMLDivElement>(null)
    const tableName = table?.name

    useLayoutEffect(() => {
        if (!selectedKey || !tableName) {
            return
        }

        const frameId = requestAnimationFrame(() => {
            const selectedColumn = containerRef.current?.querySelector<HTMLElement>(`.${SELECTED_COLUMN_CLASS}`)
            selectedColumn?.scrollIntoView({ behavior: 'auto', block: 'nearest', inline: 'center' })
        })

        return () => cancelAnimationFrame(frameId)
    }, [selectedKey, tableName])

    const columns: LemonTableColumns<Record<string, any>> = table
        ? [
              ...Object.values(table.fields)
                  .filter((column) => column.type !== 'view')
                  .map((column) => ({
                      key: column.name,
                      label: column.name,
                      type: column.type,
                  })),
              ...extraColumns,
          ].map((column) => {
              const isSelectedKey = selectedKey === column.key
              return {
                  key: column.key,
                  dataIndex: column.key,
                  className: isSelectedKey
                      ? `bg-warning-highlight border-l-2 border-r-2 border-warning ${SELECTED_COLUMN_CLASS}`
                      : undefined,
                  width: 120,
                  title: (
                      <div className="min-w-0 max-w-32">
                          <div className="font-medium text-xs truncate" title={column.label}>
                              {column.label}
                          </div>
                          <div className="text-muted text-xxs">{column.type}</div>
                      </div>
                  ),
                  render: (value) => (
                      <div className="text-xs truncate max-w-32" title={String(value || '')}>
                          {value !== null && value !== undefined ? String(value) : '-'}
                      </div>
                  ),
              }
          })
        : []

    return (
        <div ref={containerRef} className={cn('flex-1 min-w-0', className)}>
            <div
                className={
                    bordered
                        ? 'border border-primary rounded overflow-hidden h-64'
                        : 'border-t border-border rounded overflow-hidden h-64'
                }
            >
                {table ? (
                    <LemonTable
                        size="small"
                        className="w-full h-full"
                        embedded
                        loading={loading}
                        columns={columns}
                        dataSource={previewData}
                        rowKey={(_, index) => index}
                        emptyState={
                            loading ? null : <div className="text-muted text-sm text-center p-4">No data available</div>
                        }
                    />
                ) : (
                    <div className="h-full flex items-center justify-center text-muted text-sm">{emptyMessage}</div>
                )}
            </div>
        </div>
    )
}