in core/src/main/scala/org/apache/pekko/persistence/jdbc/query/dao/legacy/ReadJournalQueries.scala [33:65]
private def _allPersistenceIdsDistinct(max: ConstColumn[Long]): Query[Rep[String], String, Seq] =
baseTableQuery().map(_.persistenceId).distinct.take(max)
private def baseTableQuery() =
JournalTable.filter(_.deleted === false)
val allPersistenceIdsDistinct = Compiled(_allPersistenceIdsDistinct _)
private def _messagesQuery(
persistenceId: Rep[String],
fromSequenceNr: Rep[Long],
toSequenceNr: Rep[Long],
max: ConstColumn[Long]) =
baseTableQuery()
.filter(_.persistenceId === persistenceId)
.filter(_.sequenceNumber >= fromSequenceNr)
.filter(_.sequenceNumber <= toSequenceNr)
.sortBy(_.sequenceNumber.asc)
.take(max)
val messagesQuery = Compiled(_messagesQuery _)
private def _eventsByTag(
tag: Rep[String],
offset: ConstColumn[Long],
maxOffset: ConstColumn[Long],
max: ConstColumn[Long]) = {
baseTableQuery()
.filter(_.tags.like(tag))
.sortBy(_.ordering.asc)
.filter(row => row.ordering > offset && row.ordering <= maxOffset)
.take(max)
}