Java QueryFactory.from方法代码示例

import ch.digitalfondue.npjt.QueryFactory; //导入方法依赖的package包/类
@Test
public void autogeneratedKeyQueries() {
	QueryFactory qf = new QueryFactory("hsqldb", dataSource);

	AutogeneratedKeyQueries aq = qf.from(AutogeneratedKeyQueries.class);

	aq.createTable();

	AffectedRowCountAndKey<Integer> res = aq.insert("test");
	AffectedRowCountAndKey<Integer> res2 = aq.insert("test2");
	AffectedRowCountAndKey<Integer> res3 = aq.insert("test3");

	Assert.assertEquals(aq.findKeyByValue("test"), res.getKey());
	Assert.assertEquals(1, res.getAffectedRowCount());
	
	Assert.assertEquals(aq.findKeyByValue("test2"), res2.getKey());
	Assert.assertEquals(1, res2.getAffectedRowCount());
	
	Assert.assertEquals(aq.findKeyByValue("test3"), res3.getKey());
	Assert.assertEquals(1, res3.getAffectedRowCount());
}
 

import ch.digitalfondue.npjt.QueryFactory; //导入方法依赖的package包/类
@Test
public void enumQueriesTest() {
	QueryFactory qf = new QueryFactory("hsqldb", new JdbcTemplate(dataSource));
	EnumQueries eq = qf.from(EnumQueries.class);
	
	eq.createTable();

	eq.insert(null);
	
	eq.insert(TestEnum.TEST);
	eq.insert(TestEnum.TEST2);

	Assert.assertEquals(null, eq.findByNull());
	Assert.assertEquals(TestEnum.TEST, eq.findByKey(TestEnum.TEST));
	Assert.assertEquals(TestEnum.TEST2, eq.findByKey(TestEnum.TEST2));
	
	Assert.assertEquals(TestEnum.TEST, eq.findContainerByKey(TestEnum.TEST).key);
	Assert.assertEquals(null, eq.findContainerByKeyNull().key);
	
	List<TestEnum> all = eq.findAll();
	Assert.assertTrue(all.contains(TestEnum.TEST));
	Assert.assertTrue(all.contains(TestEnum.TEST2));
	Assert.assertTrue(all.contains(null));
}
 

import ch.digitalfondue.npjt.QueryFactory; //导入方法依赖的package包/类
@Test
public void testSimpleAnnotationQuery() {
	QueryFactory qf = new QueryFactory("HSQLDB", jdbc);

	QueryTest qt = qf.from(QueryTest.class);

	Assert.assertEquals("SELECT * FROM LA_BOARD_COLUMN_FULL WHERE BOARD_COLUMN_ID = :columnId", qt.findById());
}
 

import ch.digitalfondue.npjt.QueryFactory; //导入方法依赖的package包/类
@Test
public void testOverrideAnnotation() {
	QueryFactory qf = new QueryFactory("HSQLDB", jdbc);
	QueryTest qt = qf.from(QueryTest.class);
	Assert.assertEquals("SELECT * FROM LA_BOARD_COLUMN_FULL WHERE BOARD_COLUMN_ID = :columnId", qt.overrideQuery());

	QueryFactory qfMysql = new QueryFactory("MYSQL", jdbc);
	QueryTest qtMysql = qfMysql.from(QueryTest.class);
	Assert.assertEquals("SELECT * FROM LA_BOARD_COLUMN_FULL_MYSQL WHERE BOARD_COLUMN_ID = :columnId", qtMysql.overrideQuery());
}
 

