| | |
| | | <result column="uid" property="uid" jdbcType="BIGINT" /> |
| | | <result column="device_token" property="deviceToken" jdbcType="VARCHAR" /> |
| | | <result column="device" property="device" jdbcType="VARCHAR" /> |
| | | <result column="version" property="version" jdbcType="INTEGER" /> |
| | | <result column="createtime" property="createTime" jdbcType="TIMESTAMP" /> |
| | | <result column="updatetime" property="updateTime" jdbcType="TIMESTAMP" /> |
| | | </resultMap> |
| | | <sql id="Base_Column_List">id,uid,device_token,device,createtime,updatetime</sql> |
| | | <sql id="Base_Column_List">id,uid,device_token,device,createtime,updatetime,version</sql> |
| | | <select id="selectByPrimaryKey" resultMap="BaseResultMap" |
| | | parameterType="java.lang.Long"> |
| | | select |
| | |
| | | <insert id="insert" parameterType="com.yeshi.fanli.entity.push.DeviceTokenIOS" |
| | | useGeneratedKeys="true" keyProperty="id">insert into |
| | | yeshi_ec_uid_devicetoken_ios |
| | | (id,uid,device_token,device,createtime,updatetime) values |
| | | (#{id,jdbcType=BIGINT},#{uid,jdbcType=BIGINT},#{deviceToken,jdbcType=VARCHAR},#{device,jdbcType=VARCHAR},#{createTime,jdbcType=TIMESTAMP},#{updateTime,jdbcType=TIMESTAMP}) |
| | | (id,uid,device_token,device,createtime,updatetime,`version`) values |
| | | (#{id,jdbcType=BIGINT},#{uid,jdbcType=BIGINT},#{deviceToken,jdbcType=VARCHAR},#{device,jdbcType=VARCHAR},#{createTime,jdbcType=TIMESTAMP},#{updateTime,jdbcType=TIMESTAMP},#{version,jdbcType=INTEGER}) |
| | | </insert> |
| | | <insert id="insertSelective" parameterType="com.yeshi.fanli.entity.push.DeviceTokenIOS" |
| | | useGeneratedKeys="true" keyProperty="id"> |
| | |
| | | <if test="device != null">device,</if> |
| | | <if test="createTime != null">createtime,</if> |
| | | <if test="updateTime != null">updatetime,</if> |
| | | <if test="version != null">version,</if> |
| | | </trim> |
| | | values |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | |
| | | <if test="device != null">#{device,jdbcType=VARCHAR},</if> |
| | | <if test="createTime != null">#{createTime,jdbcType=TIMESTAMP},</if> |
| | | <if test="updateTime != null">#{updateTime,jdbcType=TIMESTAMP},</if> |
| | | <if test="version != null">#{version,jdbcType=INTEGER},</if> |
| | | </trim> |
| | | </insert> |
| | | <update id="updateByPrimaryKey" parameterType="com.yeshi.fanli.entity.push.DeviceTokenIOS">update |
| | |
| | | #{deviceToken,jdbcType=VARCHAR},device = |
| | | #{device,jdbcType=VARCHAR},createtime = |
| | | #{createTime,jdbcType=TIMESTAMP},updatetime = |
| | | #{updateTime,jdbcType=TIMESTAMP} where id = #{id,jdbcType=BIGINT} |
| | | #{updateTime,jdbcType=TIMESTAMP},version = |
| | | #{version,jdbcType=INTEGER} where id = #{id,jdbcType=BIGINT} |
| | | </update> |
| | | <update id="updateByPrimaryKeySelective" parameterType="com.yeshi.fanli.entity.push.DeviceTokenIOS"> |
| | | update yeshi_ec_uid_devicetoken_ios |
| | |
| | | <if test="device != null">device=#{device,jdbcType=VARCHAR},</if> |
| | | <if test="createTime != null">createtime=#{createTime,jdbcType=TIMESTAMP},</if> |
| | | <if test="updateTime != null">updatetime=#{updateTime,jdbcType=TIMESTAMP},</if> |
| | | <if test="version != null">version=#{version,jdbcType=INTEGER},</if> |
| | | </set> |
| | | where id = #{id,jdbcType=BIGINT} |
| | | </update> |