Class
SQLCreateTriggerBuilder
Builds
SQLCreateTrigger queries.final class SQLCreateTriggerBuilderTopics
Instance Properties
var createTrigger: SQLCreateTriggerSQLCreateTriggerquery being built.var database: any SQLDatabaseConnection to execute query on.var query: any SQLExpressionQuery being built.
Instance Methods
func body(_:)Specify a body for the trigger.func columns(_:)Specify the columns to which the trigger applies.func condition(_:)Specify a conditional expression which determines whether the trigger is actually executed.func each(_:)Identifies whether the trigger applies to each row or each statement.func isConstraint() -> SelfSpecifies this is a constraint trigger.func order(precedence:otherTriggerName:)Specify whether this trigger precedes or follows a referenced trigger.func procedure(_:)Specify a procedure name for the trigger to execute.func referencedTable(_:)Specify the name of another table referenced by the constraint.func timing(_:)Specify the trigger’s timing.
Relationships
Conforms To
See Also
Query Builders
class SQLAlterEnumBuilderBuildsSQLAlterEnumqueries.class SQLAlterTableBuilderBuildsSQLAlterTablequeries.class SQLConflictUpdateBuilderA builder for specifying column updates and an optional predicate to be applied to rows that caused unique key conflicts during anINSERT.class SQLCreateEnumBuilderBuildsSQLCreateEnumqueries.class SQLCreateIndexBuilderBuildsSQLCreateIndexqueries.class SQLCreateTableBuilderBuildsSQLCreateTablequeries.class SQLDeleteBuilderBuildsSQLDeletequeries.class SQLDropEnumBuilderBuildsSQLDropEnumqueries.class SQLDropIndexBuilderBuildsSQLDropIndexqueries.class SQLDropTableBuilderBuildsSQLDropTablequeries.class SQLDropTriggerBuilderBuildsSQLDropTriggerqueries.class SQLInsertBuilderBuildsSQLInsertqueries.class SQLPredicateGroupBuilderNestedSQLPredicateBuilderfor building expression groups.class SQLRawBuilderBuilds raw SQL queries.class SQLReturningResultBuilderA builder returned from the methods ofSQLReturningBuilder; this builder wraps the original builder with one which providesSQLQueryFetcherconformance. As such, thereturning(_:)methods must always be the last ones in any call chain.