Search in sources :

Example 26 with MyObjectMapper

use of mbg.test.mb3.generated.annotated.miscellaneous.mapper.MyObjectMapper in project generator by mybatis.

the class MiscellaneousTest method testMyObjectDeleteByExample.

@Test
public void testMyObjectDeleteByExample() {
    try (SqlSession sqlSession = sqlSessionFactory.openSession()) {
        MyObjectMapper mapper = sqlSession.getMapper(MyObjectMapper.class);
        MyObject record = new MyObject();
        FirstName fn = new FirstName();
        fn.setValue("Jeff");
        record.setFirstname(fn);
        record.setLastname("Smith");
        record.setId1(1);
        record.setId2(2);
        mapper.insert(record);
        record = new MyObject();
        fn = new FirstName();
        fn.setValue("Bob");
        record.setFirstname(fn);
        record.setLastname("Jones");
        record.setId1(3);
        record.setId2(4);
        mapper.insert(record);
        List<MyObject> answer = mapper.select(SelectDSLCompleter.allRows());
        assertEquals(2, answer.size());
        int rows = mapper.delete(dsl -> dsl.where(myObject.lastname, isLike("J%")));
        assertEquals(1, rows);
        answer = mapper.select(SelectDSLCompleter.allRows());
        assertEquals(1, answer.size());
    }
}
Also used : SqlSession(org.apache.ibatis.session.SqlSession) FirstName(mbg.test.common.FirstName) MyObject(mbg.test.mb3.generated.dsql.miscellaneous.model.MyObject) MyObjectMapper(mbg.test.mb3.generated.dsql.miscellaneous.mapper.MyObjectMapper) Test(org.junit.jupiter.api.Test)

Example 27 with MyObjectMapper

use of mbg.test.mb3.generated.annotated.miscellaneous.mapper.MyObjectMapper in project generator by mybatis.

the class MiscellaneousTest method testMyObjectSelectByExampleBetween.

@Test
public void testMyObjectSelectByExampleBetween() {
    try (SqlSession sqlSession = sqlSessionFactory.openSession()) {
        MyObjectMapper mapper = sqlSession.getMapper(MyObjectMapper.class);
        MyObject record = new MyObject();
        FirstName fn = new FirstName();
        fn.setValue("Fred");
        record.setFirstname(fn);
        record.setLastname("Flintstone");
        record.setId1(1);
        record.setId2(1);
        mapper.insert(record);
        record = new MyObject();
        fn = new FirstName();
        fn.setValue("Wilma");
        record.setFirstname(fn);
        record.setLastname("Flintstone");
        record.setId1(1);
        record.setId2(2);
        mapper.insert(record);
        record = new MyObject();
        fn = new FirstName();
        fn.setValue("Pebbles");
        record.setFirstname(fn);
        record.setLastname("Flintstone");
        record.setId1(1);
        record.setId2(3);
        mapper.insert(record);
        record = new MyObject();
        fn = new FirstName();
        fn.setValue("Barney");
        record.setFirstname(fn);
        record.setLastname("Rubble");
        record.setId1(2);
        record.setId2(1);
        mapper.insert(record);
        record = new MyObject();
        fn = new FirstName();
        fn.setValue("Betty");
        record.setFirstname(fn);
        record.setLastname("Rubble");
        record.setId1(2);
        record.setId2(2);
        mapper.insert(record);
        record = new MyObject();
        fn = new FirstName();
        fn.setValue("Bamm Bamm");
        record.setFirstname(fn);
        record.setLastname("Rubble");
        record.setId1(2);
        record.setId2(3);
        mapper.insert(record);
        List<MyObject> answer = mapper.select(dsl -> dsl.where(myObject.id2, isBetween(1).and(3)).orderBy(myObject.id1, myObject.id2));
        assertEquals(6, answer.size());
    }
}
Also used : SqlSession(org.apache.ibatis.session.SqlSession) FirstName(mbg.test.common.FirstName) MyObject(mbg.test.mb3.generated.dsql.miscellaneous.model.MyObject) MyObjectMapper(mbg.test.mb3.generated.dsql.miscellaneous.mapper.MyObjectMapper) Test(org.junit.jupiter.api.Test)

