easy-query-Kotlin资源

package com.easy.query.test; import com.easy.query.api.proxy.base.StringProxy; import com.easy.query.core.api.pagination.EasyPageResult; import com.easy.query.core.basic.extension.listener.JdbcExecuteAfterArg; import com.easy.query.core.exception.EasyQueryInvalidOperationException; import com.easy.query.core.proxy.core.draft.Draft1; import com.easy.query.core.proxy.sql.GroupKeys; import com.easy.query.core.proxy.sql.Include; import com.easy.query.core.proxy.sql.Select; import com.easy.query.core.util.EasySQLUtil; import com.easy.query.test.dto.autodto.SchoolClassAO; import com.easy.query.test.dto.autodto.SchoolClassAOProp; import com.easy.query.test.dto.autodto.SchoolClassAOProp10; import com.easy.query.test.dto.autodto.SchoolClassAOProp11; import com.easy.query.test.dto.autodto.SchoolClassAOProp12; import com.easy.query.test.dto.autodto.SchoolClassAOProp14; import com.easy.query.test.dto.autodto.SchoolClassAOProp15; import com.easy.query.test.dto.autodto.SchoolClassAOProp16; import com.easy.query.test.dto.autodto.SchoolClassAOProp2; import com.easy.query.test.dto.autodto.SchoolClassAOProp3; import com.easy.query.test.dto.autodto.SchoolClassAOProp4; import com.easy.query.test.dto.autodto.SchoolClassAOProp5; import com.easy.query.test.dto.autodto.SchoolClassAOProp6; import com.easy.query.test.dto.autodto.SchoolClassAOProp8; import com.easy.query.test.dto.autodto.SchoolClassAOProp9; import com.easy.query.test.dto.autodto.SchoolStudentDTOAO111; import com.easy.query.test.dto.autodto.SchoolStudentDTOAO222; import com.easy.query.test.dto.autodto.SchoolStudentDTOxxx; import com.easy.query.test.entity.Topic; import com.easy.query.test.entity.base.Area; import com.easy.query.test.entity.base.City; import com.easy.query.test.entity.base.MyProvinceVO; import com.easy.query.test.entity.base.Province; import com.easy.query.test.entity.base.proxy.CityProxy; import com.easy.query.test.entity.base.proxy.MyProvinceVOProxy; import com.easy.query.test.entity.base.proxy.ProvinceProxy; import com.easy.query.test.entity.school.SchoolClass; import com.easy.query.test.entity.school.SchoolClassAggregate; import com.easy.query.test.entity.school.SchoolClassTeacher; import com.easy.query.test.entity.school.SchoolStudent; import com.easy.query.test.entity.school.SchoolStudent2; import com.easy.query.test.entity.school.SchoolStudentAddress; import com.easy.query.test.entity.school.SchoolTeacher; import com.easy.query.test.entity.school.dto.SchoolClass1VO; import com.easy.query.test.entity.school.dto.SchoolClassOnlyVO; import com.easy.query.test.entity.school.dto.SchoolClassVO; import com.easy.query.test.entity.school.dto.SchoolStudentOnlyVO; import com.easy.query.test.entity.school.dto.SchoolStudentVO; import com.easy.query.test.entity.school.dto.proxy.SchoolClassVOProxy; import com.easy.query.test.entity.school.dto.proxy.SchoolStudentVOProxy; import com.easy.query.test.entity.school.proxy.SchoolClassProxy; import com.easy.query.test.listener.ListenerContext; import lombok.var; import org.junit.Assert; import org.junit.Test; import java.util.ArrayList; import java.util.Arrays; import java.util.List; import java.util.Objects; /** * create time 2023/7/16 21:47 * 文件说明 * * @author xuejiaming */ public class RelationTest extends BaseTest { public void relationInit(List<String> ids) { easyEntityQuery.deletable(SchoolStudent.class) .whereByIds(ids).executeRows(); easyEntityQuery.deletable(SchoolStudentAddress.class) .where(o -> o.studentId().in(ids)).executeRows(); easyEntityQuery.deletable(SchoolClass.class) .where(o -> o.id().in(Arrays.asList("class1", "class2", "class3"))).executeRows(); easyEntityQuery.deletable(SchoolTeacher.class) .where(o -> o.id().in(Arrays.asList("teacher1", "teacher2"))).executeRows(); easyEntityQuery.deletable(SchoolClassTeacher.class) .where(o -> o.classId().in(Arrays.asList("class1", "class2", "class3"))).executeRows(); easyEntityQuery.deletable(SchoolClassTeacher.class) .where(o -> o.teacherId().in(Arrays.asList("teacher1", "teacher2"))).executeRows(); ArrayList<SchoolStudent> schoolStudents = new ArrayList<>(); ArrayList<SchoolClass> schoolClasses = new ArrayList<>(); ArrayList<SchoolStudentAddress> schoolStudentAddresses = new ArrayList<>(); ArrayList<SchoolTeacher> schoolTeachers = new ArrayList<>(); ArrayList<SchoolClassTeacher> schoolClassTeachers = new ArrayList<>(); int i = 0; for (String id : ids) { int i1 = i % 2; SchoolStudent schoolStudent = new SchoolStudent(); schoolStudent.setId(id); schoolStudent.setClassId("class" + (i1 + 1)); schoolStudent.setName("学生" + id); schoolStudents.add(schoolStudent); SchoolStudentAddress schoolStudentAddress = new SchoolStudentAddress(); schoolStudentAddress.setId("address" + id); schoolStudentAddress.setStudentId(id); schoolStudentAddress.setAddress("地址" + id); schoolStudentAddresses.add(schoolStudentAddress); i++; } { SchoolClass schoolClass = new SchoolClass(); schoolClass.setId("class1"); schoolClass.setName("班级1"); schoolClasses.add(schoolClass); } { SchoolClass schoolClass = new SchoolClass(); schoolClass.setId("class2"); schoolClass.setName("班级2"); schoolClasses.add(schoolClass); } { SchoolClass schoolClass = new SchoolClass(); schoolClass.setId("class3"); schoolClass.setName("班级3"); schoolClasses.add(schoolClass); } { SchoolTeacher schoolTeacher = new SchoolTeacher(); schoolTeacher.setId("teacher1"); schoolTeacher.setName("老师1"); schoolTeachers.add(schoolTeacher); } { SchoolTeacher schoolTeacher = new SchoolTeacher(); schoolTeacher.setId("teacher2"); schoolTeacher.setName("老师2"); schoolTeachers.add(schoolTeacher); } { SchoolClassTeacher schoolClassTeacher = new SchoolClassTeacher(); schoolClassTeacher.setClassId("class1"); schoolClassTeacher.setTeacherId("teacher1"); schoolClassTeachers.add(schoolClassTeacher); } { SchoolClassTeacher schoolClassTeacher = new SchoolClassTeacher(); schoolClassTeacher.setClassId("class1"); schoolClassTeacher.setTeacherId("teacher2"); schoolClassTeachers.add(schoolClassTeacher); } { SchoolClassTeacher schoolClassTeacher = new SchoolClassTeacher(); schoolClassTeacher.setClassId("class2"); schoolClassTeacher.setTeacherId("teacher2"); schoolClassTeachers.add(schoolClassTeacher); } easyEntityQuery.insertable(schoolStudents).executeRows(); easyEntityQuery.insertable(schoolClasses).executeRows(); easyEntityQuery.insertable(schoolStudentAddresses).executeRows(); easyEntityQuery.insertable(schoolTeachers).executeRows(); easyEntityQuery.insertable(schoolClassTeachers).executeRows(); } public void relationRemove(List<String> ids) { easyEntityQuery.deletable(SchoolStudent.class) .whereByIds(ids).executeRows(); easyEntityQuery.deletable(SchoolStudentAddress.class) .where(o -> o.studentId().in(ids)).executeRows(); easyEntityQuery.deletable(SchoolClass.class) .where(o -> o.id().in(Arrays.asList("class1", "class2", "class3"))).executeRows(); easyEntityQuery.deletable(SchoolTeacher.class) .where(o -> o.id().in(Arrays.asList("teacher1", "teache