//package com.xzx.admin;
//
//import cn.hutool.core.date.DateUtil;
//import com.xzx.log.LogApplication;
//import com.xzx.log.entity.IntefaceAdminLog;
//import com.xzx.log.mapper.IntefaceAdminLogMapper;
//import com.xzx.log.service.MailService;
//import freemarker.template.TemplateException;
//import org.junit.Test;
//import org.junit.runner.RunWith;
//import org.springframework.beans.factory.annotation.Autowired;
//import org.springframework.boot.test.context.SpringBootTest;
//import org.springframework.test.context.ActiveProfiles;
//import org.springframework.test.context.junit4.SpringRunner;
//
//import javax.mail.MessagingException;
//import java.io.IOException;
//
//
//@RunWith(SpringRunner.class)
//@SpringBootTest(classes = {LogApplication.class})
//@ActiveProfiles("dev")
//public class SpringTest {
//
//
//    @Autowired
//    private IntefaceAdminLogMapper intefaceAdminLogMapper;
//
//
//    @Autowired
//    private MailService mailService;
//
//    @Test
//    public void 邮件发送() throws MessagingException, IOException, TemplateException {
//
//        IntefaceAdminLog intefaceAdminLog=new IntefaceAdminLog();
//        intefaceAdminLog.setId("12");
//        intefaceAdminLog.setUserId("aaaaaaaaaa");
//        intefaceAdminLog.setSqlParameter("UPDATE xzx_user_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE user_id = 'YH1206494029815349248';SELECT user_id,mobile_phone,avatar,login_account,password,salt,name,nick_name,birthday,sex,user_type,open_id,country,province,city,del_flag,regist_time,longitude,latitude,regist_type,is_prohibit FROM xzx_user_info WHERE user_id = 'YH1206494029815349248' AND del_flag = 0 AND is_prohibit = false;UPDATE xzx_user_target_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE ( ( mobile = '15574380477' and longitude is null ) )UPDATE xzx_user_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE user_id = 'YH1206494029815349248';SELECT user_id,mobile_phone,avatar,login_account,password,salt,name,nick_name,birthday,sex,user_type,open_id,country,province,city,del_flag,regist_time,longitude,latitude,regist_type,is_prohibit FROM xzx_user_info WHERE user_id = 'YH1206494029815349248' AND del_flag = 0 AND is_prohibit = false;UPDATE xzx_user_target_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE ( ( mobile = '15574380477' and longitude is null ) )" +
//                "UPDATE xzx_user_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE user_id = 'YH1206494029815349248';SELECT user_id,mobile_phone,avatar,login_account,password,salt,name,nick_name,birthday,sex,user_type,open_id,country,province,city,del_flag,regist_time,longitude,latitude,regist_type,is_prohibit FROM xzx_user_info WHERE user_id = 'YH1206494029815349248' AND del_flag = 0 AND is_prohibit = false;UPDATE xzx_user_target_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE ( ( mobile = '15574380477' and longitude is null ) )" +
//                "UPDATE xzx_user_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE user_id = 'YH1206494029815349248';SELECT user_id,mobile_phone,avatar,login_account,password,salt,name,nick_name,birthday,sex,user_type,open_id,country,province,city,del_flag,regist_time,longitude,latitude,regist_type,is_prohibit FROM xzx_user_info WHERE user_id = 'YH1206494029815349248' AND del_flag = 0 AND is_prohibit = false;UPDATE xzx_user_target_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE ( ( mobile = '15574380477' and longitude is null ) )" +
//                "UPDATE xzx_user_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE user_id = 'YH1206494029815349248';SELECT user_id,mobile_phone,avatar,login_account,password,salt,name,nick_name,birthday,sex,user_type,open_id,country,province,city,del_flag,regist_time,longitude,latitude,regist_type,is_prohibit FROM xzx_user_info WHERE user_id = 'YH1206494029815349248' AND del_flag = 0 AND is_prohibit = false;UPDATE xzx_user_target_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE ( ( mobile = '15574380477' and longitude is null ) )" +
//                "UPDATE xzx_user_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE user_id = 'YH1206494029815349248';SELECT user_id,mobile_phone,avatar,login_account,password,salt,name,nick_name,birthday,sex,user_type,open_id,country,province,city,del_flag,regist_time,longitude,latitude,regist_type,is_prohibit FROM xzx_user_info WHERE user_id = 'YH1206494029815349248' AND del_flag = 0 AND is_prohibit = false;UPDATE xzx_user_target_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE ( ( mobile = '15574380477' and longitude is null ) )" +
//                "UPDATE xzx_user_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE user_id = 'YH1206494029815349248';SELECT user_id,mobile_phone,avatar,login_account,password,salt,name,nick_name,birthday,sex,user_type,open_id,country,province,city,del_flag,regist_time,longitude,latitude,regist_type,is_prohibit FROM xzx_user_info WHERE user_id = 'YH1206494029815349248' AND del_flag = 0 AND is_prohibit = false;UPDATE xzx_user_target_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE ( ( mobile = '15574380477' and longitude is null ) )" +
//                "UPDATE xzx_user_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE user_id = 'YH1206494029815349248';SELECT user_id,mobile_phone,avatar,login_account,password,salt,name,nick_name,birthday,sex,user_type,open_id,country,province,city,del_flag,regist_time,longitude,latitude,regist_type,is_prohibit FROM xzx_user_info WHERE user_id = 'YH1206494029815349248' AND del_flag = 0 AND is_prohibit = false;UPDATE xzx_user_target_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE ( ( mobile = '15574380477' and longitude is null ) )");
//        intefaceAdminLog.setIntoParameter("{\n" +
//                "                    \"code\": \"043kTMjj0zcKts134Pij0uHzjj0kTMjb\",\n" +
//                "                    \"pageNo\": 1,\n" +
//                "                    \"start\": 0,\n" +
//                "                    \"pageSize\": 5,\n" +
//                "                    \"smsType\": 0,\n" +
//                "                    \"notCheckLoginFlag\": 0,\n" +
//                "                    \"end\": 0,\n" +
//                "                    \"returnSessionKey\": 0\n" +
//                "                }");
//        intefaceAdminLog.setCreateTime(DateUtil.date());
//        intefaceAdminLog.setImplementType("2");
//        intefaceAdminLog.setLogLevel("2");
//        mailService.sendEmail(intefaceAdminLog);
//        System.out.println("测试完成");
//
//    }
//
//
//    @Test
//    public void add(){
//        IntefaceAdminLog intefaceAdminLog=new IntefaceAdminLog();
//        intefaceAdminLog.setId("12");
//        intefaceAdminLog.setUserId("aaaaaaaaaa");
//        intefaceAdminLogMapper.save(intefaceAdminLog);
//    }
//
//
//
//
//}