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

Introduction

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

Prototype

<T> T getMapper(Class<T> type);

Source Link

Document

Retrieves a mapper.

Usage

From source file:com.bibisco.manager.ProjectManager.java

License:GNU General Public License

private static List<VSelectedSceneRevisions> getAllSelectedScenes() {

    List<VSelectedSceneRevisions> lListVSelectedSceneRevisions = null;

    mLog.debug("Start getAllSelectedScenes()");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();

    try {//w ww  .  j a  va  2  s.c  om
        VSelectedSceneRevisionsMapper lVSelectedSceneRevisionsMapper = lSqlSession
                .getMapper(VSelectedSceneRevisionsMapper.class);
        VSelectedSceneRevisionsExample lVSelectedSceneRevisionsExample = new VSelectedSceneRevisionsExample();
        lVSelectedSceneRevisionsExample.setOrderByClause("chapter_position, scene_position");
        lListVSelectedSceneRevisions = lVSelectedSceneRevisionsMapper
                .selectByExampleWithBLOBs(lVSelectedSceneRevisionsExample);
    } catch (Throwable t) {
        mLog.error(t);
        throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
    } finally {
        lSqlSession.close();
    }

    mLog.debug("End getAllSelectedScenes()");

    return lListVSelectedSceneRevisions;
}

---

From source file:com.bibisco.manager.ProjectManager.java

License:GNU General Public License

private static ImportProjectArchiveDTO checkImportProjectArchive() {

    ImportProjectArchiveDTO lImportProjectArchiveDTO = null;

    mLog.debug("Start checkIfProjectAlreadyExists(String)");

    String lStrIdProject = null;//www .ja v  a 2s.  c o m
    File[] lFiles = new File(ContextManager.getInstance().getTempDirectoryPath()).listFiles();

    // search file with extensions h2.db
    boolean lBlnIsProjectValid = false;
    if (lFiles != null) {
        for (File lFile : lFiles) {
            if (lFile.isDirectory()) {
                lStrIdProject = lFile.getName();
                lBlnIsProjectValid = lStrIdProject
                        .matches("[0-9a-f]{8}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{12}");
                if (lBlnIsProjectValid) {
                    break;
                }
            }
        }
    }

    // check if project exists
    Projects lProjects = null;
    if (lBlnIsProjectValid) {
        SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance()
                .getSqlSessionFactoryBibisco();
        SqlSession lSqlSession = lSqlSessionFactory.openSession();
        try {
            ProjectsMapper lProjectsMapper = lSqlSession.getMapper(ProjectsMapper.class);
            lProjects = lProjectsMapper.selectByPrimaryKey(lStrIdProject);

        } catch (Throwable t) {
            mLog.error(t);
            throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
        } finally {
            lSqlSession.close();
        }
    }

    // create ImportProjectArchiveDTO
    lImportProjectArchiveDTO = new ImportProjectArchiveDTO();
    if (lBlnIsProjectValid) {
        lImportProjectArchiveDTO.setArchiveFileValid(true);
        lImportProjectArchiveDTO.setIdProject(lStrIdProject);
        if (lProjects != null) {
            lImportProjectArchiveDTO.setAlreadyPresent(true);
            lImportProjectArchiveDTO.setProjectName(lProjects.getName());
        } else {
            lImportProjectArchiveDTO.setAlreadyPresent(false);
        }
    } else {
        lImportProjectArchiveDTO.setArchiveFileValid(false);
    }

    mLog.debug("End checkIfProjectAlreadyExists(String): alreadyPresent "
            + lImportProjectArchiveDTO.isAlreadyPresent());

    return lImportProjectArchiveDTO;
}

---

From source file:com.bibisco.manager.ProjectManager.java

License:GNU General Public License

