PostgresSQLSyntaxSupport

bitlap.scalikejdbc.PostgresSQLSyntaxSupport

Attributes

Graph
Supertypes
class Object
trait Matchable
class Any

Members list

Value members

Concrete methods

def batchValues(multipleValues: List[(SQLSyntax, ParameterBinder)]*): Seq[SQLSyntax]

Extensions

Extensions

extension (self: InsertSQLBuilder)(self: InsertSQLBuilder)
def multipleValuesPlus(multipleValues: List[(SQLSyntax, ParameterBinder)]*): InsertSQLBuilder

Insert multiple values with name.

Insert multiple values with name.

It also supports Array values by bitlap.scalikejdbc.binders.ArrayBinders, and supports Json by bitlap.scalikejdbc.binders.JsonBinders.

Attributes

def onConflictDoNothing(): InsertSQLBuilder

Insert and ON CONFLICT DO NOTHING

Insert and ON CONFLICT DO NOTHING

Attributes

def onConflictUpdate(constraintColumns: SQLSyntax*)(columnsAndValues: SQLSyntax*): InsertSQLBuilder

Insert and ON CONFLICT ... DO UPDATE SET ....

Insert and ON CONFLICT ... DO UPDATE SET ....

It also supports Array values by bitlap.scalikejdbc.binders.ArrayBinders, and supports Json by bitlap.scalikejdbc.binders.JsonBinders.

Attributes

extension (self: SQLSyntax.type)(self: SQLSyntax.type)
def withRecursive[T : SQLSyntaxSupport](cols: List[SQLSyntax], outerWhereConditions: SQLSyntax)(onCteTable: SQLSyntaxSupport[T] => SQLSyntax, onInnerTable: SQLSyntaxSupport[T] => SQLSyntax, returnCols: SQLSyntaxSupport[T] => SQLSyntax*)(implicit evidence$1: SQLSyntaxSupport[T]): SQLSyntax

WITH RECURSIVE

WITH RECURSIVE

Attributes