Search in sources :

Example 6 with Generatedalwaystest

use of mbg.test.mb3.generated.dsql.miscellaneous.model.Generatedalwaystest in project generator by mybatis.

the class GeneratedAlwaysTest method testInsert.

@Test
public void testInsert() {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {
        GeneratedalwaystestMapper mapper = sqlSession.getMapper(GeneratedalwaystestMapper.class);
        Generatedalwaystest gaTest = new Generatedalwaystest();
        gaTest.setId(1);
        gaTest.setName("fred");
        gaTest.setIdPlus1(55);
        gaTest.setIdPlus2(66);
        gaTest.setBlob1(TestUtilities.generateRandomBlob());
        int rows = mapper.insert(gaTest);
        assertEquals(1, rows);
        List<Generatedalwaystest> returnedRecords = mapper.selectByExampleWithBLOBs(null);
        assertEquals(1, returnedRecords.size());
        Generatedalwaystest returnedRecord = returnedRecords.get(0);
        assertEquals(1, returnedRecord.getId().intValue());
        assertEquals(2, returnedRecord.getIdPlus1().intValue());
        assertEquals(3, returnedRecord.getIdPlus2().intValue());
        assertEquals("fred", returnedRecord.getName());
        assertTrue(TestUtilities.blobsAreEqual(gaTest.getBlob1(), returnedRecord.getBlob1()));
    } finally {
        sqlSession.close();
    }
}
Also used : Generatedalwaystest(mbg.test.mb3.generated.miscellaneous.model.Generatedalwaystest) SqlSession(org.apache.ibatis.session.SqlSession) GeneratedalwaystestMapper(mbg.test.mb3.generated.miscellaneous.mapper.GeneratedalwaystestMapper) Test(org.junit.jupiter.api.Test)

Example 7 with Generatedalwaystest

use of mbg.test.mb3.generated.dsql.miscellaneous.model.Generatedalwaystest in project generator by mybatis.

the class GeneratedAlwaysTest method testUpdateByExampleWithBlobs.

@Test
public void testUpdateByExampleWithBlobs() {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {
        GeneratedalwaystestMapper mapper = sqlSession.getMapper(GeneratedalwaystestMapper.class);
        Generatedalwaystest gaTest = new Generatedalwaystest();
        gaTest.setId(1);
        gaTest.setName("fred");
        // should be ignored
        gaTest.setIdPlus1(55);
        // should be ignored
        gaTest.setIdPlus2(66);
        gaTest.setBlob1(TestUtilities.generateRandomBlob());
        int rows = mapper.insert(gaTest);
        assertEquals(1, rows);
        gaTest.setName("barney");
        // should be ignored
        gaTest.setIdPlus1(77);
        // should be ignored
        gaTest.setIdPlus2(88);
        gaTest.setBlob1(TestUtilities.generateRandomBlob());
        GeneratedalwaystestCriteria gaCriteria = new GeneratedalwaystestCriteria();
        gaCriteria.or().andIdPlus1EqualTo(2).andIdPlus2EqualTo(3);
        rows = mapper.updateByExampleWithBLOBs(gaTest, gaCriteria);
        assertEquals(1, rows);
        List<Generatedalwaystest> returnedRecords = mapper.selectByExampleWithBLOBs(gaCriteria);
        assertEquals(1, returnedRecords.size());
        Generatedalwaystest returnedRecord = returnedRecords.get(0);
        assertEquals(1, returnedRecord.getId().intValue());
        assertEquals(2, returnedRecord.getIdPlus1().intValue());
        assertEquals(3, returnedRecord.getIdPlus2().intValue());
        assertEquals("barney", returnedRecord.getName());
        assertTrue(TestUtilities.blobsAreEqual(gaTest.getBlob1(), returnedRecord.getBlob1()));
    } finally {
        sqlSession.close();
    }
}
Also used : Generatedalwaystest(mbg.test.mb3.generated.miscellaneous.model.Generatedalwaystest) SqlSession(org.apache.ibatis.session.SqlSession) GeneratedalwaystestMapper(mbg.test.mb3.generated.miscellaneous.mapper.GeneratedalwaystestMapper) GeneratedalwaystestCriteria(mbg.test.mb3.generated.miscellaneous.model.GeneratedalwaystestCriteria) Test(org.junit.jupiter.api.Test)

