Search in sources :

Example 21 with SqlSession

use of org.apache.ibatis.session.SqlSession in project generator by mybatis.

the class UpdateByExampleTest method testFieldsBlobsUpdateByExampleWithoutBLOBs.

@Test
public void testFieldsBlobsUpdateByExampleWithoutBLOBs() {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {
        FieldsblobsMapper mapper = sqlSession.getMapper(FieldsblobsMapper.class);
        FieldsblobsWithBLOBs record = new FieldsblobsWithBLOBs("Jeff", "Smith", generateRandomBlob(), generateRandomBlob(), null);
        mapper.insert(record);
        record = new FieldsblobsWithBLOBs("Scott", "Jones", generateRandomBlob(), generateRandomBlob(), null);
        mapper.insert(record);
        Fieldsblobs newRecord = new Fieldsblobs("Scott", "Doe");
        FieldsblobsExample example = new FieldsblobsExample();
        example.createCriteria().andFirstnameLike("S%");
        int rows = mapper.updateByExample(newRecord, example);
        assertEquals(1, rows);
        List<FieldsblobsWithBLOBs> answer = mapper.selectByExampleWithBLOBs(example);
        assertEquals(1, answer.size());
        FieldsblobsWithBLOBs returnedRecord = answer.get(0);
        assertEquals(newRecord.getFirstname(), returnedRecord.getFirstname());
        assertEquals(newRecord.getLastname(), returnedRecord.getLastname());
        assertTrue(blobsAreEqual(record.getBlob1(), returnedRecord.getBlob1()));
        assertTrue(blobsAreEqual(record.getBlob2(), returnedRecord.getBlob2()));
    } finally {
        sqlSession.close();
    }
}
Also used : FieldsblobsWithBLOBs(mbg.test.mb3.generated.hierarchical.immutable.model.FieldsblobsWithBLOBs) SqlSession(org.apache.ibatis.session.SqlSession) FieldsblobsExample(mbg.test.mb3.generated.hierarchical.immutable.model.FieldsblobsExample) Fieldsblobs(mbg.test.mb3.generated.hierarchical.immutable.model.Fieldsblobs) FieldsblobsMapper(mbg.test.mb3.generated.hierarchical.immutable.mapper.FieldsblobsMapper) Test(org.junit.Test)

Example 22 with SqlSession

use of org.apache.ibatis.session.SqlSession in project generator by mybatis.

the class UpdateByExampleTest method testPKFieldsUpdateByExample.

@Test
public void testPKFieldsUpdateByExample() {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {
        PkfieldsMapper mapper = sqlSession.getMapper(PkfieldsMapper.class);
        Pkfields record = new Pkfields();
        record.setFirstname("Jeff");
        record.setLastname("Smith");
        record.setId1(1);
        record.setId2(2);
        mapper.insert(record);
        record = new Pkfields();
        record.setFirstname("Bob");
        record.setLastname("Jones");
        record.setId1(3);
        record.setId2(4);
        mapper.insert(record);
        record = new Pkfields();
        record.setFirstname("Fred");
        record.setId1(3);
        record.setId2(4);
        PkfieldsExample example = new PkfieldsExample();
        example.createCriteria().andId1EqualTo(3).andId2EqualTo(4);
        int rows = mapper.updateByExample(record, example);
        assertEquals(1, rows);
        example.clear();
        example.createCriteria().andFirstnameEqualTo("Fred").andLastnameIsNull().andId1EqualTo(3).andId2EqualTo(4);
        long returnedRows = mapper.countByExample(example);
        assertEquals(1, returnedRows);
    } finally {
        sqlSession.close();
    }
}
Also used : SqlSession(org.apache.ibatis.session.SqlSession) PkfieldsMapper(mbg.test.mb3.generated.hierarchical.immutable.mapper.PkfieldsMapper) Pkfields(mbg.test.mb3.generated.hierarchical.immutable.model.Pkfields) PkfieldsExample(mbg.test.mb3.generated.hierarchical.immutable.model.PkfieldsExample) Test(org.junit.Test)

Example 23 with SqlSession

use of org.apache.ibatis.session.SqlSession in project generator by mybatis.

the class UpdateByExampleTest method testPKOnlyUpdateByExample.

@Test
public void testPKOnlyUpdateByExample() {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {
        PkonlyMapper mapper = sqlSession.getMapper(PkonlyMapper.class);
        PkonlyKey key = new PkonlyKey();
        key.setId(1);
        key.setSeqNum(3);
        mapper.insert(key);
        key = new PkonlyKey();
        key.setId(5);
        key.setSeqNum(6);
        mapper.insert(key);
        key = new PkonlyKey();
        key.setId(7);
        key.setSeqNum(8);
        mapper.insert(key);
        PkonlyExample example = new PkonlyExample();
        example.createCriteria().andIdEqualTo(7);
        key = new PkonlyKey();
        key.setSeqNum(3);
        key.setId(22);
        int rows = mapper.updateByExample(key, example);
        assertEquals(1, rows);
        example.clear();
        example.createCriteria().andIdEqualTo(22).andSeqNumEqualTo(3);
        long returnedRows = mapper.countByExample(example);
        assertEquals(1, returnedRows);
    } finally {
        sqlSession.close();
    }
}
Also used : PkonlyMapper(mbg.test.mb3.generated.hierarchical.mapper.PkonlyMapper) SqlSession(org.apache.ibatis.session.SqlSession) PkonlyExample(mbg.test.mb3.generated.hierarchical.model.PkonlyExample) PkonlyKey(mbg.test.mb3.generated.hierarchical.model.PkonlyKey) Test(org.junit.Test)

