String

extension String: SQLDataType
extension String: QueryFilterProtocol, QueryHavingProtocol, QuerySuffixProtocol

  • Return database specific representation of the string type using QueryBuilder.

    Declaration

    Swift

    public static func create(queryBuilder: QueryBuilder) -> String

    Parameters

    queryBuilder

    The QueryBuilder to use.

    Return Value

    A String representation of the type.

  • Create a Filter clause using the in operator.

    Declaration

    Swift

    public func `in`(_ values: String...) -> Filter

    Parameters

    values

    The list of values for the in expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the in operator.

    Declaration

    Swift

    public func `in`(_ values: [String]) -> Filter

    Parameters

    values

    An array of values for the in expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the in operator and Parameter.

    Declaration

    Swift

    public func `in`(_ values: Parameter...) -> Filter

    Parameters

    values

    The list of values for the in expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the in operator and Parameter.

    Declaration

    Swift

    public func `in`(_ values: [Parameter]) -> Filter

    Parameters

    values

    An array of values for the in expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notIn operator.

    Declaration

    Swift

    public func notIn(_ values: String...) -> Filter

    Parameters

    values

    The list of values for the notIn expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notIn operator.

    Declaration

    Swift

    public func notIn(_ values: [String]) -> Filter

    Parameters

    values

    An array of values for the notIn expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notIn operator and Parameter.

    Declaration

    Swift

    public func notIn(_ values: Parameter...) -> Filter

    Parameters

    values

    The list of values for the notIn expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notIn operator and Parameter.

    Declaration

    Swift

    public func notIn(_ values: [Parameter]) -> Filter

    Parameters

    values

    An array of values for the notIn expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the between operator.

    Declaration

    Swift

    public func between(_ value1: String, and value2: String) -> Filter

    Parameters

    value1

    The left hand side of the between expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the between operator and Parameter.

    Declaration

    Swift

    public func between(_ value1: Parameter, and value2: Parameter) -> Filter

    Parameters

    value1

    The left hand side of the between expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notBetween operator.

    Declaration

    Swift

    public func notBetween(_ value1: String, and value2: String) -> Filter

    Parameters

    value1

    The left hand side of the notBetween expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notBetween operator and Parameter.

    Declaration

    Swift

    public func notBetween(_ value1: Parameter, and value2: Parameter) -> Filter

    Parameters

    value1

    The left hand side of the notBetween expression.

    Return Value

    A Filter containing the clause.

  • Create a Having clause using the in operator.

    Declaration

    Swift

    public func `in`(_ values: String...) -> Having

    Parameters

    values

    The list of values for the in expression.

    Return Value

    A Having containing the clause.

  • Create a Having clause using the in operator.

    Declaration

    Swift

    public func `in`(_ values: [String]) -> Having

    Parameters

    values

    An array of values for the in expression.

    Return Value

    A Having containing the clause.

  • Create a Having clause using the in operator and Parameter.

    Declaration

    Swift

    public func `in`(_ values: Parameter...) -> Having

    Parameters

    values

    The list of values for the in expression.

    Return Value

    A Having containing the clause.

  • Create a Having clause using the in operator and Parameter.

    Declaration

    Swift

    public func `in`(_ values: [Parameter]) -> Having

    Parameters

    values

    An array of values for the in expression.

    Return Value

    A Having containing the clause.

  • Create a Having clause using the notIn operator.

    Declaration

    Swift

    public func notIn(_ values: String...) -> Having

    Parameters

    values

    The list of values for the notIn expression.

    Return Value

    A Having containing the clause.

  • Create a Having clause using the notIn operator.

    Declaration

    Swift

    public func notIn(_ values: [String]) -> Having

    Parameters

    values

    An array of values for the notIn expression.

    Return Value

    A Having containing the clause.

  • Create a Having clause using the notIn operator and Parameter.

    Declaration

    Swift

    public func notIn(_ values: Parameter...) -> Having

    Parameters

    values

    The list of values for the notIn expression.

    Return Value

    A Having containing the clause.

  • Create a Having clause using the notIn operator and Parameter.

    Declaration

    Swift

    public func notIn(_ values: [Parameter]) -> Having

    Parameters

    values

    An array of values for the notIn expression.

    Return Value

    A Having containing the clause.

  • Create a Having clause using the between operator.

    Declaration

    Swift

    public func between(_ value1: String, and value2: String) -> Having

    Parameters

    value1

    The left hand side of the between expression.

    Return Value

    A Having containing the clause.

  • Create a Having clause using the between operator and Parameter.

    Declaration

    Swift

    public func between(_ value1: Parameter, and value2: Parameter) -> Having

    Parameters

    value1

    The left hand side of the between expression.

    Return Value

    A Having containing the clause.

  • Create a Having clause using the notBetween operator.

    Declaration

    Swift

    public func notBetween(_ value1: String, and value2: String) -> Having

    Parameters

    value1

    The left hand side of the notBetween expression.

    Return Value

    A Having containing the clause.

  • Create a Having clause using the notBetween operator and Parameter.

    Declaration

    Swift

    public func notBetween(_ value1: Parameter, and value2: Parameter) -> Having

    Parameters

    value1

    The left hand side of the notBetween expression.

    Return Value

    A Having containing the clause.

  • Create a Filter clause using the like operator.

    Declaration

    Swift

    public func like(_ pattern: String) -> Filter

    Parameters

    pattern

    The pattern to use in the like expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the like operator with Parameter.

    Declaration

    Swift

    public func like(_ pattern: Parameter) -> Filter

    Parameters

    pattern

    The pattern to use in the like expression as Parameter.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notLike operator.

    Declaration

    Swift

    public func notLike(_ pattern: String) -> Filter

    Parameters

    pattern

    The pattern to use in the notLike expression.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notLike operator with Parameter.

    Declaration

    Swift

    public func notLike(_ pattern: Parameter) -> Filter

    Parameters

    pattern

    The pattern to use in the notLike expression as Parameter.

    Return Value

    A Filter containing the clause.

  • Create a Having clause using the like operator.

    Declaration

    Swift

    public func like(_ pattern: String) -> Having

    Parameters

    pattern

    The pattern to use in the like expression.

    Return Value

    A Having containing the clause.

  • Create a Having clause using the like operator with Parameter.

    Declaration

    Swift

    public func like(_ pattern: Parameter) -> Having

    Parameters

    pattern

    The pattern to use in the like expression as Parameter.

    Return Value

    A Having containing the clause.

  • Create a Having clause using the notLike operator.

    Declaration

    Swift

    public func notLike(_ pattern: String) -> Having

    Parameters

    pattern

    The pattern to use in the notLike expression.

    Return Value

    A Having containing the clause.

  • Create a Having clause using the notLike operator with Parameter.

    Declaration

    Swift

    public func notLike(_ pattern: Parameter) -> Having

    Parameters

    pattern

    The pattern to use in the notLike expression as Parameter.

    Return Value

    A Having containing the clause.

String extensions

  • Process String as raw SQL using QueryBuilder.

    Throws

    QueryError.syntaxError if query build fails.

    Declaration

    Swift

    public func build(queryBuilder: QueryBuilder) throws -> String

    Parameters

    queryBuilder

    The QueryBuilder to use.

    Return Value

    A String representation of the query.

  • Create a Filter clause using the in operator for subquery.

    Declaration

    Swift

    public func `in`(_ query: Select) -> Filter

    Parameters

    query

    The subquery.

    Return Value

    A Filter containing the clause.

  • Create a Filter clause using the notIn operator for subquery.

    Declaration

    Swift

    public func notIn(_ query: Select) -> Filter

    Parameters

    query

    The subquery.

    Return Value

    A Filter containing the clause.

  • Create a Having clause using the in operator for subquery.

    Declaration

    Swift

    public func `in`(_ query: Select) -> Having

    Parameters

    query

    The subquery.

    Return Value

    A Having containing the clause.

  • Create a Having clause using the notIn operator for subquery.

    Declaration

    Swift

    public func notIn(_ query: Select) -> Having

    Parameters

    query

    The subquery.

    Return Value

    A Having containing the clause.