1182779 - Drop several columns from the datasource table on stage/prod/heroku

Status: RESOLVED FIXED

(Tree Management :: Treeherder: Infrastructure, defect, P2)

Description

[Ed Morley [:emorley]]

Once bug 1182455 is deployed we need to drop several columns from the datasource table. We can't do this until that bug is deployed, but equally we must do so before the next time we add a new repo we'll get errors due to the columns not being defined in the SQL statements in-repo (since there are no defaults on those columns).

Columns to be dropped:
* host
* read_only_host
* type
* creation_date

eg 

ALTER TABLE treeherder.datasource DROP COLUMN host, read_only_host, type, creation_date;

Comment 1

[Ed Morley [:emorley]]

Run on Heroku:

ALTER TABLE treeherder.datasource DROP host, DROP read_only_host, DROP type, DROP creation_date;

Stage:

[[e-mail]3 treeherder-service]$ ../venv/bin/python ./manage.py dbshell

mysql> ALTER TABLE treeherder_stage.datasource DROP host, DROP read_only_host, DROP type, DROP creation_date;
Query OK, 0 rows affected (0.22 sec)
Records: 0  Duplicates: 0  Warnings: 0

Comment 2

[Ed Morley [:emorley]]

No errors on New Relic; run on prod:

[[e-mail]3 treeherder-service]$ ../venv/bin/python ./manage.py dbshell

mysql> ALTER TABLE treeherder.datasource DROP host, DROP read_only_host, DROP type, DROP creation_date;
Query OK, 0 rows affected (0.11 sec)
Records: 0  Duplicates: 0  Warnings: 0