PostgresDialect

Value Members

final def !=(arg0: Any): Boolean

Definition Classes
AnyRef → Any
final def ##(): Int

Definition Classes
AnyRef → Any
final def ==(arg0: Any): Boolean

Definition Classes
AnyRef → Any
def addFeed(feed: FeedDbModel)(implicit jdbcContext: JdbcContext): Unit

Add a feed definition to the feed table.
Add a feed definition to the feed table.
feed
The feed to add.
jdbcContext
The JDBC context to use.
returns
The id for the newly added feed.

Definition Classes
PostgresDialect → Dialect
def addFeedEntry(entryTableName: String, entryData: EntryDbModel)(implicit jdbcContext: JdbcContext): Unit

Add an entry to an entry table.
Add an entry to an entry table.
entryTableName
The name of the entry table.
entryData
The entry to add.
jdbcContext
The JDBC context to use.

Definition Classes
PostgresDialect → Dialect
final def asInstanceOf[T0]: T0

Definition Classes
Any
def clone(): AnyRef

Attributes
protected[java.lang]
Definition Classes
AnyRef
Annotations
@throws( ... )
def createEntryTableIfNotExists(entryTableName: String)(implicit jdbcContext: JdbcContext): Unit

Create an empty feed entry table with a given name.
Create an empty feed entry table with a given name.
entryTableName
The entry table name.
jdbcContext
The JDBC context to use.

Definition Classes
Dialect
def createEntryTableStatement(entryTableName: String): String

entryTableName
The entry table name.
returns
the sql statement for the Feed table.

Definition Classes
PostgresDialect → Dialect
def createFeedTableIfNotExists(implicit jdbcContext: JdbcContext): Unit

Create an empty feed table.
Create an empty feed table.
jdbcContext
The JDBC context to use.

Definition Classes
Dialect
def createFeedTableStatement: String

returns
the sql statement for the Feed table.

Definition Classes
PostgresDialect → Dialect
def dropEntryTable(entryTableName: String)(implicit jdbcContext: JdbcContext): Unit

Drop the entry table.
Drop the entry table.

Definition Classes
PostgresDialect → Dialect
def dropFeedTable(implicit jdbcContext: JdbcContext): Unit

Drop the feed table.
Drop the feed table.

Definition Classes
PostgresDialect → Dialect
final def eq(arg0: AnyRef): Boolean

Definition Classes
AnyRef
def equals(arg0: Any): Boolean

Definition Classes
AnyRef → Any
def fetchEntryCountLowerThan(entryTableName: String, sequenceNo: Long, inclusive: Boolean)(implicit jdbcContext: JdbcContext): Long

Fetch the number of entries with an id lower than a given sequence number.
Fetch the number of entries with an id lower than a given sequence number.
entryTableName
The name of the entry table.
inclusive
Indicates whether the given sequence number should be included in the entry count or not.
jdbcContext
The JDBC context to use.
returns
The number of entries with an id lower than a given sequence number.

Definition Classes
PostgresDialect → Dialect
def fetchFeed(feedName: String)(implicit jdbcContext: JdbcContext): Option[FeedDbModel]

Fetch a feed model based on the feed name.
Fetch a feed model based on the feed name.
feedName
The feed name.
jdbcContext
The JDBC context to use.
returns
A feed model wrapped in an option (None if there is no feed model with the given name).

Definition Classes
PostgresDialect → Dialect
def fetchFeedEntries(entryTableName: String, start: Long, count: Int, ascending: Boolean)(implicit jdbcContext: JdbcContext): List[EntryDbModel]

Fetch entries from an entry table starting at a given index and entry count.
Fetch entries from an entry table starting at a given index and entry count.
entryTableName
The name of the entry table.
start
The index of the first entry to fetch.
count
The max number of entries to fetch.
ascending
The direction of the search: ascending or descending indexes.
jdbcContext
The JDBC context to use.
returns
An entry list.

Definition Classes
PostgresDialect → Dialect
def fetchMaxEntryId(entryTableName: String)(implicit jdbcContext: JdbcContext): Long

Fetch the largest entry ID from the database.
Fetch the largest entry ID from the database.
entryTableName
The name of the entry table.
jdbcContext
The JDBC context to use.
returns
The largest entry id for a given entry table, or -1 if the entry table is empty.

Definition Classes
PostgresDialect → Dialect
def fetchMostRecentFeedEntries(entryTableName: String, count: Int)(implicit jdbcContext: JdbcContext): List[EntryDbModel]

Fetch the most recent feed entries from an entry table.
Fetch the most recent feed entries from an entry table.
entryTableName
The name of the entry table.
count
The max number of entries to fetch.
jdbcContext
The JDBC context to use.
returns
An entry list.

Definition Classes
PostgresDialect → Dialect
def finalize(): Unit

