congrats Icon
New! Tabnine Pro 14-day free trial
Start a free trial
Tabnine Logo
EventSchema.sequenceNumberColumn
Code IndexAdd Tabnine to your IDE (free)

How to use
sequenceNumberColumn
method
in
org.axonframework.eventsourcing.eventstore.jdbc.EventSchema

Best Java code snippets using org.axonframework.eventsourcing.eventstore.jdbc.EventSchema.sequenceNumberColumn (Showing top 20 results out of 315)

origin: AxonFramework/AxonFramework

/**
 * Creates a statement to delete all snapshots of the aggregate with given {@code aggregateIdentifier}.
 *
 * @param connection          The connection to the database.
 * @param aggregateIdentifier The identifier of the aggregate whose snapshots to delete.
 * @return A {@link PreparedStatement} that deletes all the aggregate's snapshots when executed.
 *
 * @throws SQLException when an exception occurs while creating the prepared statement.
 */
protected PreparedStatement deleteSnapshots(Connection connection, String aggregateIdentifier, long sequenceNumber)
    throws SQLException {
  PreparedStatement preparedStatement = connection.prepareStatement(
      "DELETE FROM " + schema.snapshotTable() + " WHERE " + schema.aggregateIdentifierColumn() + " = ? "
          + "AND " + schema.sequenceNumberColumn() + " < ?"
  );
  preparedStatement.setString(1, aggregateIdentifier);
  preparedStatement.setLong(2, sequenceNumber);
  return preparedStatement;
}
origin: AxonFramework/AxonFramework

/**
 * Creates a statement to read domain event entries for an aggregate with given identifier starting with the first
 * entry having a sequence number that is equal or larger than the given {@code firstSequenceNumber}.
 *
 * @param connection          The connection to the database.
 * @param identifier          The identifier of the aggregate.
 * @param firstSequenceNumber The expected sequence number of the first returned entry.
 * @param batchSize           The number of items to include in the batch
 * @return A {@link PreparedStatement} that returns event entries for the given query when executed.
 *
 * @throws SQLException when an exception occurs while creating the prepared statement.
 */
protected PreparedStatement readEventData(Connection connection, String identifier,
                     long firstSequenceNumber, int batchSize) throws SQLException {
  Transaction tx = transactionManager.startTransaction();
  try {
    final String sql = "SELECT " + trackedEventFields() + " FROM " + schema.domainEventTable() + " WHERE " +
        schema.aggregateIdentifierColumn() + " = ? AND " + schema.sequenceNumberColumn() + " >= ? AND " +
        schema.sequenceNumberColumn() + " < ? ORDER BY " + schema.sequenceNumberColumn() + " ASC";
    PreparedStatement preparedStatement = connection.prepareStatement(sql);
    preparedStatement.setString(1, identifier);
    preparedStatement.setLong(2, firstSequenceNumber);
    preparedStatement.setLong(3, firstSequenceNumber + batchSize);
    return preparedStatement;
  } finally {
    tx.commit();
  }
}
origin: AxonFramework/AxonFramework

/**
 * 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;
}
origin: AxonFramework/AxonFramework

@Override
public Optional<Long> lastSequenceNumberFor(String aggregateIdentifier) {
  String sql = "SELECT max(" + schema.sequenceNumberColumn() + ") FROM " + schema.domainEventTable() +
      " WHERE " + schema.aggregateIdentifierColumn() + " = ?";
  return Optional.ofNullable(transactionManager.fetchInTransaction(
      () -> executeQuery(getConnection(), connection -> {
                  PreparedStatement stmt = connection.prepareStatement(sql);
                  stmt.setString(1, aggregateIdentifier);
                  return stmt;
                },
                resultSet -> nextAndExtract(resultSet, 1, Long.class),
                e -> new EventStoreException(
                    format("Failed to read events for aggregate [%s]", aggregateIdentifier), e
                )
      )));
}
origin: AxonFramework/AxonFramework

/**
 * Extracts the next domain event entry from the given {@code resultSet}.
 *
 * @param resultSet The results of a query for domain events of an aggregate.
 * @return The next domain event.
 *
 * @throws SQLException when an exception occurs while creating the event data.
 */
protected DomainEventData<?> getDomainEventData(ResultSet resultSet) throws SQLException {
  return new GenericDomainEventEntry<>(resultSet.getString(schema.typeColumn()),
                     resultSet.getString(schema.aggregateIdentifierColumn()),
                     resultSet.getLong(schema.sequenceNumberColumn()),
                     resultSet.getString(schema.eventIdentifierColumn()),
                     readTimeStamp(resultSet, schema.timestampColumn()),
                     resultSet.getString(schema.payloadTypeColumn()),
                     resultSet.getString(schema.payloadRevisionColumn()),
                     readPayload(resultSet, schema.payloadColumn()),
                     readPayload(resultSet, schema.metaDataColumn()));
}
origin: AxonFramework/AxonFramework

