Example usage for org.apache.ibatis.session SqlSession close

List of usage examples for org.apache.ibatis.session SqlSession close

  1. HOME
  2. Java
  3. org.apache.ibatis
  4. org.apache.ibatis.session.*
  5. SqlSession
  6. close

Introduction

In this page you can find the example usage for org.apache.ibatis.session SqlSession close.

Prototype

@Override
void close();

Source Link

Document

Closes the session.

Usage

From source file:com.bibisco.test.ProjectManagerTest.java

License:GNU General Public License

public void checkTestProjectDBLocations() throws IOException, ParseException {

    List<Locations> lListLocations;

    SqlSessionFactory lSqlSessionFactory = AllTests.getProjectSqlSessionFactoryById(AllTests.TEST_PROJECT_ID);
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {//w ww.ja v a  2 s.com

        LocationsMapper lLocationsMapper = lSqlSession.getMapper(LocationsMapper.class);
        LocationsExample lLocationsExample = new LocationsExample();
        lLocationsExample.setOrderByClause("position");
        lListLocations = lLocationsMapper.selectByExampleWithBLOBs(lLocationsExample);

    } finally {
        lSqlSession.close();
    }

    // LOCATIONS

    Assert.assertEquals("City 1", lListLocations.get(0).getCity());
    Assert.assertEquals("<p>Location 1</p>", lListLocations.get(0).getDescription());
    Assert.assertEquals(new Long(71), lListLocations.get(0).getIdLocation());
    Assert.assertEquals("Location's name 1", lListLocations.get(0).getName());
    Assert.assertEquals("Nation 1", lListLocations.get(0).getNation());
    Assert.assertEquals(new Integer(1), lListLocations.get(0).getPosition());
    Assert.assertEquals("State 1", lListLocations.get(0).getState());
    Assert.assertEquals(new Integer(0), lListLocations.get(0).getTaskStatus());

    Assert.assertEquals("City 2", lListLocations.get(1).getCity());
    Assert.assertEquals("<p>Location 2</p>", lListLocations.get(1).getDescription());
    Assert.assertEquals(new Long(72), lListLocations.get(1).getIdLocation());
    Assert.assertEquals("Location's name 2", lListLocations.get(1).getName());
    Assert.assertEquals("Nation 2", lListLocations.get(1).getNation());
    Assert.assertEquals(new Integer(2), lListLocations.get(1).getPosition());
    Assert.assertEquals("State 2", lListLocations.get(1).getState());
    Assert.assertEquals(new Integer(1), lListLocations.get(1).getTaskStatus());

    Assert.assertEquals("City 3", lListLocations.get(2).getCity());
    Assert.assertEquals("<p>Location 3</p>", lListLocations.get(2).getDescription());
    Assert.assertEquals(new Long(73), lListLocations.get(2).getIdLocation());
    Assert.assertEquals("Location's name 3", lListLocations.get(2).getName());
    Assert.assertEquals("Nation 3", lListLocations.get(2).getNation());
    Assert.assertEquals(new Integer(3), lListLocations.get(2).getPosition());
    Assert.assertEquals("State 3", lListLocations.get(2).getState());
    Assert.assertEquals(new Integer(2), lListLocations.get(2).getTaskStatus());
}

From source file:com.bibisco.test.ProjectManagerTest.java

License:GNU General Public License

