/** * Returns a comma separated list of tracked domain event column names to select from an event entry. * * @return comma separated tracked domain event column names. */ protected String trackedEventFields() { return schema.globalIndexColumn() + ", " + domainEventFields(); }
/** * Creates a statement to read the snapshot entry of an aggregate with given identifier. * * @param connection The connection to the database. * @param identifier The aggregate identifier. * @return A {@link PreparedStatement} that returns the last snapshot entry of the aggregate (if any) when executed. * * @throws SQLException when an exception occurs while creating the prepared statement. */ protected PreparedStatement readSnapshotData(Connection connection, String identifier) throws SQLException { final String s = "SELECT " + domainEventFields() + " FROM " + schema.snapshotTable() + " WHERE " + schema.aggregateIdentifierColumn() + " = ? ORDER BY " + schema.sequenceNumberColumn() + " DESC"; PreparedStatement statement = connection.prepareStatement(s); statement.setString(1, identifier); return statement; }
/** * Returns a comma separated list of tracked domain event column names to select from an event entry. * * @return comma separated tracked domain event column names. */ protected String trackedEventFields() { return schema.globalIndexColumn() + ", " + domainEventFields(); }
/** * Returns a comma separated list of tracked domain event column names to select from an event entry. * * @return comma separated tracked domain event column names. */ protected String trackedEventFields() { return schema.globalIndexColumn() + ", " + domainEventFields(); }
/** * Creates a statement to read the snapshot entry of an aggregate with given identifier. * * @param connection The connection to the database. * @param identifier The aggregate identifier. * @return A {@link PreparedStatement} that returns the last snapshot entry of the aggregate (if any) when executed. * * @throws SQLException when an exception occurs while creating the prepared statement. */ protected PreparedStatement readSnapshotData(Connection connection, String identifier) throws SQLException { final String s = "SELECT " + domainEventFields() + " FROM " + schema.snapshotTable() + " WHERE " + schema.aggregateIdentifierColumn() + " = ? ORDER BY " + schema.sequenceNumberColumn() + " DESC"; PreparedStatement statement = connection.prepareStatement(s); statement.setString(1, identifier); return statement; }
/** * Creates a statement to read the snapshot entry of an aggregate with given identifier. * * @param connection The connection to the database. * @param identifier The aggregate identifier. * @return A {@link PreparedStatement} that returns the last snapshot entry of the aggregate (if any) when executed. * @throws SQLException when an exception occurs while creating the prepared statement. */ protected PreparedStatement readSnapshotData(Connection connection, String identifier) throws SQLException { final String s = "SELECT " + domainEventFields() + " FROM " + schema.snapshotTable() + " WHERE " + schema.aggregateIdentifierColumn() + " = ? ORDER BY " + schema.sequenceNumberColumn() + " DESC"; PreparedStatement statement = connection.prepareStatement(s); statement.setString(1, identifier); return statement; }