Modify production / dev databases - add product_active field (morgamic)
Add ability to toggle product status (morgamic)
Need to make sure that all downloadables entries that are mapped to the changed product are disabled when a product is disabled
When a product is disabled, entries should be made in sentry_tests and sentry_events to notify sentry about why a particular group of files was deactivated. This way in the HTML reports it says, "disabled by admin" or something along those lines.
When a product is reenabled the admin interface does NOT update the downloadables to be active again. The pv_active flag is the only thing chagned, and Sentry should be responsible for verifying and reenabling the downloadable statuses based on test results (and assume they are defunct until then). This is so that we don't end up with a lack of security between the time when an admin reenables a product and Sentry's initial run-through of the newly "reactivated" downloadable records attached to the pv_id in question. I don't know what I just said, but I hope it makes sense.
Add conditions to Sentry when searching for files
v1, Perl (kveton)
v2, Python (lars) - Sentry needs to know that it shouldn't check downloadables for any pv_id that has pv_active = '0'.
Migration
Run v1.0 and v2.0 in parallel
Database synchronization / comparison
MySQL dump from prod -> dev (kveton)
Script to compare actual results and to preserve hit counts (lars)
Deploy v2.0 on gecko.mozilla.org
Usability - shouldn't we call this Banana?
Add links to HTML reports in admin interface.
Add CSV exports to lists of values.
Add confirmation dialogs to delete operations (to prevent unintended deletions)
Community (morgamic)
Drupal
Licensing and packaging
Other community aspects (see [OSL:Building Communities])
Logging
Adding dated logs
Adding knowledge of where the redirect went
Source IP
Add ability to store filesize in database
Reporting Ideas
How much a mirror actually pushed over a period of time
Other stuff over time
Sentry Bandwidth Idea
When a download occurs for a mirror, dynamically compare database bandwidth rating with what the actual rating is and update (might want to rate-limit so it can't just turn everything off or lower to the point where we are offering 10Mbit for the whole network )
Hi Lars. I like your beard.