package com.sandu.ximon.dao.mapper;

import com.sandu.ximon.dao.domain.C3mChargingCharge;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.*;

import java.util.List;

/**
 * @Entity com.sandu.ximon.dao.domain.C3mChargingCharge
 */
@Mapper
public interface C3mChargingChargeMapper extends BaseMapper<C3mChargingCharge> {

    @Delete("delete from c3_charging_charge where c3_id = #{id}")
    boolean deleteCharge(@Param("id") Integer c3Id);

    @Select("select * from c3_charging_charge where c3_id = #{c3Id} limit 5")
    List<C3mChargingCharge> getChargeByC3Id(@Param("c3Id") Integer c3Id);

    @Insert("insert into c3_charging_charge values (#{c3Id},#{hour},#{min},#{charge},#{timestamp})")
    void insertCharge(C3mChargingCharge c3m);

}