package com.whyc.mapper;

import java.util.List;

/**
 * 通用mapper,用于通用数据的查询
 */
public interface CommonMapper {

    /**
     * @param schema dbName
     * @param table tableName
     * @param field 这个字段对应的值类型为数值,则valuePrefix为null,如果不为数值,valuePrefix必须指定非数值的前缀
     //* @param valuePrefix null | String
     * @return
     */
    //Object getMaxValue(String schema,String table,String field,String valuePrefix);
    Object getMaxValue(String schema, String table, String field);

    boolean existTable(String dbName, String tableName);

    //void truncate(String dbName, String tableName);

    void createTable4AlarmVoiceSet();

    //void createTable4UserLogByYear(@Param("year") String year);

    //void insertBatch4UserLogByYear(@Param("year")String year, List<UserLog> userLogs);

    //void createTable4PowerAlarmHistoryByYear(@Param("year") String year);

    //void insertBatch4PowerAlarmHistoryByYear(String year, List<PwrdevAlarmHistory> temp);

    //void createTable4BattAlarmDataHistoryByYear(@Param("year") String year);

    //void insertBatch4BattAlarmDataHistoryByYear(String year, List<BattalarmDataHistory> temp);

    //void createTable4DevAlarmDataHistoryByYear(@Param("year") String year);

    //void insertBatch4DevAlarmDataHistoryByYear(String year, List<DevalarmDataHistory> temp);

    void createBattState_RT_RamDB_Table();

    void updateTb_App_Sys_AppServerTable();

    List<String> getTableListLike(String dbName, String tableLike);

   // void createTable4UpsDataHistory(String tableName);

}