rexwilliams1234: there's no such thing as a primary genre, but you can look at which tags are the most popular (sort by artist_tag.count). determining which tags are genres is simply a matter of joining tag.name with genre.name
<bitmap[m]> "rexwilliams1234: there's no such..." <- The primary genre is not a big deal. A count works great. Being a week into this after setting up the server I am most interested in just getting some basics, especially finding the table relationships around artist to genre. For the example of the Beatles ... the musicbrainz website has these genres listed: rock, pop, pop rock, psychedelic pop, merseybeat. Am wanting to
reproduce that. From your comments I figure that I can use the Beatles artist id in the artist_tag table and go to the tag table to identify genre names, using count in the artist_tag table to find the most popular genres. Will look into this and do more homework. Thanks.
minimal has quit
bitmap[m]
<rexwilliams1234[> "The primary genre is not a big..." <- [this query](https://github.com/metabrainz/musicbrainz-server/blob/7cfbd49/lib/MusicBrainz/Server/Data/EntityTag.pm#L59-L65) from the MB server code should help (just the highlighted part is relevant for genres). `$self->tag_table` would be `artist_tag` and `$self->type` would be `artist` in your case
yvanzo: i spent a chunk of this weekend porting the prep chunk of [jira-server-vm](https://github.com/metabrainz/jira-server-vm) to ansible, and the repo for that is over here in [ansible-jira](https://github.com/metabrainz/ansible-jira). i've got the prepare-installation part mostly working, but am running into a bit of trouble with replicating [the rsync
task](https://github.com/metabrainz/jira-server-vm/blob/master/script/mirror_old_jira.sh#L11-L17); if you wouldn't mind having a look at [the corresponding ansible](https://github.com/metabrainz/ansible-jira/blob/main/roles/jira-mirror/tasks/main.yml) and seeing if i might be missing something, i'd appreciate it
that means.... haha badly tagedd music is the work of the (devil/demon)
??
mayhem[m]
zas: did you see the mail from hetzner about the two server updates -- we now have a window given to us. is that workable?
zas[m]
Yes, see MeB Sec channel ;)
mayhem[m]
ha great minds.
zas[m]
We have more time than expected to prepare, but the time window is still large
downtime should be under one hour anyway
mayhem[m]
and we can do this without downtime?
reosarevok[m] joined the channel
reosarevok[m]
bitmap: I get the feeling that we are giving modbot reorder medium errors more often than would make sense when one medium is being added and the existing removed
I see relatively often people getting confused by the modbot note on the relevant edits
