EntitiesSelectOperationBuilder

Instance Constructors

new EntitiesSelectOperationBuilder(mapper: NoIdQueryingFeature[Entity], conditions: Seq[scalikejdbc.SQLSyntax] = Nil, orderings: Seq[scalikejdbc.SQLSyntax] = Nil, limit: Option[Int] = None, offset: Option[Int] = None)

mapper
mapper
conditions
registered conditions
limit
limit
offset
offset

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 apply()(implicit session: DBSession = autoSession): List[Entity]

Actually applies SQL to the DB.
def apply(rs: WrappedResultSet): Entity

Extracts entity from ResultSet.
Extracts entity from ResultSet.

Definition Classes
SkinnyMapperBase
def apply(a: Alias[Entity])(rs: WrappedResultSet): Entity

Extracts entity from ResultSet.
Extracts entity from ResultSet.

Definition Classes
SkinnyMapperBase
def as(provider: scalikejdbc.QuerySQLSyntaxProvider[scalikejdbc.SQLSyntaxSupport[Entity], Entity]): scalikejdbc.TableAsAliasSQLSyntax

Definition Classes
SQLSyntaxSupport
final def asInstanceOf[T0]: T0

Definition Classes
Any
def autoSession: DBSession

Definition Classes
SQLSyntaxSupport
def average(fieldName: Symbol, decimals: Option[Int] = None)(implicit s: DBSession = autoSession): BigDecimal

Calculates average of a column.
Calculates average of a column.

Definition Classes
CalculationFeature
def avg(fieldName: Symbol, decimals: Option[Int] = None)(implicit s: DBSession = autoSession): BigDecimal

Definition Classes
CalculationFeature
def calculate(sql: scalikejdbc.SQLSyntax)(implicit s: DBSession = autoSession): BigDecimal

Calculates rows.
Calculates rows.

Definition Classes
EntitiesSelectOperationBuilder → CalculationFeature
def clearLoadedColumns(): Unit

Definition Classes
SQLSyntaxSupport
def clone(): AnyRef

Attributes
protected[java.lang]
Definition Classes
AnyRef
Annotations
@throws( ... )
def column: scalikejdbc.ColumnName[Entity]

Definition Classes
SQLSyntaxSupport
def columnNames: Seq[String]

Returns column names.
Returns column names.

Definition Classes
SkinnyMapperBase → SQLSyntaxSupport
def columns: Seq[String]

Definition Classes
SQLSyntaxSupport
val conditions: Seq[scalikejdbc.SQLSyntax]

registered conditions
def connectionPoolName: Any

Definition Classes
SQLSyntaxSupport
def count(fieldName: Symbol = Symbol(""), distinct: Boolean = false)(implicit s: DBSession = autoSession): Long

Count only.
Count only.

Definition Classes
CalculationFeature
def createAlias(name: String): Alias[Entity]

Creates a new table alias for this mapper.
Creates a new table alias for this mapper.

Definition Classes
SkinnyMapperBase
def defaultAlias: Alias[Entity]

Returns default table alias.
Returns default table alias. This method is abstract and should be implemented with unique name. override def defaultAlias = createAlias("sm")

Definition Classes
EntitiesSelectOperationBuilder → SkinnyMapperBase
def defaultOrderings: Seq[scalikejdbc.SQLSyntax]

Definition Classes
EntitiesSelectOperationBuilder → SkinnyMapperBase
def defaultScope(alias: Alias[Entity]): Option[scalikejdbc.SQLSyntax]

Returns default scope for select queries.
Returns default scope for select queries.

Definition Classes
SkinnyMapperBase
def defaultScopeWithDefaultAlias: Option[scalikejdbc.SQLSyntax]

Definition Classes
EntitiesSelectOperationBuilder → SkinnyMapperBase
def defaultSelectQuery: scalikejdbc.SelectSQLBuilder[Entity]

Returns select query builder.
Returns select query builder.

Definition Classes
SkinnyMapperBase
def delimiterForResultName: String

Definition Classes
SQLSyntaxSupport
def distinctCount(fieldName: Symbol = Symbol(primaryKeyFieldName))(implicit s: DBSession = autoSession): Long

Counts distinct rows.
Counts distinct rows.

Definition Classes
CalculationFeature
final def eq(arg0: AnyRef): Boolean

Definition Classes
AnyRef
def extract(rs: WrappedResultSet, n: scalikejdbc.ResultName[Entity]): Entity

Extracts entity from ResultSet.
Extracts entity from ResultSet.

Definition Classes
EntitiesSelectOperationBuilder → SkinnyMapperBase
def finalize(): Unit

Attributes
protected[java.lang]
Definition Classes
AnyRef
Annotations
@throws( classOf[java.lang.Throwable] )
def forceUpperCase: Boolean

Definition Classes
SQLSyntaxSupport
final def getClass(): Class[_]

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

Definition Classes
Any
def isValidFieldName(name: String): Boolean

Predicates the field name is valid.
Predicates the field name is valid.

Definition Classes
SkinnyMapperBase
def limit(n: Int): EntitiesSelectOperationBuilder

