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 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)

Creates a QueryInterfaceRequest with the provided primary key predicate.

// SELECT * FROM players WHERE id = 1
var request = Player.all()
request = request.filter(key: 1)

The selection defaults to all columns. This default can be changed for all requests by the TableMapping.databaseSelection property, or for individual requests with the TableMapping.select method.

Creates a QueryInterfaceRequest with the provided primary key predicate.

// SELECT * FROM players WHERE id IN (1, 2, 3)
var request = Player.all()
request = request.filter(keys: [1, 2, 3])

The selection defaults to all columns. This default can be changed for all requests by the TableMapping.databaseSelection property, or for individual requests with the TableMapping.select method.

Creates a QueryInterfaceRequest with the provided primary key predicate.

// SELECT * FROM passports WHERE personId = 1 AND countryCode = 'FR'
var request = Player.all()
request = request.filter(key: ["personId": 1, "countryCode": "FR"])

When executed, this request raises a fatal error if there is no unique index on the key columns.

The selection defaults to all columns. This default can be changed for all requests by the TableMapping.databaseSelection property, or for individual requests with the TableMapping.select method.

Creates a QueryInterfaceRequest with the provided primary key predicate.

// SELECT * FROM passports WHERE (personId = 1 AND countryCode = 'FR') OR ...
let request = Passport.filter(keys: [["personId": 1, "countryCode": "FR"], ...])

When executed, this request raises a fatal error if there is no unique index on the key columns.

The selection defaults to all columns. This default can be changed for all requests by the TableMapping.databaseSelection property, or for individual requests with the TableMapping.select method.

Deletes matching rows; returns the number of deleted rows.