public void checkTestProjectDBCharacters() throws IOException, ParseException {

    List<CharactersWithBLOBs> lListMainCharacters;
    List<CharactersWithBLOBs> lListSecondaryCharacters;
    List<CharacterInfos> lListCharacterInfosMainCharacter1;
    List<CharacterInfos> lListCharacterInfosMainCharacter2;
    List<CharacterInfos> lListCharacterInfosMainCharacter3;

    SqlSessionFactory lSqlSessionFactory = AllTests.getProjectSqlSessionFactoryById(AllTests.TEST_PROJECT_ID);
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {//from  w  w  w .j  a va  2s.c om

        CharactersMapper lCharactersMapper = lSqlSession.getMapper(CharactersMapper.class);
        CharactersExample lMainCharactersExample = new CharactersExample();
        lMainCharactersExample.createCriteria().andMainCharacterEqualTo("Y");
        lMainCharactersExample.setOrderByClause("position");
        lListMainCharacters = lCharactersMapper.selectByExampleWithBLOBs(lMainCharactersExample);

        CharactersExample lSecondaryCharactersExample = new CharactersExample();
        lSecondaryCharactersExample.createCriteria().andMainCharacterEqualTo("N");
        lSecondaryCharactersExample.setOrderByClause("position");
        lListSecondaryCharacters = lCharactersMapper.selectByExampleWithBLOBs(lSecondaryCharactersExample);

        CharacterInfosMapper lCharacterInfosMapper = lSqlSession.getMapper(CharacterInfosMapper.class);
        CharacterInfosExample lCharacterInfosExample = new CharacterInfosExample();
        lCharacterInfosExample.createCriteria().andIdCharacterEqualTo(67);
        lCharacterInfosExample.setOrderByClause("character_info_type, question");
        lListCharacterInfosMainCharacter1 = lCharacterInfosMapper
                .selectByExampleWithBLOBs(lCharacterInfosExample);

        lCharacterInfosExample = new CharacterInfosExample();
        lCharacterInfosExample.createCriteria().andIdCharacterEqualTo(68);
        lCharacterInfosExample.setOrderByClause("character_info_type, question");
        lListCharacterInfosMainCharacter2 = lCharacterInfosMapper
                .selectByExampleWithBLOBs(lCharacterInfosExample);

        lCharacterInfosExample = new CharacterInfosExample();
        lCharacterInfosExample.createCriteria().andIdCharacterEqualTo(69);
        lCharacterInfosExample.setOrderByClause("character_info_type, question");
        lListCharacterInfosMainCharacter3 = lCharacterInfosMapper
                .selectByExampleWithBLOBs(lCharacterInfosExample);

    } finally {
        lSqlSession.close();
    }

    // CHARACTERS

    Assert.assertEquals("<p>Behaviors, attitudes free text</p>",
            lListMainCharacters.get(0).getBehaviorsFreeText());
    Assert.assertEquals("Y", lListMainCharacters.get(0).getBehaviorsInterview());
    Assert.assertEquals(new Integer(0), lListMainCharacters.get(0).getBehaviorsTaskStatus());
    Assert.assertEquals("<p>Conflict</p>", lListMainCharacters.get(0).getConflict());
    Assert.assertEquals(new Integer(0), lListMainCharacters.get(0).getConflictTaskStatus());
    Assert.assertEquals("<p>Evolution</p>", lListMainCharacters.get(0).getEvolutionduringthestory());
    Assert.assertEquals(new Long(67), lListMainCharacters.get(0).getIdCharacter());
    Assert.assertEquals("<p>Ideas and passions free text</p>", lListMainCharacters.get(0).getIdeasFreeText());
    Assert.assertEquals("Y", lListMainCharacters.get(0).getIdeasInterview());
    Assert.assertEquals(new Integer(0), lListMainCharacters.get(0).getIdeasTaskStatus());
    Assert.assertEquals("<p>Life before the story&#39;s beginning</p>",
            lListMainCharacters.get(0).getLifebeforestorybeginning());
    Assert.assertEquals(new Integer(0), lListMainCharacters.get(0).getLifebeforestorybeginningTaskStatus());
    Assert.assertEquals("Y", lListMainCharacters.get(0).getMainCharacter());
    Assert.assertEquals("Main character 1", lListMainCharacters.get(0).getName());
    Assert.assertEquals("<p>Personal data free text</p>", lListMainCharacters.get(0).getPersonalDataFreeText());
    Assert.assertEquals("Y", lListMainCharacters.get(0).getPersonalDataInterview());
    Assert.assertEquals(new Integer(0), lListMainCharacters.get(0).getPersonalDataTaskStatus());
    Assert.assertEquals("<p>Physical features free text</p>",
            lListMainCharacters.get(0).getPhysionomyFreeText());
    Assert.assertEquals("Y", lListMainCharacters.get(0).getPhysionomyInterview());
    Assert.assertEquals(new Integer(0), lListMainCharacters.get(0).getPhysionomyTaskStatus());
    Assert.assertEquals(new Integer(1), lListMainCharacters.get(0).getPosition());
    Assert.assertEquals("<p>Psychology free text</p>", lListMainCharacters.get(0).getPsychologyFreeText());
    Assert.assertEquals("Y", lListMainCharacters.get(0).getPsychologyInterview());
    Assert.assertEquals(new Integer(0), lListMainCharacters.get(0).getPsychologyTaskStatus());
    Assert.assertNull(lListMainCharacters.get(0).getSecondaryCharacterDescription());
    Assert.assertEquals(new Integer(0),
            lListMainCharacters.get(0).getSecondaryCharacterDescriptionTaskStatus());
    Assert.assertEquals("<p>Sociology free text</p>", lListMainCharacters.get(0).getSociologyFreeText());
    Assert.assertEquals("Y", lListMainCharacters.get(0).getSociologyInterview());
    Assert.assertEquals(new Integer(0), lListMainCharacters.get(0).getSociologyTaskStatus());

    Assert.assertNull(lListMainCharacters.get(1).getBehaviorsFreeText());
    Assert.assertEquals("Y", lListMainCharacters.get(1).getBehaviorsInterview());
    Assert.assertEquals(new Integer(0), lListMainCharacters.get(1).getBehaviorsTaskStatus());
    Assert.assertNull(lListMainCharacters.get(1).getConflict());
    Assert.assertEquals(new Integer(0), lListMainCharacters.get(1).getConflictTaskStatus());
    Assert.assertNull(lListMainCharacters.get(1).getEvolutionduringthestory());
    Assert.assertEquals(new Long(68), lListMainCharacters.get(1).getIdCharacter());
    Assert.assertNull(lListMainCharacters.get(1).getIdeasFreeText());
    Assert.assertEquals("Y", lListMainCharacters.get(1).getIdeasInterview());
    Assert.assertEquals(new Integer(0), lListMainCharacters.get(1).getIdeasTaskStatus());
    Assert.assertNull(lListMainCharacters.get(1).getLifebeforestorybeginning());
    Assert.assertEquals(new Integer(0), lListMainCharacters.get(1).getLifebeforestorybeginningTaskStatus());
    Assert.assertEquals("Y", lListMainCharacters.get(1).getMainCharacter());
    Assert.assertEquals("Main character 2", lListMainCharacters.get(1).getName());
    Assert.assertNull(lListMainCharacters.get(1).getPersonalDataFreeText());
    Assert.assertEquals("Y", lListMainCharacters.get(1).getPersonalDataInterview());
    Assert.assertEquals(new Integer(1), lListMainCharacters.get(1).getPersonalDataTaskStatus());
    Assert.assertNull(lListMainCharacters.get(1).getPhysionomyFreeText());
    Assert.assertEquals("Y", lListMainCharacters.get(1).getPhysionomyInterview());
    Assert.assertEquals(new Integer(0), lListMainCharacters.get(1).getPhysionomyTaskStatus());
    Assert.assertEquals(new Integer(2), lListMainCharacters.get(1).getPosition());
    Assert.assertNull(lListMainCharacters.get(1).getPsychologyFreeText());
    Assert.assertEquals("Y", lListMainCharacters.get(1).getPsychologyInterview());
    Assert.assertEquals(new Integer(0), lListMainCharacters.get(1).getPsychologyTaskStatus());
    Assert.assertNull(lListMainCharacters.get(1).getSecondaryCharacterDescription());
    Assert.assertEquals(new Integer(0),
            lListMainCharacters.get(1).getSecondaryCharacterDescriptionTaskStatus());
    Assert.assertNull(lListMainCharacters.get(1).getSociologyFreeText());
    Assert.assertEquals("Y", lListMainCharacters.get(1).getSociologyInterview());
    Assert.assertEquals(new Integer(0), lListMainCharacters.get(1).getSociologyTaskStatus());

    Assert.assertNull(lListMainCharacters.get(2).getBehaviorsFreeText());
    Assert.assertEquals("Y", lListMainCharacters.get(2).getBehaviorsInterview());
    Assert.assertEquals(new Integer(2), lListMainCharacters.get(2).getBehaviorsTaskStatus());
    Assert.assertNull(lListMainCharacters.get(2).getConflict());
    Assert.assertEquals(new Integer(2), lListMainCharacters.get(2).getConflictTaskStatus());
    Assert.assertNull(lListMainCharacters.get(2).getEvolutionduringthestory());
    Assert.assertEquals(new Long(69), lListMainCharacters.get(2).getIdCharacter());
    Assert.assertNull(lListMainCharacters.get(2).getIdeasFreeText());
    Assert.assertEquals("Y", lListMainCharacters.get(2).getIdeasInterview());
    Assert.assertEquals(new Integer(2), lListMainCharacters.get(2).getIdeasTaskStatus());
    Assert.assertNull(lListMainCharacters.get(2).getLifebeforestorybeginning());
    Assert.assertEquals(new Integer(2), lListMainCharacters.get(2).getLifebeforestorybeginningTaskStatus());
    Assert.assertEquals("Y", lListMainCharacters.get(2).getMainCharacter());
    Assert.assertEquals("Main character 3", lListMainCharacters.get(2).getName());
    Assert.assertNull(lListMainCharacters.get(2).getPersonalDataFreeText());
    Assert.assertEquals("Y", lListMainCharacters.get(2).getPersonalDataInterview());
    Assert.assertEquals(new Integer(2), lListMainCharacters.get(2).getPersonalDataTaskStatus());
    Assert.assertNull(lListMainCharacters.get(2).getPhysionomyFreeText());
    Assert.assertEquals("Y", lListMainCharacters.get(2).getPhysionomyInterview());
    Assert.assertEquals(new Integer(2), lListMainCharacters.get(2).getPhysionomyTaskStatus());
    Assert.assertEquals(new Integer(3), lListMainCharacters.get(2).getPosition());
    Assert.assertNull(lListMainCharacters.get(2).getPsychologyFreeText());
    Assert.assertEquals("Y", lListMainCharacters.get(2).getPsychologyInterview());
    Assert.assertEquals(new Integer(2), lListMainCharacters.get(2).getPsychologyTaskStatus());
    Assert.assertNull(lListMainCharacters.get(2).getSecondaryCharacterDescription());
    Assert.assertEquals(new Integer(0),
            lListMainCharacters.get(2).getSecondaryCharacterDescriptionTaskStatus());
    Assert.assertNull(lListMainCharacters.get(2).getSociologyFreeText());
    Assert.assertEquals("Y", lListMainCharacters.get(2).getSociologyInterview());
    Assert.assertEquals(new Integer(2), lListMainCharacters.get(2).getSociologyTaskStatus());

    Assert.assertNull(lListSecondaryCharacters.get(0).getBehaviorsFreeText());
    Assert.assertEquals("Y", lListSecondaryCharacters.get(0).getBehaviorsInterview());
    Assert.assertEquals(new Integer(0), lListSecondaryCharacters.get(0).getBehaviorsTaskStatus());
    Assert.assertNull(lListSecondaryCharacters.get(0).getConflict());
    Assert.assertEquals(new Integer(0), lListSecondaryCharacters.get(0).getConflictTaskStatus());
    Assert.assertNull(lListSecondaryCharacters.get(0).getEvolutionduringthestory());
    Assert.assertEquals(new Long(70), lListSecondaryCharacters.get(0).getIdCharacter());
    Assert.assertNull(lListSecondaryCharacters.get(0).getIdeasFreeText());
    Assert.assertEquals("Y", lListSecondaryCharacters.get(0).getIdeasInterview());
    Assert.assertEquals(new Integer(0), lListSecondaryCharacters.get(0).getIdeasTaskStatus());
    Assert.assertNull(lListSecondaryCharacters.get(0).getLifebeforestorybeginning());
    Assert.assertEquals(new Integer(0),
            lListSecondaryCharacters.get(0).getLifebeforestorybeginningTaskStatus());
    Assert.assertEquals("N", lListSecondaryCharacters.get(0).getMainCharacter());
    Assert.assertEquals("Secondary character 1", lListSecondaryCharacters.get(0).getName());
    Assert.assertNull(lListSecondaryCharacters.get(0).getPersonalDataFreeText());
    Assert.assertEquals("Y", lListSecondaryCharacters.get(0).getPersonalDataInterview());
    Assert.assertEquals(new Integer(0), lListSecondaryCharacters.get(0).getPersonalDataTaskStatus());
    Assert.assertNull(lListSecondaryCharacters.get(0).getPhysionomyFreeText());
    Assert.assertEquals("Y", lListSecondaryCharacters.get(0).getPhysionomyInterview());
    Assert.assertEquals(new Integer(0), lListSecondaryCharacters.get(0).getPhysionomyTaskStatus());
    Assert.assertEquals(new Integer(1), lListSecondaryCharacters.get(0).getPosition());
    Assert.assertNull(lListSecondaryCharacters.get(0).getPsychologyFreeText());
    Assert.assertEquals("Y", lListSecondaryCharacters.get(0).getPsychologyInterview());
    Assert.assertEquals(new Integer(0), lListSecondaryCharacters.get(0).getPsychologyTaskStatus());
    Assert.assertEquals("<p>Secondary character 1</p>",
            lListSecondaryCharacters.get(0).getSecondaryCharacterDescription());
    Assert.assertEquals(new Integer(0),
            lListSecondaryCharacters.get(0).getSecondaryCharacterDescriptionTaskStatus());
    Assert.assertNull(lListSecondaryCharacters.get(0).getSociologyFreeText());
    Assert.assertEquals("Y", lListSecondaryCharacters.get(0).getSociologyInterview());
    Assert.assertEquals(new Integer(0), lListSecondaryCharacters.get(0).getSociologyTaskStatus());

    Assert.assertNull(lListSecondaryCharacters.get(1).getBehaviorsFreeText());
    Assert.assertEquals("Y", lListSecondaryCharacters.get(1).getBehaviorsInterview());
    Assert.assertEquals(new Integer(0), lListSecondaryCharacters.get(1).getBehaviorsTaskStatus());
    Assert.assertNull(lListSecondaryCharacters.get(1).getConflict());
    Assert.assertEquals(new Integer(0), lListSecondaryCharacters.get(1).getConflictTaskStatus());
    Assert.assertNull(lListSecondaryCharacters.get(1).getEvolutionduringthestory());
    Assert.assertEquals(new Long(71), lListSecondaryCharacters.get(1).getIdCharacter());
    Assert.assertNull(lListSecondaryCharacters.get(0).getIdeasFreeText());
    Assert.assertEquals("Y", lListSecondaryCharacters.get(1).getIdeasInterview());
    Assert.assertEquals(new Integer(0), lListSecondaryCharacters.get(1).getIdeasTaskStatus());
    Assert.assertNull(lListSecondaryCharacters.get(1).getLifebeforestorybeginning());
    Assert.assertEquals(new Integer(0),
            lListSecondaryCharacters.get(1).getLifebeforestorybeginningTaskStatus());
    Assert.assertEquals("N", lListSecondaryCharacters.get(1).getMainCharacter());
    Assert.assertEquals("Secondary character 2", lListSecondaryCharacters.get(1).getName());
    Assert.assertNull(lListSecondaryCharacters.get(1).getPersonalDataFreeText());
    Assert.assertEquals("Y", lListSecondaryCharacters.get(1).getPersonalDataInterview());
    Assert.assertEquals(new Integer(0), lListSecondaryCharacters.get(1).getPersonalDataTaskStatus());
    Assert.assertNull(lListSecondaryCharacters.get(1).getPhysionomyFreeText());
    Assert.assertEquals("Y", lListSecondaryCharacters.get(1).getPhysionomyInterview());
    Assert.assertEquals(new Integer(0), lListSecondaryCharacters.get(1).getPhysionomyTaskStatus());
    Assert.assertEquals(new Integer(2), lListSecondaryCharacters.get(1).getPosition());
    Assert.assertNull(lListSecondaryCharacters.get(1).getPsychologyFreeText());
    Assert.assertEquals("Y", lListSecondaryCharacters.get(1).getPsychologyInterview());
    Assert.assertEquals(new Integer(0), lListSecondaryCharacters.get(1).getPsychologyTaskStatus());
    Assert.assertEquals("<p>Secondary character 2</p>",
            lListSecondaryCharacters.get(1).getSecondaryCharacterDescription());
    Assert.assertEquals(new Integer(1),
            lListSecondaryCharacters.get(1).getSecondaryCharacterDescriptionTaskStatus());
    Assert.assertNull(lListSecondaryCharacters.get(1).getSociologyFreeText());
    Assert.assertEquals("Y", lListSecondaryCharacters.get(1).getSociologyInterview());
    Assert.assertEquals(new Integer(0), lListSecondaryCharacters.get(1).getSociologyTaskStatus());

    Assert.assertNull(lListSecondaryCharacters.get(2).getBehaviorsFreeText());
    Assert.assertEquals("Y", lListSecondaryCharacters.get(2).getBehaviorsInterview());
    Assert.assertEquals(new Integer(0), lListSecondaryCharacters.get(2).getBehaviorsTaskStatus());
    Assert.assertNull(lListSecondaryCharacters.get(2).getConflict());
    Assert.assertEquals(new Integer(0), lListSecondaryCharacters.get(2).getConflictTaskStatus());
    Assert.assertNull(lListSecondaryCharacters.get(2).getEvolutionduringthestory());
    Assert.assertEquals(new Long(72), lListSecondaryCharacters.get(2).getIdCharacter());
    Assert.assertNull(lListSecondaryCharacters.get(0).getIdeasFreeText());
    Assert.assertEquals("Y", lListSecondaryCharacters.get(2).getIdeasInterview());
    Assert.assertEquals(new Integer(0), lListSecondaryCharacters.get(2).getIdeasTaskStatus());
    Assert.assertNull(lListSecondaryCharacters.get(2).getLifebeforestorybeginning());
    Assert.assertEquals(new Integer(0),
            lListSecondaryCharacters.get(2).getLifebeforestorybeginningTaskStatus());
    Assert.assertEquals("N", lListSecondaryCharacters.get(2).getMainCharacter());
    Assert.assertEquals("Secondary character 3", lListSecondaryCharacters.get(2).getName());
    Assert.assertNull(lListSecondaryCharacters.get(2).getPersonalDataFreeText());
    Assert.assertEquals("Y", lListSecondaryCharacters.get(2).getPersonalDataInterview());
    Assert.assertEquals(new Integer(0), lListSecondaryCharacters.get(2).getPersonalDataTaskStatus());
    Assert.assertNull(lListSecondaryCharacters.get(2).getPhysionomyFreeText());
    Assert.assertEquals("Y", lListSecondaryCharacters.get(2).getPhysionomyInterview());
    Assert.assertEquals(new Integer(0), lListSecondaryCharacters.get(2).getPhysionomyTaskStatus());
    Assert.assertEquals(new Integer(3), lListSecondaryCharacters.get(2).getPosition());
    Assert.assertNull(lListSecondaryCharacters.get(2).getPsychologyFreeText());
    Assert.assertEquals("Y", lListSecondaryCharacters.get(2).getPsychologyInterview());
    Assert.assertEquals(new Integer(0), lListSecondaryCharacters.get(2).getPsychologyTaskStatus());
    Assert.assertEquals("<p>Secondary character 3</p>",
            lListSecondaryCharacters.get(2).getSecondaryCharacterDescription());
    Assert.assertEquals(new Integer(2),
            lListSecondaryCharacters.get(2).getSecondaryCharacterDescriptionTaskStatus());
    Assert.assertNull(lListSecondaryCharacters.get(2).getSociologyFreeText());
    Assert.assertEquals("Y", lListSecondaryCharacters.get(2).getSociologyInterview());
    Assert.assertEquals(new Integer(0), lListSecondaryCharacters.get(2).getSociologyTaskStatus());

    // CHARACTER INFO

    int lIntBehaviorsStart = 0;
    int lIntBehaviorsEnd = CharacterInfoQuestions.BEHAVIORS.getTotalQuestions();
    int lIntIdeasStart = lIntBehaviorsEnd;
    int lIntIdeasEnd = lIntIdeasStart + CharacterInfoQuestions.IDEAS.getTotalQuestions();
    int lIntPersonalDataStart = lIntIdeasEnd;
    int lIntPersonalDataEnd = lIntPersonalDataStart + CharacterInfoQuestions.PERSONAL_DATA.getTotalQuestions();
    int lIntPhysionomyStart = lIntPersonalDataEnd;
    int lIntPhysionomyEnd = lIntPhysionomyStart + CharacterInfoQuestions.PHYSIONOMY.getTotalQuestions();
    int lIntPhychologyStart = lIntPhysionomyEnd;
    int lIntPhychologyEnd = lIntPhychologyStart + CharacterInfoQuestions.PSYCHOLOGY.getTotalQuestions();
    int lIntSociologyStart = lIntPhychologyEnd;
    int lIntSociologyEnd = lIntSociologyStart + CharacterInfoQuestions.SOCIOLOGY.getTotalQuestions();

    for (int i = 0; i < lListCharacterInfosMainCharacter1.size(); i++) {
        if (i >= lIntBehaviorsStart && i < lIntBehaviorsEnd) {
            Assert.assertEquals(new Integer(i + 1), lListCharacterInfosMainCharacter1.get(i).getQuestion());
            Assert.assertEquals(CharacterInfoQuestions.BEHAVIORS.name(),
                    lListCharacterInfosMainCharacter1.get(i).getCharacterInfoType());
            Assert.assertEquals("<p>Behaviors, attitudes " + (i + 1) + "</p>",
                    lListCharacterInfosMainCharacter1.get(i).getInfo());
        }

        else if (i >= lIntIdeasStart && i < lIntIdeasEnd) {
            Assert.assertEquals(new Integer(i + 1 - lIntIdeasStart),
                    lListCharacterInfosMainCharacter1.get(i).getQuestion());
            Assert.assertEquals(CharacterInfoQuestions.IDEAS.name(),
                    lListCharacterInfosMainCharacter1.get(i).getCharacterInfoType());
            Assert.assertEquals("<p>Ideas and passions " + (i + 1 - lIntIdeasStart) + "</p>",
                    lListCharacterInfosMainCharacter1.get(i).getInfo());
        }

        else if (i >= lIntPersonalDataStart && i < lIntPersonalDataEnd) {
            Assert.assertEquals(new Integer(i + 1 - lIntPersonalDataStart),
                    lListCharacterInfosMainCharacter1.get(i).getQuestion());
            Assert.assertEquals(CharacterInfoQuestions.PERSONAL_DATA.name(),
                    lListCharacterInfosMainCharacter1.get(i).getCharacterInfoType());
            Assert.assertEquals("<p>Personal data " + (i + 1 - lIntPersonalDataStart) + "</p>",
                    lListCharacterInfosMainCharacter1.get(i).getInfo());
        }

        else if (i >= lIntPhysionomyStart && i < lIntPhysionomyEnd) {
            Assert.assertEquals(new Integer(i + 1 - lIntPhysionomyStart),
                    lListCharacterInfosMainCharacter1.get(i).getQuestion());
            Assert.assertEquals(CharacterInfoQuestions.PHYSIONOMY.name(),
                    lListCharacterInfosMainCharacter1.get(i).getCharacterInfoType());
            Assert.assertEquals("<p>Physical features " + (i + 1 - lIntPhysionomyStart) + "</p>",
                    lListCharacterInfosMainCharacter1.get(i).getInfo());
        }

        else if (i >= lIntPhychologyStart && i < lIntPhychologyEnd) {
            Assert.assertEquals(new Integer(i + 1 - lIntPhychologyStart),
                    lListCharacterInfosMainCharacter1.get(i).getQuestion());
            Assert.assertEquals(CharacterInfoQuestions.PSYCHOLOGY.name(),
                    lListCharacterInfosMainCharacter1.get(i).getCharacterInfoType());
            Assert.assertEquals("<p>Psychology " + (i + 1 - lIntPhychologyStart) + "</p>",
                    lListCharacterInfosMainCharacter1.get(i).getInfo());
        }

        else if (i >= lIntSociologyStart && i < lIntSociologyEnd) {
            Assert.assertEquals(new Integer(i + 1 - lIntSociologyStart),
                    lListCharacterInfosMainCharacter1.get(i).getQuestion());
            Assert.assertEquals(CharacterInfoQuestions.SOCIOLOGY.name(),
                    lListCharacterInfosMainCharacter1.get(i).getCharacterInfoType());
            Assert.assertEquals("<p>Sociology " + (i + 1 - lIntSociologyStart) + "</p>",
                    lListCharacterInfosMainCharacter1.get(i).getInfo());
        }
    }

    for (int i = 0; i < lListCharacterInfosMainCharacter2.size(); i++) {
        if (i >= lIntBehaviorsStart && i < lIntBehaviorsEnd) {
            Assert.assertEquals(new Integer(i + 1), lListCharacterInfosMainCharacter2.get(i).getQuestion());
            Assert.assertEquals(CharacterInfoQuestions.BEHAVIORS.name(),
                    lListCharacterInfosMainCharacter2.get(i).getCharacterInfoType());
            Assert.assertNull(lListCharacterInfosMainCharacter2.get(i).getInfo());
        }

        else if (i >= lIntIdeasStart && i < lIntIdeasEnd) {
            Assert.assertEquals(new Integer(i + 1 - lIntIdeasStart),
                    lListCharacterInfosMainCharacter2.get(i).getQuestion());
            Assert.assertEquals(CharacterInfoQuestions.IDEAS.name(),
                    lListCharacterInfosMainCharacter2.get(i).getCharacterInfoType());
            Assert.assertNull(lListCharacterInfosMainCharacter2.get(i).getInfo());
        }

        else if (i >= lIntPersonalDataStart && i < lIntPersonalDataEnd) {
            Assert.assertEquals(new Integer(i + 1 - lIntPersonalDataStart),
                    lListCharacterInfosMainCharacter2.get(i).getQuestion());
            Assert.assertEquals(CharacterInfoQuestions.PERSONAL_DATA.name(),
                    lListCharacterInfosMainCharacter2.get(i).getCharacterInfoType());
            Assert.assertNull(lListCharacterInfosMainCharacter2.get(i).getInfo());
        }

        else if (i >= lIntPhysionomyStart && i < lIntPhysionomyEnd) {
            Assert.assertEquals(new Integer(i + 1 - lIntPhysionomyStart),
                    lListCharacterInfosMainCharacter2.get(i).getQuestion());
            Assert.assertEquals(CharacterInfoQuestions.PHYSIONOMY.name(),
                    lListCharacterInfosMainCharacter2.get(i).getCharacterInfoType());
            Assert.assertNull(lListCharacterInfosMainCharacter2.get(i).getInfo());
        }

        else if (i >= lIntPhychologyStart && i < lIntPhychologyEnd) {
            Assert.assertEquals(new Integer(i + 1 - lIntPhychologyStart),
                    lListCharacterInfosMainCharacter2.get(i).getQuestion());
            Assert.assertEquals(CharacterInfoQuestions.PSYCHOLOGY.name(),
                    lListCharacterInfosMainCharacter2.get(i).getCharacterInfoType());
            Assert.assertNull(lListCharacterInfosMainCharacter2.get(i).getInfo());
        }

        else if (i >= lIntSociologyStart && i < lIntSociologyEnd) {
            Assert.assertEquals(new Integer(i + 1 - lIntSociologyStart),
                    lListCharacterInfosMainCharacter2.get(i).getQuestion());
            Assert.assertEquals(CharacterInfoQuestions.SOCIOLOGY.name(),
                    lListCharacterInfosMainCharacter2.get(i).getCharacterInfoType());
            Assert.assertNull(lListCharacterInfosMainCharacter2.get(i).getInfo());
        }
    }

    for (int i = 0; i < lListCharacterInfosMainCharacter3.size(); i++) {
        if (i >= lIntBehaviorsStart && i < lIntBehaviorsEnd) {
            Assert.assertEquals(new Integer(i + 1), lListCharacterInfosMainCharacter3.get(i).getQuestion());
            Assert.assertEquals(CharacterInfoQuestions.BEHAVIORS.name(),
                    lListCharacterInfosMainCharacter3.get(i).getCharacterInfoType());
            Assert.assertNull(lListCharacterInfosMainCharacter3.get(i).getInfo());
        }

        else if (i >= lIntIdeasStart && i < lIntIdeasEnd) {
            Assert.assertEquals(new Integer(i + 1 - lIntIdeasStart),
                    lListCharacterInfosMainCharacter3.get(i).getQuestion());
            Assert.assertEquals(CharacterInfoQuestions.IDEAS.name(),
                    lListCharacterInfosMainCharacter3.get(i).getCharacterInfoType());
            Assert.assertNull(lListCharacterInfosMainCharacter3.get(i).getInfo());
        }

        else if (i >= lIntPersonalDataStart && i < lIntPersonalDataEnd) {
            Assert.assertEquals(new Integer(i + 1 - lIntPersonalDataStart),
                    lListCharacterInfosMainCharacter3.get(i).getQuestion());
            Assert.assertEquals(CharacterInfoQuestions.PERSONAL_DATA.name(),
                    lListCharacterInfosMainCharacter3.get(i).getCharacterInfoType());
            Assert.assertNull(lListCharacterInfosMainCharacter3.get(i).getInfo());
        }

        else if (i >= lIntPhysionomyStart && i < lIntPhysionomyEnd) {
            Assert.assertEquals(new Integer(i + 1 - lIntPhysionomyStart),
                    lListCharacterInfosMainCharacter3.get(i).getQuestion());
            Assert.assertEquals(CharacterInfoQuestions.PHYSIONOMY.name(),
                    lListCharacterInfosMainCharacter3.get(i).getCharacterInfoType());
            Assert.assertNull(lListCharacterInfosMainCharacter3.get(i).getInfo());
        }

        else if (i >= lIntPhychologyStart && i < lIntPhychologyEnd) {
            Assert.assertEquals(new Integer(i + 1 - lIntPhychologyStart),
                    lListCharacterInfosMainCharacter3.get(i).getQuestion());
            Assert.assertEquals(CharacterInfoQuestions.PSYCHOLOGY.name(),
                    lListCharacterInfosMainCharacter3.get(i).getCharacterInfoType());
            Assert.assertNull(lListCharacterInfosMainCharacter3.get(i).getInfo());
        }

        else if (i >= lIntSociologyStart && i < lIntSociologyEnd) {
            Assert.assertEquals(new Integer(i + 1 - lIntSociologyStart),
                    lListCharacterInfosMainCharacter3.get(i).getQuestion());
            Assert.assertEquals(CharacterInfoQuestions.SOCIOLOGY.name(),
                    lListCharacterInfosMainCharacter3.get(i).getCharacterInfoType());
            Assert.assertNull(lListCharacterInfosMainCharacter3.get(i).getInfo());
        }
    }
}

