Spotify and Youtube - Access Token + Refresh Token
Deezer - Non-expiring Access Token
Apple Music - Expiring Access Token, refresh manually (need to confirm this one, Mr_Monkey found something in Apple docs which suggest that the usual refresh token process might be possible)
Mr_Monkey, ruaok, alastairp: I think we can use this schema for storing user tokens to external services.
alastairp
so you'd put specific implementation details (token, refresh token, etc) in auth_details?
_lucifer
yes because they differ across most services
if the user opts for only playback say using deezer or apple music, we probably do not need to store their access tokens in the database so that column is optional
Mr_Monkey
I don't see that optional column; am i missing something?
_lucifer
use of refresh tokens and permissions also varies across services
Mr_Monkey
ah, you mean the whole auth_details is optional
alastairp
for a service with no expiring token, would `token_expires` be null?
now that I look at it again, even `token_expires` can be moved into `auth_details`. I am not sure whether its better to have a column allowing NULL values or move it into `JSONB`. thoughts?
the same logic can be applied to `access_token` and `refresh_token` as to whether they should have their own columns with NULL allowed or kept in JSONB.
Etua joined the channel
Etua has quit
sumedh has quit
CatQuest has quit
shivam-kapila heard of deezer for thr 1st time
sumedh joined the channel
ruaok
I'm ok with `access_token` and `refresh_token` being in JSONB.
reosarevok, yvanzo: is there a good reason we don't store the email until it's verified? seems like it'd make the system less confusing
yvanzo
Hi bitmap, I don’t see any but then we should check permissions always depend on having verified email, not just on having email.
c1e0_ has quit
c1e0_ joined the channel
outsidecontext
zas: looks like I can't be around for the meeting today :(
zas
outsidecontext: can you send a mail to freso @ meb to summarize weblate advantages over transifex? At least it will give people matter to think about, and we can wait you're around to discuss this in details
_lucifer
alastairp, around?
alastairp
hello!
_lucifer
are you available to debug the jenkins issue?
alastairp
in ~30 minutes?
_lucifer
works for me 👍
outsidecontext
zas: yes, will do
alastairp
outsidecontext: thanks for that. is this related to the forum thread?
outsidecontext
yes
alastairp
I think this might have been started by me making a mistake with deploying jesus' CB translations
I'll have a quick look at the thread later today and see if I can make another release
outsidecontext
alastairp: we wanted to try weblate for Picard as a pilot project, basically.
zas: if it's ok let's move this discussion to next week, dealing with some work trouble here right now and won't be able to get something written down. I can prepare something for the next meeting
zas
ok, np
HenryG has quit
HenryG joined the channel
Zhele_ has quit
yvanzo
zas: would it be feasible to host our own instance of weblate?
Nizar joined the channel
zas
I guess so, but we need resources for that, prolly a VM, and time, backups, etc...
reosarevok
bitmap: I dunno, tbh. I expected it was a conscious decision not to store data that might be made up or whatever
But it might just be a historical accident
yvanzo
I did test weblate with docker last year but did not complete using MB OAuth with it.
c1e0_ is now known as c1e0
alastairp
_lucifer: sorry, time got away on me
what's up
_lucifer
hi!
CatQuest
honestly the faster we move ovv from transifex the better
_lucifer
I looking on the pending PRs and thought to discuss and move ahead the Jenkins image cleanup one. Last time, we were discussing filtering on name so that different projects don't clean each others images.
alastairp
yes, right
(we might have to postpone this discussion during meeting time, are you planning on finishing for the day after meeting or can you stay around?)
reosarevok
I dunno, transifex isn't that awful
But I'm not against a change either
_lucifer
i can stay around for another hour after the meeting
but this turns into 'listenbrainzunittest_jenkinsbuild_jenkis_[job jame]-1238'
which is huge
_lucifer
yeah, the job name seems redundant.
alastairp
I think we should use BUILD_TAG, then. we might just be able to do COMPOSE_PROJECT_NAME_ORIGINAL=${BUILD_TAG}, because I think it contains all of the information
I bring it up just to clean up the names of the containers/images
_lucifer
makes sense.
alastairp
so now going back to the filter, maybe we should just filter on label _and_ project name
_lucifer
we also have some none:none in the output when we list images.
alastairp
do you have a `docker image ls` command that reproduces this?
_lucifer
yes, i also have a build on ci showing that. let me find that
yvanzo
reosarevok: It’s not that awful indeed but it has a few hiccups and doesn’t allow for MB auth.
alastairp
this is the --format {{.Repository}}:{{.Tag}} bit, so it strikes me that there's an image layer around which matches the label filter, but doesn't have a tag for some reason
reosarevok
yvanzo: sure, not saying we can't improve on it, just wanna make sure it's an improvement :)
alastairp
filtering based on the name will solve this, but it also means that we might leave it behind and not pick it up with the filter
People up for reviews: yvanzo, bitmap, zas, alastairp, Mr_Monkey, Freso, reosarevok, _lucifer, ruaok, shivam-kapila, CatQuest – anyone else who want to give review, let me know ASAP!
I haven’t received any mailed in reviews, so…
yvanzo: Go!
alastairp
I'm going to add to this PR right now a filter to include the repository too
yvanzo
Hi all!
alastairp
we can continue after meeting
_lucifer
👍
yvanzo
Sorry alastairp and _lucifer for interrupting ;)
Last week I helped reosarevok with scheduling schema changes.
Also fixed a regression I caused in annotation formatting.
Plus reviewed some PRs and that’s all.
Go reosarevok?
reosarevok
Hi!
Last week I spent quite a bit of time putting together schema change tickets and preparing a blog post for them (with help from the team, thanks all)
I also fixed a bunch of ISEs that slipped past testing / review from a huge bitmap PR and hotfixed them
c1e0
Hi folks!
reosarevok
And started working on some smaller schema change tickets
Freso
Hi c1e0!!
reosarevok
Plus the usual triaging
And fixing small old stuff
I plan to do the same this week, plus hopefully some hiking and birdwatching
Since I need to take some days half-off or I'll go over my hour limit, lol