public OrmSessionProperties newInstance() {
OrmSessionProperties newProperties = new OrmSessionProperties();
newProperties.environmentId = environmentId;
newProperties.tableName = tableName;
newProperties.allowNonPkParameter = allowNonPkParameter;
return newProperties;
}
@Test
public void setWhere() {
properties.addWhere(" WHERE A = #{A} AND B = #{B}", "BBB");
Assert.assertEquals(
"AND ( A = #{NybatisOrm-User-0-NybatisSingleParameter} AND B = #{NybatisOrm-User-0-NybatisSingleParameter} )",
properties.getParameter().getString(Const.db.ORM_PARAMETER_WHERE));
NMap param = new NMap();
param.put("name", "NAME");
param.put("age", 19);
properties.removeWhere();
properties.addWhere(" WHERE name = #{name} AND age = #{age} ", param);
Assert.assertEquals(
"AND ( name = #{NybatisOrm-User-0-name} AND age = #{NybatisOrm-User-0-age} )",
properties.getParameter().get(Const.db.ORM_PARAMETER_WHERE).toString());
properties.setOrderBy("Order by name, age");
Assert.assertEquals(
"ORDER BY name, age",
properties.getParameter().get(Const.db.ORM_PARAMETER_ORDER_BY).toString());
}
@Test
public void setParameter() {
TestDomain testDomain = new TestDomain();
testDomain.setProdId("001");
NMap param = new NMap();
param.put("name", "NAME");
param.put("age", 19);
properties = new OrmSessionProperties();
properties.removeWhere();
properties.addWhere("where name = #{name} and age = #{age}", param);
NLogger.debug(properties.getParameter());
Assert.assertEquals(
"{NybatisOrm-User-0-name=NAME, NybatisOrm-User-0-age=19, NybatisOrm-DynamicSqlWhere=AND ( name = #{NybatisOrm-User-0-name} and age = #{NybatisOrm-User-0-age} )}",
properties.getParameter().toString());
properties = new OrmSessionProperties();
properties.setEntityParameter(testDomain);
NLogger.debug(properties.getParameter());
Assert.assertEquals(
"{NybatisOrm-Entity-listId=null, NybatisOrm-Entity-prodId=001, NybatisOrm-Entity-price=null, NybatisOrm-Entity-prodName=null}",
properties.getParameter().toString());
properties.setEntityParameter(testDomain);
properties.removeWhere();
properties.addWhere("where name = #{name} and age = #{age}", param);
NLogger.debug(properties.getParameter());
Assert.assertEquals(
"{NybatisOrm-Entity-listId=null, NybatisOrm-Entity-prodId=001, NybatisOrm-Entity-price=null, NybatisOrm-Entity-prodName=null, NybatisOrm-User-0-name=NAME, NybatisOrm-User-0-age=19, NybatisOrm-DynamicSqlWhere=AND ( name = #{NybatisOrm-User-0-name} and age = #{NybatisOrm-User-0-age} )}",
properties.getParameter().toString());
properties.setOrderBy("name, age");
NLogger.debug(properties.getParameter());
Assert.assertEquals(
"{NybatisOrm-Entity-listId=null, NybatisOrm-Entity-prodId=001, NybatisOrm-Entity-price=null, NybatisOrm-Entity-prodName=null, NybatisOrm-User-0-name=NAME, NybatisOrm-User-0-age=19, NybatisOrm-DynamicSqlWhere=AND ( name = #{NybatisOrm-User-0-name} and age = #{NybatisOrm-User-0-age} ), NybatisOrm-DynamicSqlOrderBy=ORDER BY name, age}",
properties.getParameter().toString());
}
