There's no state passed down to the IdentifierRow component. It just creates a row for every identifier with generic props.
2017-12-22 35641, 2017
S_Pradhan joined the channel
2017-12-22 35649, 2017
S_Pradhan
Hi
2017-12-22 35602, 2017
S_Pradhan
Can you please help me out
2017-12-22 35618, 2017
reosarevok
Maybe. What with_
2017-12-22 35619, 2017
reosarevok
?
2017-12-22 35644, 2017
S_Pradhan has quit
2017-12-22 35623, 2017
Lotheric has quit
2017-12-22 35623, 2017
xps2 joined the channel
2017-12-22 35606, 2017
MusicbrainzB0T1 joined the channel
2017-12-22 35642, 2017
Lotheric joined the channel
2017-12-22 35648, 2017
MusicbrainzB0T has quit
2017-12-22 35605, 2017
xps2 has quit
2017-12-22 35643, 2017
xps2 joined the channel
2017-12-22 35602, 2017
drsaunde joined the channel
2017-12-22 35605, 2017
heyoni has quit
2017-12-22 35628, 2017
heyoni joined the channel
2017-12-22 35646, 2017
naiveai
yvanzo: https://pastebin.com/GesFHu4Z first query gets the potentially confusing artists, and second query gets a list of recordings with their artist names in an array
yvanzo: for a detailed explanation, will "This report shows releases (official and promotional only) that have mediums with formats that support Disc ID, but do not have them"
2017-12-22 35631, 2017
annebelleo has quit
2017-12-22 35603, 2017
naiveai
what does "NOTICE: table "releases_missing_disc_ids" does not exist, skipping" when running a report mean?
2017-12-22 35622, 2017
SothoTalKer
moin moin
2017-12-22 35602, 2017
theremin
I've been talking to naiveai about psql not working on the pre-built VM. They said in #musicbrainz to maybe ask in here?
2017-12-22 35647, 2017
theremin
AND/OR, my main goal is to export a huge list of tracks in alpha order.
samj1912 has never been happier seeing so many zeroes :P
2017-12-22 35636, 2017
theremin
it's extracted
2017-12-22 35608, 2017
samj1912
theremin: now use any scripting language to extract the parts you want
2017-12-22 35624, 2017
samj1912
if you know some python, it should be a couple of lines of code
2017-12-22 35621, 2017
heyoni has quit
2017-12-22 35634, 2017
naiveai
this is very od
2017-12-22 35605, 2017
gcilou joined the channel
2017-12-22 35633, 2017
naiveai
yvanzo: done
2017-12-22 35625, 2017
zas
samj1912: I'll make the dashboard you need tomorrow
2017-12-22 35615, 2017
Leftmost
LordSputnik, would you say data migrations should go into bookbrainz-sql or only schema migrations?
2017-12-22 35623, 2017
samj1912
zas: Thanks!
2017-12-22 35634, 2017
LordSputnik
Leftmost: what sort of data migrations?
2017-12-22 35645, 2017
Leftmost
I just put together a PR that filters on identifier types. It sets the proper type on existing identifier types, creates new Wikidata identifier types for each entity type, and then migrates old Wikidata identifiers to the proper type.
2017-12-22 35612, 2017
LordSputnik
Hmm
2017-12-22 35625, 2017
LordSputnik
Yeah put it somewhere in -sql
2017-12-22 35635, 2017
Leftmost
Okay.
2017-12-22 35638, 2017
LordSputnik
Leftmost: speaking of data, I've been thinking of moving static lists like Creator Types, Work Types, Edition Format/Status into the code, rather than the database.
2017-12-22 35600, 2017
LordSputnik
Benefits are: adding types doesn't require a schema change; probably easier to use throughout the code
2017-12-22 35636, 2017
Leftmost
Adding types wouldn't require a schema change as-is. They're tables, not enums.
2017-12-22 35602, 2017
LordSputnik
Oh yeah, I meant database access, wasn't concentrating
2017-12-22 35618, 2017
LordSputnik
So someone can just submit a PR to add more types
2017-12-22 35641, 2017
Leftmost
It'd also make it impossible to tell what the type of a Creator is if they only had the database.
2017-12-22 35643, 2017
LordSputnik
And it reduces the amount of work needed to set up a new BB database from scratch, rather than from a dump
samj1912: yes, i set you as editor, so you can update/create dashboards, but please, only work on your dashboards, grafana is sometimes very picky, and you can easily break existing stuff. That's less an issue now because of the new feature https://github.com/grafana/grafana/pull/8472 but still, better not break things
2017-12-22 35654, 2017
yokel joined the channel
2017-12-22 35655, 2017
samj1912
okay, yup, will work on my own ones
2017-12-22 35601, 2017
samj1912
thanks
2017-12-22 35630, 2017
zas
note there are a lot of metrics stored in influxdb, ask me if you arent sure about smt, also you need to use derivatives to get bytes/s etc..
2017-12-22 35651, 2017
alastairp
hmm, I found a bug in the bcn metro ticket system
2017-12-22 35651, 2017
zas
check existing graphs queries
2017-12-22 35654, 2017
TehTotalPwnage has quit
2017-12-22 35601, 2017
samj1912
okay
2017-12-22 35604, 2017
naiveai
do we have indexes on any columns in the db?
2017-12-22 35648, 2017
zas
important: we collect metrics every minute, but queries are limited in number of results, so you can't draw detailed graphs over a long period, those are truncated silently, it is a bit disapointing sometimes. In any case, just ask me (and read docs ofc). I still have a lot of things to learn concerning this stack.
