| | |
|---|
| | | |
|---|
| | | public interface EquipmentMapper extends BaseMapper<Equipment> { |
|---|
| | | |
|---|
| | | @Select(" SELECT name FROM SysObjects Where XType='U' AND name = '${saveTableName}' ") |
|---|
| | | @Select(" SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = '${saveTableName}' ") |
|---|
| | | String checkTableExists(@Param("saveTableName") String saveTableName); |
|---|
| | | |
|---|
| | | @Select(" SELECT COUNT(CollectTime) num FROM ${saveTableName} WHERE CollectTime < '${day}' ") |
|---|
| | |
|---|
| | | @Delete(" delete from ${tableName} where CollectTime < '${day}' ") |
|---|
| | | void deleteTableData(@Param("tableName") String saveTableName, @Param("day") String day); |
|---|
| | | |
|---|
| | | @Insert(" SELECT * INTO ${tableName} FROM ${lastTableName} WHERE CollectTime < '${date}' ") |
|---|
| | | @Insert("CREATE TABLE `{tableName}` AS SELECT * FROM `{lastTableName}` WHERE CollectTime < '${date}' ") |
|---|
| | | void insertNoTableData(@Param("tableName") String tableName, @Param("lastTableName") String lastTableName, @Param("date") String date); |
|---|
| | | } |
|---|
