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

@Test
public void testInsertProject() throws IOException {
    ProjectDTO lProjectDTO = new ProjectDTO();
    lProjectDTO.setName("Test Insert");
    lProjectDTO.setLanguage(LocaleManager.getInstance().getLocale().getLanguage());
    lProjectDTO.setBibiscoVersion(VersionManager.getInstance().getVersion());
    lProjectDTO = ProjectManager.insert(lProjectDTO);

    Assert.assertNotNull(lProjectDTO.getIdProject());
    Assert.assertEquals(lProjectDTO.getName(), "Test Insert");
    Assert.assertEquals(lProjectDTO.getLanguage(), LocaleManager.getInstance().getLocale().getLanguage());
    Assert.assertEquals(lProjectDTO.getBibiscoVersion(), VersionManager.getInstance().getVersion());
    Assert.assertNotNull(lProjectDTO.getArchitecture());
    Assert.assertEquals(lProjectDTO.getArchitecture().getPremiseTaskStatus(), TaskStatus.TODO);
    Assert.assertEquals(lProjectDTO.getArchitecture().getFabulaTaskStatus(), TaskStatus.TODO);
    Assert.assertEquals(lProjectDTO.getArchitecture().getSettingTaskStatus(), TaskStatus.TODO);
    Assert.assertNull(lProjectDTO.getArchitecture().getStrandList());
    Assert.assertNull(lProjectDTO.getChapterList());
    Assert.assertNull(lProjectDTO.getLocationList());
    Assert.assertNull(lProjectDTO.getMainCharacterList());
    Assert.assertNull(lProjectDTO.getSecondaryCharacterList());

    SqlSessionFactory lSqlSessionFactory = AllTests.getProjectSqlSessionFactoryById(lProjectDTO.getIdProject());
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    List<Project> lListProject;
    try {/*from   ww w.  j  a  v  a  2s  . co  m*/
        ProjectMapper lProjectMapper = lSqlSession.getMapper(ProjectMapper.class);
        ProjectExample lProjectExample = new ProjectExample();
        lProjectExample.createCriteria().andNameEqualTo("Test Insert")
                .andLanguageEqualTo(LocaleManager.getInstance().getLocale().getLanguage())
                .andBibiscoVersionEqualTo(VersionManager.getInstance().getVersion());
        lListProject = lProjectMapper.selectByExample(lProjectExample);
    } finally {
        lSqlSession.close();
    }
    Assert.assertEquals(lListProject.size(), 1);

    lSqlSessionFactory = AllTests.getBibiscoSqlSessionFactory();
    lSqlSession = lSqlSessionFactory.openSession();
    List<Projects> lListProjects;
    try {
        ProjectsMapper lProjectsMapper = lSqlSession.getMapper(ProjectsMapper.class);
        ProjectsExample lProjectsExample = new ProjectsExample();
        lProjectsExample.createCriteria().andIdProjectEqualTo(lProjectDTO.getIdProject())
                .andNameEqualTo("Test Insert");
        lListProjects = lProjectsMapper.selectByExample(lProjectsExample);
    } finally {
        lSqlSession.close();
    }
    Assert.assertEquals(lListProjects.size(), 1);
}

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

License:GNU General Public License

