| # 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. |
| """Fixtures for test_datasource.py""" |
| datasource_post = { |
| "id": None, |
| "column_formats": {"ratio": ".2%"}, |
| "database": {"id": 1}, |
| "description": "Adding a DESCRip", |
| "default_endpoint": "", |
| "filter_select_enabled": True, |
| "name": "birth_names", |
| "table_name": "birth_names", |
| "datasource_name": "birth_names", |
| "type": "table", |
| "schema": "", |
| "offset": 66, |
| "cache_timeout": 55, |
| "sql": "", |
| "columns": [ |
| { |
| "id": 504, |
| "column_name": "ds", |
| "verbose_name": "", |
| "description": None, |
| "expression": "", |
| "filterable": True, |
| "groupby": True, |
| "is_dttm": True, |
| "type": "DATETIME", |
| }, |
| { |
| "id": 505, |
| "column_name": "gender", |
| "verbose_name": None, |
| "description": None, |
| "expression": "", |
| "filterable": True, |
| "groupby": True, |
| "is_dttm": False, |
| "type": "VARCHAR(16)", |
| }, |
| { |
| "id": 506, |
| "column_name": "name", |
| "verbose_name": None, |
| "description": None, |
| "expression": None, |
| "filterable": True, |
| "groupby": True, |
| "is_dttm": None, |
| "type": "VARCHAR(255)", |
| }, |
| { |
| "id": 508, |
| "column_name": "state", |
| "verbose_name": None, |
| "description": None, |
| "expression": None, |
| "filterable": True, |
| "groupby": True, |
| "is_dttm": None, |
| "type": "VARCHAR(10)", |
| }, |
| { |
| "id": 509, |
| "column_name": "num_boys", |
| "verbose_name": None, |
| "description": None, |
| "expression": None, |
| "filterable": True, |
| "groupby": True, |
| "is_dttm": None, |
| "type": "BIGINT(20)", |
| }, |
| { |
| "id": 510, |
| "column_name": "num_girls", |
| "verbose_name": None, |
| "description": None, |
| "expression": "", |
| "filterable": False, |
| "groupby": False, |
| "is_dttm": False, |
| "type": "BIGINT(20)", |
| }, |
| { |
| "id": 532, |
| "column_name": "num", |
| "verbose_name": None, |
| "description": None, |
| "expression": None, |
| "filterable": True, |
| "groupby": True, |
| "is_dttm": None, |
| "type": "BIGINT(20)", |
| }, |
| { |
| "id": 522, |
| "column_name": "num_california", |
| "verbose_name": None, |
| "description": None, |
| "expression": "CASE WHEN state = 'CA' THEN num ELSE 0 END", |
| "filterable": False, |
| "groupby": False, |
| "is_dttm": False, |
| "type": "NUMBER", |
| }, |
| ], |
| "metrics": [ |
| { |
| "id": 824, |
| "metric_name": "sum__num", |
| "verbose_name": "Babies", |
| "description": "", |
| "expression": "SUM(num)", |
| "warning_text": "", |
| "d3format": "", |
| }, |
| { |
| "id": 836, |
| "metric_name": "count", |
| "verbose_name": "", |
| "description": None, |
| "expression": "count(1)", |
| "warning_text": None, |
| "d3format": None, |
| }, |
| { |
| "id": 843, |
| "metric_name": "ratio", |
| "verbose_name": "Ratio Boys/Girls", |
| "description": "This represents the ratio of boys/girls", |
| "expression": "sum(num_boys) / sum(num_girls)", |
| "warning_text": "no warning", |
| "d3format": ".2%", |
| }, |
| ], |
| } |