/**
 * Extracts the next snapshot entry from the given {@code resultSet}.
 *
 * @param resultSet The results of a query for a snapshot of an aggregate.
 * @return The next snapshot data.
 *
 * @throws SQLException when an exception occurs while creating the event data.
 */
protected DomainEventData<?> getSnapshotData(ResultSet resultSet) throws SQLException {
  return new GenericDomainEventEntry<>(resultSet.getString(schema.typeColumn()),
                     resultSet.getString(schema.aggregateIdentifierColumn()),
                     resultSet.getLong(schema.sequenceNumberColumn()),
                     resultSet.getString(schema.eventIdentifierColumn()),
                     readTimeStamp(resultSet, schema.timestampColumn()),
                     resultSet.getString(schema.payloadTypeColumn()),
                     resultSet.getString(schema.payloadRevisionColumn()),
                     readPayload(resultSet, schema.payloadColumn()),
                     readPayload(resultSet, schema.metaDataColumn()));
}
origin: AxonFramework/AxonFramework

/**
 * Returns a comma separated list of domain event column names to select from an event or snapshot entry.
 *
 * @return comma separated domain event column names.
 */
protected String domainEventFields() {
  return String.join(", ", schema.eventIdentifierColumn(), schema.timestampColumn(), schema.payloadTypeColumn(),
            schema.payloadRevisionColumn(), schema.payloadColumn(), schema.metaDataColumn(),
            schema.typeColumn(), schema.aggregateIdentifierColumn(), schema.sequenceNumberColumn());
}
origin: AxonFramework/AxonFramework

resultSet.getString(schema.typeColumn()),
resultSet.getString(schema.aggregateIdentifierColumn()),
resultSet.getLong(schema.sequenceNumberColumn()),
resultSet.getString(schema.eventIdentifierColumn()),
readTimeStamp(resultSet, schema.timestampColumn()),
origin: AxonFramework/AxonFramework

@Override
public PreparedStatement createSnapshotEventTable(Connection connection, EventSchema schema) throws SQLException {
  String sql = "CREATE TABLE " + schema.snapshotTable() + " (\n" +
      schema.aggregateIdentifierColumn() + " VARCHAR(255) NOT NULL,\n" +
      schema.sequenceNumberColumn() + " NUMBER(19) NOT NULL,\n" +
      schema.typeColumn() + " VARCHAR(255) NOT NULL,\n" +
      schema.eventIdentifierColumn() + " VARCHAR(255) NOT NULL,\n" +
      schema.metaDataColumn() + " " + payloadType() + ",\n" +
      schema.payloadColumn() + " " + payloadType() + " NOT NULL,\n" +
      schema.payloadRevisionColumn() + " VARCHAR(255),\n" +
      schema.payloadTypeColumn() + " VARCHAR(255) NOT NULL,\n" +
      schema.timestampColumn() + " VARCHAR(255) NOT NULL,\n" +
      "PRIMARY KEY (" + schema.aggregateIdentifierColumn() + ", " +
      schema.sequenceNumberColumn() + "),\n" +
      "UNIQUE (" + schema.eventIdentifierColumn() + ")\n" +
      ")";
  return connection.prepareStatement(sql);
}
origin: AxonFramework/AxonFramework

@Override
public PreparedStatement createSnapshotEventTable(Connection connection,
                         EventSchema schema) throws SQLException {
  String sql = "CREATE TABLE IF NOT EXISTS " + schema.snapshotTable() + " (\n" +
      schema.aggregateIdentifierColumn() + " VARCHAR(255) NOT NULL,\n" +
      schema.sequenceNumberColumn() + " BIGINT NOT NULL,\n" +
      schema.typeColumn() + " VARCHAR(255) NOT NULL,\n" +
      schema.eventIdentifierColumn() + " VARCHAR(255) NOT NULL,\n" +
      schema.metaDataColumn() + " " + payloadType() + ",\n" +
      schema.payloadColumn() + " " + payloadType() + " NOT NULL,\n" +
      schema.payloadRevisionColumn() + " VARCHAR(255),\n" +
      schema.payloadTypeColumn() + " VARCHAR(255) NOT NULL,\n" +
      schema.timestampColumn() + " VARCHAR(255) NOT NULL,\n" +
      "PRIMARY KEY (" + schema.aggregateIdentifierColumn() + ", " +
      schema.sequenceNumberColumn() + "),\n" +
      "UNIQUE (" + schema.eventIdentifierColumn() + ")\n" +
      ")";
  return connection.prepareStatement(sql);
}
origin: AxonFramework/AxonFramework