@Test
public void testImportProjectsFromProjectsDirectory()
        throws ConfigurationException, IOException, ParseException {

    SqlSessionFactory lSqlSessionFactory = AllTests.getBibiscoSqlSessionFactory();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {//from   w  ww .  j av  a 2 s.c o m
        ProjectsMapper lProjectMapper = lSqlSession.getMapper(ProjectsMapper.class);
        lProjectMapper.deleteByExample(new ProjectsExample());
        lSqlSession.commit();
    } finally {
        lSqlSession.close();
    }

    int lIntResult = ProjectManager.importProjectsFromProjectsDirectory();
    Assert.assertEquals(3, lIntResult);

    List<Projects> lListProjects;
    lSqlSession = lSqlSessionFactory.openSession();
    try {
        ProjectsMapper lProjectMapper = lSqlSession.getMapper(ProjectsMapper.class);
        ProjectsExample lProjectsExample = new ProjectsExample();
        lProjectsExample.setOrderByClause("id_project");
        lListProjects = lProjectMapper.selectByExample(lProjectsExample);
    } finally {
        lSqlSession.close();
    }

    Assert.assertEquals(AllTests.TEST_PROJECT_ID, lListProjects.get(0).getIdProject());
    Assert.assertEquals(AllTests.TEST_PROJECT2_ID, lListProjects.get(1).getIdProject());
    Assert.assertEquals(AllTests.TEST_PROJECT3_ID, lListProjects.get(2).getIdProject());

    checkTestProjectDB();

    Project lProject;
    lSqlSessionFactory = AllTests.getProjectSqlSessionFactoryById(AllTests.TEST_PROJECT2_ID);
    lSqlSession = lSqlSessionFactory.openSession();
    try {
        ProjectMapper lProjectMapper = lSqlSession.getMapper(ProjectMapper.class);
        lProject = lProjectMapper.selectByPrimaryKey(AllTests.TEST_PROJECT2_ID);
    } finally {
        lSqlSession.close();
    }
    Assert.assertEquals(AllTests.TEST_PROJECT2_ID, lProject.getIdProject());
    Assert.assertEquals(TaskStatus.TODO.getValue(), lProject.getFabulaTaskStatus());
    Assert.assertEquals("1.5.1", lProject.getBibiscoVersion());
    Assert.assertEquals("en_US", lProject.getLanguage());
    Assert.assertEquals("Test 2", lProject.getName());
    Assert.assertEquals(TaskStatus.TODO.getValue(), lProject.getPremiseTaskStatus());
    Assert.assertEquals(TaskStatus.TODO.getValue(), lProject.getSettingTaskStatus());
    Assert.assertEquals(TaskStatus.TODO.getValue(), lProject.getStrandTaskStatus());

    lSqlSessionFactory = AllTests.getProjectSqlSessionFactoryById(AllTests.TEST_PROJECT3_ID);
    lSqlSession = lSqlSessionFactory.openSession();
    try {
        ProjectMapper lProjectMapper = lSqlSession.getMapper(ProjectMapper.class);
        lProject = lProjectMapper.selectByPrimaryKey(AllTests.TEST_PROJECT3_ID);
    } finally {
        lSqlSession.close();
    }
    Assert.assertEquals(AllTests.TEST_PROJECT3_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 3       $ ! /", lProject.getName());
    Assert.assertEquals(TaskStatus.TODO.getValue(), lProject.getPremiseTaskStatus());
    Assert.assertEquals(TaskStatus.TODO.getValue(), lProject.getSettingTaskStatus());
    Assert.assertEquals(TaskStatus.TODO.getValue(), lProject.getStrandTaskStatus());

}

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

License:GNU General Public License

public void emptyProjectsDirectory() {

    SqlSessionFactory lSqlSessionFactory = AllTests.getBibiscoSqlSessionFactory();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {/*from w ww. ja v  a 2s .c o m*/
        PropertiesMapper lPropertiesMapper = lSqlSession.getMapper(PropertiesMapper.class);

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

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

    PropertiesManager.getInstance().reload();
}

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

License:GNU General Public License

@Test
public void testLoadAllWithNoProjects() {

    SqlSessionFactory lSqlSessionFactory = AllTests.getBibiscoSqlSessionFactory();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {/*from  www. j  ava2 s  .c  o m*/
        ProjectsMapper lProjectMapper = lSqlSession.getMapper(ProjectsMapper.class);
        lProjectMapper.deleteByExample(new ProjectsExample());
        lSqlSession.commit();
    } finally {
        lSqlSession.close();
    }

    List<ProjectDTO> lListProjectDTOs = ProjectManager.loadAll();
    checkTestProjectsDB(lListProjectDTOs);
}

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

License:GNU General Public License

@Test
public void testDeleteProject() throws ConfigurationException, IOException, SQLException {

    File lFile = new File(AllTests.BIBISCO_INTERNAL_PROJECTS_DIR + System.getProperty("file.separator")
            + AllTests.TEST_PROJECT3_ID);
    Assert.assertTrue(lFile.exists());//from w ww . jav  a 2  s.c  om

    ProjectManager.delete(AllTests.TEST_PROJECT3_ID);

    SqlSessionFactory lSqlSessionFactory = AllTests.getBibiscoSqlSessionFactory();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    Projects lProjects;
    try {
        ProjectsMapper lProjectMapper = lSqlSession.getMapper(ProjectsMapper.class);
        lProjects = lProjectMapper.selectByPrimaryKey(AllTests.TEST_PROJECT3_ID);
    } finally {
        lSqlSession.close();
    }
    Assert.assertNull(lProjects);
    Assert.assertFalse(lFile.exists());
}

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

License:GNU General Public License

@Test
public void testImportProjectWithNonExistingProject() throws IOException {

    FileUtils.copyDirectoryToDirectory(new File(AllTests.getTestProject4DBFilePath()),
            new File(AllTests.getTempPath()));

    ImportProjectArchiveDTO lImportProjectArchiveDTO = new ImportProjectArchiveDTO();
    lImportProjectArchiveDTO.setIdProject(AllTests.TEST_PROJECT4_ID);
    lImportProjectArchiveDTO.setProjectName("Test 4");
    lImportProjectArchiveDTO.setArchiveFileValid(true);
    lImportProjectArchiveDTO.setAlreadyPresent(false);
    ProjectManager.importProject(lImportProjectArchiveDTO);

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

    ProjectWithBLOBs lProject;
    List<ChaptersWithBLOBs> lListChapters;
    List<CharactersWithBLOBs> lListMainCharacters;
    List<CharactersWithBLOBs> lListSecondaryCharacters;
    List<CharacterInfos> lListCharacterInfos;
    List<Locations> lListLocations;
    List<Scenes> lListScenes;
    List<SceneRevisions> lListSceneRevisions;
    List<SceneRevisionCharactersKey> lListRevisionCharactersKeys;
    List<SceneRevisionStrandsKey> lListRevisionStrandsKeys;
    List<Strands> lListStrands;

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

        ChaptersMapper lChaptersMapper = lSqlSession.getMapper(ChaptersMapper.class);
        ChaptersExample lChaptersExample = new ChaptersExample();
        lChaptersExample.setOrderByClause("position");
        lListChapters = lChaptersMapper.selectByExampleWithBLOBs(lChaptersExample);

        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);
        lListCharacterInfos = lCharacterInfosMapper.selectByExampleWithBLOBs(new CharacterInfosExample());

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

        ScenesMapper lScenesMapper = lSqlSession.getMapper(ScenesMapper.class);
        ScenesExample lScenesExample = new ScenesExample();
        lScenesExample.setOrderByClause("position");
        lListScenes = lScenesMapper.selectByExample(lScenesExample);

        SceneRevisionsMapper lSceneRevisionsMapper = lSqlSession.getMapper(SceneRevisionsMapper.class);
        SceneRevisionsExample lSceneRevisionsExample = new SceneRevisionsExample();
        lSceneRevisionsExample.setOrderByClause("id_scene, revision_number");
        lListSceneRevisions = lSceneRevisionsMapper.selectByExampleWithBLOBs(lSceneRevisionsExample);

        SceneRevisionCharactersMapper lSceneRevisionCharactersMapper = lSqlSession
                .getMapper(SceneRevisionCharactersMapper.class);
        SceneRevisionCharactersExample lSceneRevisionCharactersExample = new SceneRevisionCharactersExample();
        lSceneRevisionCharactersExample.setOrderByClause("id_scene_revision, id_character");
        lListRevisionCharactersKeys = lSceneRevisionCharactersMapper
                .selectByExample(lSceneRevisionCharactersExample);

        SceneRevisionStrandsMapper lSceneRevisionStrandsMapper = lSqlSession
                .getMapper(SceneRevisionStrandsMapper.class);
        SceneRevisionStrandsExample lSceneRevisionStrandsExample = new SceneRevisionStrandsExample();
        lSceneRevisionStrandsExample.setOrderByClause("id_scene_revision, id_strand");
        lListRevisionStrandsKeys = lSceneRevisionStrandsMapper.selectByExample(lSceneRevisionStrandsExample);

        StrandsMapper lStrandsMapper = lSqlSession.getMapper(StrandsMapper.class);
        StrandsExample lStrandsExample = new StrandsExample();
        lStrandsExample.setOrderByClause("id_strand");
        lListStrands = lStrandsMapper.selectByExampleWithBLOBs(lStrandsExample);

    } finally {
        lSqlSession.close();
    }

    Assert.assertEquals(AllTests.TEST_PROJECT4_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 4", lProject.getName());
    Assert.assertEquals(TaskStatus.TODO.getValue(), lProject.getPremiseTaskStatus());
    Assert.assertEquals(TaskStatus.TODO.getValue(), lProject.getSettingTaskStatus());
    Assert.assertEquals(TaskStatus.TODO.getValue(), lProject.getStrandTaskStatus());

    Assert.assertEquals(0, lListChapters.size());
    Assert.assertEquals(0, lListMainCharacters.size());
    Assert.assertEquals(0, lListSecondaryCharacters.size());
    Assert.assertEquals(0, lListCharacterInfos.size());
    Assert.assertEquals(0, lListLocations.size());
    Assert.assertEquals(0, lListScenes.size());
    Assert.assertEquals(0, lListSceneRevisions.size());
    Assert.assertEquals(0, lListRevisionCharactersKeys.size());
    Assert.assertEquals(0, lListRevisionStrandsKeys.size());
    Assert.assertEquals(0, lListStrands.size());
}

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

License:GNU General Public License

@Test
public void testSave() throws IOException, ParseException, ConfigurationException, InterruptedException {

    ContextManager.getInstance().setIdProject(AllTests.TEST_PROJECT_ID);

    ProjectDTO lProjectDTO = new ProjectDTO();
    lProjectDTO.setIdProject(AllTests.TEST_PROJECT_ID);
    lProjectDTO.setName("Test name updated");

    lProjectDTO.setArchitecture(new ArchitectureDTO());
    lProjectDTO.setBibiscoVersion("X.X.X");
    lProjectDTO.setChapterList(new ArrayList<ChapterDTO>());
    lProjectDTO.setLanguage("xx_XX");
    lProjectDTO.setLocationList(new ArrayList<LocationDTO>());
    lProjectDTO.setMainCharacterList(new ArrayList<CharacterDTO>());
    lProjectDTO.setSecondaryCharacterList(new ArrayList<CharacterDTO>());

    ProjectManager.save(lProjectDTO);/* w  ww  . j  ava2 s.  co  m*/

    SqlSessionFactory lSqlSessionFactory = AllTests.getBibiscoSqlSessionFactory();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    Projects lProjects;
    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 name updated", 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 name updated", 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());

    checkTestProjectDBChapters();
    checkTestProjectDBStrands();
    checkTestProjectDBLocations();
    checkTestProjectDBCharacters();
}

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