Appends limit part.
Appends limit part.
n
value
returns
query builder
val limit: Option[Int]

limit
val mapper: NoIdQueryingFeature[Entity]

mapper
def max(fieldName: Symbol)(implicit s: DBSession = autoSession): BigDecimal

Definition Classes
CalculationFeature
def maximum(fieldName: Symbol)(implicit s: DBSession = autoSession): BigDecimal

Calculates minimum value of a column.
Calculates minimum value of a column.

Definition Classes
CalculationFeature
def min(fieldName: Symbol)(implicit s: DBSession = autoSession): BigDecimal

Definition Classes
CalculationFeature
def minimum(fieldName: Symbol)(implicit s: DBSession = autoSession): BigDecimal

Calculates minimum value of a column.
Calculates minimum value of a column.

Definition Classes
CalculationFeature
def nameConverters: Map[String, String]

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

Definition Classes
AnyRef
final def notify(): Unit

Definition Classes
AnyRef
final def notifyAll(): Unit

Definition Classes
AnyRef
def offset(n: Int): EntitiesSelectOperationBuilder

Appends offset part.
Appends offset part.
n
value
returns
query builder
val offset: Option[Int]

offset
def orderBy(orderings: scalikejdbc.SQLSyntax*): EntitiesSelectOperationBuilder

Appends order by condition.
Appends order by condition.
orderings
orderings
returns
query builder
val orderings: Seq[scalikejdbc.SQLSyntax]
def paginate(pagination: Pagination): EntitiesSelectOperationBuilder

Appends pagination settings as limit/offset.
Appends pagination settings as limit/offset.
pagination
pagination
returns
query buildder
def primaryKeyField: scalikejdbc.SQLSyntax

Definition Classes
SkinnyMapperBase
def primaryKeyFieldName: String

Returns primary key name.
Returns primary key name. (default: "id") Notice: Not a column name but field name. For example, not "first_name" but "firstName"

Definition Classes
SkinnyMapperBase
def schemaName: Option[String]

Definition Classes
SQLSyntaxSupport
def settings: SettingsProvider

Attributes
protected[this]
Definition Classes
SQLSyntaxSupport
def simpleCountQuery: scalikejdbc.SelectSQLBuilder[Entity]

Returns simple select count query.
Returns simple select count query.

Definition Classes
SkinnyMapperBase
def singleSelectQuery: scalikejdbc.SelectSQLBuilder[Entity]

Returns select query builder object to simply fetch rows without other joined tables.
Returns select query builder object to simply fetch rows without other joined tables.

Definition Classes
EntitiesSelectOperationBuilder → SkinnyMapperBase
def sum(fieldName: Symbol)(implicit s: DBSession = autoSession): BigDecimal

Calculates sum of a column.
Calculates sum of a column.

Definition Classes
CalculationFeature
final def synchronized[T0](arg0: ⇒ T0): T0

Definition Classes
AnyRef
def syntax(name: String): scalikejdbc.QuerySQLSyntaxProvider[scalikejdbc.SQLSyntaxSupport[Entity], Entity]

Definition Classes
SQLSyntaxSupport
def syntax: scalikejdbc.QuerySQLSyntaxProvider[scalikejdbc.SQLSyntaxSupport[Entity], Entity]

Definition Classes
SQLSyntaxSupport
def table: scalikejdbc.TableDefSQLSyntax

Definition Classes
SQLSyntaxSupport
def tableName: String

Returns table name.
Returns table name.

Definition Classes
EntitiesSelectOperationBuilder → SkinnyMapperBase → SQLSyntaxSupport
def tableNameWithSchema: String

Definition Classes
SQLSyntaxSupport
def underlying: SkinnyMapperBase[Entity]

Attributes
protected
Definition Classes
SkinnyMapperBase
def useShortenedResultName: Boolean

Definition Classes
SQLSyntaxSupport
def useSnakeCaseColumnName: Boolean

Definition Classes
SQLSyntaxSupport
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( ... )
def where(condition: scalikejdbc.SQLSyntax): EntitiesSelectOperationBuilder

Appends a raw where condition.
Appends a raw where condition.
returns
query builder

Definition Classes
SelectOperationBuilder
def where(additionalConditions: (Symbol, Any)*): EntitiesSelectOperationBuilder

Appends where conditions.
Appends where conditions.
additionalConditions
conditions
returns
query builder

Definition Classes
SelectOperationBuilder
def withAlias[A](name: String)(op: (Alias[Entity]) ⇒ A): A

Provides a code block with a table alias.
Provides a code block with a table alias.

Definition Classes
SkinnyMapperBase
def withAlias[A](op: (Alias[Entity]) ⇒ A): A

Provides a code block with a table alias.
Provides a code block with a table alias.

Definition Classes
SkinnyMapperBase
def withColumns[A](op: (scalikejdbc.ColumnName[Entity]) ⇒ A): A

Provides a code block with the column name provider.
Provides a code block with the column name provider.

Definition Classes
SkinnyMapperBase

Related Doc: package NoIdQueryingFeature

Instance Constructors

