@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"); }