Newer
Older
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
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
package unibz.cs.semint.kprime.domain
import org.junit.Test
import unibz.cs.semint.kprime.adapter.service.XMLSerializerJacksonAdapter
import unibz.cs.semint.kprime.domain.dql.*
import unibz.cs.semint.kprime.usecase.SQLizeUseCase
class QueryTest {
private fun simpleQueryFixture(tableName:String): Query {
val query = Query()
var select = query.select
var attr = Attribute()
attr.name = "Name"
select.attributes.add(attr)
attr = Attribute()
attr.name = "Surname"
select.attributes.add(attr)
val fromT1 = From()
fromT1.tableName = tableName
select.from.add(fromT1)
select.where.condition = "Name='Gigi'"
return query
}
private fun unionFixtureQuery(): Query {
var query = Query()
query.select = simpleQueryFixture("Table1").select
var simple2 = simpleQueryFixture("Table2")
val union = Union()
union.selects.add(simple2.select)
query.union.add(union)
return query
}
@Test
fun test_from_simple_query_to_xml() {
// given
val query = simpleQueryFixture("Table1")
// when
var queryXml = XMLSerializerJacksonAdapter().prettyQuery(query) as String
// then
println(queryXml)
}
@Test
fun test_from_simple_query_to_sql() {
// given
val query = simpleQueryFixture("Table1")
// when
var queryXml = SQLizeUseCase().sqlize(query)
// then
println(queryXml)
}
@Test
fun test_from_union_query_to_xml() {
// given
val query = unionFixtureQuery()
// when
var queryXml = XMLSerializerJacksonAdapter().prettyQuery(query) as String
// then
println(queryXml)
}
@Test
fun test_from_union_query_to_sql() {
// given
val query = unionFixtureQuery()
// when
var queryXml = SQLizeUseCase().sqlize(query)
// then
println(queryXml)
}
@Test
fun test_from_xml_to_query() {
}
@Test
fun test_from_sql_to_query() {
}
}