From source file:com.bibisco.test.ProjectManagerTest.java

License:GNU General Public License

public void checkTestProjectDBProject() throws IOException, ParseException {

    SqlSessionFactory lSqlSessionFactory = AllTests.getBibiscoSqlSessionFactory();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    Projects lProjects;// ww w .  j  a  va2  s.  c om
    try {
        ProjectsMapper lProjectMapper = lSqlSession.getMapper(ProjectsMapper.class);
        lProjects = lProjectMapper.selectByPrimaryKey(AllTests.TEST_PROJECT_ID);
    } finally {
        lSqlSession.close();
    }
    Assert.assertNotNull(lProjects);
    Assert.assertEquals(AllTests.TEST_PROJECT_ID, lProjects.getIdProject());
    Assert.assertEquals("Test", lProjects.getName());

    ProjectWithBLOBs lProject;

    lSqlSessionFactory = AllTests.getProjectSqlSessionFactoryById(AllTests.TEST_PROJECT_ID);
    lSqlSession = lSqlSessionFactory.openSession();
    try {
        ProjectMapper lProjectMapper = lSqlSession.getMapper(ProjectMapper.class);
        lProject = lProjectMapper.selectByPrimaryKey(AllTests.TEST_PROJECT_ID);

    } finally {
        lSqlSession.close();
    }

    // PROJECT

    Assert.assertEquals(AllTests.TEST_PROJECT_ID, lProject.getIdProject());
    Assert.assertEquals(TaskStatus.TODO.getValue(), lProject.getFabulaTaskStatus());
    Assert.assertEquals("1.4.2", lProject.getBibiscoVersion());
    Assert.assertEquals("en_US", lProject.getLanguage());
    Assert.assertEquals("Test", lProject.getName());
    Assert.assertEquals(TaskStatus.TODO.getValue(), lProject.getStrandTaskStatus());
    Assert.assertEquals("<p>Fabula</p>", lProject.getFabula());
    Assert.assertEquals(TaskStatus.TODO.getValue(), lProject.getFabulaTaskStatus());
    Assert.assertEquals("<p>Premise</p>", lProject.getPremise());
    Assert.assertEquals(TaskStatus.TODO.getValue(), lProject.getPremiseTaskStatus());
    Assert.assertEquals("<p>Setting</p>", lProject.getSetting());
    Assert.assertEquals(TaskStatus.TODO.getValue(), lProject.getSettingTaskStatus());
}

