SHA256
251 lines
11 KiB
Java
251 lines
11 KiB
Java
package shine.db.dao;
|
||
|
||
import shine.db.DbController;
|
||
import shine.db.entities.KeyRotationCandidateBlockEntry;
|
||
|
||
import java.sql.Connection;
|
||
import java.sql.PreparedStatement;
|
||
import java.sql.ResultSet;
|
||
import java.sql.SQLException;
|
||
import java.sql.Statement;
|
||
import java.util.ArrayList;
|
||
import java.util.Arrays;
|
||
import java.util.List;
|
||
|
||
/** Хранилище candidate-блоков будущего fork во время ротации ключей. */
|
||
public final class KeyRotationCandidateBlocksDAO {
|
||
private static volatile KeyRotationCandidateBlocksDAO instance;
|
||
private final DbController db = DbController.getInstance();
|
||
|
||
private KeyRotationCandidateBlocksDAO() { }
|
||
|
||
public static KeyRotationCandidateBlocksDAO getInstance() {
|
||
if (instance == null) {
|
||
synchronized (KeyRotationCandidateBlocksDAO.class) {
|
||
if (instance == null) instance = new KeyRotationCandidateBlocksDAO();
|
||
}
|
||
}
|
||
return instance;
|
||
}
|
||
|
||
/**
|
||
* Идемпотентно сохраняет один candidate-блок.
|
||
* Повтор того же blockNumber допустим только при полном совпадении hash и DataItem id.
|
||
*/
|
||
public KeyRotationCandidateBlockEntry insertOrGet(Connection c, KeyRotationCandidateBlockEntry entry) throws SQLException {
|
||
KeyRotationCandidateBlockEntry existing = getByNumber(c, entry.getRotationSessionId(), entry.getBlockNumber());
|
||
if (existing != null) {
|
||
if (Arrays.equals(existing.getBlockHash(), entry.getBlockHash())
|
||
&& Arrays.equals(existing.getDataItemId(), entry.getDataItemId())) {
|
||
return existing;
|
||
}
|
||
throw new SQLException("Candidate block conflict at number=" + entry.getBlockNumber());
|
||
}
|
||
|
||
String sql = """
|
||
INSERT INTO key_rotation_candidate_blocks (
|
||
rotation_session_id, login, candidate_blockchain_name,
|
||
block_number, block_hash, data_item_id, block_bytes,
|
||
arweave_publish_pending, arweave_published_at_ms, created_at_ms
|
||
) VALUES (?, ?, ?, ?, ?, ?, ?, TRUE, NULL, ?)
|
||
""";
|
||
try (PreparedStatement ps = c.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS)) {
|
||
int i = 1;
|
||
ps.setLong(i++, entry.getRotationSessionId());
|
||
ps.setString(i++, entry.getLogin());
|
||
ps.setString(i++, entry.getCandidateBlockchainName());
|
||
ps.setInt(i++, entry.getBlockNumber());
|
||
ps.setBytes(i++, entry.getBlockHash());
|
||
ps.setBytes(i++, entry.getDataItemId());
|
||
ps.setBytes(i++, entry.getBlockBytes());
|
||
ps.setLong(i++, entry.getCreatedAtMs());
|
||
ps.executeUpdate();
|
||
try (ResultSet keys = ps.getGeneratedKeys()) {
|
||
if (!keys.next()) throw new SQLException("candidate block insert returned no id");
|
||
entry.setId(keys.getLong(1));
|
||
}
|
||
} catch (SQLException insertFailure) {
|
||
// Конкурирующий повтор из другой сессии мог успеть вставиться между SELECT и INSERT.
|
||
KeyRotationCandidateBlockEntry raced = getByNumber(c, entry.getRotationSessionId(), entry.getBlockNumber());
|
||
if (raced != null
|
||
&& Arrays.equals(raced.getBlockHash(), entry.getBlockHash())
|
||
&& Arrays.equals(raced.getDataItemId(), entry.getDataItemId())) {
|
||
return raced;
|
||
}
|
||
throw insertFailure;
|
||
}
|
||
entry.setArweavePublishPending(true);
|
||
return entry;
|
||
}
|
||
|
||
public KeyRotationCandidateBlockEntry getByNumber(Connection c, long sessionId, int blockNumber) throws SQLException {
|
||
try (PreparedStatement ps = c.prepareStatement("""
|
||
SELECT * FROM key_rotation_candidate_blocks
|
||
WHERE rotation_session_id = ? AND block_number = ?
|
||
""")) {
|
||
ps.setLong(1, sessionId);
|
||
ps.setInt(2, blockNumber);
|
||
try (ResultSet rs = ps.executeQuery()) {
|
||
return rs.next() ? map(rs) : null;
|
||
}
|
||
}
|
||
}
|
||
|
||
public int countStored(Connection c, long sessionId) throws SQLException {
|
||
try (PreparedStatement ps = c.prepareStatement("""
|
||
SELECT COUNT(*) FROM key_rotation_candidate_blocks WHERE rotation_session_id = ?
|
||
""")) {
|
||
ps.setLong(1, sessionId);
|
||
try (ResultSet rs = ps.executeQuery()) {
|
||
rs.next();
|
||
return rs.getInt(1);
|
||
}
|
||
}
|
||
}
|
||
|
||
public int countPublished(Connection c, long sessionId) throws SQLException {
|
||
try (PreparedStatement ps = c.prepareStatement("""
|
||
SELECT COUNT(*) FROM key_rotation_candidate_blocks
|
||
WHERE rotation_session_id = ? AND arweave_publish_pending = FALSE
|
||
""")) {
|
||
ps.setLong(1, sessionId);
|
||
try (ResultSet rs = ps.executeQuery()) {
|
||
rs.next();
|
||
return rs.getInt(1);
|
||
}
|
||
}
|
||
}
|
||
|
||
/** Все candidate-блоки одной ротации в строгом порядке block_number. */
|
||
public List<KeyRotationCandidateBlockEntry> listBySession(Connection c, long sessionId) throws SQLException {
|
||
try (PreparedStatement ps = c.prepareStatement("""
|
||
SELECT * FROM key_rotation_candidate_blocks
|
||
WHERE rotation_session_id = ?
|
||
ORDER BY block_number
|
||
""")) {
|
||
ps.setLong(1, sessionId);
|
||
List<KeyRotationCandidateBlockEntry> out = new ArrayList<>();
|
||
try (ResultSet rs = ps.executeQuery()) {
|
||
while (rs.next()) out.add(map(rs));
|
||
}
|
||
return out;
|
||
}
|
||
}
|
||
|
||
/** Возвращает ещё не опубликованный candidate DataItem для быстрой Turbo-попытки. */
|
||
public KeyRotationCandidateBlockEntry getPendingArweaveByDataItemId(byte[] dataItemId) throws SQLException {
|
||
if (dataItemId == null || dataItemId.length != 32) return null;
|
||
try (Connection c = db.getConnection();
|
||
PreparedStatement ps = c.prepareStatement("""
|
||
SELECT * FROM key_rotation_candidate_blocks
|
||
WHERE data_item_id = ? AND arweave_publish_pending = TRUE
|
||
LIMIT 1
|
||
""")) {
|
||
ps.setBytes(1, dataItemId);
|
||
try (ResultSet rs = ps.executeQuery()) { return rs.next() ? map(rs) : null; }
|
||
}
|
||
}
|
||
|
||
/** Candidate-блоки имеют приоритет перед обычной очередью publisher-а. */
|
||
public List<KeyRotationCandidateBlockEntry> listPendingArweave(int limit) throws SQLException {
|
||
if (limit <= 0) return List.of();
|
||
try (Connection c = db.getConnection();
|
||
PreparedStatement ps = c.prepareStatement("""
|
||
SELECT * FROM key_rotation_candidate_blocks
|
||
WHERE arweave_publish_pending = TRUE
|
||
ORDER BY id
|
||
LIMIT ?
|
||
""")) {
|
||
ps.setInt(1, limit);
|
||
List<KeyRotationCandidateBlockEntry> out = new ArrayList<>();
|
||
try (ResultSet rs = ps.executeQuery()) {
|
||
while (rs.next()) out.add(map(rs));
|
||
}
|
||
return out;
|
||
}
|
||
}
|
||
|
||
/**
|
||
* Помечает DataItem опубликованными и синхронизирует progress_current ротации
|
||
* с реальным количеством DataItem, подтверждённых publisher-ом.
|
||
*/
|
||
public void markArweavePublished(List<byte[]> dataItemIds, long publishedAtMs) throws SQLException {
|
||
if (dataItemIds == null || dataItemIds.isEmpty()) return;
|
||
try (Connection c = db.getConnection()) {
|
||
boolean oldAutoCommit = c.getAutoCommit();
|
||
c.setAutoCommit(false);
|
||
try {
|
||
java.util.Set<Long> sessions = new java.util.HashSet<>();
|
||
try (PreparedStatement find = c.prepareStatement("""
|
||
SELECT rotation_session_id
|
||
FROM key_rotation_candidate_blocks
|
||
WHERE data_item_id = ?
|
||
""")) {
|
||
for (byte[] id : dataItemIds) {
|
||
find.setBytes(1, id);
|
||
try (ResultSet rs = find.executeQuery()) {
|
||
if (rs.next()) sessions.add(rs.getLong(1));
|
||
}
|
||
}
|
||
}
|
||
|
||
try (PreparedStatement ps = c.prepareStatement("""
|
||
UPDATE key_rotation_candidate_blocks
|
||
SET arweave_publish_pending = FALSE,
|
||
arweave_published_at_ms = COALESCE(arweave_published_at_ms, ?)
|
||
WHERE data_item_id = ?
|
||
""")) {
|
||
for (byte[] id : dataItemIds) {
|
||
ps.setLong(1, publishedAtMs);
|
||
ps.setBytes(2, id);
|
||
ps.addBatch();
|
||
}
|
||
ps.executeBatch();
|
||
}
|
||
|
||
try (PreparedStatement progress = c.prepareStatement("""
|
||
UPDATE key_rotation_sessions s
|
||
SET progress_current = LEAST(s.progress_total, (
|
||
SELECT COUNT(*)::INTEGER
|
||
FROM key_rotation_candidate_blocks b
|
||
WHERE b.rotation_session_id = s.id
|
||
AND b.arweave_publish_pending = FALSE
|
||
)),
|
||
updated_at_ms = ?
|
||
WHERE s.id = ? AND s.status = 'COPYING_CHAIN'
|
||
""")) {
|
||
for (Long sessionId : sessions) {
|
||
progress.setLong(1, publishedAtMs);
|
||
progress.setLong(2, sessionId);
|
||
progress.addBatch();
|
||
}
|
||
progress.executeBatch();
|
||
}
|
||
c.commit();
|
||
} catch (Exception e) {
|
||
c.rollback();
|
||
if (e instanceof SQLException sql) throw sql;
|
||
throw new SQLException("Failed to mark candidate DataItems published", e);
|
||
} finally {
|
||
c.setAutoCommit(oldAutoCommit);
|
||
}
|
||
}
|
||
}
|
||
|
||
private static KeyRotationCandidateBlockEntry map(ResultSet rs) throws SQLException {
|
||
KeyRotationCandidateBlockEntry e = new KeyRotationCandidateBlockEntry();
|
||
e.setId(rs.getLong("id"));
|
||
e.setRotationSessionId(rs.getLong("rotation_session_id"));
|
||
e.setLogin(rs.getString("login"));
|
||
e.setCandidateBlockchainName(rs.getString("candidate_blockchain_name"));
|
||
e.setBlockNumber(rs.getInt("block_number"));
|
||
e.setBlockHash(rs.getBytes("block_hash"));
|
||
e.setDataItemId(rs.getBytes("data_item_id"));
|
||
e.setBlockBytes(rs.getBytes("block_bytes"));
|
||
e.setArweavePublishPending(rs.getBoolean("arweave_publish_pending"));
|
||
e.setArweavePublishedAtMs((Long) rs.getObject("arweave_published_at_ms"));
|
||
e.setCreatedAtMs(rs.getLong("created_at_ms"));
|
||
return e;
|
||
}
|
||
}
|