QueryInterfaceRequest

Returns a new QueryInterfaceRequest with a matching predicate added to the eventual set of already applied predicates.

// SELECT * FROM books WHERE books MATCH '...'
var request = Book.all()
request = request.matching(pattern)

If the search pattern is nil, the request does not match any database row.

A tuple that contains a prepared statement that is ready to be executed, and an eventual row adapter.

The number of rows fetched by the request.

A new QueryInterfaceRequest with a new net of selected columns.

// SELECT id, email FROM players
var request = Player.all()
request = request.select(Column("id"), Column("email"))

Any previous selection is replaced:

// SELECT email FROM players
request
    .select(Column("id"))
    .select(Column("email"))

A new QueryInterfaceRequest with a new net of selected columns.

// SELECT id, email FROM players
var request = Player.all()
request = request.select([Column("id"), Column("email")])

Any previous selection is replaced:

// SELECT email FROM players
request
    .select([Column("id")])
    .select([Column("email")])

A new QueryInterfaceRequest with a new net of selected columns.

// SELECT id, email FROM players
var request = Player.all()
request = request.select(sql: "id, email")

Any previous selection is replaced:

// SELECT email FROM players
request
    .select(sql: "id")
    .select(sql: "email")

A new QueryInterfaceRequest which returns distinct rows.

// SELECT DISTINCT * FROM players
var request = Player.all()
request = request.distinct()

// SELECT DISTINCT name FROM players
var request = Player.select(Column("name"))
request = request.distinct()

A new QueryInterfaceRequest with the provided predicate added to the eventual set of already applied predicates.

// SELECT * FROM players WHERE email = 'arthur@example.com'
var request = Player.all()
request = request.filter(Column("email") == "arthur@example.com")

A new QueryInterfaceRequest with the provided predicate added to the eventual set of already applied predicates.

// SELECT * FROM players WHERE email = 'arthur@example.com'
var request = Player.all()
request = request.filter(sql: "email = ?", arguments: ["arthur@example.com"])

A new QueryInterfaceRequest grouped according to expressions.

A new QueryInterfaceRequest grouped according to expressions.

A new QueryInterfaceRequest with a new grouping.

A new QueryInterfaceRequest with the provided predicate added to the eventual set of already applied predicates.

A new QueryInterfaceRequest with the provided sql added to the eventual set of already applied predicates.

A new QueryInterfaceRequest with the provided orderings.

// SELECT * FROM players ORDER BY name
var request = Player.all()
request = request.order(Column("name"))

Any previous ordering is replaced:

// SELECT * FROM players ORDER BY name
request
    .order(Column("email"))
    .reversed()
    .order(Column("name"))

A new QueryInterfaceRequest with the provided orderings.

// SELECT * FROM players ORDER BY name
var request = Player.all()
request = request.order([Column("name")])

Any previous ordering is replaced:

// SELECT * FROM players ORDER BY name
request
    .order([Column("email")])
    .reversed()
    .order([Column("name")])

A new QueryInterfaceRequest with the provided sql used for sorting.

// SELECT * FROM players ORDER BY name
var request = Player.all()
request = request.order(sql: "name")

Any previous ordering is replaced:

// SELECT * FROM players ORDER BY name
request
    .order(sql: "email")
    .order(sql: "name")

A new QueryInterfaceRequest sorted in reversed order.

// SELECT * FROM players ORDER BY name DESC
var request = Player.all().order(Column("name"))
request = request.reversed()

A QueryInterfaceRequest which fetches limit rows, starting at offset.

// SELECT * FROM players LIMIT 1
var request = Player.all()
request = request.limit(1)

Deletes matching rows; returns the number of deleted rows.