592168 - Tag Toolbars as toolbar

Status: RESOLVED FIXED

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

Description

[Justin Scott [:fligtar]]

I want to delete the Toolbars category, but first we should make sure everything in it is tagged with "toolbar".

Please run a query to tag every add-on in the Toolbar category with toolbar (if it isn't already).

Comment 1

[Justin Scott [:fligtar]]

I've been tricked

Comment 2

[Justin Scott [:fligtar]]

SQL is:

INSERT INTO users_tags_addons (user_id, tag_id, addon_id, created) SELECT '9945',  '119', addon_id, NOW() FROM addons_categories WHERE category_id=92;
DELETE FROM addons_categories WHERE category_id=92;
DELETE FROM categories WHERE id=92;

Comment 3

[Justin Scott [:fligtar]]

I don't care much, but just curious why this didn't make 5.12?

Comment 4

[Wil Clouser [:clouserw]]

(In reply to comment #3)
> I don't care much, but just curious why this didn't make 5.12?

It's assigned to you, code freeze was upon us, and I didn't know if you were done with it.  If running the sql in comment 2 closes this bug you can assign it to me or make a new file in the migrations/ directory.

Comment 5

[Justin Scott [:fligtar]]

The SQL is all that is required.

Comment 6

[Wil Clouser [:clouserw]]

http://github.com/jbalogh/zamboni/commit/d4709703574c8b42948aa1c50ab50325a782a06d

Comment 7

[Stephen Donner [:stephend] Not actively reading bugmail]

Not sure if this is something for which we need Selenium test (doubt it), but just in case, flagging.

Comment 8

[Wil Clouser [:clouserw]]

All this did was tag the toolbars and delete the category.  Neither are verified at any point past when this script runs.