/
MDatabase.java
201 lines (175 loc) · 5.72 KB
/
MDatabase.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
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
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
/*
* Copyright © 2022 Mark Raynsford <code@io7m.com> https://www.io7m.com
*
* Permission to use, copy, modify, and/or distribute this software for any
* purpose with or without fee is hereby granted, provided that the above
* copyright notice and this permission notice appear in all copies.
*
* THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
* WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF
* MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY
* SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES
* WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN
* ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF OR
* IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.
*/
package com.io7m.mesquida.internal.database;
import com.io7m.trasco.api.TrArguments;
import com.io7m.trasco.api.TrEventExecutingSQL;
import com.io7m.trasco.api.TrEventType;
import com.io7m.trasco.api.TrEventUpgrading;
import com.io7m.trasco.api.TrExecutorConfiguration;
import com.io7m.trasco.api.TrSchemaRevisionSet;
import com.io7m.trasco.vanilla.TrExecutors;
import com.io7m.trasco.vanilla.TrSchemaRevisionSetParsers;
import org.apache.derby.jdbc.EmbeddedConnectionPoolDataSource;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import java.io.Closeable;
import java.math.BigInteger;
import java.net.URI;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Objects;
import java.util.Optional;
import static com.io7m.trasco.api.TrExecutorUpgrade.FAIL_INSTEAD_OF_UPGRADING;
import static com.io7m.trasco.api.TrExecutorUpgrade.PERFORM_UPGRADES;
import static java.math.BigInteger.valueOf;
/**
* The main database.
*/
public final class MDatabase implements Closeable
{
private static final Logger LOG =
LoggerFactory.getLogger(MDatabase.class);
private static final String LANG_SCHEMA_DOES_NOT_EXIST = "42Y07";
private static final String LANG_TABLE_NOT_FOUND = "42X05";
private final EmbeddedConnectionPoolDataSource dataSource;
private MDatabase(
final EmbeddedConnectionPoolDataSource inDataSource)
{
this.dataSource =
Objects.requireNonNull(inDataSource, "dataSource");
}
/**
* Open a database.
*
* @param configuration The database configuration
*
* @return The database
*
* @throws Exception On errors
*/
public static MDatabase open(
final MDatabaseConfiguration configuration)
throws Exception
{
final var dataSource = new EmbeddedConnectionPoolDataSource();
dataSource.setDatabaseName(configuration.file().toString());
dataSource.setCreateDatabase("true");
dataSource.setConnectionAttributes("create=" + configuration.create());
final var parsers =
new TrSchemaRevisionSetParsers();
final TrSchemaRevisionSet revisions;
try (var stream = MDatabase.class.getResourceAsStream(
"/com/io7m/mesquida/internal/database.xml")) {
revisions = parsers.parse(URI.create("urn:source"), stream);
}
try (var connection = dataSource.getConnection()) {
connection.setAutoCommit(false);
new TrExecutors().create(
new TrExecutorConfiguration(
MDatabase::schemaVersionGet,
MDatabase::schemaVersionSet,
MDatabase::showEvent,
revisions,
configuration.upgrade() ? PERFORM_UPGRADES : FAIL_INSTEAD_OF_UPGRADING,
TrArguments.empty(),
connection
)
).execute();
connection.commit();
}
return new MDatabase(dataSource);
}
private static void showEvent(
final TrEventType event)
{
if (event instanceof TrEventExecutingSQL sql) {
LOG.debug("executing: {}", sql);
return;
}
if (event instanceof TrEventUpgrading upgrading) {
LOG.info(
"upgrading database from version {} -> {}",
upgrading.fromVersion(),
upgrading.toVersion()
);
}
}
private static void schemaVersionSet(
final BigInteger version,
final Connection connection)
throws SQLException
{
final String statementText;
if (Objects.equals(version, BigInteger.ZERO)) {
statementText = "insert into schema_version (version_number) values (?)";
} else {
statementText = "update schema_version set version_number = ?";
}
try (var statement = connection.prepareStatement(statementText)) {
statement.setLong(1, version.longValueExact());
statement.execute();
}
}
private static Optional<BigInteger> schemaVersionGet(
final Connection connection)
throws SQLException
{
Objects.requireNonNull(connection, "connection");
try {
final var statementText = "SELECT version_number FROM schema_version";
LOG.debug("execute: {}", statementText);
try (var statement = connection.prepareStatement(statementText)) {
try (var result = statement.executeQuery()) {
if (!result.next()) {
throw new SQLException("schema_version table is empty!");
}
return Optional.of(valueOf(result.getLong(1)));
}
}
} catch (final SQLException e) {
final var state = e.getSQLState();
if (state == null) {
throw e;
}
switch (state) {
case LANG_SCHEMA_DOES_NOT_EXIST:
case LANG_TABLE_NOT_FOUND: {
return Optional.empty();
}
default: {
throw e;
}
}
}
}
/**
* @return An SQL connection
*
* @throws SQLException On errors
*/
public Connection openConnection()
throws SQLException
{
final var connection =
this.dataSource.getPooledConnection().getConnection();
connection.setAutoCommit(false);
return connection;
}
@Override
public void close()
{
}
}