def load_country_map_data():
    """Loading data for map with country map"""
    csv_bytes = get_example_data(
        'birth_france_data_for_country_map.csv', is_gzip=False, make_bytes=True)
    data = pd.read_csv(csv_bytes, encoding='utf-8')
    data['dttm'] = datetime.datetime.now().date()
    data.to_sql(  # pylint: disable=no-member
        'birth_france_by_region',
        db.engine,
        if_exists='replace',
        chunksize=500,
        dtype={
            'DEPT_ID': String(10),
            '2003': BigInteger,
            '2004': BigInteger,
            '2005': BigInteger,
            '2006': BigInteger,
            '2007': BigInteger,
            '2008': BigInteger,
            '2009': BigInteger,
            '2010': BigInteger,
            '2011': BigInteger,
            '2012': BigInteger,
            '2013': BigInteger,
            '2014': BigInteger,
            'dttm': Date(),
        },
        index=False)
    print('Done loading table!')
    print('-' * 80)
    print('Creating table reference')
    obj = db.session.query(TBL).filter_by(table_name='birth_france_by_region').first()
    if not obj:
        obj = TBL(table_name='birth_france_by_region')
    obj.main_dttm_col = 'dttm'
    obj.database = utils.get_or_create_main_db()
    if not any(col.metric_name == 'avg__2004' for col in obj.metrics):
        obj.metrics.append(SqlMetric(
            metric_name='avg__2004',
            expression='AVG(2004)',
        ))
    db.session.merge(obj)
    db.session.commit()
    obj.fetch_metadata()
    tbl = obj

    slice_data = {
        'granularity_sqla': '',
        'since': '',
        'until': '',
        'where': '',
        'viz_type': 'country_map',
        'entity': 'DEPT_ID',
        'metric': {
            'expressionType': 'SIMPLE',
            'column': {
                'type': 'INT',
                'column_name': '2004',
            },
            'aggregate': 'AVG',
            'label': 'Boys',
            'optionName': 'metric_112342',
        },
        'row_limit': 500000,
    }

    print('Creating a slice')
    slc = Slice(
        slice_name='Birth in France by department in 2016',
        viz_type='country_map',
        datasource_type='table',
        datasource_id=tbl.id,
        params=get_slice_json(slice_data),
    )
    misc_dash_slices.add(slc.slice_name)
    merge_slice(slc)
def load_country_map_data ( ) : csv_bytes = get_example_data ( 'birth_france_data_for_country_map.csv' , is_gzip = False , make_bytes = True ) data = pd . read_csv ( csv_bytes , encoding = 'utf-8' ) data [ 'dttm' ] = datetime . datetime . now ( ) . date ( ) data . to_sql ( 'birth_france_by_region' , db . engine , if_exists = 'replace' , chunksize = 500 , dtype = { 'DEPT_ID' : String ( 10 ) , '2003' : BigInteger , '2004' : BigInteger , '2005' : BigInteger , '2006' : BigInteger , '2007' : BigInteger , '2008' : BigInteger , '2009' : BigInteger , '2010' : BigInteger , '2011' : BigInteger , '2012' : BigInteger , '2013' : BigInteger , '2014' : BigInteger , 'dttm' : Date ( ) , } , index = False ) print ( 'Done loading table!' ) print ( '-' * 80 ) print ( 'Creating table reference' ) obj = db . session . query ( TBL ) . filter_by ( table_name = 'birth_france_by_region' ) . first ( ) if not obj : obj = TBL ( table_name = 'birth_france_by_region' ) obj . main_dttm_col = 'dttm' obj . database = utils . get_or_create_main_db ( ) if not any ( col . metric_name == 'avg__2004' for col in obj . metrics ) : obj . metrics . append ( SqlMetric ( metric_name = 'avg__2004' , expression = 'AVG(2004)' , ) ) db . session . merge ( obj ) db . session . commit ( ) obj . fetch_metadata ( ) tbl = obj slice_data = { 'granularity_sqla' : '' , 'since' : '' , 'until' : '' , 'where' : '' , 'viz_type' : 'country_map' , 'entity' : 'DEPT_ID' , 'metric' : { 'expressionType' : 'SIMPLE' , 'column' : { 'type' : 'INT' , 'column_name' : '2004' , } , 'aggregate' : 'AVG' , 'label' : 'Boys' , 'optionName' : 'metric_112342' , } , 'row_limit' : 500000 , } print ( 'Creating a slice' ) slc = Slice ( slice_name = 'Birth in France by department in 2016' , viz_type = 'country_map' , datasource_type = 'table' , datasource_id = tbl . id , params = get_slice_json ( slice_data ) , ) misc_dash_slices . add ( slc . slice_name ) merge_slice ( slc )
Loading data for map with country map