Transactions in Make¶
Each call of the make method is enclosed in a transaction. DataJoint users do not need to explicitly manage transactions but must be aware of their use.
Transactions produce two effects:
First, the state of the database appears stable within the
make call throughout the transaction:
two executions of the same query will yield identical results within the same
Second, any changes to the database (inserts) produced by the
make method will not become visible to other processes until the
make call completes execution.
make method raises an exception, all changes made so far will be discarded and will never become visible to other processes.
Transactions are particularly important in maintaining group integrity with master-part relationships.
make call of a master table first inserts the master entity and then inserts all the matching part entities in the part tables.
None of the entities become visible to other processes until the entire
make call completes, at which point they all become visible.