Search in sources :

Example 1 with Role

use of com.github.drinkjava2.functionstest.entitynet.entities.Role in project jSqlBox by drinkjava2.

the class EntityNetDemoTest method testEntityCrudWithTransientAnnotation.

/**
 * Test User class with Transient Annotated fields Address and Role
 */
@Test
public void testEntityCrudWithTransientAnnotation() {
    System.out.println(DebugUtils.getTableModelDebugInfo(TableModelUtils.entity2Model(User.class)));
    new User().put("id", "u1").put("userName", "user1").insert();
    Assert.assertEquals(1, ctx.nQueryForLongValue("select count(*) from usertb"));
    User u = new User().load("u1");
    Assert.assertEquals("user1", u.getUserName());
    u.setUserName("user2");
    u.update();
    Assert.assertEquals("user2", ((User) (new User().load("u1"))).getUserName());
    u.delete();
    Assert.assertEquals(0, ctx.nQueryForLongValue("select count(*) from usertb"));
}
Also used : User(com.github.drinkjava2.functionstest.entitynet.entities.User) Test(org.junit.Test)

Example 2 with Role

use of com.github.drinkjava2.functionstest.entitynet.entities.Role in project jSqlBox by drinkjava2.

the class EntityNetDemoTest method testPathFind.

@Test
public void testPathFind() {
    insertDemoData();
    EntityNet net = ctx.netLoad(new User(), new Role(), Privilege.class, UserRole.class, RolePrivilege.class);
    Set<Privilege> privileges = net.findEntitySet(Privilege.class, new Path("S-", User.class).where("id='u1' or id='u2'").nextPath("C-", UserRole.class, "userId").nextPath("P-", Role.class, "rid").nextPath("C-", RolePrivilege.class, "rid").nextPath("P+", Privilege.class, "pid"));
    for (Privilege privilege : privileges) System.out.print(privilege.getId() + " ");
    Assert.assertEquals(3, privileges.size());
}
Also used : UserRole(com.github.drinkjava2.functionstest.entitynet.entities.UserRole) Role(com.github.drinkjava2.functionstest.entitynet.entities.Role) Path(com.github.drinkjava2.jsqlbox.entitynet.Path) User(com.github.drinkjava2.functionstest.entitynet.entities.User) EntityNet(com.github.drinkjava2.jsqlbox.entitynet.EntityNet) RolePrivilege(com.github.drinkjava2.functionstest.entitynet.entities.RolePrivilege) Privilege(com.github.drinkjava2.functionstest.entitynet.entities.Privilege) Test(org.junit.Test)

Example 3 with Role

use of com.github.drinkjava2.functionstest.entitynet.entities.Role in project jSqlBox by drinkjava2.

the class EntityNetDemoTest method testAutoPath2.

@Test
public void testAutoPath2() {
    insertDemoData();
    EntityNet net = ctx.netLoad(new Email(), new User(), new Role(), Privilege.class, UserRole.class, RolePrivilege.class);
    Set<Privilege> privileges = net.findEntitySet(Privilege.class, new Path(Email.class).setValidator(new EmailValidator()).autoPath(Privilege.class));
    for (Privilege privilege : privileges) System.out.println(privilege.getId());
    Assert.assertEquals(1, privileges.size());
}
Also used : UserRole(com.github.drinkjava2.functionstest.entitynet.entities.UserRole) Role(com.github.drinkjava2.functionstest.entitynet.entities.Role) Path(com.github.drinkjava2.jsqlbox.entitynet.Path) Email(com.github.drinkjava2.functionstest.entitynet.entities.Email) User(com.github.drinkjava2.functionstest.entitynet.entities.User) EntityNet(com.github.drinkjava2.jsqlbox.entitynet.EntityNet) RolePrivilege(com.github.drinkjava2.functionstest.entitynet.entities.RolePrivilege) Privilege(com.github.drinkjava2.functionstest.entitynet.entities.Privilege) Test(org.junit.Test)

Example 4 with Role

use of com.github.drinkjava2.functionstest.entitynet.entities.Role in project jSqlBox by drinkjava2.

the class EntityNetDemoTest method insertDemoData.

