@Test public void testBulkSQLUpdate() throws Exception { Owner owner = this.createOwner(); Content c1 = this.createContent("c1", "content 1", owner); Content c2 = this.createContent("c2", "content 2", owner); Content c3 = this.createContent("c3", "content 3", owner); Map<Object, Object> values = new HashMap<Object, Object>(); values.put("content 1", "update 1"); values.put("content 2", "update 2"); values.put("content ?", "should not exist"); int result = this.testContentCurator.bulkSQLUpdate(Content.DB_TABLE, "name", values, null); // Note: // This looks like it should be 2, and technically that's what's happening here, but with // the way the bulk updater works, even the non-matching columns are getting updated to // themselves. assertEquals(3, result); testContentCurator.refresh(c1, c2, c3); assertEquals("update 1", c1.getName()); assertEquals("update 2", c2.getName()); assertEquals("content 3", c3.getName()); }
@Test public void testBulkSQLUpdateWithMultipleCriteria() { Owner owner = this.createOwner(); Content c1 = this.createContent("c1", "content 1", owner); Content c2 = this.createContent("c2", "content 2", owner); Content c3 = this.createContent("c3", "content 3", owner); Map<Object, Object> values = new HashMap<Object, Object>(); values.put("content 1", "update 1"); values.put("content 2", "update 2"); values.put("content ?", "should not exist"); Map<String, Object> criteria = new HashMap<String, Object>(); criteria.put("name", values.keySet()); criteria.put("content_id", "c2"); int result = this.testContentCurator.bulkSQLUpdate(Content.DB_TABLE, "name", values, criteria); // Unlike the base test where the result count is 3, this filters by only the values we // intend to update, so it should be 1. assertEquals(1, result); testContentCurator.refresh(c1, c2, c3); assertEquals("content 1", c1.getName()); assertEquals("update 2", c2.getName()); assertEquals("content 3", c3.getName()); }
@Test @Parameters(method = "largeValueSetSizes") public void testBulkSQLUpdateWithLargeValueSets(int count, int skip) { Owner owner = this.createOwner(); for (int i = 1; i <= count; ++i) { this.createContent("c" + i, "content-" + i, owner); } Map<Object, Object> values = new LinkedHashMap<Object, Object>(); for (int i = 1; i <= count; ++i) { // We want every odd value to be unaffected, but we still want a fake update entry // for the query values.put("content-" + (i % 2 == skip ? i : "X" + i), "update-" + i); } int result = this.testContentCurator.bulkSQLUpdate(Content.DB_TABLE, "name", values, null); assertEquals(count, result); testContentCurator.clear(); for (int i = 1; i <= count; ++i) { Content content = this.ownerContentCurator.getContentById(owner, "c" + i); if (i % 2 == skip) { assertEquals("update-" + i, content.getName()); } else { assertEquals("content-" + i, content.getName()); } } }
@Test public void testBulkSQLUpdateWithEmptyValues() throws Exception { Owner owner = this.createOwner(); Content c1 = this.createContent("c1", "content 1", owner); Content c2 = this.createContent("c2", "content 2", owner); Content c3 = this.createContent("c3", "content 3", owner); Map<Object, Object> values = new HashMap<Object, Object>(); int result = this.testContentCurator.bulkSQLUpdate(Content.DB_TABLE, "name", values, null); assertEquals(0, result); testContentCurator.refresh(c1, c2, c3); assertEquals("content 1", c1.getName()); assertEquals("content 2", c2.getName()); assertEquals("content 3", c3.getName()); }
@Test @Parameters(method = "largeValueSetAndCriteriaSizes") public void testBulkSQLUpdateWithLargeValueSetAndCriteriaList( int valueCount, int criteriaListSize) { Owner owner = this.createOwner(); Map<Object, Object> values = new HashMap<Object, Object>(); for (int i = 1; i <= valueCount; ++i) { this.createContent("c" + i, "content-" + i, owner); // We want every odd value to be unaffected, but we still want a fake update entry // for the query values.put("content-" + (i % 2 == 0 ? i : "X" + i), "update-" + i); } Map<String, Object> criteria = new HashMap<String, Object>(); List<String> valueList = new LinkedList<String>(); criteria.put("name", valueList); for (int i = 1; i <= criteriaListSize; ++i) { valueList.add("content-" + (i % 2 == 0 ? i : "X" + i)); } int result = this.testContentCurator.bulkSQLUpdate(Content.DB_TABLE, "name", values, criteria); assertEquals(valueCount / 2, result); testContentCurator.clear(); for (int i = 1; i <= valueCount; ++i) { Content content = this.ownerContentCurator.getContentById(owner, "c" + i); if (i % 2 == 0) { assertEquals("update-" + i, content.getName()); } else { assertEquals("content-" + i, content.getName()); } } }