def make_views(): for cube in get_cubes(): slug = slugify(cube.get('statistic_title_de')) slug = slug.replace('-', '_') slug = slug + '_' + cube.get('cube_name') q = 'DROP VIEW IF EXISTS ' + slug engine.query(q) q, params = query_cube(cube.get('cube_name'), readable=False) q = 'CREATE VIEW ' + slug + ' AS ' + str(q) engine.query(q, **params) print([slug, q])
def make_views(): for cube in get_cubes(): slug = slugify(cube.get('statistic_title_de')) slug = slug.replace('-', '_') slug = slug + '_' + cube.get('cube_name') q = 'DROP VIEW IF EXISTS ' + slug engine.query(q) q, params = query_cube(cube.get('cube_name'), readable=False) q = 'CREATE VIEW ' + slug + ' AS ' + unicode(q) engine.query(q, **params) print [slug, q]
def freeze_data(): print "Freezing dimension values..." prefix = os.path.join(get_output_dir(), 'data', 'dimensions') freeze(value_table.all(), prefix=prefix, filename='{{dimension_name}}.csv', format='csv') freeze(value_table.all(), prefix=prefix, filename='{{dimension_name}}.json', format='json') print "Freezing cubes..." for cube in get_cubes(): prefix = os.path.join(get_output_dir(), 'data', cube['statistic_name'], cube['cube_name']) slug = slugify(cube['statistic_title_de']) for (text, rb) in [('labeled', True), ('raw', False)]: q, ps = query_cube(cube['cube_name'], readable=rb) fn = '%s-%s-%s.csv' % (slug, cube['cube_name'], text) print [fn] freeze(engine.query(q), prefix=prefix, filename=fn)