package com.ks.lucky; import com.ks.lucky.mapper.*; import com.ks.lucky.pojo.DO.LuckyActivity; import com.ks.lucky.pojo.DO.LuckyActivityAwardResult; import com.ks.lucky.pojo.DO.LuckySponsorMoneyRecord; import com.ks.lucky.pojo.DO.LuckySponsors; import com.ks.lucky.query.*; import org.junit.jupiter.api.Test; import org.springframework.boot.test.context.SpringBootTest; import javax.annotation.Resource; import java.math.BigDecimal; import java.util.ArrayList; import java.util.Arrays; import java.util.Date; import java.util.List; @SpringBootTest public class MapperTest { @Resource private LuckyActivityAwardResultExtraMapper luckyActivityAwardResultExtraMapper; @Resource private LuckyActivityAwardResultMapper luckyActivityAwardResultMapper; @Resource private LuckyActivityAwardsMapper luckyActivityAwardsMapper; @Resource private LuckyActivityJoinAssistMapper luckyActivityJoinAssistMapper; @Resource private LuckyActivityJoinRecordMapper luckyActivityJoinRecordMapper; @Resource private LuckyActivityMapper luckyActivityMapper; @Resource private LuckyActivityOpenInfoMapper luckyActivityOpenInfoMapper; @Resource private LuckyActivitySponsorInfoMapper luckyActivitySponsorInfoMapper; @Resource private LuckySponsorsMapper luckySponsorsMapper; @Resource private LuckySponsorMoneyRecordMapper luckySponsorMoneyRecordMapper; @Test public void sponsors() { LuckySponsorQuery query = new LuckySponsorQuery(); query.state = LuckySponsors.STATE_NORMAL; query.start = 0; query.count = 100; query.key = "测试"; query.account = "1101184511@qq.com"; query.minCreateTime = new Date(); query.maxCreateTime = new Date(); luckySponsorsMapper.list(query); luckySponsorsMapper.count(query); List ids = new ArrayList<>(); ids.add(12L); List list = luckySponsorsMapper.listDetail(ids); System.out.println(list); } @Test public void sponsorActivityInfo() { ActivitySponsorInfoQuery query = new ActivitySponsorInfoQuery(); query.activityId = 123L; query.sponsorId = 1L; query.minCreateTime = new Date(); query.maxCreateTime = new Date(); luckyActivitySponsorInfoMapper.list(query); luckyActivitySponsorInfoMapper.count(query); } @Test public void openInfo() { luckyActivityOpenInfoMapper.selectByActivityId(1L); } @Test public void activity() { luckyActivityMapper.selectByPrimaryKeyForUpdate(1L); luckyActivityMapper.addJoinCount(1L, 2); ActivityDaoQuery query = new ActivityDaoQuery(); query.sponsorId = 1L; query.stateList = Arrays.asList(new Integer[]{LuckyActivity.STATE_NOT_STARTED, LuckyActivity.STATE_VERIFY_REJECT}); query.appId = 1L; query.full = true; query.start = 0; query.count = 100; query.minCreateTime = new Date(); query.maxCreateTime = new Date(); luckyActivityMapper.list(query); luckyActivityMapper.count(query); } @Test public void join() { ActivityJoinRecordQuery query = new ActivityJoinRecordQuery(); query.activityId = 1L; query.uid = "123123"; query.appId = 1L; query.start = 0; query.count = 100; query.minCreateTime = new Date(); query.maxCreateTime = new Date(); luckyActivityJoinRecordMapper.list(query); luckyActivityJoinRecordMapper.count(query); luckyActivityJoinRecordMapper.addWeight(1L, 1); } @Test public void assist() { ActivityJoinAssistQuery query = new ActivityJoinAssistQuery(); query.appId = 4L; query.joinId = 1L; query.uid = "123"; query.start = 0; query.count = 100; query.minCreateTime = new Date(); query.maxCreateTime = new Date(); luckyActivityJoinAssistMapper.list(query); luckyActivityJoinAssistMapper.count(query); } @Test public void award() { ActivityAwardQuery query = new ActivityAwardQuery(); query.activityId = 1L; query.start = 0; query.count = 100; query.minCreateTime = new Date(); query.maxCreateTime = new Date(); luckyActivityAwardsMapper.list(query); luckyActivityAwardsMapper.count(query); } @Test public void awardResult() { luckyActivityAwardResultMapper.selectByPrimaryKeyForUpdate(1L); luckyActivityAwardResultMapper.setStateByActivityId(1L, LuckyActivityAwardResult.STATE_NOT_RECIEVE, "", new Date()); ActivityAwardResultQuery query = new ActivityAwardResultQuery(); query.uid = "123"; query.awardId = 1L; query.activityId = 1L; query.appId = 4L; query.minCreateTime = new Date(); query.maxCreateTime = new Date(); luckyActivityAwardResultMapper.list(query); luckyActivityAwardResultMapper.count(query); } @Test public void awardResultExtra() { luckyActivityAwardResultExtraMapper.selectByAwardResultId(1L); } @Test public void addSponsorMoneyRecord() { // LuckySponsorMoneyRecord luckySponsorMoneyRecord=new LuckySponsorMoneyRecord(); // luckySponsorMoneyRecord.setSponsorId(1L); // luckySponsorMoneyRecord.setMoney(new BigDecimal(0)); // luckySponsorMoneyRecord.setActivityId(1L); // luckySponsorMoneyRecord.setType(LuckySponsorMoneyRecord.RecordType.publishActivity); // // luckySponsorMoneyRecordMapper.insertSelective(luckySponsorMoneyRecord); LuckySponsorMoneyRecord record = luckySponsorMoneyRecordMapper.selectByPrimaryKey(2L); System.out.println(record); } }