///|
/// Parser-free data execution shared by SQL and precompiled entry points.
fn execute_data_statement(
store : Store,
statement : DataStatement,
params : Array[Value],
prepared_selection~ : PreparedSelection? = None,
) -> Array[Environment] raise SqlError {
let previous = store.triggers.prior_changes
store.triggers.prior_changes = connection_changes(store)
store.triggers.data_depth += 1
if !data_readonly(statement) {
store.triggers.failed_statement = false
}
defer {
store.triggers.prior_changes = previous
store.triggers.data_depth -= 1
}
let result = match statement {
PreparedTransaction(op, name) => return execute_transaction(store, op, name)
PreparedSelect(select) =>
return select_rows(store, select, params, 0, prepared=prepared_selection)
PreparedPragma(name, table) =>
return execute_pragma(store, name, table, None, params)
PreparedInsert(insertion) => insert_rows(store, insertion, params)
PreparedUpdate(name, setters, predicate, returning) => {
let table = get_table(store, name)
prepare_foreign_table(store, table)
prepare_trigger_event(store, table, "update", setters.map(p => p.0))
let with_triggers = store.objects.any(o => {
o.kind == "trigger" &&
matches_identifier(o.table, identifier(table.name))
})
let rows : Array[Environment] = []
store.changes = 0
let template = row_environment(
table,
{ id: 0L, values: Array::make(table.columns.length(), Null), },
table.name,
)
prepare_expression(
predicate,
evaluation(store, params, template),
false,
false,
)
prepare_returning(returning, evaluation(store, params, template))
for (n, e) in setters {
ignore(column_index(table, n))
prepare_expression(e, evaluation(store, params, template), false, false)
}
for
candidate in primary_candidates(store, table, predicate, params, name).unwrap_or_else(() => {
candidate_rows(
store,
table,
rowid_equality(table, predicate, params, name),
)
},
) {
let row = if with_triggers {
guard table_row_by_id(store, table, candidate.id) is Some(current) else {
continue
}
current
} else {
candidate
}
if truth(
evaluate(
predicate,
evaluation(store, params, row_environment_from(template, row)),
),
) !=
1 {
continue
}
let next = updated_row(store, table, row, setters, [], params)
if !run_triggers(
store,
table,
"before",
"update",
setters.map(p => p.0),
Some(row),
Some(next),
) {
continue
}
if !check_updated_row(
store,
table,
row,
next,
params,
policy=store.triggers.conflict_override,
) {
continue
}
foreign_restrict(store, table, row, Some(next))
replace_table_row(store, table, row, next)
foreign_actions(store, table, row, Some(next), 0)
store.changes += 1
if !returning.is_empty() {
rows.push(
project(
returning,
evaluation(store, params, row_environment_from(template, next)),
),
)
}
ignore(
run_triggers(
store,
table,
"after",
"update",
setters.map(p => p.0),
Some(row),
Some(next),
),
)
}
rows
}
PreparedDelete(name, predicate, returning) => {
let table = get_table(store, name)
prepare_foreign_table(store, table)
prepare_trigger_event(store, table, "delete", [])
let with_triggers = store.objects.any(o => {
o.kind == "trigger" &&
matches_identifier(o.table, identifier(table.name))
})
let rows : Array[Environment] = []
store.changes = 0
let template = row_environment(
table,
{ id: 0L, values: Array::make(table.columns.length(), Null), },
table.name,
)
prepare_expression(
predicate,
evaluation(store, params, template),
false,
false,
)
prepare_returning(returning, evaluation(store, params, template))
for
candidate in primary_candidates(store, table, predicate, params, name).unwrap_or_else(() => {
candidate_rows(
store,
table,
rowid_equality(table, predicate, params, name),
)
},
) {
let row = if with_triggers {
guard table_row_by_id(store, table, candidate.id) is Some(current) else {
continue
}
current
} else {
candidate
}
let ctx = evaluation(store, params, row_environment_from(template, row))
if truth(evaluate(predicate, ctx)) != 1 {
continue
}
if delete_row(store, table, row, 0, true) {
if !returning.is_empty() {
rows.push(project(returning, ctx))
}
store.changes += 1
}
}
rows
}
}
if !store.deferred && store.triggers.active.is_empty() {
validate_foreign_keys(store, immediate=true)
}
result
}