func (tr *Transaction) Insert(t *table.Table, row map[string]string) int {
// Execute "before insert" triggers.
beforeTable, status := tr.DB.Get("~before")
if status != st.OK {
return status
}
triggerRA := ra.New()
_, status = triggerRA.Load(beforeTable)
if status != st.OK {
return status
}
_, status = triggerRA.Select("TABLE", filter.Eq{}, t.Name)
if status != st.OK {
return status
}
status = trigger.ExecuteTrigger(tr.DB, t, triggerRA, "IN", row, nil)
if status != st.OK {
return status
}
// Insert the new row to table.
numberOfRows, status := t.NumberOfRows()
if status != st.OK {
return status
}
status = t.Insert(row)
if status != st.OK {
return status
}
// Execute "after insert" triggers.
afterTable, status := tr.DB.Get("~after")
if status != st.OK {
return status
}
triggerRA = ra.New()
_, status = triggerRA.Load(afterTable)
if status != st.OK {
return status
}
_, status = triggerRA.Select("TABLE", filter.Eq{}, t.Name)
if status != st.OK {
return status
}
status = trigger.ExecuteTrigger(tr.DB, t, triggerRA, "IN", row, nil)
if status != st.OK {
return status
}
// Log the inserted row.
tr.Log(&UndoInsert{t, numberOfRows})
return st.OK
}
