superset-frontend/packages/superset-ui-demo/storybook/stories/plugins/plugin-chart-pivot-table/testData.ts

/**
 * Licensed to the Apache Software Foundation (ASF) under one
 * or more contributor license agreements.  See the NOTICE file
 * distributed with this work for additional information
 * regarding copyright ownership.  The ASF licenses this file
 * to you under the Apache License, Version 2.0 (the
 * "License"); you may not use this file except in compliance
 * with the License.  You may obtain a copy of the License at
 *
 *   http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing,
 * software distributed under the License is distributed on an
 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
 * KIND, either express or implied.  See the License for the
 * specific language governing permissions and limitations
 * under the License.
 */
import { VizType } from '@superset-ui/core';

export const basicFormData = {
  datasource: '1__table',
  viz_type: VizType.PivotTable,
  granularity_sqla: 'ts',
  groupbyColumns: ['location'],
  groupbyRows: ['program_language'],
  metrics: [
    {
      expressionType: 'SIMPLE',
      column: {
        id: 1,
        column_name: 'count',
        description: null,
        expression: null,
        groupby: true,
        is_dttm: false,
        python_date_format: null,
        type: 'BIGINT',
        type_generic: 0,
      },
      aggregate: 'SUM',
      sqlExpression: null,
      isNew: false,
      hasCustomLabel: true,
      label: 'Count',
    },
    {
      expressionType: 'SIMPLE',
      column: {
        id: 2,
        column_name: 'ts',
        description: null,
        expression: "DATE_PARSE(ds || ' ' || hr, '%Y-%m-%d %H')",
        groupby: true,
        is_dttm: true,
        type: 'TIMESTAMP',
        type_generic: 2,
        python_date_format: null,
      },
      aggregate: 'MAX',
      sqlExpression: null,
      isNew: false,
      hasCustomLabel: true,
      label: 'Most Recent Data',
    },
  ],
  metricsLayout: 'COLUMNS',
  order_desc: true,
  aggregateFunction: 'Sum',
  valueFormat: '~g',
  date_format: 'smart_date',
  rowOrder: 'key_a_to_z',
  colOrder: 'key_a_to_z',
};

export const basicData = {
  cache_key: 'f2cd2a37b6977e3619ce6c07d0027972',
  cached_dttm: '2022-07-27T17:42:39',
  cache_timeout: 129600,
  applied_template_filters: [],
  annotation_data: {},
  error: null,
  is_cached: true,
  query: 'SELECT \nFROM\nWHERE',
  status: 'success',
  stacktrace: null,
  rowcount: 5,
  from_dttm: 1658426268000,
  to_dttm: 1659031068000,
  colnames: ['location', 'program_language', 'Count', 'Most Recent Data'],
  indexnames: [0, 1, 2, 3, 4],
  coltypes: [1, 1, 0, 1],
  data: [
    {
      location: 'AMEA',
      program_language: 'JavaScript',
      Count: 134,
      'Most Recent Data': '2022-07-25 13:00:00.000',
    },
    {
      location: 'ASIA',
      program_language: 'python',
      Count: 19,
      'Most Recent Data': '2022-07-25 16:00:00.000',
    },
    {
      location: 'ASIA',
      program_language: 'Java',
      Count: 7,
      'Most Recent Data': '2022-07-25 15:00:00.000',
    },
    {
      location: 'ASIA',
      program_language: 'C++',
      Count: 1,
      'Most Recent Data': '2022-07-25 02:00:00.000',
    },
    {
      location: 'ASIA',
      program_language: 'PHP',
      Count: 1,
      'Most Recent Data': '2022-07-24 00:00:00.000',
    },
  ],
  result_format: 'json',
  applied_filters: [],
  rejected_filters: [],
};