def soft_delete_dashboard(dashboard_id):
dashboard = models.WriteDashboard(deleted=True)
try:
sdk.update_dashboard(str(dashboard_id), body=dashboard)
print(f"Successfully soft deleted dashboard {dashboard_id}")
except Exception as e:
print(f"Error: {e}")
def sync_dashboards(sdk: methods.Looker31SDK, config: dict) -> None:
for dashboard_id, lookml_dashboard_id in config.items():
try:
dashboard = sdk.dashboard(str(dashboard_id))
sdk.dashboard_lookml(lookml_dashboard_id)
sdk.update_dashboard(
str(dashboard_id),
models.WriteDashboard(lookml_link_id=lookml_dashboard_id),
)
sdk.sync_lookml_dashboard(lookml_dashboard_id,
models.WriteDashboard())
logging.info(
f"Dashboard {dashboard_id} synced with LookML dashboard {lookml_dashboard_id}"
)
except looker_sdk.error.SDKError as e:
logging.error(
f"Dashboard {dashboard_id} dashboard sync failed with {e}")
def delete_dashboards(dashboards: Sequence[models.Dashboard]):
"""Soft delete dashboards"""
for dashboard in dashboards:
try:
assert dashboard.id
sdk.update_dashboard(dashboard.id,
models.WriteDashboard(deleted=True))
except error.SDKError:
print(f"Failed to delete dashboard with id {dashboard.id}.")
else:
print(
f'"{dashboard.title}" (id {dashboard.id}) has been moved to trash.'
)
def move_to_trash(df):
'''
Moves unused content to trash
'''
for row in df.iterrows():
content_id = row[1]['id']
content_type = row[1]['content_type']
if (content_type == 'look'):
sdk.update_look(content_id,
body=models.WriteLookWithQuery(deleted=True))
print('look {} has successfully been moved to trash'.format(
content_id))
elif (content_type == "dashboard"):
sdk.update_dashboard(str(content_id),
body=models.WriteDashboard(deleted=True))
print('dashboard {} has successfully been moved to trash'.format(
content_id))
else:
pass
def test_crud_dashboard(sdk: mtds.LookerSDK, queries, dashboards):
"""Test creating, retrieving, updating and deleting a user.
"""
qhash: Dict[Union[str, int], ml.Query] = {}
for idx, q in enumerate(queries):
limit = "10"
request = create_query_request(q, limit)
key = q.get("id") or str(idx)
qhash[key] = sdk.create_query(request)
for d in dashboards:
dashboard = sdk.create_dashboard(
ml.WriteDashboard(
description=d.get("description"),
hidden=d.get("hidden"),
query_timezone=d.get("query_timezone"),
refresh_interval=d.get("refresh_interval"),
title=d.get("title"),
background_color=d.get("background_color"),
load_configuration=d.get("load_configuration"),
lookml_link_id=d.get("lookml_link_id"),
show_filters_bar=d.get("show_filters_bar"),
show_title=d.get("show_title"),
slug=d.get("slug"),
space_id=d.get("space_id") or sdk.me().home_space_id,
text_tile_text_color=d.get("text_tile_text_color"),
tile_background_color=d.get("tile_background_color"),
tile_text_color=d.get("tile_text_color"),
title_color=d.get("title_color"),
))
assert isinstance(dashboard, ml.Dashboard)
if d.get("background_color"):
assert d["background_color"] == dashboard.background_color
if d.get("text_tile_text_color"):
assert d["text_tile_text_color"] == dashboard.text_tile_text_color
if d.get("tile_background_color"):
assert d[
"tile_background_color"] == dashboard.tile_background_color
if d.get("tile_text_color"):
assert d["tile_text_color"] == dashboard.tile_text_color
if d.get("title_color"):
assert d["title_color"] == dashboard.title_color
# Update dashboard
assert isinstance(dashboard.id, str)
update_response = sdk.update_dashboard(dashboard.id,
ml.WriteDashboard(deleted=True))
assert update_response.deleted
assert update_response.title == dashboard.title
dashboard = sdk.update_dashboard(dashboard.id,
ml.WriteDashboard(deleted=False))
assert isinstance(dashboard.id, str)
assert not dashboard.deleted
if d.get("filters"):
for f in d["filters"]:
filter = sdk.create_dashboard_filter(
ml.WriteCreateDashboardFilter(
dashboard_id=dashboard.id,
name=f.get("name"),
title=f.get("title"),
type=f.get("type"),
default_value=f.get("default_value"),
model=f.get("model"),
explore=f.get("explore"),
dimension=f.get("dimension"),
row=f.get("row"),
listens_to_filters=f.get("listens_to_filters"),
allow_multiple_values=f.get("allow_multiple_values"),
required=f.get("required"),
))
assert isinstance(filter, ml.DashboardFilter)
assert filter.name == f.get("name")
assert filter.title == f.get("title")
assert filter.type == f.get("type")
assert filter.default_value == f.get("default_value")
assert filter.model == f.get("model")
assert filter.explore == f.get("explore")
assert filter.dimension == f.get("dimension")
assert filter.row == f.get("row")
assert filter.allow_multiple_values == f.get(
"allow_multiple_values", False)
assert filter.required == f.get("required", False)
if d.get("tiles"):
for t in d["tiles"]:
tile = sdk.create_dashboard_element(
ml.WriteDashboardElement(
body_text=t.get("body_text"),
dashboard_id=dashboard.id,
look=t.get("look"),
look_id=t.get("look_id"),
merge_result_id=t.get("merge_result_id"),
note_display=t.get("note_display"),
note_state=t.get("note_state"),
note_text=t.get("note_text"),
query=t.get("query"),
query_id=get_query_id(qhash, t.get("query_id")),
refresh_interval=t.get("refresh_interval"),
subtitle_text=t.get("subtitle_text"),
title=t.get("title"),
title_hidden=t.get("title_hidden"),
type=t.get("type"),
))
assert isinstance(tile, ml.DashboardElement)
assert tile.dashboard_id == dashboard.id
assert tile.title == t.get("title")
assert tile.type == t.get("type")