final String sql = "INSERT INTO " + table + " (" +
    String.join(", ", schema.eventIdentifierColumn(), schema.aggregateIdentifierColumn(),
          schema.sequenceNumberColumn(), schema.typeColumn(), schema.timestampColumn(),
          schema.payloadTypeColumn(), schema.payloadRevisionColumn(), schema.payloadColumn(),
          schema.metaDataColumn()) + ") VALUES (?,?,?,?,?,?,?,?,?)";
origin: AxonFramework/AxonFramework

final String sql = "INSERT INTO " + schema.snapshotTable() + " (" +
    String.join(", ", schema.eventIdentifierColumn(), schema.aggregateIdentifierColumn(),
          schema.sequenceNumberColumn(), schema.typeColumn(), schema.timestampColumn(),
          schema.payloadTypeColumn(), schema.payloadRevisionColumn(), schema.payloadColumn(),
          schema.metaDataColumn()) + ") VALUES (?,?,?,?,?,?,?,?,?)";
origin: AxonFramework/AxonFramework

@Override
public PreparedStatement createDomainEventTable(Connection connection,
                        EventSchema schema) throws SQLException {
  String sql = "CREATE TABLE IF NOT EXISTS " + schema.domainEventTable() + " (\n" +
      schema.globalIndexColumn() + " " + idColumnType() + " NOT NULL,\n" +
      schema.aggregateIdentifierColumn() + " VARCHAR(255) NOT NULL,\n" +
      schema.sequenceNumberColumn() + " BIGINT NOT NULL,\n" +
      schema.typeColumn() + " VARCHAR(255),\n" +
      schema.eventIdentifierColumn() + " VARCHAR(255) NOT NULL,\n" +
      schema.metaDataColumn() + " " + payloadType() + ",\n" +
      schema.payloadColumn() + " " + payloadType() + " NOT NULL,\n" +
      schema.payloadRevisionColumn() + " VARCHAR(255),\n" +
      schema.payloadTypeColumn() + " VARCHAR(255) NOT NULL,\n" +
      schema.timestampColumn() + " VARCHAR(255) NOT NULL,\n" +
      "PRIMARY KEY (" + schema.globalIndexColumn() + "),\n" +
      "UNIQUE (" + schema.aggregateIdentifierColumn() + ", " +
      schema.sequenceNumberColumn() + "),\n" +
      "UNIQUE (" + schema.eventIdentifierColumn() + ")\n" +
      ")";
  return connection.prepareStatement(sql);
}
origin: AxonFramework/AxonFramework

@Override
public PreparedStatement createDomainEventTable(Connection connection, EventSchema schema) throws SQLException {
  String sql = "CREATE TABLE " + schema.domainEventTable() + " (\n" +
      schema.globalIndexColumn() + " NUMBER(19) NOT NULL,\n" +
      schema.aggregateIdentifierColumn() + " VARCHAR(255) NOT NULL,\n" +
      schema.sequenceNumberColumn() + " NUMBER(19) NOT NULL,\n" +
      schema.typeColumn() + " VARCHAR(255),\n" +
      schema.eventIdentifierColumn() + " VARCHAR(255) NOT NULL,\n" +
      schema.metaDataColumn() + " " + payloadType() + ",\n" +
      schema.payloadColumn() + " " + payloadType() + " NOT NULL,\n" +
      schema.payloadRevisionColumn() + " VARCHAR(255),\n" +
      schema.payloadTypeColumn() + " VARCHAR(255) NOT NULL,\n" +
      schema.timestampColumn() + " VARCHAR(255) NOT NULL,\n" +
      "PRIMARY KEY (" + schema.globalIndexColumn() + "),\n" +
      "UNIQUE (" + schema.aggregateIdentifierColumn() + ", " +
      schema.sequenceNumberColumn() + "),\n" +
      "UNIQUE (" + schema.eventIdentifierColumn() + ")\n" +
      ")";
  try (PreparedStatement pst = connection.prepareStatement(sql)) {
    pst.execute();
  }
  Oracle11Utils.simulateAutoIncrement(connection, schema.domainEventTable(), schema.globalIndexColumn());
  return Oracle11Utils.createNullStatement(connection);
}
origin: org.axonframework/axon-core

/**
 * Creates a statement to delete all snapshots of the aggregate with given {@code aggregateIdentifier}.
 *
 * @param connection          The connection to the database.
 * @param aggregateIdentifier The identifier of the aggregate whose snapshots to delete.
 * @return A {@link PreparedStatement} that deletes all the aggregate's snapshots when executed.
 * @throws SQLException when an exception occurs while creating the prepared statement.
 */
protected PreparedStatement deleteSnapshots(Connection connection, String aggregateIdentifier, long sequenceNumber)
    throws SQLException {
  PreparedStatement preparedStatement = connection.prepareStatement(
      "DELETE FROM " + schema.snapshotTable() + " WHERE " + schema.aggregateIdentifierColumn() + " = ? "
          + "AND " + schema.sequenceNumberColumn() + " < ?"
  );
  preparedStatement.setString(1, aggregateIdentifier);
  preparedStatement.setLong(2, sequenceNumber);
  return preparedStatement;
}
origin: org.axonframework/axon-eventsourcing

