From Dev.to
Roll Back the Whole SQLite Batch When One Row Breaks a Constraint
A multi-row import can fail after an earlier row has already been inserted. Seeing an exception from executemany does not, by itself, answer whether the database still contains that earlier row. Make...