flattenOperator.test.ts 1.7 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859
  1. /**
  2. * Licensed to the Apache Software Foundation (ASF) under one
  3. * or more contributor license agreements. See the NOTICE file
  4. * distributed with this work for additional information
  5. * regarding copyright ownership. The ASF licenses this file
  6. * to you under the Apache License, Version 2.0 (the
  7. * "License"); you may not use this file except in compliance
  8. * with the License. You may obtain a copy of the License at
  9. *
  10. * http://www.apache.org/licenses/LICENSE-2.0
  11. *
  12. * Unless required by applicable law or agreed to in writing,
  13. * software distributed under the License is distributed on an
  14. * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
  15. * KIND, either express or implied. See the License for the
  16. * specific language governing permissions and limitations
  17. * under the License.
  18. */
  19. import { QueryObject, SqlaFormData, VizType } from '@superset-ui/core';
  20. import { flattenOperator } from '@superset-ui/chart-controls';
  21. const formData: SqlaFormData = {
  22. metrics: [
  23. 'count(*)',
  24. { label: 'sum(val)', expressionType: 'SQL', sqlExpression: 'sum(val)' },
  25. ],
  26. time_range: '2015 : 2016',
  27. granularity: 'month',
  28. datasource: 'foo',
  29. viz_type: VizType.Table,
  30. };
  31. const queryObject: QueryObject = {
  32. metrics: [
  33. 'count(*)',
  34. { label: 'sum(val)', expressionType: 'SQL', sqlExpression: 'sum(val)' },
  35. ],
  36. time_range: '2015 : 2016',
  37. granularity: 'month',
  38. post_processing: [
  39. {
  40. operation: 'pivot',
  41. options: {
  42. index: ['__timestamp'],
  43. columns: ['nation'],
  44. aggregates: {
  45. 'count(*)': {
  46. operator: 'sum',
  47. },
  48. },
  49. },
  50. },
  51. ],
  52. };
  53. test('should do flattenOperator', () => {
  54. expect(flattenOperator(formData, queryObject)).toEqual({
  55. operation: 'flatten',
  56. });
  57. });