Example 8 with Generatedalwaystest

use of mbg.test.mb3.generated.dsql.miscellaneous.model.Generatedalwaystest in project generator by mybatis.

the class GeneratedAlwaysTest method testUpdateByPrimaryKey.

@Test
public void testUpdateByPrimaryKey() {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {
        GeneratedalwaystestMapper mapper = sqlSession.getMapper(GeneratedalwaystestMapper.class);
        Generatedalwaystest gaTest = new Generatedalwaystest();
        gaTest.setId(1);
        gaTest.setName("fred");
        // should be ignored
        gaTest.setIdPlus1(55);
        // should be ignored
        gaTest.setIdPlus2(66);
        gaTest.setBlob1(TestUtilities.generateRandomBlob());
        int rows = mapper.insert(gaTest);
        assertEquals(1, rows);
        byte[] originalBlob = gaTest.getBlob1();
        gaTest.setName("barney");
        // should be ignored
        gaTest.setIdPlus1(77);
        // should be ignored
        gaTest.setIdPlus2(88);
        gaTest.setBlob1(TestUtilities.generateRandomBlob());
        rows = mapper.updateByPrimaryKey(gaTest);
        assertEquals(1, rows);
        List<Generatedalwaystest> returnedRecords = mapper.selectByExampleWithBLOBs(null);
        assertEquals(1, returnedRecords.size());
        Generatedalwaystest returnedRecord = returnedRecords.get(0);
        assertEquals(1, returnedRecord.getId().intValue());
        assertEquals(2, returnedRecord.getIdPlus1().intValue());
        assertEquals(3, returnedRecord.getIdPlus2().intValue());
        assertEquals("barney", returnedRecord.getName());
        // should not have update the BLOB in regular update by primary key
        assertTrue(TestUtilities.blobsAreEqual(originalBlob, returnedRecord.getBlob1()));
    } finally {
        sqlSession.close();
    }
}
Also used : Generatedalwaystest(mbg.test.mb3.generated.miscellaneous.model.Generatedalwaystest) SqlSession(org.apache.ibatis.session.SqlSession) GeneratedalwaystestMapper(mbg.test.mb3.generated.miscellaneous.mapper.GeneratedalwaystestMapper) Test(org.junit.jupiter.api.Test)

Example 9 with Generatedalwaystest

use of mbg.test.mb3.generated.dsql.miscellaneous.model.Generatedalwaystest in project generator by mybatis.

the class GeneratedAlwaysTest method testUpdateByPrimaryKeySelective.

@Test
public void testUpdateByPrimaryKeySelective() {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {
        GeneratedalwaystestMapper mapper = sqlSession.getMapper(GeneratedalwaystestMapper.class);
        Generatedalwaystest gaTest = new Generatedalwaystest();
        gaTest.setId(1);
        gaTest.setName("fred");
        // should be ignored
        gaTest.setIdPlus1(55);
        // should be ignored
        gaTest.setIdPlus2(66);
        gaTest.setBlob1(TestUtilities.generateRandomBlob());
        int rows = mapper.insert(gaTest);
        assertEquals(1, rows);
        gaTest.setName(null);
        // should be ignored
        gaTest.setIdPlus1(77);
        // should be ignored
        gaTest.setIdPlus2(88);
        gaTest.setBlob1(TestUtilities.generateRandomBlob());
        rows = mapper.updateByPrimaryKeySelective(gaTest);
        assertEquals(1, rows);
        List<Generatedalwaystest> returnedRecords = mapper.selectByExampleWithBLOBs(null);
        assertEquals(1, returnedRecords.size());
        Generatedalwaystest returnedRecord = returnedRecords.get(0);
        assertEquals(1, returnedRecord.getId().intValue());
        assertEquals(2, returnedRecord.getIdPlus1().intValue());
        assertEquals(3, returnedRecord.getIdPlus2().intValue());
        assertEquals("fred", returnedRecord.getName());
        assertTrue(TestUtilities.blobsAreEqual(gaTest.getBlob1(), returnedRecord.getBlob1()));
    } finally {
        sqlSession.close();
    }
}
Also used : Generatedalwaystest(mbg.test.mb3.generated.miscellaneous.model.Generatedalwaystest) SqlSession(org.apache.ibatis.session.SqlSession) GeneratedalwaystestMapper(mbg.test.mb3.generated.miscellaneous.mapper.GeneratedalwaystestMapper) Test(org.junit.jupiter.api.Test)

