package pwc.taxtech.atms.dao;

import java.util.List;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.session.RowBounds;
import pwc.taxtech.atms.MyMapper;
import pwc.taxtech.atms.entity.KeyValueConfig;
import pwc.taxtech.atms.entity.KeyValueConfigExample;

@Mapper
public interface KeyValueConfigMapper extends MyMapper {
    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table key_value_config
     *
     * @mbg.generated
     */
    long countByExample(KeyValueConfigExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table key_value_config
     *
     * @mbg.generated
     */
    int deleteByExample(KeyValueConfigExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table key_value_config
     *
     * @mbg.generated
     */
    int deleteByPrimaryKey(String id);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table key_value_config
     *
     * @mbg.generated
     */
    int insert(KeyValueConfig record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table key_value_config
     *
     * @mbg.generated
     */
    int insertSelective(KeyValueConfig record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table key_value_config
     *
     * @mbg.generated
     */
    List<KeyValueConfig> selectByExampleWithRowbounds(KeyValueConfigExample example, RowBounds rowBounds);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table key_value_config
     *
     * @mbg.generated
     */
    List<KeyValueConfig> selectByExample(KeyValueConfigExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table key_value_config
     *
     * @mbg.generated
     */
    KeyValueConfig selectByPrimaryKey(String id);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table key_value_config
     *
     * @mbg.generated
     */
    int updateByExampleSelective(@Param("record") KeyValueConfig record, @Param("example") KeyValueConfigExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table key_value_config
     *
     * @mbg.generated
     */
    int updateByExample(@Param("record") KeyValueConfig record, @Param("example") KeyValueConfigExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table key_value_config
     *
     * @mbg.generated
     */
    int updateByPrimaryKeySelective(KeyValueConfig record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table key_value_config
     *
     * @mbg.generated
     */
    int updateByPrimaryKey(KeyValueConfig record);

    @Select("SELECT  " +
            "        kvc.id AS id,  " +
            "        kvc.key_code AS keyCode,  " +
            "        kvc.name AS name,  " +
            "        kvc.key_value_type AS keyValueType,  " +
            "        kvc.formula AS formula,  " +
            "        kvc.is_constant AS isConstant,  " +
            "        kvc.calculate_status AS calculateStatus,  " +
            "        kvc.result_type AS resultType,  " +
            "        kvc.service_type_ids AS serviceTypeIds,  " +
            "        kvc.industry_ids AS industryIds,  " +
            "        kvc.description AS description,  " +
            "        kvc.creator AS creator,  " +
            "        kvc.create_time AS createTime,  " +
            "        kvc.updator AS updator,  " +
            "        kvc.update_time AS updateTime,  " +
            "        kvc.data_source AS dataSource  " +
            "        FROM  " +
            "        key_value_config kvc" +
            "        ORDER BY  " +
            "        kvc.create_time" +
            "")
    List<KeyValueConfig> selectKeyValueConfigsByOrderByCreateTime();
}