From source file:com.bibisco.test.PropertiesManagerTest.java

License:GNU General Public License

@Test
public void testUpdateProperty() throws ConfigurationException, IOException {

    PropertiesManager.getInstance().updateProperty("projectsDirectory", "C:\\Users\\AndreaDocuments\\");

    SqlSessionFactory lSqlSessionFactory = AllTests.getBibiscoSqlSessionFactory();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    Properties lProperties;/*from  ww w. j  a  v  a2s.c  o m*/
    try {
        PropertiesMapper lPropertiesMapper = lSqlSession.getMapper(PropertiesMapper.class);
        lProperties = lPropertiesMapper.selectByPrimaryKey("projectsDirectory");
    } finally {
        lSqlSession.close();
    }

    Assert.assertEquals(lProperties.getValue(), "C:\\Users\\AndreaDocuments\\");
}

From source file:com.bibisco.test.PropertiesManagerTest.java

License:GNU General Public License

@Before
@After// w ww. j av a2s.c  o  m
public void init() {

    SqlSessionFactory lSqlSessionFactory = AllTests.getBibiscoSqlSessionFactory();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {
        PropertiesMapper lPropertiesMapper = lSqlSession.getMapper(PropertiesMapper.class);

        Properties lProperties = new Properties();
        lProperties.setProperty("projectsDirectory");
        lProperties.setValue("");
        lPropertiesMapper.updateByPrimaryKey(lProperties);

        lProperties = new Properties();
        lProperties.setProperty("socialMediaTip");
        lProperties.setValue("true");
        lPropertiesMapper.updateByPrimaryKey(lProperties);

        lProperties = new Properties();
        lProperties.setProperty("locationsdndTip");
        lProperties.setValue("true");
        lPropertiesMapper.updateByPrimaryKey(lProperties);

        lSqlSession.commit();
    } catch (Throwable t) {
        lSqlSession.rollback();
    } finally {
        lSqlSession.close();
    }

    PropertiesManager.getInstance().reload();
}

