german also has cases, but the system's a lot less complicated than estonian's
warp
ah, then a german example would probably help me understand it better.
ianmcorvidae
but for example "{age} ago" doesn't work in german because the preposition you have to use to translate 'ago' changes the thing into a different case than what you'd use for an age alone
i.e. 'am 7 Jahren' rather than '7 Jahre'
er, not am, vor
and the case ending isn't always just 'add n', so you can't just make it 'vor {age}n', which would of course be a gross hack anyway :P
I could easily see estonian translating "Artist" and "Artist:" differently, because the context provided by the ':' might change the case
Previously if you talked in an edit you would receive notifications…
ijabz joined the channel
ijabz_ joined the channel
ijabz
warp, ping
stefans joined the channel
warp
ijabz: ack
reosarevok joined the channel
ocharles
good morning
warp: no standard way
and yes, you've asked before :)
warp
ocharles: ok
ocharles
warp: the 'standard' postgres way is to update, check the row count returned, insert if it's not what you expected, and do all this in a loop; you break if the insert completed without exceptions, and you loop if there was a primary key violation
warp
what I have now is:
INSERT INTO cover_art_archive.release_group_cover_art (release_group, release)
(SELECT ? AS release_group, ? AS release WHERE NOT EXISTS
(SELECT 1 FROM cover_art_archive.release_group_cover_art
WHERE release_group = ?));",
ocharles
that's what an approach
warp
(which I haven't tested yet)
ocharles
you can simplify it with a function in postgresql and use try/catch
but you can't do that outside a postgresql function without causing the exception to be logged, which i would like to avoid :)
warp
ah
I'll stick to this, assuming it works. you can offer alternatives on the code review if you come up with something better :)
ocharles
ocharles has changed the topic to: Arctic week! | http://musicbrainz.org/#devel | Agenda: replication packets (ocharles), schema change progress, nes3 (ocharles), github (ocharles), translations (ian), MBS-2377 DR (ocharles), MBS-3059 DR (ocharles), echoprint "partnership" (reotab)
ianmcorvidae
ianmcorvidae has changed the topic to: Arctic week! | http://musicbrainz.org/#devel | Agenda: replication packets (ocharles), schema change progress, nes3 (ocharles), github (ocharles), MBS-2377 DR (ocharles), MBS-3059 DR (ocharles), echoprint "partnership" (reotab), translations (ian)
ianmcorvidae puts myself at the end of the line, everything else seems more important
reosarevok
Not mine :p
(and heh, sounds like another looong meeting)
warp
ocharles: I guess we should release today.
reosarevok
Remember to revert the relationship editor first, if it's not done yet
ocharles
i know
i'm doing it now
warp
ok :)
ocharles
well that was to reosarevok, but I guess it applies to your comment too :)
warp
haha
>_<
ianmcorvidae hopes jenkins for master is fixed?
ocharles ponders how to revert the relationship editor
ocharles
ianmcorvidae: not that i know
nikki
is that why beta is so slow then?
DremoraLV joined the channel
ocharles
possibly
but i don't think so right now, cause jenkins isn't doing anything
ocharles questions how well this revert is going to work
doing it on the day of the release is fun
warp
:)
ocharles
All tests successful.
ok, the site will be perfect. yay
ianmcorvidae: what exactly am I testing on the edit search?
ianmcorvidae
ocharles: do a search, get results, then try to add a new property and hit search again
ocharles
ok
ianmcorvidae
before my fix that wouldn't work, but it had to do with the new jquery version, so I want to make sure my fix doesn't need reverting too.