Jan 12 2020
I'm getting through this task quite nicely but just have a couple of concerns:
Firstly, for adding in the tooltips that use Flask-JSONLocale, is it ok that I cannot translate them into all of the languages?
Secondly, I'm having some issues with getting the data by selecting multiple options in a <select multiple> that I'd like to discuss on IRC please, and how I can then translate this into SQL. Thanks!
Jan 8 2020
Dec 22 2019
For future reference, I've decided to do the following:
Dec 20 2019
Excited to be working with you again, Mr Urbanec on my first Tracker task! In terms of my approach to this, I have come up with two options:
- Redirect everyone to /my/details after registering and add 'PLEASE COMPLETE' in red text next to bank account so that it stands out therefore compelling them to fill it in.
- Redirect everyone to a new page which says 'Please fill in the following details: (copy of parts of /my/details)' + a skip button.
Dec 19 2019
It says on the dashboard page that it's only on Wikipedia UK so I'll push my changes to Gerrit as described above! Thanks, Mr Urbanec.
Just want to check, if I may, whether I should be allowing a grace period before/after the event and also in the value of users? Right now I've extended the exception for one hour either side of the event and also set a value of 25 because 'expecting roughly 15 people', in my mind, may rise up to such number. Is this ok or should I change these settings? Thanks!
Hiya, I'll be working on this task hopefully as part of Google Code-in 2019!
Dec 11 2019
No, thank you Mr Urbanec!
Dec 10 2019
Brilliant! Thank you so much for your assistance sir throughout this task. I'll push for review now.
Dec 9 2019
Hi, thanks for your very helpful advice! It has allowed me to fix my SQL such that it is now working fine on Quarry.
One last thing, before I push for review: When trying to run the flask app to see if it is working, it is erroring that it cannot connect to 'commonswiki.web.db.svc.eqiad.wmflabs' when using toolforget.connect('commonswiki') or commonswiki_p.
Dec 8 2019
Now my queries aren't completing - probably because I'm joining too many (rather large I suppose) tables together. Is there a better way of submitting such a query which now requires so many tables? Thanks!
Ahhh, how stupid of me! I should've realised! Thanks very much.
Similarly, I have fixed the second SQL query as part of this task:
SELECT count(*) FROM change_tag join change_tag_def join revision join actor_revision on ct_rev_id=rev_id where ctd_name="OAuth CID: 821" AND actor_id>0
I've created the following SQL query to replace what was not previously working.
SELECT actor_name, count(*) from change_tag join actor_revision join revision join change_tag_def on ct_rev_id=rev_id where ctd_name="OAuth CID: 821" and actor_user>0 group by actor_user order by count(*) desc