package com.whyc.mapper;
|
|
import org.apache.ibatis.annotations.Param;
|
|
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(@Param("schema") String schema,@Param("table") String table,@Param("field") String field);
|
|
String 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);
|
|
}
|
