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.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;
|
|
|
@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<Long> ids = new ArrayList<>();
|
ids.add(12L);
|
List<LuckySponsors> 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.sort = "create_time desc";
|
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);
|
}
|
|
|
}
|