protected void insertDemoData() {
    // @formatter:off
    // Batch insert enabled
    ctx.nBatchBegin();
    new User().put("id", "u1").put("userName", "user1").insert();
    new User().put("id", "u2").put("userName", "user2").insert();
    new User().put("id", "u3").put("userName", "user3").insert();
    new User().put("id", "u4").put("userName", "user4").insert();
    new User().put("id", "u5").put("userName", "user5").insert();
    new Address().put("id", "a1", "addressName", "address1", "userId", "u1").insert();
    new Address().put("id", "a2", "addressName", "address2", "userId", "u2").insert();
    new Address().put("id", "a3", "addressName", "address3", "userId", "u3").insert();
    new Address().put("id", "a4", "addressName", "address4", "userId", "u4").insert();
    new Address().put("id", "a5", "addressName", "address5", "userId", "u5").insert();
    new Email().putFields("id", "emailName", "userId");
    new Email().putValues("e1", "email1", "u1").insert();
    new Email().putValues("e2", "email2", "u1").insert();
    new Email().putValues("e3", "email3", "u2").insert();
    new Email().putValues("e4", "email4", "u2").insert();
    new Email().putValues("e5", "email5", "u3").insert();
    Role r = new Role();
    r.setId("r1");
    r.setRoleName("role1");
    r.insert();
    r.setId("r2");
    r.setRoleName("role2");
    r.insert();
    r.setId("r3");
    r.setRoleName("role3");
    r.insert();
    r.setId("r4");
    r.setRoleName("role4");
    r.insert();
    r.setId("r5");
    r.setRoleName("role5");
    r.insert();
    Privilege p = new Privilege();
    p.setId("p1");
    p.setPrivilegeName("privilege1");
    p.insert();
    p.setId("p2");
    p.setPrivilegeName("privilege2");
    p.insert();
    p.setId("p3");
    p.setPrivilegeName("privilege3");
    p.insert();
    p.setId("p4");
    p.setPrivilegeName("privilege4");
    p.insert();
    p.setId("p5");
    p.setPrivilegeName("privilege5");
    p.insert();
    UserRole ur = new UserRole();
    ur.setUserId("u1");
    ur.setRid("r1");
    ur.insert();
    ur.setUserId("u2");
    ur.setRid("r1");
    ur.insert();
    ur.setUserId("u2");
    ur.setRid("r2");
    ur.insert();
    ur.setUserId("u2");
    ur.setRid("r3");
    ur.insert();
    ur.setUserId("u3");
    ur.setRid("r4");
    ur.insert();
    ur.setUserId("u4");
    ur.setRid("r1");
    ur.insert();
    new RolePrivilege().putFields("rid", "pid");
    new RolePrivilege().putValues("r1", "p1").insert();
    new RolePrivilege().putValues("r2", "p1").insert();
    new RolePrivilege().putValues("r2", "p2").insert();
    new RolePrivilege().putValues("r2", "p3").insert();
    new RolePrivilege().putValues("r3", "p3").insert();
    new RolePrivilege().putValues("r4", "p1").insert();
    // Batch insert end
    ctx.nBatchEnd();
// @formatter:on
}
Also used : UserRole(com.github.drinkjava2.functionstest.entitynet.entities.UserRole) Role(com.github.drinkjava2.functionstest.entitynet.entities.Role) User(com.github.drinkjava2.functionstest.entitynet.entities.User) Email(com.github.drinkjava2.functionstest.entitynet.entities.Email) Address(com.github.drinkjava2.functionstest.entitynet.entities.Address) UserRole(com.github.drinkjava2.functionstest.entitynet.entities.UserRole) RolePrivilege(com.github.drinkjava2.functionstest.entitynet.entities.RolePrivilege) RolePrivilege(com.github.drinkjava2.functionstest.entitynet.entities.RolePrivilege) Privilege(com.github.drinkjava2.functionstest.entitynet.entities.Privilege)

Example 5 with Role

use of com.github.drinkjava2.functionstest.entitynet.entities.Role in project jSqlBox by drinkjava2.

the class EntityNetDemoTest method testNetLoadSketch.

@Test
public void testNetLoadSketch() {
    insertDemoData();
    EntityNet net = ctx.netLoadSketch(new User(), Email.class, Address.class, new Role(), Privilege.class, UserRole.class, RolePrivilege.class);
    Assert.assertEquals(37, net.size());
    System.out.println(net.size());
    List<User> users = net.getAllEntityList(User.class);
    Assert.assertEquals(5, users.size());
    Assert.assertEquals(null, users.get(0).getUserName());
}
Also used : UserRole(com.github.drinkjava2.functionstest.entitynet.entities.UserRole) Role(com.github.drinkjava2.functionstest.entitynet.entities.Role) User(com.github.drinkjava2.functionstest.entitynet.entities.User) EntityNet(com.github.drinkjava2.jsqlbox.entitynet.EntityNet) Test(org.junit.Test)

Aggregations

User (com.github.drinkjava2.functionstest.entitynet.entities.User)8 Role (com.github.drinkjava2.functionstest.entitynet.entities.Role)7 UserRole (com.github.drinkjava2.functionstest.entitynet.entities.UserRole)7 Test (org.junit.Test)7 EntityNet (com.github.drinkjava2.jsqlbox.entitynet.EntityNet)6 Privilege (com.github.drinkjava2.functionstest.entitynet.entities.Privilege)5 RolePrivilege (com.github.drinkjava2.functionstest.entitynet.entities.RolePrivilege)5 Path (com.github.drinkjava2.jsqlbox.entitynet.Path)4 Email (com.github.drinkjava2.functionstest.entitynet.entities.Email)2 Address (com.github.drinkjava2.functionstest.entitynet.entities.Address)1