import ch.digitalfondue.npjt.QueryFactory; //导入方法依赖的package包/类
@Test
public void dateQueriesTest() {
	QueryFactory qf = new QueryFactory("hsqldb", new JdbcTemplate(dataSource));
	
	qf.addColumnMapperFactory(new ZonedDateTimeMapper.Factory());
	qf.addParameterConverters(new ZonedDateTimeMapper.Converter());
	
	qf.addColumnMapperFactory(new LocalDateMapper.Factory());
	qf.addParameterConverters(new LocalDateMapper.Converter());
	
	qf.addColumnMapperFactory(new LocalDateTimeMapper.Factory());
	qf.addParameterConverters(new LocalDateTimeMapper.Converter());
	
	qf.addColumnMapperFactory(new InstantMapper.Factory());
	qf.addParameterConverters(new InstantMapper.Converter());
	
	DateQueries dq = qf.from(DateQueries.class);
	
	dq.createTable();
	
	ZonedDateTime now = ZonedDateTime.now(ZoneId.of("UTC"));
	
	dq.insertValue("KEY", now);
	check(dq, "KEY", now);
	
	dq.insertValue("KEY2", now.toLocalDate());
	check(dq, "KEY2", now.toLocalDate());
	
	dq.insertValue("KEY3", now.toLocalDateTime());
	check(dq, "KEY3", now);
	
	Instant iNow = Instant.now();
	dq.insertValue("KEY4", iNow);
	Assert.assertEquals(iNow, dq.findInstantByKey("KEY4"));
	Assert.assertEquals(iNow, dq.findConfInstantByKey("KEY4").value);
	
}
 

import ch.digitalfondue.npjt.QueryFactory; //导入方法依赖的package包/类
@Test
public void simpleQueriesTest() {
	QueryFactory qf = new QueryFactory("hsqldb", new JdbcTemplate(dataSource));

	BoolQueries bq = qf.from(BoolQueries.class);

	bq.createTable();

	bq.insertValue("KEY", true, true, true);
	
	BoolConf bc = bq.findByKey("KEY");
	
	Assert.assertTrue(bc.confBool);
	Assert.assertTrue(bc.confStr);
	Assert.assertTrue(bc.confInt);
	
	bq.insertValue("KEY2", false, true, false);
	BoolConf bc2 = bq.findByKey("KEY2");
	
	Assert.assertFalse(bc2.confBool);
	Assert.assertTrue(bc2.confStr);
	Assert.assertFalse(bc2.confInt);
	
	Assert.assertTrue(bq.findConfBoolByKey("KEY"));
	Assert.assertFalse(bq.findConfBoolByKey("KEY2"));
	
}
 

import ch.digitalfondue.npjt.QueryFactory; //导入方法依赖的package包/类
/**
 * Simple DB interaction.
 */
@Test
public void simpleQueriesTest() {
	QueryFactory qf = new QueryFactory("hsqldb", dataSource);

	MySimpleQueries mq = qf.from(MySimpleQueries.class);

	mq.createTable();

	Assert.assertTrue(mq.findAll().isEmpty());
	Assert.assertEquals(1, mq.insertValue("MY_KEY", "MY_VALUE"));

	Conf conf = mq.findByKey("MY_KEY");

	Assert.assertEquals("MY_KEY", conf.key);
	Assert.assertEquals("MY_VALUE", conf.value);

	Assert.assertFalse(mq.findAll().isEmpty());

	Assert.assertEquals(1, mq.update("MY_KEY", "MY_VALUE_UPDATED"));

	Conf confUpd = mq.findByKey("MY_KEY");
	Assert.assertEquals("MY_KEY", confUpd.key);
	Assert.assertEquals("MY_VALUE_UPDATED", confUpd.value);
	
	Assert.assertTrue(mq.findAllKeys().contains("MY_KEY"));
	
	Assert.assertEquals("MY_VALUE_UPDATED", mq.findValueForKey("MY_KEY"));
	
	Assert.assertEquals("MY_TEMPLATE", mq.template());
	
	//Assert.assertEquals("defaultMethod", mq.defaultMethod());
	
	Assert.assertNotNull(mq.getNamedParameterJdbcTemplate());
	
	Assert.assertEquals("MY_VALUE_UPDATED", mq.findOptionalValueForKey("MY_KEY").get());
	
	Assert.assertFalse(mq.findOptionalValueForKey("MY_KEY_NOT").isPresent());
	
	Assert.assertEquals("MY_VALUE_UPDATED", mq.findOptionalWrappedValueForKey("MY_KEY").get().value);
	
	Assert.assertFalse(mq.findOptionalWrappedValueForKey("MY_KEY_NOT").isPresent());

	Assert.assertEquals("defaultMethod", mq.defaultMethod());
}