Example 28 with MyObjectMapper

use of mbg.test.mb3.generated.annotated.miscellaneous.mapper.MyObjectMapper in project generator by mybatis.

the class MiscellaneousTest method testMyObjectUpdateByPrimaryKey.

@Test
public void testMyObjectUpdateByPrimaryKey() {
    try (SqlSession sqlSession = sqlSessionFactory.openSession()) {
        MyObjectMapper mapper = sqlSession.getMapper(MyObjectMapper.class);
        MyObject record = new MyObject();
        FirstName fn = new FirstName();
        fn.setValue("Jeff");
        record.setFirstname(fn);
        record.setLastname("Smith");
        record.setId1(1);
        record.setId2(2);
        mapper.insert(record);
        fn = new FirstName();
        fn.setValue("Scott");
        record.setFirstname(fn);
        record.setLastname("Jones");
        int rows = mapper.updateByPrimaryKey(record);
        assertEquals(1, rows);
        Optional<MyObject> record2 = mapper.selectByPrimaryKey(2, 1);
        assertThat(record2).hasValueSatisfying(r2 -> {
            assertEquals(record.getFirstname(), r2.getFirstname());
            assertEquals(record.getLastname(), r2.getLastname());
            assertEquals(record.getId1(), r2.getId1());
            assertEquals(record.getId2(), r2.getId2());
        });
    }
}
Also used : SqlSession(org.apache.ibatis.session.SqlSession) FirstName(mbg.test.common.FirstName) MyObject(mbg.test.mb3.generated.dsql.miscellaneous.model.MyObject) MyObjectMapper(mbg.test.mb3.generated.dsql.miscellaneous.mapper.MyObjectMapper) Test(org.junit.jupiter.api.Test)

Example 29 with MyObjectMapper

use of mbg.test.mb3.generated.annotated.miscellaneous.mapper.MyObjectMapper in project generator by mybatis.

the class MiscellaneousTest method testMyObjectSelectByExampleNotLike.

@Test
public void testMyObjectSelectByExampleNotLike() {
    try (SqlSession sqlSession = sqlSessionFactory.openSession()) {
        MyObjectMapper mapper = sqlSession.getMapper(MyObjectMapper.class);
        MyObject record = new MyObject();
        FirstName fn = new FirstName();
        fn.setValue("Fred");
        record.setFirstname(fn);
        record.setLastname("Flintstone");
        record.setId1(1);
        record.setId2(1);
        mapper.insert(record);
        record = new MyObject();
        fn = new FirstName();
        fn.setValue("Wilma");
        record.setFirstname(fn);
        record.setLastname("Flintstone");
        record.setId1(1);
        record.setId2(2);
        mapper.insert(record);
        record = new MyObject();
        fn = new FirstName();
        fn.setValue("Pebbles");
        record.setFirstname(fn);
        record.setLastname("Flintstone");
        record.setId1(1);
        record.setId2(3);
        mapper.insert(record);
        record = new MyObject();
        fn = new FirstName();
        fn.setValue("Barney");
        record.setFirstname(fn);
        record.setLastname("Rubble");
        record.setId1(2);
        record.setId2(1);
        mapper.insert(record);
        record = new MyObject();
        fn = new FirstName();
        fn.setValue("Betty");
        record.setFirstname(fn);
        record.setLastname("Rubble");
        record.setId1(2);
        record.setId2(2);
        mapper.insert(record);
        record = new MyObject();
        fn = new FirstName();
        fn.setValue("Bamm Bamm");
        record.setFirstname(fn);
        record.setLastname("Rubble");
        record.setId1(2);
        record.setId2(3);
        mapper.insert(record);
        FirstName fn1 = new FirstName();
        fn1.setValue("B%");
        List<MyObject> answer = mapper.select(dsl -> dsl.where(myObject.firstname, isNotLike(fn1)).orderBy(myObject.id1, myObject.id2));
        assertEquals(3, answer.size());
        MyObject returnedRecord = answer.get(0);
        assertEquals(1, returnedRecord.getId1().intValue());
        assertEquals(1, returnedRecord.getId2().intValue());
        returnedRecord = answer.get(1);
        assertEquals(1, returnedRecord.getId1().intValue());
        assertEquals(2, returnedRecord.getId2().intValue());
        returnedRecord = answer.get(2);
        assertEquals(1, returnedRecord.getId1().intValue());
        assertEquals(3, returnedRecord.getId2().intValue());
    }
}
Also used : SqlSession(org.apache.ibatis.session.SqlSession) FirstName(mbg.test.common.FirstName) MyObject(mbg.test.mb3.generated.dsql.miscellaneous.model.MyObject) MyObjectMapper(mbg.test.mb3.generated.dsql.miscellaneous.mapper.MyObjectMapper) Test(org.junit.jupiter.api.Test)

