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

Example 26 with User

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

the class TinyParserTest method testParams.

@Test
public void testParams() {
    User user = new User();
    user.setId("001");
    user.setUserName("Tom");
    Assert.assertEquals(true, TinyParser.instance.doParse(user, null, "userName equals ? and id equals ?", "Tom", "001"));
    Assert.assertEquals(false, TinyParser.instance.doParse(user, null, "userName equals ? and id equals ?", "Tom", "002"));
}

Example 27 with User

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

the class TinyParserTest method testNull.

@Test
public void testNull() {
    Assert.assertEquals(false, TinyParser.instance.doParse(null, null, "null = 'abc'"));
    Assert.assertEquals(true, TinyParser.instance.doParse(null, null, "null <> 'abc'"));
    Assert.assertEquals(false, TinyParser.instance.doParse(null, null, "null >6"));
    Assert.assertEquals(false, TinyParser.instance.doParse(null, null, "6 >=null"));
    Assert.assertEquals(true, TinyParser.instance.doParse(null, null, "null is null"));
    User user = new User();
    user.setUserName("Tom");
    Assert.assertEquals(false, TinyParser.instance.doParse(user, null, "not(id is null)"));
    Map<String, Object> preset = new HashMap<String, Object>();
    preset.put("FOO", null);
    Assert.assertEquals(true, TinyParser.instance.doParse(null, preset, "FOO is NULL"));
}

Example 28 with User

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

the class TinyParserTest method testBeanField.

@Test
public void testBeanField() {
    User user = new User();
    user.setUserName("Tom");
    user.setAge(5);
    Assert.assertEquals(true, TinyParser.instance.doParse(user, null, "userName equals 'Tom'"));
    Assert.assertEquals(false, TinyParser.instance.doParse(user, null, "userName equals 'tom'"));
    Assert.assertEquals(true, TinyParser.instance.doParse(user, null, "userName equalsIgnoreCase 'Tom'"));
    Assert.assertEquals(true, TinyParser.instance.doParse(user, null, "userName startWith ? and not(age*(10+2) -age>?)", "T", 100));
}

Example 29 with User

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

the class UsuageAndSpeedTest method activeRecordDefaultContext.

@Test
public void activeRecordDefaultContext() {
    SqlBoxContext ctx = new SqlBoxContext(dataSource);
    // use global default context
    SqlBoxContext.setGlobalSqlBoxContext(ctx);
    UserAR user = new UserAR();
    for (int i = 0; i < REPEAT_TIMES; i++) {
        user.setName("Sam");
        user.setAddress("Canada");
        user.insert();
        user.setAddress("China");
        user.update();
        UserAR user2 = ctx.load(UserAR.class, "Sam");
        user2.delete();
    }
}

Example 30 with User

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

the class UsuageAndSpeedTest method init.

@Before
public void init() {
    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 ctx = new SqlBoxContext(dataSource);
    SqlBoxContext.setGlobalSqlBoxContext(null);
    for (String ddl : ctx.getDialect().toDropAndCreateDDL(UserAR.class)) try {
        ctx.nExecute(ddl);
    } catch (Exception e) {
    }
}