-
Notifications
You must be signed in to change notification settings - Fork 10
Expand file tree
/
Copy pathLambda2SqlTest.java
More file actions
42 lines (35 loc) · 1.32 KB
/
Lambda2SqlTest.java
File metadata and controls
42 lines (35 loc) · 1.32 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
package lambda2sql;
import org.junit.Assert;
import org.junit.Test;
public class Lambda2SqlTest {
@Test
public void testComparisons() {
assertEqual("age = 1", e -> e.getAge() == 1);
assertEqual("age > 1", e -> e.getAge() > 1);
assertEqual("age < 1", e -> e.getAge() < 1);
assertEqual("age >= 1", e -> e.getAge() >= 1);
assertEqual("age <= 1", e -> e.getAge() <= 1);
assertEqual("age != 1", e -> e.getAge() != 1);
}
@Test
public void testLogicalOps() {
assertEqual("!isActive", e -> !e.isActive());
assertEqual("age < 100 AND height > 200", e -> e.getAge() < 100 && e.getHeight() > 200);
assertEqual("age < 100 OR height > 200", e -> e.getAge() < 100 || e.getHeight() > 200);
}
@Test
public void testMultipleLogicalOps() {
assertEqual("isActive AND (age < 100 OR height > 200)", e -> e.isActive() && (e.getAge() < 100 || e.getHeight() > 200));
assertEqual("(age < 100 OR height > 200) AND isActive", e -> (e.getAge() < 100 || e.getHeight() > 200) && e.isActive());
}
@Test
public void testWithVariables() {
String name = "Donald";
int age = 80;
assertEqual("name = 'Donald' AND age > 80", person -> person.getName() == name && person.getAge() > age);
}
private void assertEqual(String expectedSql, SqlPredicate<Person> p) {
String sql = Lambda2Sql.toSql(p);
Assert.assertEquals(expectedSql, sql);
}
}