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

Example 1 with User

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

the class LoggerTest method doSqlBoxLoggerTest.

@Test
public void doSqlBoxLoggerTest() {
    HikariDataSource dataSource = new HikariDataSource();
    dataSource.setJdbcUrl("jdbc:h2:mem:DBName;MODE=MYSQL;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=0");
    dataSource.setDriverClassName("org.h2.Driver");
    // change to your user & password
    dataSource.setUsername("sa");
    dataSource.setPassword("");
    SqlBoxContext.setGlobalAllowShowSql(true);
    SqlBoxContext ctx = new SqlBoxContext(dataSource);
    for (String ddl : ctx.getDialect().toDropAndCreateDDL(LoggerTest.class)) ctx.quiteExecute(ddl);
    LoggerTest t = new LoggerTest();
    t.setName("Tom");
    ctx.insert(t);
    SqlBoxContext.setGlobalAllowShowSql(false);
    SqlBoxContext.getGlobalLogger().info("Logger test message3 output ok");
    SqlBoxContext.getGlobalLogger().info("Logger test message4 output ok");
}

Example 2 with User

use of com.github.drinkjava2.functionstest.entitynet.entities.User 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"));
}

Example 3 with User

use of com.github.drinkjava2.functionstest.entitynet.entities.User 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());
}

Example 4 with User

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

the class EntityNetDemoTest method testReturnDifferentType.

@Test
public void testReturnDifferentType() {
    insertDemoData();
    EntityNet net = ctx.netLoad(new User(), new Email());
    Map<Class<?>, Set<Object>> result = net.findEntityMap(new Path("S+", Email.class).nextPath("P+", User.class, "userId"));
    System.out.println("user selected:" + result.get(User.class).size());
    System.out.println("email selected:" + result.get(Email.class).size());
}

Example 5 with User

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

the class EntityNetQueryTest method testEntityListHandler.

@Test
public void testEntityListHandler() {
    System.out.println("==============testJoinFields================ ");
    new User().put("id", "u1").put("userName", "user1").put("age", 10).insert();
    new User().put("id", "u2").put("userName", "user2").put("age", 20).insert();
    new User().put("id", "u3").put("userName", "user3").put("age", 30).insert();
    List<User> setResult = ctx.nQuery(new EntityListHandler(User.class), "select u.** from usertb u where u.age>?", 10);
    Assert.assertTrue(setResult.size() == 2);
}