public static void save(ProjectDTO pProjectDTO) {

    mLog.debug("Start save(ProjectDTO)");

    // validate preconditions
    Validate.notNull(pProjectDTO, "argument ProjectDTO cannot be null");

    // open session in bibisco db
    SqlSessionFactory lSqlSessionFactoryBibisco = SqlSessionFactoryManager.getInstance()
            .getSqlSessionFactoryBibisco();
    SqlSession lSqlSessionBibisco = lSqlSessionFactoryBibisco.openSession();

    // open session in project db
    SqlSessionFactory lSqlSessionFactoryProject = SqlSessionFactoryManager.getInstance()
            .getSqlSessionFactoryProject();
    SqlSession lSqlSessionProject = lSqlSessionFactoryProject.openSession();

    try {/*from w  w w .j a v a  2s. c  o m*/

        Projects lProjects = new Projects();
        lProjects.setIdProject(ContextManager.getInstance().getIdProject());
        lProjects.setName(pProjectDTO.getName());

        ProjectsMapper lProjectsMapper = lSqlSessionBibisco.getMapper(ProjectsMapper.class);
        lProjectsMapper.updateByPrimaryKey(lProjects);

        ProjectWithBLOBs lProjectWithBLOBs = new ProjectWithBLOBs();
        lProjectWithBLOBs.setIdProject(ContextManager.getInstance().getIdProject());
        lProjectWithBLOBs.setName(pProjectDTO.getName());

        ProjectMapper lProjectMapper = lSqlSessionProject.getMapper(ProjectMapper.class);
        lProjectMapper.updateByPrimaryKeySelective(lProjectWithBLOBs);

        lSqlSessionBibisco.commit();
        lSqlSessionProject.commit();

    } catch (Throwable t) {
        mLog.error(t);
        lSqlSessionBibisco.rollback();
        lSqlSessionProject.rollback();
        throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
    } finally {
        lSqlSessionBibisco.close();
        lSqlSessionProject.close();
    }

    mLog.debug("End save(ProjectDTO)");
}

---

From source file:com.bibisco.manager.ProjectManager.java

License:GNU General Public License

public static int deleteProjectsEntriesOnBibiscoDB() {

    int lIntResult = 0;

    mLog.debug("Start importProjectsFromProjectsDirectory()");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryBibisco();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {/*from   w  w w.  jav  a 2  s  . co  m*/

        // delete entry on bibisco db
        ProjectsMapper lProjectsMapper = lSqlSession.getMapper(ProjectsMapper.class);
        lIntResult = lProjectsMapper.deleteByExample(new ProjectsExample());

        lSqlSession.commit();

    } catch (Throwable t) {
        mLog.error(t);
        lSqlSession.rollback();
        throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
    } finally {
        lSqlSession.close();
    }

    mLog.debug("End importProjectsFromProjectsDirectory()");

    return lIntResult;
}

---

From source file:com.bibisco.manager.ProjectManager.java

License:GNU General Public License

private static void checkProjectVersionAndUpdateIfNecessary(String pStrIdProject) {

    mLog.debug("Start checkProjectVersionAndUpdateIfNecessary(String)");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {//from ww  w.  jav  a 2  s . c  om
        ProjectMapper lProjectMapper = lSqlSession.getMapper(ProjectMapper.class);
        String lStrBibiscoVersion = lProjectMapper.getProjectVersion(pStrIdProject);

        // update version if necessary
        if (VersionManager.compare(lStrBibiscoVersion, "1.1.0") == -1) {
            update_to_1_1_0(lSqlSession, lProjectMapper);
        }
        if (VersionManager.compare(lStrBibiscoVersion, "1.1.2") == -1) {
            update_to_1_1_2(lSqlSession, lProjectMapper);
        }
        if (VersionManager.compare(lStrBibiscoVersion, "1.2.0") == -1) {
            update_to_1_2_0(lSqlSession, lProjectMapper);
        }

        // update project version
        ProjectWithBLOBs lProjectWithBLOBs = new ProjectWithBLOBs();
        lProjectWithBLOBs.setIdProject(pStrIdProject);
        lProjectWithBLOBs.setBibiscoVersion(VersionManager.getInstance().getVersion());
        lProjectMapper.updateByPrimaryKeySelective(lProjectWithBLOBs);

        lSqlSession.commit();

    } catch (Throwable t) {
        lSqlSession.rollback();
        mLog.error(t);
        throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
    } finally {
        lSqlSession.close();
    }

    mLog.debug("End checkProjectVersionAndUpdateIfNecessary(String)");
}

---

From source file:com.bibisco.manager.ProjectManager.java

License:GNU General Public License

private static void update_to_1_1_0(SqlSession pSqlSession, ProjectMapper pProjectMapper) {

    mLog.debug("Start update_to_1_1_0(SqlSession, ProjectMapper");

    // run ddl script
    pProjectMapper.update_to_1_1_0();//from   w w  w.  j  a va2s .c  o m

    // update character and word count
    SceneRevisionsMapper lSceneRevisionsMapper = pSqlSession.getMapper(SceneRevisionsMapper.class);
    List<SceneRevisions> lListSceneRevisions = lSceneRevisionsMapper
            .selectByExampleWithBLOBs(new SceneRevisionsExample());
    if (lListSceneRevisions != null && lListSceneRevisions.size() > 0) {
        for (SceneRevisions lSceneRevisions : lListSceneRevisions) {
            String lStrSceneText = lSceneRevisions.getScene();
            CharacterWordCount lCharacterWordCount = TextEditorManager.getCharacterWordCount(lStrSceneText);
            lSceneRevisions.setCharacters(lCharacterWordCount.getCharacters());
            lSceneRevisions.setWords(lCharacterWordCount.getWords());
            lSceneRevisionsMapper.updateByPrimaryKey(lSceneRevisions);
        }
    }

    mLog.debug("End update_to_1_1_0(SqlSession, ProjectMapper");
}

