def test_filter(): wb = JsonSpreadsheet('tests/configs/things.json') site = Site(wb) filtered_wb = site.public_workbook() result = wb.as_dict(filtered_wb) columns = result["tables"]["countries"]["columns"] assert "country" in columns assert not "opinion" in columns assert not "secret" in result["tables"] filtered_wb = site.private_workbook() result = wb.as_dict(filtered_wb) assert "secret" in result["tables"]
def test_filter(): wb = JsonSpreadsheet('tests/configs/things.json') site = Site(wb) filtered_wb = site.public_workbook() result = wb.as_dict(filtered_wb) columns = result["tables"]["countries"]["columns"] assert "country" in columns assert not "opinion" in columns assert not "secret" in result["tables"] filtered_wb = site.private_workbook() result = wb.as_dict(filtered_wb) assert "secret" in result["tables"]
def write_destination_json(params, state): workbook = state['workbook'] output_file = params['output_file'] result = JsonSpreadsheet.as_dict(workbook) if output_file is None: print(dumps(result, indent=2)) else: with open(output_file, 'w') as f: dump(result, f, indent=2) return True
def write_destination_json(params, state): workbook = state['workbook'] output_file = params['output_file'] result = JsonSpreadsheet.as_dict(workbook) if output_file == None: print(json.dumps(result, indent=2)) else: with open(output_file, 'w') as f: json.dump(result, f, indent=2) return True