/**
 * 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;
}
origin: org.axonframework/axon-core

/**
 * 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;
}
origin: org.axonframework/axon-core

@Override
public Optional<Long> lastSequenceNumberFor(String aggregateIdentifier) {
  String sql = "SELECT max(" + schema.sequenceNumberColumn() + ") FROM " + schema.domainEventTable() + " WHERE " + schema.aggregateIdentifierColumn() + " = ?";
  return Optional.ofNullable(transactionManager.fetchInTransaction(
      () -> executeQuery(getConnection(), connection -> {
                  PreparedStatement stmt = connection.prepareStatement(sql);
                  stmt.setString(1, aggregateIdentifier);
                  return stmt;
                },
                resultSet -> nextAndExtract(resultSet, 1, Long.class),
                e -> new EventStoreException(format("Failed to read events for aggregate [%s]", aggregateIdentifier), e)
      )));
}
origin: org.axonframework/axon-eventsourcing

/**
 * Returns a comma separated list of domain event column names to select from an event or snapshot entry.
 *
 * @return comma separated domain event column names.
 */
protected String domainEventFields() {
  return String.join(", ", schema.eventIdentifierColumn(), schema.timestampColumn(), schema.payloadTypeColumn(),
            schema.payloadRevisionColumn(), schema.payloadColumn(), schema.metaDataColumn(),
            schema.typeColumn(), schema.aggregateIdentifierColumn(), schema.sequenceNumberColumn());
}
origin: org.axonframework/axon-core

/**
 * Returns a comma separated list of domain event column names to select from an event or snapshot entry.
 *
 * @return comma separated domain event column names.
 */
protected String domainEventFields() {
  return String.join(", ", schema.eventIdentifierColumn(), schema.timestampColumn(), schema.payloadTypeColumn(),
            schema.payloadRevisionColumn(), schema.payloadColumn(), schema.metaDataColumn(),
            schema.typeColumn(), schema.aggregateIdentifierColumn(), schema.sequenceNumberColumn());
}
org.axonframework.eventsourcing.eventstore.jdbcEventSchemasequenceNumberColumn

Javadoc

Get the name of the column containing the aggregate sequence number of the event.

Popular methods of EventSchema

  • <init>
  • domainEventTable
    Returns the name of the domain event table.
  • snapshotTable
    Returns the name of the snapshot event table.
  • aggregateIdentifierColumn
    Get the name of the column containing the aggregate identifier of the event.
  • builder
    Returns a new Builder initialized with default settings.
  • eventIdentifierColumn
    Get the name of the column containing the identifier of the event.
  • globalIndexColumn
    Get the name of the column containing the global index of the event.
  • metaDataColumn
    Get the name of the column containing the serialized metadata of the event.
  • payloadColumn
    Get the name of the column containing the serialized payload of the event.
  • payloadRevisionColumn
    Get the name of the column containing the revision number of the serialized payload.
  • payloadTypeColumn
    Get the name of the column containing the event payload type.
  • timestampColumn
    Get the name of the column containing the timestamp of the event.
  • payloadTypeColumn,
  • timestampColumn,
  • typeColumn

Popular in Java

  • Finding current android device location
  • scheduleAtFixedRate (Timer)
  • findViewById (Activity)
  • getOriginalFilename (MultipartFile)
    Return the original filename in the client's filesystem.This may contain path information depending
  • String (java.lang)
  • Format (java.text)
    The base class for all formats. This is an abstract base class which specifies the protocol for clas
  • Comparator (java.util)
    A Comparator is used to compare two objects to determine their ordering with respect to each other.
  • Stream (java.util.stream)
    A sequence of elements supporting sequential and parallel aggregate operations. The following exampl
  • DataSource (javax.sql)
    An interface for the creation of Connection objects which represent a connection to a database. This
  • Logger (org.slf4j)
    The org.slf4j.Logger interface is the main user entry point of SLF4J API. It is expected that loggin
  • PhpStorm for WordPress
Tabnine Logo
  • Products

    Search for Java codeSearch for JavaScript code
  • IDE Plugins

    IntelliJ IDEAWebStormVisual StudioAndroid StudioEclipseVisual Studio CodePyCharmSublime TextPhpStormVimAtomGoLandRubyMineEmacsJupyter NotebookJupyter LabRiderDataGripAppCode
  • Company

    About UsContact UsCareers
  • Resources

    FAQBlogTabnine AcademyStudentsTerms of usePrivacy policyJava Code IndexJavascript Code Index
Get Tabnine for your IDE now