---

From source file:com.bibisco.manager.ProjectManager.java

License:GNU General Public License

private static void update_to_1_1_2(SqlSession pSqlSession, ProjectMapper pProjectMapper) {

    mLog.debug("Start update_to_1_1_2(SqlSession, ProjectMapper");

    // repair scenes' position
    ScenesMapper lScenesMapper = pSqlSession.getMapper(ScenesMapper.class);
    ScenesExample lScenesExample = new ScenesExample();
    lScenesExample.setOrderByClause("id_chapter, position, id_scene");
    List<Scenes> lListScenes = lScenesMapper.selectByExample(lScenesExample);

    Integer lIntLastChapter = null;
    int i = 0;/*from  ww  w . j a v a  2s . co m*/
    for (Scenes lScenes : lListScenes) {
        if (!lScenes.getIdChapter().equals(lIntLastChapter)) {
            lIntLastChapter = lScenes.getIdChapter();
            i = 0;
        }
        lScenes.setPosition(++i);
        lScenesMapper.updateByPrimaryKey(lScenes);
    }

    // run ddl script
    pProjectMapper.update_to_1_1_2();

    mLog.debug("End update_to_1_1_2(SqlSession, ProjectMapper");
}

---

From source file:com.bibisco.manager.PropertiesManager.java

License:GNU General Public License

private void initPropertiesMap() {

    mLog.debug("Start initPropertiesMap()");

    mMapProperties = new HashMap<String, String>();

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryBibisco();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {//from   ww w . j  av a  2  s .  c om
        PropertiesMapper lPropertiesMapper = lSqlSession.getMapper(PropertiesMapper.class);
        List<Properties> lListProperties = lPropertiesMapper.selectByExample(new PropertiesExample());
        for (Properties lProperties : lListProperties) {
            mMapProperties.put(lProperties.getProperty(), lProperties.getValue());
        }

    } catch (Throwable t) {
        mLog.error(t);
        throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
    } finally {
        lSqlSession.close();
    }

    mLog.debug("End initPropertiesMap()");
}

---

From source file:com.bibisco.manager.PropertiesManager.java

License:GNU General Public License

public void updateProperties(Map<String, String> pMapProperties) {

    mLog.debug("Start updateProperties(Map<String, String>)");

    Validate.notEmpty(pMapProperties, "Properties map cannot be empty");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryBibisco();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();

    try {//w  w w.  j  av  a 2 s .co  m

        PropertiesMapper lPropertiesMapper = lSqlSession.getMapper(PropertiesMapper.class);
        for (String lStrProperty : pMapProperties.keySet()) {
            Properties lProperties = new Properties();
            lProperties.setProperty(lStrProperty);
            lProperties.setValue(pMapProperties.get(lStrProperty));
            lPropertiesMapper.updateByPrimaryKey(lProperties);
            mMapProperties.put(lStrProperty, pMapProperties.get(lStrProperty));
        }

        lSqlSession.commit();

    } catch (Throwable t) {
        mLog.error(t);
        lSqlSession.rollback();
        throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
    } finally {
        lSqlSession.close();
    }

    mLog.debug("End updateProperties()");
}

---

From source file:com.bibisco.manager.PropertiesManager.java

License:GNU General Public License

public void updateProperty(String pStrProperty, String pStrValue) {

    mLog.debug("Start updateProperty(", pStrProperty, ",", pStrValue, ")");

    Validate.notEmpty(pStrProperty, "Property cannot be empty");
    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryBibisco();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {/*from   ww w . ja va  2s.  co m*/

        PropertiesMapper lPropertiesMapper = lSqlSession.getMapper(PropertiesMapper.class);
        Properties lProperties = new Properties();
        lProperties.setProperty(pStrProperty);
        lProperties.setValue(pStrValue);
        lPropertiesMapper.updateByPrimaryKey(lProperties);
        mMapProperties.put(pStrProperty, pStrValue);

        lSqlSession.commit();

    } catch (Throwable t) {
        mLog.error(t);
        lSqlSession.rollback();
        throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
    } finally {
        lSqlSession.close();
    }

    mLog.debug("End updateProperty(", pStrProperty, ",", pStrValue, ")");
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »