forked from croc-code/sql-boot
-
Notifications
You must be signed in to change notification settings - Fork 0
/
JdbcSqlQueryTest.java
77 lines (68 loc) · 2.91 KB
/
JdbcSqlQueryTest.java
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
/**
* The MIT License (MIT)
* <p>
* Copyright (c) 2016-2017 Maksim Gramin
* <p>
* Permission is hereby granted, free of charge, to any person obtaining a copy
* of this software and associated documentation files (the "Software"), to deal
* in the Software without restriction, including without limitation the rights
* to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
* copies of the Software, and to permit persons to whom the Software is
* furnished to do so, subject to the following conditions:
* <p>
* The above copyright notice and this permission notice shall be included
* in all copies or substantial portions of the Software.
* <p>
* THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
* IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
* FITNESS FOR A PARTICULAR PURPOSE AND NON-INFRINGEMENT. IN NO EVENT SHALL THE
* AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
* LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
* OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
* SOFTWARE.
*/
package com.github.mgramin.sqlboot.sql.impl;
import static java.util.stream.Collectors.toList;
import static org.junit.Assert.assertEquals;
import com.github.mgramin.sqlboot.sql.SqlQuery;
import com.github.mgramin.sqlboot.template.generator.impl.GroovyTemplateGenerator;
import java.util.List;
import java.util.Map;
import javax.sql.DataSource;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringRunner;
/**
* @author Maksim Gramin (mgramin@gmail.com)
* @version $Id$
* @since 0.1
*/
@RunWith(SpringRunner.class)
@ContextConfiguration(locations = {"/test_config.xml"})
public class JdbcSqlQueryTest {
@Autowired
DataSource dataSource;
@Test
public void select() {
final List<Map<String, Object>> select = new JdbcSqlQuery(dataSource,
"select * from (select name AS \"n\", email as \"mail\" from main_schema.users)")
.select().collect(toList());
assertEquals(select.toString(),
"[{n=mkyong, mail=mkyong@gmail.com}, {n=alex, mail=alex@yahoo.com}, {n=joel, mail=joel@gmail.com}]");
}
@Test
public void medataData() throws Exception {
SqlQuery sqlQuery = new JdbcSqlQuery(dataSource,
new GroovyTemplateGenerator("select name /* name */, email /* email */ from main_schema.users"));
final Map<String, String> metadata = sqlQuery.metaData();
System.out.println(metadata);
assertEquals("email", metadata.get("email"));
assertEquals("name", metadata.get("name"));
}
@Test
public void dbHealth() throws Exception {
new JdbcSqlQuery(dataSource, "").dbHealth();
}
}