From source file:com.bibisco.test.PropertiesManagerTest.java

License:GNU General Public License

@Test
public void testUpdateProperties() throws ConfigurationException, IOException {

    Map<String, String> lMapProperties = new HashMap<String, String>();
    lMapProperties.put("socialMediaTip", "false");
    lMapProperties.put("locationsdndTip", "false");
    PropertiesManager.getInstance().updateProperties(lMapProperties);

    SqlSessionFactory lSqlSessionFactory = AllTests.getBibiscoSqlSessionFactory();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    Properties lProperties;//from   w  w w  .j a  va 2  s  . c  o m
    try {
        PropertiesMapper lPropertiesMapper = lSqlSession.getMapper(PropertiesMapper.class);
        lProperties = lPropertiesMapper.selectByPrimaryKey("socialMediaTip");
    } finally {
        lSqlSession.close();
    }
    Assert.assertEquals(lProperties.getValue(), "false");

    lSqlSession = lSqlSessionFactory.openSession();
    try {
        PropertiesMapper lPropertiesMapper = lSqlSession.getMapper(PropertiesMapper.class);
        lProperties = lPropertiesMapper.selectByPrimaryKey("locationsdndTip");
    } finally {
        lSqlSession.close();
    }
    Assert.assertEquals(lProperties.getValue(), "false");
}

