Constraint raised by a trigger

SQLITE_CONSTRAINT_TRIGGER (1811) is returned when a trigger raises a constraint violation using the RAISE() function.

1. 1A BEFORE or AFTER trigger called RAISE(ABORT, 'message') or RAISE(FAIL, 'message').
2. 2Business logic enforced via triggers rejected the DML operation.

INSERT, UPDATE, or DELETE that fires a trigger containing RAISE().

import sqlite3
conn = sqlite3.connect(':memory:')
conn.execute('CREATE TABLE t(x)')
conn.execute("""
  CREATE TRIGGER no_negatives BEFORE INSERT ON t
  BEGIN
    SELECT RAISE(ABORT, 'negative values not allowed')
    WHERE NEW.x < 0;
  END
""")
try:
    conn.execute('INSERT INTO t VALUES(-1)')
except sqlite3.IntegrityError as e:
    print(e)  # negative values not allowed

sqlite3.IntegrityError: negative values not allowed

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev