Skip to contents

Converts a URL-friendly slug to a full artist record. This is the entry point for artist profile pages - when a user visits /artist/jane-doe, use this function to resolve the slug to an artist UUID and profile data.

Returns NULL if no artist matches the slug, allowing you to render a 404. The result includes artist preferences (featured artwork/collection) via a LEFT JOIN, so these fields may be NA for artists without preferences.

Usage

get_artist_by_slug(slug, cn = NULL)

Arguments

slug

URL-friendly artist identifier (e.g., "jane-doe"). Generated from artist name during registration.

cn

Optional database connection. Pass an existing connection to avoid connection overhead when making multiple queries.

Value

data.table with artist profile fields (artist_uuid, artist_name, bio, location, social URLs, etc.), or NULL if not found.

Examples

if (FALSE) { # \dontrun{
artist_record <- get_artist_by_slug("jane-doe")
if (!is.null(artist_record)) {
  artist <- artist_record$artist_uuid
  # Use artist UUID for subsequent queries
}
} # }