Example 10 with Generatedalwaystest

use of mbg.test.mb3.generated.dsql.miscellaneous.model.Generatedalwaystest in project generator by mybatis.

the class GeneratedAlwaysTest method testUpdateByPrimaryKeyWithBlobs.

@Test
public void testUpdateByPrimaryKeyWithBlobs() {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {
        GeneratedalwaystestMapper mapper = sqlSession.getMapper(GeneratedalwaystestMapper.class);
        Generatedalwaystest gaTest = new Generatedalwaystest();
        gaTest.setId(1);
        gaTest.setName("fred");
        // should be ignored
        gaTest.setIdPlus1(55);
        // should be ignored
        gaTest.setIdPlus2(66);
        gaTest.setBlob1(TestUtilities.generateRandomBlob());
        int rows = mapper.insert(gaTest);
        assertEquals(1, rows);
        gaTest.setName("barney");
        // should be ignored
        gaTest.setIdPlus1(77);
        // should be ignored
        gaTest.setIdPlus2(88);
        gaTest.setBlob1(TestUtilities.generateRandomBlob());
        rows = mapper.updateByPrimaryKeyWithBLOBs(gaTest);
        assertEquals(1, rows);
        List<Generatedalwaystest> returnedRecords = mapper.selectByExampleWithBLOBs(null);
        assertEquals(1, returnedRecords.size());
        Generatedalwaystest returnedRecord = returnedRecords.get(0);
        assertEquals(1, returnedRecord.getId().intValue());
        assertEquals(2, returnedRecord.getIdPlus1().intValue());
        assertEquals(3, returnedRecord.getIdPlus2().intValue());
        assertEquals("barney", returnedRecord.getName());
        assertTrue(TestUtilities.blobsAreEqual(gaTest.getBlob1(), returnedRecord.getBlob1()));
    } finally {
        sqlSession.close();
    }
}
Also used : Generatedalwaystest(mbg.test.mb3.generated.miscellaneous.model.Generatedalwaystest) SqlSession(org.apache.ibatis.session.SqlSession) GeneratedalwaystestMapper(mbg.test.mb3.generated.miscellaneous.mapper.GeneratedalwaystestMapper) Test(org.junit.jupiter.api.Test)

Aggregations

SqlSession (org.apache.ibatis.session.SqlSession)24 Test (org.junit.jupiter.api.Test)24 GeneratedalwaystestMapper (mbg.test.mb3.generated.annotated.miscellaneous.mapper.GeneratedalwaystestMapper)8 Generatedalwaystest (mbg.test.mb3.generated.annotated.miscellaneous.model.Generatedalwaystest)8 GeneratedalwaystestMapper (mbg.test.mb3.generated.dsql.miscellaneous.mapper.GeneratedalwaystestMapper)8 Generatedalwaystest (mbg.test.mb3.generated.dsql.miscellaneous.model.Generatedalwaystest)8 GeneratedalwaystestMapper (mbg.test.mb3.generated.miscellaneous.mapper.GeneratedalwaystestMapper)8 Generatedalwaystest (mbg.test.mb3.generated.miscellaneous.model.Generatedalwaystest)8 List (java.util.List)3 TestUtilities (mbg.test.common.util.TestUtilities)3 GeneratedalwaystestCriteria (mbg.test.mb3.generated.annotated.miscellaneous.model.GeneratedalwaystestCriteria)3 GeneratedalwaystestDynamicSqlSupport (mbg.test.mb3.generated.dsql.miscellaneous.support.GeneratedalwaystestDynamicSqlSupport)3 GeneratedalwaystestCriteria (mbg.test.mb3.generated.miscellaneous.model.GeneratedalwaystestCriteria)3 Assertions (org.junit.jupiter.api.Assertions)3 SqlBuilder (org.mybatis.dynamic.sql.SqlBuilder)3 SelectDSLCompleter (org.mybatis.dynamic.sql.select.SelectDSLCompleter)3