/**
 * 執(zhí)行備份數(shù)據(jù)庫相關(guān)表的Mapper
 */
public interface BackupDataMapper {
    
    /**
     * 修改數(shù)據(jù)庫的表名字
     * @param originalTableName
     * @param newTableName
     * @return
     */
    int alterTableName(@Param("originalTableName") String originalTableName,
            @Param("newTableName") String newTableName);
    
    /**
     * truncate指定數(shù)據(jù)庫表的數(shù)據(jù)
     * @param tableName
     * @return
     */
    int truncateTable(@Param("tableName") String tableName);

    
    /**
     * 根據(jù)傳入的表明，創(chuàng)建新的表并且將原表的數(shù)據(jù)插入到新的Occur表中
     * @param newTableName
     * @param originalTableName
     */
    void createNewTableAndInsertData(@Param("newTableName") String newTableName,
            @Param("originalTableName") String originalTableName);
    
    /**
     * 統(tǒng)計(jì)某張表中的總數(shù)據(jù)條數(shù)泻骤。
     * @param tableName
     * @return 指定表中的總記錄條數(shù)刑赶。
     */
    int getRecordCount(@Param("tableName") String tableName);
    
    /**
     * 獲得當(dāng)前數(shù)據(jù)庫的名字
     */
    String getCurDataBaseName();
    
    /**
     * 從指定數(shù)據(jù)庫中竖慧，查詢是否存在某張表
     * @param dataBaseName
     * @param tableName
     * @return
     */
    String isTargetTableExistInDB(@Param("dataBaseName") String dataBaseName, 
            @Param("tableName") String tableName);
}

<mapper namespace="org.lixj.mapper.BackupDataMapper">

    <update id="alterTableName">
        alter table ${originalTableName} rename ${newTableName}
    </update>

    <update id="truncateTable">
        truncate table ${tableName}
    </update>
    
    <update id="createNewTableAndInsertData">
        create table ${newTableName} as select * from ${originalTableName}
    </update>
    
    <select id="getRecordCount" resultType="int">
        select count(1) from ${tableName}
    </select>
    
    <select id="getCurDataBaseName" resultType="string">
        select database();
    </select>
    
    <select id="isTargetTableExistInDB" resultType="string">
        SELECT table_name FROM information_schema.tables WHERE table_schema = #{dataBaseName} and TABLE_NAME = #{tableName}
    </select>

</mapper>