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

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

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

origin: AxonFramework/AxonFramework

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

GapAwareTrackingToken previousToken = (GapAwareTrackingToken) lastToken;
String sql = "SELECT " + trackedEventFields() + " FROM " + schema.domainEventTable() +
    " WHERE (" + schema.globalIndexColumn() + " > ? AND " + schema.globalIndexColumn() + " <= ?) ";
List<Long> gaps;
if (previousToken != null) {
  gaps = new ArrayList<>(previousToken.getGaps());
  if (!gaps.isEmpty()) {
    sql += " OR " + schema.globalIndexColumn() + " IN (" +
        String.join(",", Collections.nCopies(gaps.size(), "?")) + ") ";
  gaps = Collections.emptyList();
sql += "ORDER BY " + schema.globalIndexColumn() + " ASC";
PreparedStatement preparedStatement = connection.prepareStatement(sql);
long globalIndex = previousToken == null ? -1 : previousToken.getIndex();
origin: AxonFramework/AxonFramework

@Override
public TrackingToken createTailToken() {
  String sql = "SELECT min(" + schema.globalIndexColumn() + ") - 1 FROM " + schema.domainEventTable();
  Long index = transactionManager.fetchInTransaction(
      () -> executeQuery(getConnection(),
                connection -> connection.prepareStatement(sql),
                resultSet -> nextAndExtract(resultSet, 1, Long.class),
                e -> new EventStoreException("Failed to get tail token", e)));
  return Optional.ofNullable(index)
          .map(seq -> GapAwareTrackingToken.newInstance(seq, Collections.emptySet()))
          .orElse(null);
}
origin: AxonFramework/AxonFramework

@Override
public TrackingToken createHeadToken() {
  String sql = "SELECT max(" + schema.globalIndexColumn() + ") FROM " + schema.domainEventTable();
  Long index = transactionManager.fetchInTransaction(
      () -> executeQuery(getConnection(),
                connection -> connection.prepareStatement(sql),
                resultSet -> nextAndExtract(resultSet, 1, Long.class),
                e -> new EventStoreException("Failed to get head token", e)));
  return Optional.ofNullable(index)
          .map(seq -> GapAwareTrackingToken.newInstance(seq, Collections.emptySet()))
          .orElse(null);
}
origin: AxonFramework/AxonFramework

PreparedStatement statement =
    conn.prepareStatement(format("SELECT %s, %s FROM %s WHERE %s >= ? AND %s <= ?",
                   schema.globalIndexColumn(),
                   schema.timestampColumn(),
                   schema.domainEventTable(),
                   schema.globalIndexColumn(),
                   schema.globalIndexColumn()));
statement.setLong(1, gaps.first());
statement.setLong(2, gaps.last() + 1L);
while (resultSet.next()) {
  try {
    long sequenceNumber = resultSet.getLong(schema.globalIndexColumn());
    Instant timestamp =
        DateTimeUtils.parseInstant(readTimeStamp(resultSet, schema.timestampColumn()).toString());
origin: AxonFramework/AxonFramework

@Override
public TrackingToken createTokenAt(Instant dateTime) {
  String sql = "SELECT min(" + schema.globalIndexColumn() + ") - 1 FROM " + schema.domainEventTable() + " WHERE "
      + schema.timestampColumn() + " >= ?";
  Long index = transactionManager.fetchInTransaction(
      () -> executeQuery(getConnection(),
                connection -> {
                  PreparedStatement stmt = connection.prepareStatement(sql);
                  stmt.setString(1, formatInstant(dateTime));
                  return stmt;
                },
                resultSet -> nextAndExtract(resultSet, 1, Long.class),
                e -> new EventStoreException(format("Failed to get token at [%s]", dateTime), e)));
  if (index == null) {
    return null;
  }
  return GapAwareTrackingToken.newInstance(index, Collections.emptySet());
}
origin: AxonFramework/AxonFramework

PreparedStatement stat = connection.prepareStatement(
    format("SELECT min(%s) FROM %s WHERE %s > ?",
       schema.globalIndexColumn(),
       schema.domainEventTable(),
       schema.globalIndexColumn()));
stat.setLong(1, index);
return stat;
origin: AxonFramework/AxonFramework

long globalSequence = resultSet.getLong(schema.globalIndexColumn());
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: 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: org.axonframework/axon-core

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

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

@Override
public TrackingToken createHeadToken() {
  String sql = "SELECT max(" + schema.globalIndexColumn() + ") FROM " + schema.domainEventTable();
  Long index = transactionManager.fetchInTransaction(
      () -> executeQuery(getConnection(),
                connection -> connection.prepareStatement(sql),
                resultSet -> nextAndExtract(resultSet, 1, Long.class),
                e -> new EventStoreException("Failed to get head token", e)));
  return Optional.ofNullable(index)
          .map(seq -> GapAwareTrackingToken.newInstance(seq, Collections.emptySet()))
          .orElse(null);
}
origin: org.axonframework/axon-core

@Override
public TrackingToken createTailToken() {
  String sql = "SELECT min(" + schema.globalIndexColumn() + ") - 1 FROM " + schema.domainEventTable();
  Long index = transactionManager.fetchInTransaction(
      () -> executeQuery(getConnection(),
                connection -> connection.prepareStatement(sql),
                resultSet -> nextAndExtract(resultSet, 1, Long.class),
                e -> new EventStoreException("Failed to get tail token", e)));
  return Optional.ofNullable(index)
          .map(seq -> GapAwareTrackingToken.newInstance(seq, Collections.emptySet()))
          .orElse(null);
}
origin: org.axonframework/axon-eventsourcing

@Override
public TrackingToken createTailToken() {
  String sql = "SELECT min(" + schema.globalIndexColumn() + ") - 1 FROM " + schema.domainEventTable();
  Long index = transactionManager.fetchInTransaction(
      () -> executeQuery(getConnection(),
                connection -> connection.prepareStatement(sql),
                resultSet -> nextAndExtract(resultSet, 1, Long.class),
                e -> new EventStoreException("Failed to get tail token", e)));
  return Optional.ofNullable(index)
          .map(seq -> GapAwareTrackingToken.newInstance(seq, Collections.emptySet()))
          .orElse(null);
}
origin: org.axonframework/axon-eventsourcing

@Override
public TrackingToken createHeadToken() {
  String sql = "SELECT max(" + schema.globalIndexColumn() + ") FROM " + schema.domainEventTable();
  Long index = transactionManager.fetchInTransaction(
      () -> executeQuery(getConnection(),
                connection -> connection.prepareStatement(sql),
                resultSet -> nextAndExtract(resultSet, 1, Long.class),
                e -> new EventStoreException("Failed to get head token", e)));
  return Optional.ofNullable(index)
          .map(seq -> GapAwareTrackingToken.newInstance(seq, Collections.emptySet()))
          .orElse(null);
}
origin: org.axonframework/axon-core

@Override
public TrackingToken createTokenAt(Instant dateTime) {
  String sql = "SELECT min(" + schema.globalIndexColumn() + ") - 1 FROM " + schema.domainEventTable() + " WHERE "
      + schema.timestampColumn() + " >= ?";
  Long index = transactionManager.fetchInTransaction(
      () -> executeQuery(getConnection(),
                connection -> {
                  PreparedStatement stmt = connection.prepareStatement(sql);
                  stmt.setString(1, formatInstant(dateTime));
                  return stmt;
                },
                resultSet -> nextAndExtract(resultSet, 1, Long.class),
                e -> new EventStoreException(format("Failed to get token at [%s]", dateTime), e)));
  if (index == null) {
    return null;
  }
  return GapAwareTrackingToken.newInstance(index, Collections.emptySet());
}
origin: org.axonframework/axon-eventsourcing

@Override
public TrackingToken createTokenAt(Instant dateTime) {
  String sql = "SELECT min(" + schema.globalIndexColumn() + ") - 1 FROM " + schema.domainEventTable() + " WHERE "
      + schema.timestampColumn() + " >= ?";
  Long index = transactionManager.fetchInTransaction(
      () -> executeQuery(getConnection(),
                connection -> {
                  PreparedStatement stmt = connection.prepareStatement(sql);
                  stmt.setString(1, formatInstant(dateTime));
                  return stmt;
                },
                resultSet -> nextAndExtract(resultSet, 1, Long.class),
                e -> new EventStoreException(format("Failed to get token at [%s]", dateTime), e)));
  if (index == null) {
    return null;
  }
  return GapAwareTrackingToken.newInstance(index, Collections.emptySet());
}
origin: org.axonframework/axon-eventsourcing

@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: org.axonframework/axon-core

@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);
}
org.axonframework.eventsourcing.eventstore.jdbcEventSchemaglobalIndexColumn

Javadoc

Get the name of the column containing the global index 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.
  • 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.
  • sequenceNumberColumn
    Get the name of the column containing the aggregate sequence number of the event.
  • timestampColumn
    Get the name of the column containing the timestamp of the event.
  • sequenceNumberColumn,
  • timestampColumn,
  • typeColumn

Popular in Java

  • Reactive rest calls using spring rest template
  • findViewById (Activity)
  • addToBackStack (FragmentTransaction)
  • notifyDataSetChanged (ArrayAdapter)
  • BufferedWriter (java.io)
    Wraps an existing Writer and buffers the output. Expensive interaction with the underlying reader is
  • File (java.io)
    An "abstract" representation of a file system entity identified by a pathname. The pathname may be a
  • Selector (java.nio.channels)
    A controller for the selection of SelectableChannel objects. Selectable channels can be registered w
  • Collections (java.util)
    This class consists exclusively of static methods that operate on or return collections. It contains
  • SortedMap (java.util)
    A map that has its keys ordered. The sorting is according to either the natural ordering of its keys
  • TreeMap (java.util)
    Walk the nodes of the tree left-to-right or right-to-left. Note that in descending iterations, next
  • 21 Best IntelliJ Plugins
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