408680 - Add support for reviews column in addons table

Status: RESOLVED FIXED

(addons.mozilla.org Graveyard :: Administration, defect)

Description

[Michael Morgan [:morgamic]]

Review counts are needed in 3.2's redesign, and I don't want to have to do an extra query on the reviews table to get this info.

For the same reason we have flattened out average rating, weekly and total downloads, etc.

So I'd like an additional field added to addons named 'reviews' that's an unsigned int(11) and also we will need another action in maintenance.php to update these counts (read from slave, update master).

Comment 1

[Michael Morgan [:morgamic]]

Attachment: v1, adding column to addons and case to maintenance script

This depends on fligtar's patch for maintenance.php.

Need to add reviews to addon model... will reupload after meeting.

Comment 2

[Michael Morgan [:morgamic]]

Attachment: v1.5, fixes maint script col name and adds column to addon model

When we push this, we will need to have this run on prod:

alter table addons add column `totalreviews` int(11) unsigned NOT NULL default '0'

Comment 3

[Fred Wenzel [:wenzel]]

Comment on attachment 299951 [details] [diff] [review]
v1.5, fixes maint script col name and adds column to addon model

Yes, this looks good.

You want to use it in the stars element too, I assume.

Comment 4

[Justin Scott [:fligtar]]

This is live.