From source file:com.bibisco.test.RichTextEditorSettingsManagerTest.java

License:GNU General Public License

@Test
public void testSaveSettings() {

    RichTextEditorSettings lRichTextEditorSettings = new RichTextEditorSettings();
    lRichTextEditorSettings.setFont("arial");
    lRichTextEditorSettings.setSize("small");
    lRichTextEditorSettings.setIndentParagraphEnabled(false);
    lRichTextEditorSettings.setSpellCheckEnabled(false);
    lRichTextEditorSettings.setAutoSaveEnabled(false);
    RichTextEditorSettingsManager.save(lRichTextEditorSettings);

    SqlSessionFactory lSqlSessionFactory = AllTests.getBibiscoSqlSessionFactory();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    Properties lProperties;/*  w w  w .ja va 2 s  . com*/
    String lStrFont;
    String lStrFontSize;
    String lStrIndentParagraphEnabled;
    String lStrSpellCheckEnabled;
    String lStrAutoSaveEnabled;
    try {
        PropertiesMapper lPropertiesMapper = lSqlSession.getMapper(PropertiesMapper.class);
        lProperties = lPropertiesMapper.selectByPrimaryKey("font");
        lStrFont = lProperties.getValue();
        lProperties = lPropertiesMapper.selectByPrimaryKey("font-size");
        lStrFontSize = lProperties.getValue();
        lProperties = lPropertiesMapper.selectByPrimaryKey("indentParagraphEnabled");
        lStrIndentParagraphEnabled = lProperties.getValue();
        lProperties = lPropertiesMapper.selectByPrimaryKey("spellCheckEnabled");
        lStrSpellCheckEnabled = lProperties.getValue();
        lProperties = lPropertiesMapper.selectByPrimaryKey("autoSaveEnabled");
        lStrAutoSaveEnabled = lProperties.getValue();
    } finally {
        lSqlSession.close();
    }

    Assert.assertEquals(lStrFont, "arial");
    Assert.assertEquals(lStrFontSize, "small");
    Assert.assertEquals(lStrIndentParagraphEnabled, "false");
    Assert.assertEquals(lStrSpellCheckEnabled, "false");
    Assert.assertEquals(lStrAutoSaveEnabled, "false");
}

