Bid for "Better no-dsa support in PTS"

Bid for Proposal

Request for Bid Reference

https://salsa.debian.org/freexian-team/project-funding/-/blob/master/accepted/2020-12-pts-no-dsa.md

Project Task Summary

• Setup distro-tracker locally
• Understand the requirements
• Implementation: pull information from the appropiate places, save it into models, change views and templates
• Delivery

Project Task Detail

Setup distro-tracker locally (1 hour remaining, already done some of them)

• Read docs (https://qa.pages.debian.net/distro-tracker/contributing.html)
• Setup the project in my local environment (bin/quick-setup.sh, etc.). Verify basic running in localhost
• Execute "manage.py tracker_run_all_tasks" in order to populate the database
• Install unit test dependencies (chromedriver, etc.). Verify that unit tests pass in my environment

Understand requirements (0 hours, already done)

• Done mockups to double-check requirements (#2 (closed))
• Checked where the data can be pulled from
• Understand the data flow (which data gets into the database, when is it processed, etc.)

Implementation (17 hours)

• Write unit tests and integration tests (4 hours, I haven't done integration tests using the chromedriver)
• Identify if/which information is needed (to display/logic) but is not yet in the database (might need to save some more fields from https://security-tracker.debian.org/tracker/data/json ? modify models?) (1 hour)
• Possibly create new model in the database and save the information from https://salsa.debian.org/security-tracker-team/security-tracker/raw/master/data/next-point-update.txt (during the fetching information process) (4 hours)
• Change the templates and views to display the new information in the correct place (4 hours)
• Testing, fixing errors, etc. (2 hours)
• Document changes, finish unit tests/integration tests (2 hours)

Delivery (2 hours)

• Send screenshots to help validation
• I expect adjustments to the presentation (links, badges, tooltips, text, etc.)

Please let me know if you want more detail in general or for a specific point.

There is more information in the comments: #2 (comment 208513)

Project Cost Information

I'll send this part to Raphaël.

Qualification and Experience

I have been a Debian user (desktop and servers) for more than 20 years:

• My first Debian was Debian Potato. I have been using Debian as a main operating system since September 2000
• I am the upstream author (https://github.com/cpina/qdacco) of the package (https://tracker.debian.org/pkg/qdacco)
• I have sent bugs or fixes to Debian (last bug with a fix for gpw last month (security related): https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=975469 released https://tracker.debian.org/news/1198189/accepted-gpw-0019940601-10-source-amd64-into-unstable/ and Thunderbird https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=960230

Nowadays my main job is programming applications in Django:

• I write applications for a polar institute: https://github.com/Swiss-Polar-Institute/spi-media-gallery and https://github.com/Swiss-Polar-Institute/project-application
• Recently I have been more involved in the Django ecosystem specially in django-crispy-forms: https://github.com/django-crispy-forms/django-crispy-forms (member of the core team)
• I have made some small Django contributions, for example https://github.com/django/django/commit/721c95ba0b67eb46422dcf05a4274960e49c8894
• Recently I finished a grant for the Open Knowledge Foundation writing a Django Application: https://github.com/frictionlessdata/schema-collaboration , introductory blog: https://frictionlesdata.io/blog/2020/07/16/tool-fund-polar-institute/

Over the years I have been involved in different free software projects:

• Contributed to some free software software, for example added gettext support to Grub2
• Contributed (as part of my previous job) to some free software projects such as github.com/citation-style-language
• Attending FOSDEM since 2006
• A long time ago I did more free software outreach in Spain and online (https://debaday.debian.net/2007/08/12/xdiskusage-where-is-the-space/ or https://debaday.debian.net/2008/01/16/synergy-sharing-the-keyboard-and-mouse/index.html )

I am interested in contributing to Debian and I am currently working part-time. Hopefully this task might get me onboard for other features/fixes.

More information on my website https://carles.pina.cat

Debian Community Impact

I am not involved in any Debian team.