License:GNU General Public License

@Test
public void testDeleteProjectsEntriesOnBibiscoDB() {
    Assert.assertEquals(3, ProjectManager.deleteProjectsEntriesOnBibiscoDB());

    List<Projects> lListProjects;
    SqlSessionFactory lSqlSessionFactory = AllTests.getBibiscoSqlSessionFactory();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {//from   ww w.j  a  v a2  s.  co  m
        ProjectsMapper lProjectMapper = lSqlSession.getMapper(ProjectsMapper.class);
        ProjectsExample lProjectsExample = new ProjectsExample();
        lListProjects = lProjectMapper.selectByExample(lProjectsExample);
    } finally {
        lSqlSession.close();
    }

    Assert.assertEquals(0, lListProjects.size());
}

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

License:GNU General Public License

public void checkTestProjectDBChapters() throws IOException, ParseException {

    List<ChaptersWithBLOBs> lListChapters;
    List<Scenes> lListScenes;
    List<SceneRevisions> lListSceneRevisions;
    List<SceneRevisionCharactersKey> lListRevisionCharactersKeys;
    List<SceneRevisionStrandsKey> lListRevisionStrandsKeys;

    SqlSessionFactory lSqlSessionFactory = AllTests.getProjectSqlSessionFactoryById(AllTests.TEST_PROJECT_ID);
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {/*from   w w w  .  j  a  v  a 2s .co  m*/
        ChaptersMapper lChaptersMapper = lSqlSession.getMapper(ChaptersMapper.class);
        ChaptersExample lChaptersExample = new ChaptersExample();
        lChaptersExample.setOrderByClause("position");
        lListChapters = lChaptersMapper.selectByExampleWithBLOBs(lChaptersExample);
        ScenesMapper lScenesMapper = lSqlSession.getMapper(ScenesMapper.class);
        ScenesExample lScenesExample = new ScenesExample();
        lScenesExample.setOrderByClause("position");
        lListScenes = lScenesMapper.selectByExample(lScenesExample);

        SceneRevisionsMapper lSceneRevisionsMapper = lSqlSession.getMapper(SceneRevisionsMapper.class);
        SceneRevisionsExample lSceneRevisionsExample = new SceneRevisionsExample();
        lSceneRevisionsExample.setOrderByClause("id_scene, revision_number");
        lListSceneRevisions = lSceneRevisionsMapper.selectByExampleWithBLOBs(lSceneRevisionsExample);

        SceneRevisionCharactersMapper lSceneRevisionCharactersMapper = lSqlSession
                .getMapper(SceneRevisionCharactersMapper.class);
        SceneRevisionCharactersExample lSceneRevisionCharactersExample = new SceneRevisionCharactersExample();
        lSceneRevisionCharactersExample.setOrderByClause("id_scene_revision, id_character");
        lListRevisionCharactersKeys = lSceneRevisionCharactersMapper
                .selectByExample(lSceneRevisionCharactersExample);

        SceneRevisionStrandsMapper lSceneRevisionStrandsMapper = lSqlSession
                .getMapper(SceneRevisionStrandsMapper.class);
        SceneRevisionStrandsExample lSceneRevisionStrandsExample = new SceneRevisionStrandsExample();
        lSceneRevisionStrandsExample.setOrderByClause("id_scene_revision, id_strand");
        lListRevisionStrandsKeys = lSceneRevisionStrandsMapper.selectByExample(lSceneRevisionStrandsExample);

    } finally {
        lSqlSession.close();
    }

    // CHAPTERS

    Assert.assertEquals(new Long(1), lListChapters.get(0).getIdChapter());
    Assert.assertEquals("<p>Notes 1</p>", lListChapters.get(0).getNote());
    Assert.assertEquals(new Integer(1), lListChapters.get(0).getPosition());
    Assert.assertEquals("<p>Reason 1</p>", lListChapters.get(0).getReason());
    Assert.assertEquals(new Integer(0), lListChapters.get(0).getReasonTaskStatus());
    Assert.assertEquals("Chapter 1", lListChapters.get(0).getTitle());

    Assert.assertEquals(new Long(2), lListChapters.get(1).getIdChapter());
    Assert.assertEquals("<p>Notes 2</p>", lListChapters.get(1).getNote());
    Assert.assertEquals(new Integer(2), lListChapters.get(1).getPosition());
    Assert.assertEquals("<p>Reason 2</p>", lListChapters.get(1).getReason());
    Assert.assertEquals(new Integer(1), lListChapters.get(1).getReasonTaskStatus());
    Assert.assertEquals("Chapter 2", lListChapters.get(1).getTitle());

    Assert.assertEquals(new Long(3), lListChapters.get(2).getIdChapter());
    Assert.assertEquals("<p>Notes 3</p>", lListChapters.get(2).getNote());
    Assert.assertEquals(new Integer(3), lListChapters.get(2).getPosition());
    Assert.assertEquals("<p>Reason 3</p>", lListChapters.get(2).getReason());
    Assert.assertEquals(new Integer(2), lListChapters.get(2).getReasonTaskStatus());
    Assert.assertEquals("Chapter 3", lListChapters.get(2).getTitle());

    // SCENES

    Assert.assertEquals("Scene 1.1", lListScenes.get(0).getDescription());
    Assert.assertEquals(new Integer(1), lListScenes.get(0).getIdChapter());
    Assert.assertEquals(new Long(10), lListScenes.get(0).getIdScene());
    Assert.assertEquals(new Integer(1), lListScenes.get(0).getPosition());
    Assert.assertEquals(new Integer(0), lListScenes.get(0).getTaskStatus());

    Assert.assertEquals("Scene 1.2", lListScenes.get(1).getDescription());
    Assert.assertEquals(new Integer(1), lListScenes.get(1).getIdChapter());
    Assert.assertEquals(new Long(11), lListScenes.get(1).getIdScene());
    Assert.assertEquals(new Integer(2), lListScenes.get(1).getPosition());
    Assert.assertEquals(new Integer(1), lListScenes.get(1).getTaskStatus());

    Assert.assertEquals("Scene 1.3", lListScenes.get(2).getDescription());
    Assert.assertEquals(new Integer(1), lListScenes.get(2).getIdChapter());
    Assert.assertEquals(new Long(12), lListScenes.get(2).getIdScene());
    Assert.assertEquals(new Integer(3), lListScenes.get(2).getPosition());
    Assert.assertEquals(new Integer(2), lListScenes.get(2).getTaskStatus());

    // SCENE REVISIONS

    SimpleDateFormat lSimpleDateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.S");

    Assert.assertEquals(new Integer(20), lListSceneRevisions.get(0).getCharacters());
    Assert.assertEquals(new Integer(71), lListSceneRevisions.get(0).getIdLocation());
    Assert.assertEquals(new Integer(10), lListSceneRevisions.get(0).getIdScene());
    Assert.assertEquals(new Long(1), lListSceneRevisions.get(0).getIdSceneRevision());
    Assert.assertEquals(new Integer(0), lListSceneRevisions.get(0).getPointOfView());
    Assert.assertEquals(new Integer(67), lListSceneRevisions.get(0).getPointOfViewIdCharacter());
    Assert.assertEquals(new Integer(1), lListSceneRevisions.get(0).getRevisionNumber());
    Assert.assertEquals("<p>Scene 1.1 Revision 1</p>", lListSceneRevisions.get(0).getScene());
    Assert.assertEquals(lSimpleDateFormat.parse("1975-04-23 22:14:00.0"),
            lListSceneRevisions.get(0).getSceneDate());
    Assert.assertEquals("Y", lListSceneRevisions.get(0).getSelected());
    Assert.assertNull(lListSceneRevisions.get(0).getTense());
    Assert.assertEquals(new Integer(3), lListSceneRevisions.get(0).getWords());

    Assert.assertEquals(new Integer(20), lListSceneRevisions.get(1).getCharacters());
    Assert.assertEquals(new Integer(72), lListSceneRevisions.get(1).getIdLocation());
    Assert.assertEquals(new Integer(11), lListSceneRevisions.get(1).getIdScene());
    Assert.assertEquals(new Long(2), lListSceneRevisions.get(1).getIdSceneRevision());
    Assert.assertEquals(new Integer(1), lListSceneRevisions.get(1).getPointOfView());
    Assert.assertEquals(new Integer(68), lListSceneRevisions.get(1).getPointOfViewIdCharacter());
    Assert.assertEquals(new Integer(1), lListSceneRevisions.get(1).getRevisionNumber());
    Assert.assertEquals("<p>Scene 1.2 Revision 1</p>", lListSceneRevisions.get(1).getScene());
    Assert.assertEquals(lSimpleDateFormat.parse("1976-10-22 14:25:00.0"),
            lListSceneRevisions.get(1).getSceneDate());
    Assert.assertEquals("N", lListSceneRevisions.get(1).getSelected());
    Assert.assertNull(lListSceneRevisions.get(1).getTense());
    Assert.assertEquals(new Integer(5), lListSceneRevisions.get(1).getWords());

    Assert.assertEquals(new Integer(20), lListSceneRevisions.get(2).getCharacters());
    Assert.assertEquals(new Integer(72), lListSceneRevisions.get(2).getIdLocation());
    Assert.assertEquals(new Integer(11), lListSceneRevisions.get(2).getIdScene());
    Assert.assertEquals(new Long(4), lListSceneRevisions.get(2).getIdSceneRevision());
    Assert.assertEquals(new Integer(1), lListSceneRevisions.get(2).getPointOfView());
    Assert.assertEquals(new Integer(68), lListSceneRevisions.get(2).getPointOfViewIdCharacter());
    Assert.assertEquals(new Integer(2), lListSceneRevisions.get(2).getRevisionNumber());
    Assert.assertEquals("<p>Scene 1.2 Revision 2</p>", lListSceneRevisions.get(2).getScene());
    Assert.assertEquals(lSimpleDateFormat.parse("1976-10-22 14:25:00.0"),
            lListSceneRevisions.get(2).getSceneDate());
    Assert.assertEquals("Y", lListSceneRevisions.get(2).getSelected());
    Assert.assertNull(lListSceneRevisions.get(2).getTense());
    Assert.assertEquals(new Integer(5), lListSceneRevisions.get(2).getWords());

    Assert.assertEquals(new Integer(20), lListSceneRevisions.get(3).getCharacters());
    Assert.assertNull(lListSceneRevisions.get(3).getIdLocation());
    Assert.assertEquals(new Integer(12), lListSceneRevisions.get(3).getIdScene());
    Assert.assertEquals(new Long(3), lListSceneRevisions.get(3).getIdSceneRevision());
    Assert.assertNull(lListSceneRevisions.get(3).getPointOfView());
    Assert.assertNull(lListSceneRevisions.get(3).getPointOfViewIdCharacter());
    Assert.assertEquals(new Integer(1), lListSceneRevisions.get(3).getRevisionNumber());
    Assert.assertEquals("<p>Scene 1.3 Revision 1</p>", lListSceneRevisions.get(3).getScene());
    Assert.assertNull(lListSceneRevisions.get(3).getSceneDate());
    Assert.assertEquals("N", lListSceneRevisions.get(3).getSelected());
    Assert.assertNull(lListSceneRevisions.get(3).getTense());
    Assert.assertEquals(new Integer(5), lListSceneRevisions.get(3).getWords());

    Assert.assertEquals(new Integer(20), lListSceneRevisions.get(4).getCharacters());
    Assert.assertNull(lListSceneRevisions.get(4).getIdLocation());
    Assert.assertEquals(new Integer(12), lListSceneRevisions.get(4).getIdScene());
    Assert.assertEquals(new Long(5), lListSceneRevisions.get(4).getIdSceneRevision());
    Assert.assertNull(lListSceneRevisions.get(4).getPointOfView());
    Assert.assertNull(lListSceneRevisions.get(4).getPointOfViewIdCharacter());
    Assert.assertEquals(new Integer(2), lListSceneRevisions.get(4).getRevisionNumber());
    Assert.assertEquals("<p>Scene 1.3 Revision 2</p>", lListSceneRevisions.get(4).getScene());
    Assert.assertNull(lListSceneRevisions.get(4).getSceneDate());
    Assert.assertEquals("N", lListSceneRevisions.get(4).getSelected());
    Assert.assertNull(lListSceneRevisions.get(4).getTense());
    Assert.assertEquals(new Integer(5), lListSceneRevisions.get(4).getWords());

    Assert.assertEquals(new Integer(20), lListSceneRevisions.get(5).getCharacters());
    Assert.assertEquals(new Integer(73), lListSceneRevisions.get(5).getIdLocation());
    Assert.assertEquals(new Integer(12), lListSceneRevisions.get(5).getIdScene());
    Assert.assertEquals(new Long(6), lListSceneRevisions.get(5).getIdSceneRevision());
    Assert.assertEquals(new Integer(3), lListSceneRevisions.get(5).getPointOfView());
    Assert.assertNull(lListSceneRevisions.get(5).getPointOfViewIdCharacter());
    Assert.assertEquals(new Integer(3), lListSceneRevisions.get(5).getRevisionNumber());
    Assert.assertEquals("<p>Scene 1.3 Revision 3</p>", lListSceneRevisions.get(5).getScene());
    Assert.assertEquals(lSimpleDateFormat.parse("2004-01-01 09:17:00.0"),
            lListSceneRevisions.get(5).getSceneDate());
    Assert.assertEquals("Y", lListSceneRevisions.get(5).getSelected());
    Assert.assertNull(lListSceneRevisions.get(5).getTense());
    Assert.assertEquals(new Integer(5), lListSceneRevisions.get(5).getWords());

    // SCENE REVISION CHARACTERS

    Assert.assertEquals(new Integer(1), lListRevisionCharactersKeys.get(0).getIdSceneRevision());
    Assert.assertEquals(new Integer(67), lListRevisionCharactersKeys.get(0).getIdCharacter());
    Assert.assertEquals(new Integer(2), lListRevisionCharactersKeys.get(1).getIdSceneRevision());
    Assert.assertEquals(new Integer(67), lListRevisionCharactersKeys.get(1).getIdCharacter());
    Assert.assertEquals(new Integer(2), lListRevisionCharactersKeys.get(2).getIdSceneRevision());
    Assert.assertEquals(new Integer(68), lListRevisionCharactersKeys.get(2).getIdCharacter());
    Assert.assertEquals(new Integer(6), lListRevisionCharactersKeys.get(3).getIdSceneRevision());
    Assert.assertEquals(new Integer(67), lListRevisionCharactersKeys.get(3).getIdCharacter());
    Assert.assertEquals(new Integer(6), lListRevisionCharactersKeys.get(4).getIdSceneRevision());
    Assert.assertEquals(new Integer(68), lListRevisionCharactersKeys.get(4).getIdCharacter());
    Assert.assertEquals(new Integer(6), lListRevisionCharactersKeys.get(5).getIdSceneRevision());
    Assert.assertEquals(new Integer(69), lListRevisionCharactersKeys.get(5).getIdCharacter());

    // SCENE REVISION STRANDS

    Assert.assertEquals(new Integer(1), lListRevisionStrandsKeys.get(0).getIdSceneRevision());
    Assert.assertEquals(new Integer(15), lListRevisionStrandsKeys.get(0).getIdStrand());
    Assert.assertEquals(new Integer(2), lListRevisionStrandsKeys.get(1).getIdSceneRevision());
    Assert.assertEquals(new Integer(15), lListRevisionStrandsKeys.get(1).getIdStrand());
    Assert.assertEquals(new Integer(2), lListRevisionStrandsKeys.get(2).getIdSceneRevision());
    Assert.assertEquals(new Integer(16), lListRevisionStrandsKeys.get(2).getIdStrand());
    Assert.assertEquals(new Integer(6), lListRevisionStrandsKeys.get(3).getIdSceneRevision());
    Assert.assertEquals(new Integer(15), lListRevisionStrandsKeys.get(3).getIdStrand());
    Assert.assertEquals(new Integer(6), lListRevisionStrandsKeys.get(4).getIdSceneRevision());
    Assert.assertEquals(new Integer(16), lListRevisionStrandsKeys.get(4).getIdStrand());
    Assert.assertEquals(new Integer(6), lListRevisionStrandsKeys.get(5).getIdSceneRevision());
    Assert.assertEquals(new Integer(17), lListRevisionStrandsKeys.get(5).getIdStrand());

}

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

