#metabrainz

/

      • ruaok
        what Gentlecat said.
      • 2016-03-04 06428, 2016

      • alastairp
        if we add a new field which has a default value
      • 2016-03-04 06434, 2016

      • alastairp
        and forget to add it to the dumps
      • 2016-03-04 06440, 2016

      • alastairp
        then it'll import fine
      • 2016-03-04 06444, 2016

      • ruaok
        this wasn't done in MB and it bit us a number of time.
      • 2016-03-04 06445, 2016

      • Gentlecat
        or add a private field
      • 2016-03-04 06446, 2016

      • ruaok
        +s
      • 2016-03-04 06447, 2016

      • alastairp
        (and also forget to update the schema number)
      • 2016-03-04 06420, 2016

      • alastairp
        ruaok: right. knowing that not doing it in the past has been a problem is useful, thanks
      • 2016-03-04 06448, 2016

      • alastairp
        I'm just wondering if it's also a good idea to do an inspection of the columns in the table and compare it against our list
      • 2016-03-04 06451, 2016

      • alastairp
        to see if something is missing
      • 2016-03-04 06408, 2016

      • alastairp
        or just saying that we'll make it a people problem, and assume that someone will point it out if we make a mistake
      • 2016-03-04 06454, 2016

      • Gentlecat
        well, it's still our problem in that case, no? if we forget to make an update properly
      • 2016-03-04 06428, 2016

      • alastairp
        if we check on dump, we'd fail before we made a bad dump
      • 2016-03-04 06456, 2016

      • alastairp
        whereas if we didn't have the check and made a mistake, we wouldn't notice until we had a disaster and were recovering the data
      • 2016-03-04 06427, 2016

      • alastairp
        (I'm more explicitly thinking about our private dumps here, which won't be imported by others - no additional consumers to find the issue early)
      • 2016-03-04 06412, 2016

      • Gentlecat
        but in case of private dumps we can export all columns
      • 2016-03-04 06433, 2016

      • Gentlecat
        then it's just a matter of sorting them to make sure that ordering in consistent
      • 2016-03-04 06442, 2016

      • Gentlecat
        that's how it's done in CB
      • 2016-03-04 06444, 2016

      • alastairp
        explicitly or explicitly though?
      • 2016-03-04 06450, 2016

      • alastairp
        uh, explicitly or implicitly
      • 2016-03-04 06458, 2016

      • alastairp
        show me the cb dumps?
      • 2016-03-04 06402, 2016

      • Gentlecat
      • 2016-03-04 06433, 2016

      • Gentlecat
      • 2016-03-04 06405, 2016

      • alastairp
      • 2016-03-04 06411, 2016

      • alastairp
        ah, this is something from sqlalchemy?
      • 2016-03-04 06412, 2016

      • Gentlecat
        oh, sorry. I'm starting to forget how it works
      • 2016-03-04 06448, 2016

      • Gentlecat
        looks like we do this for all dumps
      • 2016-03-04 06450, 2016

      • alastairp
        so it looks like here you get the list of columns from the model
      • 2016-03-04 06455, 2016

      • Gentlecat
        but the idea would be the same
      • 2016-03-04 06403, 2016

      • alastairp
        which means if the model has changed since the dump was made, it won't work?
      • 2016-03-04 06416, 2016

      • alastairp
        I'm getting a weird sense of deja-vu. have we talked about this before?
      • 2016-03-04 06417, 2016

      • Gentlecat
        yeah, just because that's where they are defined
      • 2016-03-04 06428, 2016

      • Gentlecat
        another thing we have is schema version
      • 2016-03-04 06428, 2016

      • alastairp
        so I was thinking
      • 2016-03-04 06440, 2016

      • Gentlecat
        it is incremented after every schema change
      • 2016-03-04 06448, 2016

      • alastairp
        what if we inspect the database structure (how? does psycopg2 let us do this?)
      • 2016-03-04 06457, 2016

      • alastairp
        and compare that to the table dictionary that we have in the file
      • 2016-03-04 06431, 2016

      • alastairp
        right. I guess all of what I'm asking is for a last-chance check if we for some reason forget to update the dumps after we make a change to the database tables
      • 2016-03-04 06404, 2016

      • alastairp
        in the normal case, we would make an updte script, change the schema version, and update the table definition
      • 2016-03-04 06418, 2016

      • Gentlecat
        so you are trying to find more safe way to get columns then from these lists that we have with dumping code?
      • 2016-03-04 06447, 2016

      • alastairp
        in the exceptional case, I hurredly make a patch and deploy it without putting it through PR, because it's "urgent", and forget, and you don't pick up on it
      • 2016-03-04 06449, 2016

      • alastairp
        yes, exactly
      • 2016-03-04 06450, 2016

      • Gentlecat
        are you concerned about importing or dumping?
      • 2016-03-04 06407, 2016

      • alastairp
        I was concerned about importing
      • 2016-03-04 06418, 2016

      • alastairp
        but after thinking about it, I think that dumping is the correct place to do it
      • 2016-03-04 06423, 2016

      • alastairp
        maybe both?
      • 2016-03-04 06421, 2016

      • alastairp
        perhaps I just don't trust myself and I shouldn't be so hard
      • 2016-03-04 06439, 2016

      • Gentlecat
        maybe we can query information_schema to get columns and tables, but this might make it unnecessarily complex
      • 2016-03-04 06453, 2016

      • alastairp
        yeah, exactly
      • 2016-03-04 06457, 2016

      • alastairp
        there's a lot of complexity there
      • 2016-03-04 06401, 2016

      • alastairp
        ok, --> home for lunch
      • 2016-03-04 06403, 2016

      • alastairp
        back soon
      • 2016-03-04 06439, 2016

      • Gentlecat
        oh, btw
      • 2016-03-04 06440, 2016

      • Gentlecat
        maybe not
      • 2016-03-04 06444, 2016

      • Gentlecat
        nvm
      • 2016-03-04 06459, 2016

      • kartikgupta0909
        alastairp: I have made a pull request for AB-79, can you please review that whenever possible.
      • 2016-03-04 06422, 2016

      • Gentlecat
        kartikgupta0909: you shouldn't create a new pull request for every update when you are working on the same thing
      • 2016-03-04 06431, 2016

      • Gentlecat
        just update the same one
      • 2016-03-04 06442, 2016

      • Gentlecat
        either create a new commit or force push
      • 2016-03-04 06400, 2016

      • Gentlecat
        also, it's more useful when titles are more descriptive
      • 2016-03-04 06407, 2016

      • kartikgupta0909
        actually I deleted my fork by mistake. thats why had to make a new one
      • 2016-03-04 06415, 2016

      • kartikgupta0909
        Oh okay I ll note about the titles
      • 2016-03-04 06422, 2016

      • Gentlecat
        "Changed the schema for dataset table and worked on AB-79" doesn't tell me much
      • 2016-03-04 06440, 2016

      • Gentlecat
        I updated your old one
      • 2016-03-04 06402, 2016

      • kartikgupta0909
        Okay I ll keep in mind to give more descriptive messages from next time
      • 2016-03-04 06420, 2016

      • Gentlecat
        you can still update it, I think
      • 2016-03-04 06452, 2016

      • kartikgupta0909
        Oh, even after deleting my previous fork and making a new fork?
      • 2016-03-04 06408, 2016

      • Gentlecat
        on a pull request that you just created
      • 2016-03-04 06416, 2016

      • kartikgupta0909
        oh okay the message
      • 2016-03-04 06423, 2016

      • kartikgupta0909
        That i ll do it right now
      • 2016-03-04 06426, 2016

      • kartikgupta0909
        Gentlecat: Updated the message
      • 2016-03-04 06421, 2016

      • gcilou has quit
      • 2016-03-04 06459, 2016

      • AadityaNair joined the channel
      • 2016-03-04 06403, 2016

      • rahulr
        (Need a little Picard help) How do I refresh the coverart box? I've made changes to image metadata after save is triggered (i.e. on a File object). I want to pass this new metadata to the coverartbox so it can reflect the change.
      • 2016-03-04 06426, 2016

      • rahulr
        bitmap: Maybe you've got some idea? ^
      • 2016-03-04 06407, 2016

      • gcilou joined the channel
      • 2016-03-04 06439, 2016

      • gcilou
        Freso, yeah option 3 sounds best for me and my mom :)
      • 2016-03-04 06423, 2016

      • regagain joined the channel
      • 2016-03-04 06441, 2016

      • Skeebadoo
        LordSputnik: Q about wikidata ids
      • 2016-03-04 06458, 2016

      • Skeebadoo
        This is how I've added a few books so far: http://svgur.com/i/33.svg
      • 2016-03-04 06406, 2016

      • Skeebadoo
        Simple case scenario: one author : one book
      • 2016-03-04 06445, 2016

      • Skeebadoo
        Publication (EG) doesn't get any identifiers b/c it's an artificial grouping entity
      • 2016-03-04 06410, 2016

      • Skeebadoo
        However wikidata ids seem to be corresponding to it
      • 2016-03-04 06436, 2016

      • Skeebadoo
        I mean, wikidata items identified as literary work
      • 2016-03-04 06449, 2016

      • Skeebadoo
        So I guess wikidata ids should be moved from works to publications?
      • 2016-03-04 06433, 2016

      • outsidecontext joined the channel
      • 2016-03-04 06416, 2016

      • Skeebadoo
        Oh and also what's the reason behind making 'authored' a relationship between entities while the publisher is an inherent property of the edition?
      • 2016-03-04 06444, 2016

      • Skeebadoo
        Or is it just the way it displays and there's no difference in the database?
      • 2016-03-04 06406, 2016

      • armalcolite
        kafka.common.KafkaUnavailableError: All serbers failed to process request.
      • 2016-03-04 06412, 2016

      • armalcolite
        *servers
      • 2016-03-04 06444, 2016

      • armalcolite
        i installed blist==1.3.6 instead of 1.3.4
      • 2016-03-04 06404, 2016

      • armalcolite
        can this be the possible reason for the error?
      • 2016-03-04 06432, 2016

      • Leftmost joined the channel
      • 2016-03-04 06425, 2016

      • reosarevok
      • 2016-03-04 06434, 2016

      • reosarevok
        Maybe someone wants to tell them that that schema is horribly outdated? :p
      • 2016-03-04 06444, 2016

      • outsidecontext
        I wonder how much fun it is to have the MB database all stored in sqlite
      • 2016-03-04 06448, 2016

      • kahu has quit
      • 2016-03-04 06423, 2016

      • harshul_pythonis joined the channel
      • 2016-03-04 06433, 2016

      • reosarevok
        there Freso, I have my 1M autoedits now :p
      • 2016-03-04 06457, 2016

      • harshul_pythonis
        Hi everyone. I am harshul jain.I want to contribute in accousticbrrainz project, using Python, Postgress and flask. Am I going right by first configuring the server,then using the submitting tool for local server and understanding how the infrastructure works? Atleast this is what ideas page says. https://wiki.musicbrainz.org/Development/Summer_o…
      • 2016-03-04 06447, 2016

      • harshul_pythonis has quit
      • 2016-03-04 06424, 2016

      • vidhan has quit
      • 2016-03-04 06445, 2016

      • harshul1610 joined the channel
      • 2016-03-04 06408, 2016

      • mihaitish has quit
      • 2016-03-04 06450, 2016

      • harshul1610
        Hi everyone, my name is harshul jain. I am a pythonist based in India. I will like to contribute to accousticbrainz project using python, flask and postgress. According to https://wiki.musicbrainz.org/Development/Summer_o… page, I am in process of setting up my development server and understanding how infrastructure works. Am I going with right approach?
      • 2016-03-04 06408, 2016

      • zag joined the channel
      • 2016-03-04 06402, 2016

      • reosarevok
        harshul1610: if you're setting up stuff on your own and you can prove that you can get stuff working (mostly) by yourself, then my understanding is that yes, you're in the right direction
      • 2016-03-04 06410, 2016

      • reosarevok
        (but I'm not involved with AB specifically)
      • 2016-03-04 06455, 2016

      • zag2 has quit
      • 2016-03-04 06418, 2016

      • harshul1610 has quit
      • 2016-03-04 06430, 2016

      • harshul1610 joined the channel
      • 2016-03-04 06426, 2016

      • harshul1610
        Hi everyone, my name is harshul jain. I am a pythonist based in India. I will like to contribute to accousticbrainz project using python, flask and postgress. According to https://wiki.musicbrainz.org/Development/Summer_o… page, I am in process of setting up my development server and understanding how infrastructure works. Am I going with right approach?
      • 2016-03-04 06456, 2016

      • kepstin
        harshul1610: please don't spam the channel; we saw your message the first two times, and reosarevok has already responded.
      • 2016-03-04 06422, 2016

      • kepstin
        (if your internet connection isn't very reliable, you might want to look at our irc logs, or try a service like irccloud)
      • 2016-03-04 06410, 2016

      • harshul1610
        yes. internet connection is not reliable at this moment. let me look at logs. sorry for inconvinience.
      • 2016-03-04 06420, 2016

      • diana_olhovyk has quit
      • 2016-03-04 06445, 2016

      • harshul1610 has left the channel
      • 2016-03-04 06408, 2016

      • zag has quit
      • 2016-03-04 06459, 2016

      • harshul1610 joined the channel
      • 2016-03-04 06454, 2016

      • tungol joined the channel
      • 2016-03-04 06457, 2016

      • stanislas has quit
      • 2016-03-04 06457, 2016

      • mRokita_ has quit
      • 2016-03-04 06431, 2016

      • reosarevok
        Gah https://twitter.com/reddmoody we get it, you have a single
      • 2016-03-04 06454, 2016

      • reosarevok wishes he'd stop spamming the MB link to it and getting in the way of useful MB-related tweets :/
      • 2016-03-04 06404, 2016

      • reosarevok
        At least it's not straight-up unrelated spam...
      • 2016-03-04 06445, 2016

      • JesseW joined the channel
      • 2016-03-04 06404, 2016

      • harshul1610 has quit
      • 2016-03-04 06456, 2016

      • tungol has quit
      • 2016-03-04 06420, 2016

      • tungol joined the channel
      • 2016-03-04 06449, 2016

      • tungol has quit
      • 2016-03-04 06445, 2016

      • Mineo joined the channel
      • 2016-03-04 06445, 2016

      • mRokita joined the channel
      • 2016-03-04 06445, 2016

      • mRokita has quit
      • 2016-03-04 06445, 2016

      • mRokita joined the channel
      • 2016-03-04 06454, 2016

      • harshul1610 joined the channel
      • 2016-03-04 06446, 2016

      • stanislas joined the channel
      • 2016-03-04 06403, 2016

      • JesseW has quit
      • 2016-03-04 06450, 2016

      • bitmap
        rahulr: probably through tagger.window.cover_art_box.set_metadata
      • 2016-03-04 06459, 2016

      • gcilou has quit
      • 2016-03-04 06418, 2016

      • gcilou joined the channel
      • 2016-03-04 06448, 2016

      • outsidecontext has quit
      • 2016-03-04 06416, 2016

      • Somasis has quit
      • 2016-03-04 06431, 2016

      • harshul1610 has quit
      • 2016-03-04 06446, 2016

      • rahulr
        bitmap: Thanks. It worked, but only for a fraction of second, then again the initial image is displayed. But I think I can figure this out. Will ask if couldn't. :)
      • 2016-03-04 06406, 2016

      • bitmap
        :)
      • 2016-03-04 06409, 2016

      • Leftmost
        LordSputnik, did you ever put up the Doodle?
      • 2016-03-04 06429, 2016

      • harshul1610 joined the channel
      • 2016-03-04 06407, 2016

      • armalcolite
        on running "manage.py init_db" it says role "listenbrainz" already exists
      • 2016-03-04 06427, 2016

      • armalcolite
        i then forced the db creating using -f