Example 24 with SqlSession

use of org.apache.ibatis.session.SqlSession in project generator by mybatis.

the class UpdateByExampleTest method testPKBlobsUpdateByExampleWithoutBLOBs.

@Test
public void testPKBlobsUpdateByExampleWithoutBLOBs() {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {
        PkblobsMapper mapper = sqlSession.getMapper(PkblobsMapper.class);
        PkblobsWithBLOBs record = new PkblobsWithBLOBs();
        record.setId(3);
        record.setBlob1(generateRandomBlob());
        record.setBlob2(generateRandomBlob());
        mapper.insert(record);
        record = new PkblobsWithBLOBs();
        record.setId(6);
        record.setBlob1(generateRandomBlob());
        record.setBlob2(generateRandomBlob());
        mapper.insert(record);
        PkblobsKey newRecord = new PkblobsKey();
        newRecord.setId(8);
        PkblobsExample example = new PkblobsExample();
        example.createCriteria().andIdGreaterThan(4);
        int rows = mapper.updateByExample(newRecord, example);
        assertEquals(1, rows);
        List<PkblobsWithBLOBs> answer = mapper.selectByExampleWithBLOBs(example);
        assertEquals(1, answer.size());
        PkblobsWithBLOBs returnedRecord = answer.get(0);
        assertEquals(8, returnedRecord.getId().intValue());
        assertTrue(blobsAreEqual(record.getBlob1(), returnedRecord.getBlob1()));
        assertTrue(blobsAreEqual(record.getBlob2(), returnedRecord.getBlob2()));
    } finally {
        sqlSession.close();
    }
}
Also used : PkblobsExample(mbg.test.mb3.generated.hierarchical.model.PkblobsExample) PkblobsWithBLOBs(mbg.test.mb3.generated.hierarchical.model.PkblobsWithBLOBs) PkblobsKey(mbg.test.mb3.generated.hierarchical.model.PkblobsKey) SqlSession(org.apache.ibatis.session.SqlSession) PkblobsMapper(mbg.test.mb3.generated.hierarchical.mapper.PkblobsMapper) Test(org.junit.Test)

Example 25 with SqlSession

use of org.apache.ibatis.session.SqlSession in project generator by mybatis.

the class UpdateByExampleTest method testPKBlobsUpdateByExampleSelective.

@Test
public void testPKBlobsUpdateByExampleSelective() {
    SqlSession sqlSession = sqlSessionFactory.openSession();
    try {
        PkblobsMapper mapper = sqlSession.getMapper(PkblobsMapper.class);
        PkblobsWithBLOBs record = new PkblobsWithBLOBs();
        record.setId(3);
        record.setBlob1(generateRandomBlob());
        record.setBlob2(generateRandomBlob());
        mapper.insert(record);
        record = new PkblobsWithBLOBs();
        record.setId(6);
        record.setBlob1(generateRandomBlob());
        record.setBlob2(generateRandomBlob());
        mapper.insert(record);
        PkblobsWithBLOBs newRecord = new PkblobsWithBLOBs();
        newRecord.setBlob1(generateRandomBlob());
        PkblobsExample example = new PkblobsExample();
        example.createCriteria().andIdGreaterThan(4);
        int rows = mapper.updateByExampleSelective(newRecord, example);
        assertEquals(1, rows);
        List<PkblobsWithBLOBs> answer = mapper.selectByExampleWithBLOBs(example);
        assertEquals(1, answer.size());
        PkblobsWithBLOBs returnedRecord = answer.get(0);
        assertEquals(6, returnedRecord.getId().intValue());
        assertTrue(blobsAreEqual(newRecord.getBlob1(), returnedRecord.getBlob1()));
        assertTrue(blobsAreEqual(record.getBlob2(), returnedRecord.getBlob2()));
    } finally {
        sqlSession.close();
    }
}
Also used : PkblobsExample(mbg.test.mb3.generated.hierarchical.model.PkblobsExample) PkblobsWithBLOBs(mbg.test.mb3.generated.hierarchical.model.PkblobsWithBLOBs) SqlSession(org.apache.ibatis.session.SqlSession) PkblobsMapper(mbg.test.mb3.generated.hierarchical.mapper.PkblobsMapper) Test(org.junit.Test)

Aggregations

SqlSession (org.apache.ibatis.session.SqlSession)1671 Test (org.junit.Test)1561 SqlSessionFactoryBuilder (org.apache.ibatis.session.SqlSessionFactoryBuilder)85 Reader (java.io.Reader)83 Connection (java.sql.Connection)75 Country (com.github.pagehelper.model.Country)71 ScriptRunner (org.apache.ibatis.jdbc.ScriptRunner)69 BeforeClass (org.junit.BeforeClass)62 ArrayList (java.util.ArrayList)59 CountryMapper (com.github.pagehelper.mapper.CountryMapper)57 BaseDataTest (org.apache.ibatis.BaseDataTest)48 HashMap (java.util.HashMap)47 FirstName (mbg.test.common.FirstName)45 RowBounds (org.apache.ibatis.session.RowBounds)31 Map (java.util.Map)28 SqlSessionFactory (org.apache.ibatis.session.SqlSessionFactory)27 Date (java.util.Date)26 Blog (org.apache.ibatis.domain.blog.Blog)13 AwfulTableMapper (mbg.test.mb3.generated.annotated.hierarchical.mapper.AwfulTableMapper)11 AwfulTable (mbg.test.mb3.generated.annotated.hierarchical.model.AwfulTable)11