in core/src/main/scala/org/apache/pekko/persistence/jdbc/query/dao/ReadJournalQueries.scala [46:72]
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)
.filter(!_.deleted)
.sortBy(_.sequenceNumber.asc)
.take(max)
val messagesQuery = Compiled(_messagesQuery _)
private def _eventsByTag(
tag: Rep[String],
offset: ConstColumn[Long],
maxOffset: ConstColumn[Long],
max: ConstColumn[Long]) = {
baseTableWithTagsQuery()
.filter(_._2.tag === tag)
.sortBy(_._1.ordering.asc)
.filter(row => row._1.ordering > offset && row._1.ordering <= maxOffset)
.take(max)
.map(_._1)
}