Recalculate aggregate stats after artwork changes

Recalculates aggregated statistics in artist_stats table. Call this after adding or removing artworks to keep counts accurate.

Computes: total_brushes, total_hours, total_artworks, total_collections, ave_bpm, ave_brushes, ave_hours.

Usage

updateArtistStats(artist, cn = NULL)

Arguments

artist

Artist UUID

cn

Database connection. If NULL, opens and closes automatically.

Value

NULL invisibly. Updates database as side effect.

See also

Other data-modify: addArtwork(), addCollection(), updateArtistBenchmarks()