package com.whyc.mapper;

import com.whyc.pojo.ExperimentPrecondition;
import net.sf.jsqlparser.expression.JdbcNamedParameter;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;

public interface CommonMapper {

    @Select("select TABLE_NAME FROM information_schema.TABLES where TABLE_SCHEMA= #{dBName} and TABLE_NAME like concat(#{tableLike},'%')")
    List<String> getTableName(String dBName, String tableLike);

    @Select("select ${field} as actualValue from ${tableName} where dev_id in (#{deviceId})")
    Object getPreconditionStatus(ExperimentPrecondition precondition);

    @Update("update ${tableName} set ${field} = #{value} where dev_id in (${deviceId})")
    int setPrecondition(String tableName,String deviceId,String field,String value);
}