Method Close

backend/database/sql/sqlite.go:415–434

Close closes the database connection and removes the temporary file if it is not persistent.

()

// Close closes the database connection and removes the temporary file if it is not persistent.
func (t *TempDB) Close() error {
	t.mu.Lock()
	defer t.mu.Unlock()

	if t.db != nil {
		if err := t.db.Close(); err != nil {
			// Only remove file if it's not persistent
			if t.config != nil && t.config.PersistentFile == "" {
				os.Remove(t.path)
			}
			return err
		}
	}

	// Only remove file if it's not persistent
	if t.config != nil && t.config.PersistentFile == "" {
		return os.Remove(t.path)
	}
	return nil
}

// verifyPragmaSettings reads back PRAGMA values to verify they were applied correctly
func verifyPragmaSettings(db *sql.DB, cfg *TempDBConfig) error {