From source file:com.bibisco.test.RichTextEditorSettingsManagerTest.java

License:GNU General Public License

@Before
@After/*from ww w .  j a va 2  s. c om*/
public void init() {

    SqlSessionFactory lSqlSessionFactory = AllTests.getBibiscoSqlSessionFactory();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {
        PropertiesMapper lPropertiesMapper = lSqlSession.getMapper(PropertiesMapper.class);

        Properties lProperties = new Properties();
        lProperties.setProperty("font");
        lProperties.setValue("courier");
        lPropertiesMapper.updateByPrimaryKey(lProperties);

        lProperties = new Properties();
        lProperties.setProperty("font-size");
        lProperties.setValue("medium");
        lPropertiesMapper.updateByPrimaryKey(lProperties);

        lProperties = new Properties();
        lProperties.setProperty("indentParagraphEnabled");
        lProperties.setValue("true");
        lPropertiesMapper.updateByPrimaryKey(lProperties);

        lProperties = new Properties();
        lProperties.setProperty("spellCheckEnabled");
        lProperties.setValue("true");
        lPropertiesMapper.updateByPrimaryKey(lProperties);

        lProperties = new Properties();
        lProperties.setProperty("autoSaveEnabled");
        lProperties.setValue("true");
        lPropertiesMapper.updateByPrimaryKey(lProperties);

        lSqlSession.commit();
    } catch (Throwable t) {
        lSqlSession.rollback();
    } finally {
        lSqlSession.close();
    }

    PropertiesManager.getInstance().reload();
}