License:GNU General Public License

public void checkTestProjectDBStrands() throws IOException, ParseException {

    List<Strands> lListStrands;

    SqlSessionFactory lSqlSessionFactory = AllTests.getProjectSqlSessionFactoryById(AllTests.TEST_PROJECT_ID);
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {//  w  ww. java  2  s.co  m

        StrandsMapper lStrandsMapper = lSqlSession.getMapper(StrandsMapper.class);
        StrandsExample lStrandsExample = new StrandsExample();
        lStrandsExample.setOrderByClause("id_strand");
        lListStrands = lStrandsMapper.selectByExampleWithBLOBs(lStrandsExample);

    } finally {
        lSqlSession.close();
    }

    // STRANDS

    Assert.assertEquals("<p>Strand 1</p>", lListStrands.get(0).getDescription());
    Assert.assertEquals(new Long(15), lListStrands.get(0).getIdStrand());
    Assert.assertEquals("Strand 1", lListStrands.get(0).getName());
    Assert.assertEquals(new Integer(1), lListStrands.get(0).getPosition());
    Assert.assertEquals(new Integer(0), lListStrands.get(0).getTaskStatus());

    Assert.assertEquals("<p>Strand 2</p>", lListStrands.get(1).getDescription());
    Assert.assertEquals(new Long(16), lListStrands.get(1).getIdStrand());
    Assert.assertEquals("Strand 2", lListStrands.get(1).getName());
    Assert.assertEquals(new Integer(2), lListStrands.get(1).getPosition());
    Assert.assertEquals(new Integer(1), lListStrands.get(1).getTaskStatus());

    Assert.assertEquals("<p>Strand 3</p>", lListStrands.get(2).getDescription());
    Assert.assertEquals(new Long(17), lListStrands.get(2).getIdStrand());
    Assert.assertEquals("Strand 3", lListStrands.get(2).getName());
    Assert.assertEquals(new Integer(3), lListStrands.get(2).getPosition());
    Assert.assertEquals(new Integer(2), lListStrands.get(2).getTaskStatus());
}