Example 30 with MyObjectMapper

use of mbg.test.mb3.generated.annotated.miscellaneous.mapper.MyObjectMapper in project generator by mybatis.

the class MiscellaneousTest method testMyObjectSelectByExampleLikeInsensitive.

@Test
public void testMyObjectSelectByExampleLikeInsensitive() {
    try (SqlSession sqlSession = sqlSessionFactory.openSession()) {
        MyObjectMapper mapper = sqlSession.getMapper(MyObjectMapper.class);
        MyObject record = new MyObject();
        FirstName fn = new FirstName();
        fn.setValue("Fred");
        record.setFirstname(fn);
        record.setLastname("Flintstone");
        record.setId1(1);
        record.setId2(1);
        mapper.insert(record);
        record = new MyObject();
        fn = new FirstName();
        fn.setValue("Wilma");
        record.setFirstname(fn);
        record.setLastname("Flintstone");
        record.setId1(1);
        record.setId2(2);
        mapper.insert(record);
        record = new MyObject();
        fn = new FirstName();
        fn.setValue("Pebbles");
        record.setFirstname(fn);
        record.setLastname("Flintstone");
        record.setId1(1);
        record.setId2(3);
        mapper.insert(record);
        record = new MyObject();
        fn = new FirstName();
        fn.setValue("Barney");
        record.setFirstname(fn);
        record.setLastname("Rubble");
        record.setId1(2);
        record.setId2(1);
        mapper.insert(record);
        record = new MyObject();
        fn = new FirstName();
        fn.setValue("Betty");
        record.setFirstname(fn);
        record.setLastname("Rubble");
        record.setId1(2);
        record.setId2(2);
        mapper.insert(record);
        record = new MyObject();
        fn = new FirstName();
        fn.setValue("Bamm Bamm");
        record.setFirstname(fn);
        record.setLastname("Rubble");
        record.setId1(2);
        record.setId2(3);
        mapper.insert(record);
        List<MyObject> answer = mapper.select(dsl -> dsl.where(myObject.lastname, isLike("RU%")).orderBy(myObject.id1, myObject.id2));
        assertEquals(0, answer.size());
        answer = mapper.select(dsl -> dsl.where(myObject.lastname, isLikeCaseInsensitive("RU%")));
        assertEquals(3, answer.size());
        MyObject returnedRecord = answer.get(0);
        assertEquals(2, returnedRecord.getId1().intValue());
        assertEquals(1, returnedRecord.getId2().intValue());
        returnedRecord = answer.get(1);
        assertEquals(2, returnedRecord.getId1().intValue());
        assertEquals(2, returnedRecord.getId2().intValue());
        returnedRecord = answer.get(2);
        assertEquals(2, returnedRecord.getId1().intValue());
        assertEquals(3, returnedRecord.getId2().intValue());
    }
}
Also used : FirstName(mbg.test.common.FirstName) MyTime(mbg.test.common.MyTime) SqlBuilder(org.mybatis.dynamic.sql.SqlBuilder) SelectDSLCompleter(org.mybatis.dynamic.sql.select.SelectDSLCompleter) Date(java.util.Date) Assertions.assertThat(org.assertj.core.api.Assertions.assertThat) TestUtilities.datesAreEqual(mbg.test.common.util.TestUtilities.datesAreEqual) SelectStatementProvider(org.mybatis.dynamic.sql.select.render.SelectStatementProvider) Enumtest(mbg.test.mb3.generated.dsql.miscellaneous.model.Enumtest) RowBounds(org.apache.ibatis.session.RowBounds) ArrayList(java.util.ArrayList) MultiRowInsertStatementProvider(org.mybatis.dynamic.sql.insert.render.MultiRowInsertStatementProvider) MyObjectMapper(mbg.test.mb3.generated.dsql.miscellaneous.mapper.MyObjectMapper) SqlSession(org.apache.ibatis.session.SqlSession) RegexrenameMapper(mbg.test.mb3.generated.dsql.miscellaneous.mapper.RegexrenameMapper) TestEnum(mbg.test.mb3.common.TestEnum) Collection(java.util.Collection) MyObjectDynamicSqlSupport.myObject(mbg.test.mb3.generated.dsql.miscellaneous.support.MyObjectDynamicSqlSupport.myObject) Test(org.junit.jupiter.api.Test) List(java.util.List) Assertions(org.junit.jupiter.api.Assertions) Optional(java.util.Optional) Regexrename(mbg.test.mb3.generated.dsql.miscellaneous.model.Regexrename) EnumtestMapper(mbg.test.mb3.generated.dsql.miscellaneous.mapper.EnumtestMapper) MyObject(mbg.test.mb3.generated.dsql.miscellaneous.model.MyObject) SqlSession(org.apache.ibatis.session.SqlSession) FirstName(mbg.test.common.FirstName) MyObject(mbg.test.mb3.generated.dsql.miscellaneous.model.MyObject) MyObjectMapper(mbg.test.mb3.generated.dsql.miscellaneous.mapper.MyObjectMapper) Test(org.junit.jupiter.api.Test)