From source file:com.bibisco.test.RichTextEditorSettingsManagerTest.java

License:GNU General Public License

@Test
public void testSaveSettingsWithoutIndentParagraphEnabled() {
    RichTextEditorSettings lRichTextEditorSettings = new RichTextEditorSettings();
    lRichTextEditorSettings.setFont("arial");
    lRichTextEditorSettings.setSize("small");
    lRichTextEditorSettings.setIndentParagraphEnabled(false);
    lRichTextEditorSettings.setSpellCheckEnabled(true);
    lRichTextEditorSettings.setAutoSaveEnabled(true);
    RichTextEditorSettingsManager.save(lRichTextEditorSettings);

    SqlSessionFactory lSqlSessionFactory = AllTests.getBibiscoSqlSessionFactory();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    Properties lProperties;/*from ww  w. jav  a  2s  . c o  m*/
    String lStrIndentParagraphEnabled;
    try {
        PropertiesMapper lPropertiesMapper = lSqlSession.getMapper(PropertiesMapper.class);
        lProperties = lPropertiesMapper.selectByPrimaryKey("indentParagraphEnabled");
        lStrIndentParagraphEnabled = lProperties.getValue();
    } finally {
        lSqlSession.close();
    }

    Assert.assertEquals(lStrIndentParagraphEnabled, "false");
}

From source file:com.bibisco.test.RichTextEditorSettingsManagerTest.java

License:GNU General Public License

@Test
public void testSaveSettingsWithoutSpellCheckEnabled() {
    RichTextEditorSettings lRichTextEditorSettings = new RichTextEditorSettings();
    lRichTextEditorSettings.setFont("arial");
    lRichTextEditorSettings.setSize("small");
    lRichTextEditorSettings.setIndentParagraphEnabled(true);
    lRichTextEditorSettings.setSpellCheckEnabled(false);
    lRichTextEditorSettings.setAutoSaveEnabled(true);
    RichTextEditorSettingsManager.save(lRichTextEditorSettings);

    SqlSessionFactory lSqlSessionFactory = AllTests.getBibiscoSqlSessionFactory();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    Properties lProperties;//from w w w .  jav  a 2s .c  om
    String lStrSpellCheckEnabled;
    try {
        PropertiesMapper lPropertiesMapper = lSqlSession.getMapper(PropertiesMapper.class);
        lProperties = lPropertiesMapper.selectByPrimaryKey("spellCheckEnabled");
        lStrSpellCheckEnabled = lProperties.getValue();
    } finally {
        lSqlSession.close();
    }

    Assert.assertEquals(lStrSpellCheckEnabled, "false");
}