@Test
public void test_intProperty() {
IntProperty intProperty = PropertyFactory.from(5);
assertEquals("5", intProperty.getQuery());
QueryBuilder queryBuilder = new QueryBuilder();
intProperty.greaterThan(TestModel2_Table.model_order).appendConditionToQuery(queryBuilder);
assertEquals("5>`model_order`", queryBuilder.getQuery().trim());
}
@Test
public void test_byteProperty() {
ByteProperty byteProperty = PropertyFactory.from((byte) 5);
assertEquals("5", byteProperty.getQuery());
QueryBuilder queryBuilder = new QueryBuilder();
byteProperty.in((byte) 6, (byte) 7, (byte) 8, (byte) 9).appendConditionToQuery(queryBuilder);
assertEquals("5 IN (6,7,8,9)", queryBuilder.getQuery().trim());
}
@Test
public void test_stringProperty() {
Property<String> stringProperty = PropertyFactory.from("MyGirl");
assertEquals("'MyGirl'", stringProperty.getQuery());
QueryBuilder queryBuilder = new QueryBuilder();
stringProperty.concatenate("Talkin' About").appendConditionToQuery(queryBuilder);
assertEquals("'MyGirl'='MyGirl' || 'Talkin'' About'", queryBuilder.getQuery().trim());
}
@Test
public void test_charProperty() {
CharProperty charProperty = PropertyFactory.from('c');
assertEquals("'c'", charProperty.getQuery());
QueryBuilder queryBuilder = new QueryBuilder();
charProperty.between('d').and('e').appendConditionToQuery(queryBuilder);
assertEquals("'c' BETWEEN 'd' AND 'e'", queryBuilder.getQuery().trim());
}
@Test
public void test_doubleProperty() {
DoubleProperty doubleProperty = PropertyFactory.from(10d);
assertEquals("10.0", doubleProperty.getQuery());
QueryBuilder queryBuilder = new QueryBuilder();
doubleProperty
.plus(ConditionModel_Table.fraction)
.lessThan(ConditionModel_Table.fraction)
.appendConditionToQuery(queryBuilder);
assertEquals("10.0 + `fraction`<`fraction`", queryBuilder.getQuery().trim());
}
@Test
public void test_queryProperty() {
Property<TestModel1> model1Property =
PropertyFactory.from(
SQLite.select().from(TestModel1.class).where(TestModel1_Table.name.eq("Test")))
.as("Cool");
assertEquals(
"(SELECT * FROM `TestModel1` WHERE `name`='Test') AS `Cool`",
model1Property.getDefinition());
QueryBuilder queryBuilder = new QueryBuilder();
model1Property
.minus(ConditionModel_Table.fraction)
.plus(TestModel1_Table.name.withTable())
.like("%somethingnotvalid%")
.appendConditionToQuery(queryBuilder);
assertEquals(
"(SELECT * FROM `TestModel1` WHERE `name`='Test') - `fraction` + `TestModel1`.`name` LIKE '%somethingnotvalid%'",
queryBuilder.getQuery().trim());
}
@Override
public String getQuery() {
QueryBuilder queryBuilder = new QueryBuilder("SELECT ");
if (mSelectQualifier != NONE) {
if (mSelectQualifier == DISTINCT) {
queryBuilder.append("DISTINCT");
} else if (mSelectQualifier == ALL) {
queryBuilder.append("ALL");
}
queryBuilder.appendSpace();
}
queryBuilder.append(QueryBuilder.join(",", propertyList));
queryBuilder.appendSpace();
return queryBuilder.getQuery();
}