Custom preset for table filter (configable via QueryConfig)

[duyet]

Custom preset for table filter (configable via QueryConfig)

[duyet]

Done implement, example usage with defaultParams and filterParamPresets:

import { ColumnFormat } from '@/types/column-format'
import { type QueryConfig } from '@/types/query-config'

export const historyQueriesConfig: QueryConfig = {
  name: 'history-queries',
  description:
    'Contains information about executed queries: start time, duration of processing, error messages',
  sql: `
      SELECT ...
      FROM system.query_log
      WHERE
        if ({type: String} != '', type = {type: String}, type != 'QueryStart')
        AND if ({duration_1m: String} = '1', query_duration >= 60, true)
        AND if ({event_time: String} != '', toDate(event_time) = toDate({event_time: String}), true)
        AND if ({database: String} != '' AND {table: String} != '', has(tables, format('{}.{}', {database: String}, {table: String})), true)
      ORDER BY event_time DESC
      LIMIT 1000
  `,

  columns: [ ... ],
  columnFormats: { ... },

  defaultParams: {
    type: '',
    duration_1m: '',
    event_time: '',
    database: '',
    table: '',
  },

  filterParamPresets: [
    {
      name: 'type = QueryStart',
      key: 'type',
      value: 'QueryStart',
    },
    {
      name: 'query_duration > 1m',
      key: 'duration_1m',
      value: '1',
    },
  ],

}