Method set_autocommit

crates/stdlib/src/_sqlite3.rs:1527–1553

(&self, val: PyObjectRef, vm: &VirtualMachine)

        }
        #[pygetset(setter)]
        fn set_autocommit(&self, val: PyObjectRef, vm: &VirtualMachine) -> PyResult<()> {
            let mode = AutocommitMode::try_from_borrowed_object(vm, &val)?;
            let db = self.db_lock(vm)?;

            // Handle transaction state based on mode change
            match mode {
                AutocommitMode::Enabled => {
                    // If there's a pending transaction, commit it
                    if !db.is_autocommit() {
                        db._exec(b"COMMIT", vm)?;
                    }
                }
                AutocommitMode::Disabled => {
                    // If not in a transaction, begin one
                    if db.is_autocommit() {
                        db._exec(b"BEGIN", vm)?;
                    }
                }
                AutocommitMode::Legacy => {
                    // Legacy mode doesn't change transaction state
                }
            }

            drop(db);
            *self.autocommit.lock() = mode;
            Ok(())
        }

        #[pygetset]
        fn text_factory(&self) -> PyObjectRef {