Attributes
protected[java.lang]
Definition Classes
AnyRef
Annotations
@throws( classOf[java.lang.Throwable] )
final def getClass(): Class[_]

Definition Classes
AnyRef → Any
def hashCode(): Int

Definition Classes
AnyRef → Any
final def isInstanceOf[T0]: Boolean

Definition Classes
Any
final def ne(arg0: AnyRef): Boolean

Definition Classes
AnyRef
final def notify(): Unit

Definition Classes
AnyRef
final def notifyAll(): Unit

Definition Classes
AnyRef
def sqlQuery[T](sql: String, maxRows: Option[Int], factory: (ResultSet) ⇒ T)(implicit jdbcContext: JdbcContext): List[T]

Helper function to execute an SQL query.
Helper function to execute an SQL query.
sql
The SQL query to execute.
maxRows
The maximum number of rows to return (only the first maxRows rows are returned).
jdbcContext
The JDBC context to use.
returns
The result set resulting from executing the query.

Attributes
protected
Definition Classes
Dialect
def sqlUpdate(sql: String)(implicit jdbcContext: JdbcContext): Int

Helper function to execute an SQL update statement.
Helper function to execute an SQL update statement.
sql
The SQL update.
jdbcContext
The JDBC context to use.
returns
The number of rows affected by the update.

Attributes
protected
Definition Classes
Dialect
def sqlUpdatePepared(sql: String, data: Any*)(implicit jdbcContext: JdbcContext): Int

Helper function to execute a prepared SQL update statement.
Helper function to execute a prepared SQL update statement.
sql
The prepared SQL update statement containing ? placeholders where data has to be filled in.
data
The data to fill into the ? placeholders of the prepared SQL update statement.
jdbcContext
The JDBC context to use.
returns
The number of rows affected by the update.

Attributes
protected
Definition Classes
Dialect
final def synchronized[T0](arg0: ⇒ T0): T0

Definition Classes
AnyRef
def toString(): String

Definition Classes
AnyRef → Any
final def wait(): Unit

Definition Classes
AnyRef
Annotations
@throws( ... )
final def wait(arg0: Long, arg1: Int): Unit

Definition Classes
AnyRef
Annotations
@throws( ... )
final def wait(arg0: Long): Unit

Definition Classes
AnyRef
Annotations
@throws( ... )

Related Doc: package jdbc

trait PostgresDialect extends Dialect

Value Members

final def !=(arg0: Any): Boolean

final def ##(): Int

final def ==(arg0: Any): Boolean

def addFeed(feed: FeedDbModel)(implicit jdbcContext: JdbcContext): Unit

def addFeedEntry(entryTableName: String, entryData: EntryDbModel)(implicit jdbcContext: JdbcContext): Unit

final def asInstanceOf[T0]: T0

def clone(): AnyRef

def createEntryTableIfNotExists(entryTableName: String)(implicit jdbcContext: JdbcContext): Unit

def createEntryTableStatement(entryTableName: String): String

def createFeedTableIfNotExists(implicit jdbcContext: JdbcContext): Unit

def createFeedTableStatement: String

def dropEntryTable(entryTableName: String)(implicit jdbcContext: JdbcContext): Unit

def dropFeedTable(implicit jdbcContext: JdbcContext): Unit

final def eq(arg0: AnyRef): Boolean

def equals(arg0: Any): Boolean

def fetchEntryCountLowerThan(entryTableName: String, sequenceNo: Long, inclusive: Boolean)(implicit jdbcContext: JdbcContext): Long

def fetchFeed(feedName: String)(implicit jdbcContext: JdbcContext): Option[FeedDbModel]

def fetchFeedEntries(entryTableName: String, start: Long, count: Int, ascending: Boolean)(implicit jdbcContext: JdbcContext): List[EntryDbModel]

def fetchMaxEntryId(entryTableName: String)(implicit jdbcContext: JdbcContext): Long

def fetchMostRecentFeedEntries(entryTableName: String, count: Int)(implicit jdbcContext: JdbcContext): List[EntryDbModel]

def finalize(): Unit

final def getClass(): Class[_]

def hashCode(): Int

final def isInstanceOf[T0]: Boolean

final def ne(arg0: AnyRef): Boolean

final def notify(): Unit

final def notifyAll(): Unit

def sqlQuery[T](sql: String, maxRows: Option[Int], factory: (ResultSet) ⇒ T)(implicit jdbcContext: JdbcContext): List[T]

def sqlUpdate(sql: String)(implicit jdbcContext: JdbcContext): Int

def sqlUpdatePepared(sql: String, data: Any*)(implicit jdbcContext: JdbcContext): Int

final def synchronized[T0](arg0: ⇒ T0): T0

def toString(): String

final def wait(): Unit

final def wait(arg0: Long, arg1: Int): Unit

final def wait(arg0: Long): Unit

Inherited from Dialect

Inherited from AnyRef

Inherited from Any

Ungrouped