Examples with User com.github.drinkjava2.functionstest.entitynet.entities.User used on opensource projects

Example 6 with User

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

the class EntityNetQueryTest method testJoinParents.

@Test
public void testJoinParents() {
    System.out.println("==============testJoinParents================ ");
    new User().put("id", "u1").put("userName", "user1").insert();
    new User().put("id", "u2").put("userName", "user2").insert();
    new Email().putFields("id", "emailName", "userId");
    new Email().putValues("e1", "email1", "u1").insert();
    new Email().putValues("e2", "email2", "u1").insert();
    List<Map<String, Object>> listMap = ctx.nQuery(new EntitySqlMapListHandler(new Email().alias("e")), "select e.id as e_id from emailtb e");
    EntityNet net = (EntityNet) ctx.netCreate(listMap);
    Assert.assertEquals(2, net.size());
    Node emailNode = net.getOneNode(Email.class, "e1");
    // e1 have no userId
    Assert.assertNull(emailNode.getParentRelations());
    // field
    List<Map<String, Object>> listMap2 = ctx.nQuery(new EntitySqlMapListHandler(Email.class), "select e.** from emailtb e");
    ctx.netJoinList(net, listMap2);
    Assert.assertEquals(2, net.size());
    emailNode = net.getOneNode(Email.class, "e1");
    Assert.assertNotNull(emailNode.getParentRelations());
}

Example 7 with User

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

the class EntityNetQueryTest method testValidateByBeanValidator.

@Test
public void testValidateByBeanValidator() {
    // no cache
    System.out.println("==============testValidateByBeanValidator================ ");
    int sampleSize = 30;
    int queyrTimes = 60;
    for (int i = 0; i < sampleSize; i++) {
        new User().put("id", "usr" + i).put("userName", "user" + i).insert();
        for (int j = 0; j < sampleSize; j++) new Email().put("id", "email" + i + "_" + j, "userId", "usr" + i).insert();
    }
    EntityNet net = ctx.netLoad(User.class, Email.class);
    long start = System.currentTimeMillis();
    Set<Email> emails = null;
    // Set validator instance will not cache query result
    Path p = new Path("S-", User.class).nextPath("C+", Email.class, "userId").setValidator(new MyBeanValidator());
    for (int i = 0; i < queyrTimes; i++) {
        emails = net.findEntitySet(Email.class, p);
    }
    printTimeUsed(start, "Bean Validator instance (No Cache)");
    Assert.assertEquals(sampleSize * sampleSize, emails.size());
    // Set validator class will cache query result
    net.setAllowQueryCache(true);
    start = System.currentTimeMillis();
    p = new Path("S-", User.class).nextPath("C+", Email.class, "userId").setValidator(MyBeanValidator.class);
    for (int i = 0; i < queyrTimes; i++) {
        emails = net.findEntitySet(Email.class, p);
    }
    printTimeUsed(start, "Bean Validator instance (Has Cache)");
    Assert.assertEquals(sampleSize * sampleSize, emails.size());
}

Example 8 with User

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

the class EntityNetQueryTest method testValidateByExpression.

@Test
public void testValidateByExpression() {
    System.out.println("==============testValidateByExpression================ ");
    // no cache
    int sampleSize = 20;
    int queyrTimes = 20;
    for (int i = 0; i < sampleSize; i++) {
        new User().put("id", "usr" + i).put("userName", "user" + i).put("age", i).insert();
        for (int j = 0; j < sampleSize; j++) new Email().put("id", "email" + i + "_" + j, "userId", "usr" + i).insert();
    }
    EntityNet net = ctx.netLoad(User.class, Email.class);
    long start = System.currentTimeMillis();
    Set<Email> emails = null;
    // Set expression query parameters will not cache query result
    Path p = new Path("S-", User.class).where("age>?", 10).nextPath("C+", Email.class, "userId").where("id startwith ? or emailName=?", "email1", "Bar");
    for (int i = 0; i < queyrTimes; i++) {
        emails = net.findEntitySet(Email.class, p);
    }
    printTimeUsed(start, "Validate by expression with parameters");
    Assert.assertEquals(180, emails.size());
    // Do not have query parameters will cause query result be cached
    start = System.currentTimeMillis();
    p = new Path("S-", User.class).where("age>10").nextPath("C+", Email.class, "userId").where("id startwith 'email1' or emailName='Bar'");
    for (int i = 0; i < queyrTimes; i++) {
        emails = net.findEntitySet(Email.class, p);
    }
    printTimeUsed(start, "Validate by expression no parameters");
    Assert.assertEquals(180, emails.size());
}

Example 9 with User

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

the class EntityNetQueryTest method testFindParent.

@Test
public void testFindParent() {
    System.out.println("==============testFindParent================ ");
    int sampleSize = 20;
    int queyrTimes = 10;
    for (int i = 0; i < sampleSize; i++) {
        new User().put("id", "usr" + i).put("userName", "user" + i).insert();
        for (int j = 0; j < sampleSize; j++) new Email().put("id", "email" + i + "_" + j, "userId", "usr" + i).insert();
    }
    EntityNet net = ctx.netLoad(new User(), Email.class);
    Map<Class<?>, Set<Node>> result = null;
    long start = System.currentTimeMillis();
    start = System.currentTimeMillis();
    for (int i = 0; i < queyrTimes; i++) {
        result = net.findNodeMapByEntities(new Path("S+", Email.class).nextPath("P+", User.class, "userId"));
    }
    printTimeUsed(start, "Find parent (no cache)");
    System.out.println("user selected2:" + result.get(User.class).size());
    System.out.println("email selected2:" + result.get(Email.class).size());
}

Example 10 with User

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

the class EntityNetQueryTest method testUpdateEntity.

@Test
public void testUpdateEntity() {
    System.out.println("==============testUpdateEntity================ ");
    new User().put("id", "u1").put("userName", "user1").insert();
    new User().put("id", "u2").put("userName", "user2").insert();
    EntityNet net = ctx.netLoad(User.class);
    Assert.assertEquals(2, net.size());
    User u2 = net.getOneEntity(User.class, "u2");
    u2.setUserName("newName");
    ctx.netUpdateEntity(net, u2);
    u2 = net.getOneEntity(User.class, "u2");
    Assert.assertEquals("newName", u2.getUserName());
}