scalikejdbc

Basic Query SQLSyntax Provider for result.nameProviders.

SQLSyntax provider for column names.

SQLBuilder for delete queries.

Except query builder

for update query builder

SQLBuilder for insert queries.

Intersect query builder

Prefix object to avoid name confliction.

 withSQL { QueryDSL.select.from(User as u).where.eq(u.id, 123) }

SQLSyntax provider for query parts.

SQLSyntax provider for result.nameProviders.

SQLSyntax provider for result parts.

SQLBuilder

SQLSyntax Provider

SQLSyntaxSupport trait. Companion object needs this trait as follows.

 case class Member(id: Long, name: Option[String])
 object Member extends SQLSyntaxSupport[Member]

SQLBuilder for select queries.

Sub query builder

Table definition (which has alias name) part SQLSyntax

Table definition part SQLSyntax

Union query builder

Represents UpdateOperation (used as SQLBuilder[UpdateOperation]).

SQLBuilder for update queries.

withSQL and execute.apply()

withSQL and update.apply()

withSQL and updateAndReturnGeneratedKey.apply()

withSQL clause which returns SQL[A, NoExtractor] from SQLBuilder.

Option value converter.

Enables sql"", sqls"" interpolation.

 sql"select * from members"
 val whereClause = sqls"where id = ${id}"
 sql"select * from members ${whereClause}"

Returns String value when String type is expected for scalikejdbc.WrappedResultSet.

 val c = Company.syntax("c").resultName
 rs.string(c.name)