Creates a unique, URL-safe slug from an artist's full name.
Usage
.gen_artist_slug(full_name, cn = NULL)
Arguments
- full_name
Character. Artist's full display name (required).
- cn
Database connection. Required for uniqueness check.
Value
Character string containing the unique URL-friendly slug.
Details
The slug generation process:
Converts name to lowercase
Replaces non-alphanumeric characters with hyphens
Removes leading/trailing hyphens
Collapses multiple consecutive hyphens
Checks database for uniqueness, appending counter if needed
Uniqueness
If the base slug already exists in the database, a numeric suffix is
appended (e.g., "jane-doe-1", "jane-doe-2") until a unique slug is found.
