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
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
|
/*******************************************************************************
* Copyright (c) 2014 Boeing.
* All rights reserved. This program and the accompanying materials
* are made available under the terms of the Eclipse Public License v1.0
* which accompanies this distribution, and is available at
* http://www.eclipse.org/legal/epl-v10.html
*
* Contributors:
* Boeing - initial API and implementation
*******************************************************************************/
package org.eclipse.osee.jdbc;
import static org.junit.Assert.assertEquals;
import java.io.File;
import java.io.IOException;
import java.net.URL;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Collections;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import org.eclipse.osee.framework.jdk.core.type.IVariantData;
import org.junit.After;
import org.junit.Before;
import org.junit.Rule;
import org.junit.Test;
import org.junit.rules.TemporaryFolder;
import org.mockito.MockitoAnnotations;
/**
* Test Case for {@link JdbcClient, JdbcServer}
*
* @author Roberto E. Escobar
*/
public class JdbcReadWriteTest {
private static final Object[][] DB_DATA = new Object[][] {
{1, "The Odyssey", "Homer"},
{2, "Pride and Prejudice", "Jane Austen"},
{3, "Romeo and Juliet", "William Shakespeare"},
{4, "The Great Gatsby", "F. Scott Fitzgerald"}};
@Rule
public TemporaryFolder folder = new TemporaryFolder();
private JdbcServer server;
private int dbPort;
private String dbName;
private JdbcClient client;
@Before
public void setUp() throws IOException {
MockitoAnnotations.initMocks(this);
File newFile = folder.newFile("hsql.db.read.write.test");
server = JdbcServerBuilder.hsql(newFile.toURI().toASCIIString())//
.useRandomPort(true) //
.build();
JdbcServerConfig config = server.getConfig();
dbName = config.getDbName();
dbPort = config.getDbPort();
server.start();
client = JdbcClientBuilder.hsql(dbName, dbPort).build();
}
@After
public void tearDown() {
server.stop();
}
@Test
public void testCreateReadAndWrite() {
JdbcMigrationResource migrationResource = new JdbcMigrationResource() {
@Override
public boolean isApplicable(JdbcClientConfig config) {
return true;
}
@Override
public URL getLocation() {
return getClass().getResource("migration");
}
@Override
public void addPlaceholders(Map<String, String> placeholders) {
// do nothing
}
};
client.migrate(new JdbcMigrationOptions(true, true), Collections.singleton(migrationResource));
client.runBatchUpdate("insert into books (id, title, author) values (?,?,?)", Arrays.asList(DB_DATA));
List<Book> books = new ArrayList<>();
client.runQuery(newBookProcessor(books), "select * from books");
assertEquals(4, books.size());
Iterator<Book> iterator = books.iterator();
assertBook(iterator.next(), 1, "The Odyssey", "Homer");
assertBook(iterator.next(), 2, "Pride and Prejudice", "Jane Austen");
assertBook(iterator.next(), 3, "Romeo and Juliet", "William Shakespeare");
assertBook(iterator.next(), 4, "The Great Gatsby", "F. Scott Fitzgerald");
assertEquals("William Shakespeare",
client.runPreparedQueryFetchObject("", "select author from books where id = ?", 3));
client.runPreparedUpdate("insert into books (id, title, author) values (?,?,?)", 5, "Dracula", "Bram Stoker");
assertEquals("Dracula", client.runPreparedQueryFetchObject("", "select title from books where id = ?", 5));
client.runTransaction(new JdbcTransaction() {
@Override
public void handleTxWork(JdbcConnection connection) {
client.runPreparedUpdate(connection, "insert into books (id, title, author) values (?,?,?)", 6,
"Lord of the Flies", "William Golding");
}
});
assertEquals("Lord of the Flies",
client.runPreparedQueryFetchObject("", "select title from books where id = ?", 6));
Iterator<IVariantData> it = client.runQuery("select * from books").iterator();
assertVariant(it.next(), "1", "The Odyssey", "Homer");
assertVariant(it.next(), "2", "Pride and Prejudice", "Jane Austen");
assertVariant(it.next(), "3", "Romeo and Juliet", "William Shakespeare");
assertVariant(it.next(), "4", "The Great Gatsby", "F. Scott Fitzgerald");
assertVariant(it.next(), "5", "Dracula", "Bram Stoker");
assertVariant(it.next(), "6", "Lord of the Flies", "William Golding");
}
private static JdbcProcessor newBookProcessor(final List<Book> books) {
return new JdbcProcessor() {
@Override
public void processNext(JdbcStatement chStmt) {
books.add(new Book(chStmt.getInt("id"), chStmt.getString("title"), chStmt.getString("author")));
}
};
}
private static void assertVariant(IVariantData data, String id, String title, String author) {
assertEquals(id, data.get("ID"));
assertEquals(title, data.get("TITLE"));
assertEquals(author, data.get("AUTHOR"));
}
private static void assertBook(Book book, int id, String title, String author) {
assertEquals(id, book.getId());
assertEquals(title, book.getTitle());
assertEquals(author, book.getAuthor());
}
private static final class Book {
private final int id;
private final String title;
private final String author;
public Book(int id, String title, String author) {
super();
this.id = id;
this.title = title;
this.author = author;
}
public int getId() {
return id;
}
public String getTitle() {
return title;
}
public String getAuthor() {
return author;
}
}
public static Object[] row(Object... row) {
return row;
}
}
|
