@Test
public void shouldSelectGlobalDashboard() {
setupData("shouldSelectGlobalDashboard");
DashboardDto dashboard = dao.selectGlobalDashboard("SQALE");
assertThat(dashboard.getId(), is(2L));
assertThat(dashboard.getUserId(), nullValue());
assertNull(dao.selectGlobalDashboard("unknown"));
}
@Test
public void shouldSelectGlobalDashboard() {
dbTester.prepareDbUnit(getClass(), "shouldSelectGlobalDashboard.xml");
DashboardDto dashboard = underTest.selectGlobalDashboard("SQALE");
assertThat(dashboard.getId(), is(2L));
assertThat(dashboard.getUserId(), nullValue());
assertNull(underTest.selectGlobalDashboard("unknown"));
}
@Test
public void shouldInsertWithNullableColumns() throws Exception {
setupData("shouldInsert");
DashboardDto dashboardDto = new DashboardDto();
dashboardDto.setUserId(null);
dashboardDto.setName(null);
dashboardDto.setDescription(null);
dashboardDto.setColumnLayout(null);
dashboardDto.setShared(true);
dashboardDto.setGlobal(false);
dashboardDto.setCreatedAt(null);
dashboardDto.setUpdatedAt(null);
WidgetDto widgetDto = new WidgetDto();
widgetDto.setKey("code_coverage");
widgetDto.setName(null);
widgetDto.setDescription(null);
widgetDto.setColumnIndex(null);
widgetDto.setRowIndex(null);
widgetDto.setConfigured(true);
widgetDto.setCreatedAt(null);
widgetDto.setUpdatedAt(null);
dashboardDto.addWidget(widgetDto);
WidgetPropertyDto property = new WidgetPropertyDto();
property.setKey(null);
property.setValue(null);
widgetDto.addWidgetProperty(property);
dao.insert(dashboardDto);
checkTables("shouldInsertWithNullableColumns", "dashboards", "widgets", "widget_properties");
}
@Test
public void shouldInsert() {
setupData("shouldInsert");
Date aDate = new Date();
DashboardDto dashboardDto = new DashboardDto();
dashboardDto.setUserId(6L);
dashboardDto.setName("My Dashboard");
dashboardDto.setDescription("This is a dashboard");
dashboardDto.setColumnLayout("100%");
dashboardDto.setShared(true);
dashboardDto.setGlobal(true);
dashboardDto.setCreatedAt(aDate);
dashboardDto.setUpdatedAt(aDate);
WidgetDto widgetDto = new WidgetDto();
widgetDto.setKey("code_coverage");
widgetDto.setName("Code coverage");
widgetDto.setDescription("Widget for code coverage");
widgetDto.setColumnIndex(13);
widgetDto.setRowIndex(14);
widgetDto.setConfigured(true);
widgetDto.setCreatedAt(aDate);
widgetDto.setUpdatedAt(aDate);
dashboardDto.addWidget(widgetDto);
WidgetPropertyDto property = new WidgetPropertyDto();
property.setKey("displayITs");
property.setValue("true");
widgetDto.addWidgetProperty(property);
dao.insert(dashboardDto);
checkTables(
"shouldInsert",
new String[] {"created_at", "updated_at"},
"dashboards",
"widgets",
"widget_properties");
}
@Test
public void shouldInsert() {
dbTester.prepareDbUnit(getClass(), "shouldInsert.xml");
Date aDate = new Date();
DashboardDto dashboardDto = new DashboardDto();
dashboardDto.setUserId(6L);
dashboardDto.setName("My Dashboard");
dashboardDto.setDescription("This is a dashboard");
dashboardDto.setColumnLayout("100%");
dashboardDto.setShared(true);
dashboardDto.setCreatedAt(aDate);
dashboardDto.setUpdatedAt(aDate);
WidgetDto widgetDto = new WidgetDto();
widgetDto.setWidgetKey("code_coverage");
widgetDto.setName("Code coverage");
widgetDto.setDescription("Widget for code coverage");
widgetDto.setColumnIndex(13);
widgetDto.setRowIndex(14);
widgetDto.setConfigured(true);
widgetDto.setCreatedAt(aDate);
widgetDto.setUpdatedAt(aDate);
dashboardDto.addWidget(widgetDto);
WidgetPropertyDto property = new WidgetPropertyDto();
property.setPropertyKey("displayITs");
property.setTextValue("true");
widgetDto.addWidgetProperty(property);
underTest.insert(dashboardDto);
dbTester.assertDbUnit(
getClass(),
"shouldInsert-result.xml",
new String[] {"created_at", "updated_at"},
"dashboards",
"widgets",
"widget_properties");
}
@Test
public void shouldInsertWithNullableColumns() {
dbTester.prepareDbUnit(getClass(), "shouldInsert.xml");
DashboardDto dashboardDto = new DashboardDto();
dashboardDto.setUserId(null);
dashboardDto.setName(null);
dashboardDto.setDescription(null);
dashboardDto.setColumnLayout(null);
dashboardDto.setShared(true);
dashboardDto.setCreatedAt(null);
dashboardDto.setUpdatedAt(null);
WidgetDto widgetDto = new WidgetDto();
widgetDto.setWidgetKey("code_coverage");
widgetDto.setName(null);
widgetDto.setDescription(null);
widgetDto.setColumnIndex(null);
widgetDto.setRowIndex(null);
widgetDto.setConfigured(true);
widgetDto.setCreatedAt(null);
widgetDto.setUpdatedAt(null);
dashboardDto.addWidget(widgetDto);
WidgetPropertyDto property = new WidgetPropertyDto();
property.setPropertyKey(null);
property.setTextValue(null);
widgetDto.addWidgetProperty(property);
underTest.insert(dashboardDto);
dbTester.assertDbUnit(
getClass(),
"shouldInsertWithNullableColumns-result.xml",
"dashboards",
"widgets",
"widget_properties");
}