Aggregations

FirstName (mbg.test.common.FirstName)45 SqlSession (org.apache.ibatis.session.SqlSession)45 Test (org.junit.jupiter.api.Test)45 MyObjectMapper (mbg.test.mb3.generated.annotated.miscellaneous.mapper.MyObjectMapper)15 MyObject (mbg.test.mb3.generated.annotated.miscellaneous.model.MyObject)15 MyObjectMapper (mbg.test.mb3.generated.dsql.miscellaneous.mapper.MyObjectMapper)15 MyObject (mbg.test.mb3.generated.dsql.miscellaneous.model.MyObject)15 MyObjectMapper (mbg.test.mb3.generated.mixed.miscellaneous.mapper.MyObjectMapper)15 MyObject (mbg.test.mb3.generated.mixed.miscellaneous.model.MyObject)15 MyObjectCriteria (mbg.test.mb3.generated.annotated.miscellaneous.model.MyObjectCriteria)11 MyObjectCriteria (mbg.test.mb3.generated.mixed.miscellaneous.model.MyObjectCriteria)11 Date (java.util.Date)10 MyTime (mbg.test.common.MyTime)7 MyObjectKey (mbg.test.mb3.generated.annotated.miscellaneous.model.MyObjectKey)5 MyObjectKey (mbg.test.mb3.generated.mixed.miscellaneous.model.MyObjectKey)5 ArrayList (java.util.ArrayList)4 Collection (java.util.Collection)1 List (java.util.List)1 Optional (java.util.Optional)1 TestUtilities.datesAreEqual (mbg.test.common.util.TestUtilities.datesAreEqual)1