@Transactional
public static boolean revokeAccount(String email) {
if (((List) OrderTire.findByUserAndNotInInitiated(email)).size() == 0) {
Ebean.delete(OrderTire.findByUser(email));
Ebean.delete(User.findByEmail(email));
return true;
} else {
return false;
}
}
@Test
public void testInsert() {
SomePeriodBean bean = new SomePeriodBean();
bean.setPeriod(Period.of(3, 4, 5));
bean.setAnniversary(MonthDay.of(4, 29));
Ebean.save(bean);
SomePeriodBean bean1 = Ebean.find(SomePeriodBean.class, bean.getId());
assertEquals(bean.getPeriod(), bean1.getPeriod());
assertEquals(bean.getAnniversary(), bean1.getAnniversary());
// insert fetch null value
SomePeriodBean bean2 = new SomePeriodBean();
Ebean.save(bean2);
SomePeriodBean bean3 = Ebean.find(SomePeriodBean.class, bean2.getId());
assertNull(bean3.getPeriod());
assertNull(bean3.getAnniversary());
List<SomePeriodBean> anniversaryList =
Ebean.find(SomePeriodBean.class)
.where()
.eq("anniversary", MonthDay.of(4, 29))
.eq("period_years", 3)
.eq("period_months", 4)
.findList();
assertEquals(1, anniversaryList.size());
// must use year 2000 for range predicates
// ... using 2001 here so not finding anything
anniversaryList =
Ebean.find(SomePeriodBean.class)
.where()
.gt("anniversary", Date.valueOf(LocalDate.of(2001, 4, 29)))
.findList();
assertEquals(0, anniversaryList.size());
// can use year 2000 for range predicates
// ... and can use LocalDate to bind
anniversaryList =
Ebean.find(SomePeriodBean.class)
.where()
.gt("anniversary", LocalDate.of(2000, 4, 22))
.findList();
assertEquals(1, anniversaryList.size());
Ebean.delete(bean);
Ebean.delete(bean2);
}
@AccessLevel(level = 2)
public Result delete(String id) {
try {
Ebean.delete(ShakeRecord.class, id);
return ok();
} catch (Throwable e) {
return status(ErrDefinition.E_SHAKE_RECORD_DELETE_ERROR, Messages.get("shakerecord.failure"));
}
}
@Test
public void test_deleteCascading() {
Permission p1 = new Permission("p1");
Permission p2 = new Permission("p2");
Ebean.save(p1);
Ebean.save(p2);
Role role1 = new Role("role");
Set<Permission> permissions = new HashSet<Permission>();
permissions.add(p2);
role1.setPermissions(permissions);
Ebean.save(role1);
// only deletes as not associated
Ebean.delete(p1);
// delete cascades
Ebean.delete(role1);
}
@AccessLevel(level = 2)
public Result delete(String id) {
try {
Ebean.delete(ActivityChoice.class, id);
} catch (Throwable e) {
return status(
ErrDefinition.E_ACTIVITY_CHOICE_DELETE_FAILED, Messages.get("activitychoice.failure"));
}
return ok();
}
@Test
public void test() {
Ebean.createUpdate(Permission.class, "delete from Permission").execute();
Ebean.createUpdate(Tenant.class, "delete from Tenant").execute();
Ebean.createUpdate(Role.class, "delete from Role").execute();
Tenant t = new Tenant("tenant");
Ebean.save(t);
Permission p1 = new Permission("p1");
Permission p2 = new Permission("p2");
Ebean.save(p1);
Ebean.save(p2);
Role role1 = new Role("role");
role1.setTenant(t);
Set<Permission> permissions = new HashSet<Permission>();
List<Permission> permsList = Ebean.find(Permission.class).findList();
permissions.addAll(permsList);
role1.setPermissions(permissions);
Ebean.save(role1);
List<Tenant> tenantList = Ebean.find(Tenant.class).fetch("roles").findList();
List<Role> roleList = Ebean.find(Role.class).fetch("permissions").findList();
List<Permission> permissionList = Ebean.find(Permission.class).fetch("roles").findList();
Assert.assertEquals(1, tenantList.size());
Assert.assertEquals(2, permissionList.size());
Assert.assertEquals(1, roleList.size());
Ebean.delete(role1);
List<Tenant> tenantList2 = Ebean.find(Tenant.class).fetch("roles").findList();
List<Role> roleList2 = Ebean.find(Role.class).fetch("permissions").findList();
List<Permission> permissionList2 = Ebean.find(Permission.class).fetch("roles").findList();
Assert.assertEquals(0, roleList2.size());
Assert.assertEquals(1, tenantList2.size());
Assert.assertEquals(2, permissionList2.size());
}
@Test
public void test() {
PFile persistentFile = new PFile("test.txt", new PFileContent("test".getBytes()));
Ebean.save(persistentFile);
Integer id = persistentFile.getId();
Integer contentId = persistentFile.getFileContent().getId();
PFile partialPfile =
Ebean.find(PFile.class).select("id").where().idEq(persistentFile.getId()).findUnique();
// should delete file and fileContent
Ebean.delete(partialPfile);
System.out.println("finished delete");
PFile file1 = Ebean.find(PFile.class, id);
PFileContent content1 = Ebean.find(PFileContent.class, contentId);
Assert.assertNull(file1);
Assert.assertNull(content1);
}
/**
* 删除图片
*
* @param img_code
*/
public static void deleteImage(String img_code) {
// TODO 删除图片文件
Ebean.delete(find.where().eq("img_code", img_code).findList());
}
@After
public void afterEachTest() {
Ebean.delete(fixturesToUnload());
}
public static Result delete(Long id) {
FastSubject fastSubject = FastSubject.find.byId(id);
Ebean.delete(fastSubject);
FlashMessage.updateSuccess.send();
return redirect(routes.FastSubjects.list(0, "name", "asc", ""));
}
