Function nameExists

internal/instructions/store.go:221–231

nameExists reports whether a row with name exists, optionally excluding an id.

(ctx context.Context, q queryer, name string, excludeID int64)

// nameExists reports whether a row with name exists, optionally excluding an id.
func nameExists(ctx context.Context, q queryer, name string, excludeID int64) (bool, error) {
	var existingID int64
	err := q.QueryRowContext(ctx, `SELECT id FROM instructions WHERE name = ?`, name).Scan(&existingID)
	if err == sql.ErrNoRows {
		return false, nil
	}
	if err != nil {
		return false, err
	}
	return existingID != excludeID, nil
}

// writeManagedFile atomically writes content to the managed file for name.
func writeManagedFile(name, content string) error {