new EntitiesSelectOperationBuilder(mapper: NoIdQueryingFeature[Entity], conditions: Seq[scalikejdbc.SQLSyntax] = Nil, orderings: Seq[scalikejdbc.SQLSyntax] = Nil, limit: Option[Int] = None, offset: Option[Int] = None)

Value Members

final def !=(arg0: Any): Boolean

final def ##(): Int

final def ==(arg0: Any): Boolean

def apply()(implicit session: DBSession = autoSession): List[Entity]

def apply(rs: WrappedResultSet): Entity

def apply(a: Alias[Entity])(rs: WrappedResultSet): Entity

def as(provider: scalikejdbc.QuerySQLSyntaxProvider[scalikejdbc.SQLSyntaxSupport[Entity], Entity]): scalikejdbc.TableAsAliasSQLSyntax

final def asInstanceOf[T0]: T0

def autoSession: DBSession

def average(fieldName: Symbol, decimals: Option[Int] = None)(implicit s: DBSession = autoSession): BigDecimal

def avg(fieldName: Symbol, decimals: Option[Int] = None)(implicit s: DBSession = autoSession): BigDecimal

def calculate(sql: scalikejdbc.SQLSyntax)(implicit s: DBSession = autoSession): BigDecimal

def clearLoadedColumns(): Unit

def clone(): AnyRef

def column: scalikejdbc.ColumnName[Entity]

def columnNames: Seq[String]

def columns: Seq[String]

val conditions: Seq[scalikejdbc.SQLSyntax]

def connectionPoolName: Any

def count(fieldName: Symbol = Symbol(""), distinct: Boolean = false)(implicit s: DBSession = autoSession): Long

def createAlias(name: String): Alias[Entity]

def defaultAlias: Alias[Entity]

def defaultOrderings: Seq[scalikejdbc.SQLSyntax]

def defaultScope(alias: Alias[Entity]): Option[scalikejdbc.SQLSyntax]

def defaultScopeWithDefaultAlias: Option[scalikejdbc.SQLSyntax]

def defaultSelectQuery: scalikejdbc.SelectSQLBuilder[Entity]

def delimiterForResultName: String

def distinctCount(fieldName: Symbol = Symbol(primaryKeyFieldName))(implicit s: DBSession = autoSession): Long

final def eq(arg0: AnyRef): Boolean

def extract(rs: WrappedResultSet, n: scalikejdbc.ResultName[Entity]): Entity

def finalize(): Unit

def forceUpperCase: Boolean

final def getClass(): Class[_]

final def isInstanceOf[T0]: Boolean

def isValidFieldName(name: String): Boolean

def limit(n: Int): EntitiesSelectOperationBuilder

val limit: Option[Int]

val mapper: NoIdQueryingFeature[Entity]

def max(fieldName: Symbol)(implicit s: DBSession = autoSession): BigDecimal

def maximum(fieldName: Symbol)(implicit s: DBSession = autoSession): BigDecimal

def min(fieldName: Symbol)(implicit s: DBSession = autoSession): BigDecimal

def minimum(fieldName: Symbol)(implicit s: DBSession = autoSession): BigDecimal

def nameConverters: Map[String, String]

final def ne(arg0: AnyRef): Boolean

final def notify(): Unit

final def notifyAll(): Unit

def offset(n: Int): EntitiesSelectOperationBuilder

val offset: Option[Int]

def orderBy(orderings: scalikejdbc.SQLSyntax*): EntitiesSelectOperationBuilder

val orderings: Seq[scalikejdbc.SQLSyntax]

def paginate(pagination: Pagination): EntitiesSelectOperationBuilder

def primaryKeyField: scalikejdbc.SQLSyntax

def primaryKeyFieldName: String

def schemaName: Option[String]

def settings: SettingsProvider

def simpleCountQuery: scalikejdbc.SelectSQLBuilder[Entity]

def singleSelectQuery: scalikejdbc.SelectSQLBuilder[Entity]

def sum(fieldName: Symbol)(implicit s: DBSession = autoSession): BigDecimal

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

def syntax(name: String): scalikejdbc.QuerySQLSyntaxProvider[scalikejdbc.SQLSyntaxSupport[Entity], Entity]

def syntax: scalikejdbc.QuerySQLSyntaxProvider[scalikejdbc.SQLSyntaxSupport[Entity], Entity]

def table: scalikejdbc.TableDefSQLSyntax

def tableName: String

def tableNameWithSchema: String

def underlying: SkinnyMapperBase[Entity]

def useShortenedResultName: Boolean

def useSnakeCaseColumnName: Boolean

final def wait(): Unit

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

final def wait(arg0: Long): Unit

def where(condition: scalikejdbc.SQLSyntax): EntitiesSelectOperationBuilder

def where(additionalConditions: (Symbol, Any)*): EntitiesSelectOperationBuilder

def withAlias[A](name: String)(op: (Alias[Entity]) ⇒ A): A

def withAlias[A](op: (Alias[Entity]) ⇒ A): A

def withColumns[A](op: (scalikejdbc.ColumnName[Entity]) ⇒ A): A