OLD | NEW |
---|---|
1 package db | 1 package db |
2 | 2 |
3 /* | 3 /* |
4 Store/Retrieve Cluster Telemetry Frontend data in a database. | 4 Store/Retrieve Cluster Telemetry Frontend data in a database. |
5 */ | 5 */ |
6 | 6 |
7 import ( | 7 import ( |
8 "github.com/jmoiron/sqlx" | 8 "github.com/jmoiron/sqlx" |
9 "go.skia.org/infra/go/database" | 9 "go.skia.org/infra/go/database" |
10 ) | 10 ) |
(...skipping 50 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... | |
61 platform VARCHAR(100) NOT NULL, | 61 platform VARCHAR(100) NOT NULL, |
62 page_sets VARCHAR(100) NOT NULL, | 62 page_sets VARCHAR(100) NOT NULL, |
63 repeat_runs INT NOT NULL, | 63 repeat_runs INT NOT NULL, |
64 benchmark_args VARCHAR(255), | 64 benchmark_args VARCHAR(255), |
65 browser_args_nopatch VARCHAR(255), | 65 browser_args_nopatch VARCHAR(255), |
66 browser_args_withpatch VARCHAR(255), | 66 browser_args_withpatch VARCHAR(255), |
67 description VARCHAR(255), | 67 description VARCHAR(255), |
68 chromium_patch TEXT, | 68 chromium_patch TEXT, |
69 blink_patch TEXT, | 69 blink_patch TEXT, |
70 skia_patch TEXT, | 70 skia_patch TEXT, |
71 benchmark_patch TEXT, | |
dogben
2015/10/20 15:17:26
I don't think this is supposed to be here.
rmistry
2015/10/20 17:47:48
Oops. Removed.
| |
71 ts_added BIGINT NOT NULL, | 72 ts_added BIGINT NOT NULL, |
72 ts_started BIGINT, | 73 ts_started BIGINT, |
73 ts_completed BIGINT, | 74 ts_completed BIGINT, |
74 failure TINYINT(1), | 75 failure TINYINT(1), |
75 nopatch_raw_output VARCHAR(255), | 76 nopatch_raw_output VARCHAR(255), |
76 withpatch_raw_output VARCHAR(255), | 77 withpatch_raw_output VARCHAR(255), |
77 results VARCHAR(255) | 78 results VARCHAR(255) |
78 )`, | 79 )`, |
79 } | 80 } |
80 | 81 |
(...skipping 161 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... | |
242 } | 243 } |
243 | 244 |
244 var v10_up = []string{ | 245 var v10_up = []string{ |
245 `ALTER TABLE ChromiumPerfTasks CONVERT TO CHARACTER SET utf32`, | 246 `ALTER TABLE ChromiumPerfTasks CONVERT TO CHARACTER SET utf32`, |
246 } | 247 } |
247 | 248 |
248 var v10_down = []string{ | 249 var v10_down = []string{ |
249 `ALTER TABLE ChromiumPerfTasks CONVERT TO CHARACTER SET utf8`, | 250 `ALTER TABLE ChromiumPerfTasks CONVERT TO CHARACTER SET utf8`, |
250 } | 251 } |
251 | 252 |
253 var v11_up = []string{ | |
254 `ALTER TABLE ChromiumPerfTasks ADD benchmark_patch longtext NOT NULL DEF AULT ""`, | |
255 } | |
256 | |
257 var v11_down = []string{ | |
258 `ALTER TABLE ChromiumPerfTasks DROP benchmark_patch`, | |
259 } | |
260 | |
252 // Define the migration steps. | 261 // Define the migration steps. |
253 // Note: Only add to this list, once a step has landed in version control it | 262 // Note: Only add to this list, once a step has landed in version control it |
254 // must not be changed. | 263 // must not be changed. |
255 var migrationSteps = []database.MigrationStep{ | 264 var migrationSteps = []database.MigrationStep{ |
256 // version 1. Create Chromium Perf tables. | 265 // version 1. Create Chromium Perf tables. |
257 { | 266 { |
258 MySQLUp: v1_up, | 267 MySQLUp: v1_up, |
259 MySQLDown: v1_down, | 268 MySQLDown: v1_down, |
260 }, | 269 }, |
261 // version 2. Create Admin Task tables. | 270 // version 2. Create Admin Task tables. |
(...skipping 34 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... | |
296 // version 9: Change chromium_patch, blink_patch and skia_patch to longt ext in ChromiumPerfTasks table. | 305 // version 9: Change chromium_patch, blink_patch and skia_patch to longt ext in ChromiumPerfTasks table. |
297 { | 306 { |
298 MySQLUp: v9_up, | 307 MySQLUp: v9_up, |
299 MySQLDown: v9_down, | 308 MySQLDown: v9_down, |
300 }, | 309 }, |
301 // version 10: Convert character set in ChromiumPerfTasks from utf8 to u tf32. | 310 // version 10: Convert character set in ChromiumPerfTasks from utf8 to u tf32. |
302 { | 311 { |
303 MySQLUp: v10_up, | 312 MySQLUp: v10_up, |
304 MySQLDown: v10_down, | 313 MySQLDown: v10_down, |
305 }, | 314 }, |
315 // version 11: Add benchmark_patch column to ChromiumPerfTasks. | |
316 { | |
317 MySQLUp: v11_up, | |
318 MySQLDown: v11_down, | |
319 }, | |
306 } | 320 } |
307 | 321 |
308 // MigrationSteps returns the database migration steps. | 322 // MigrationSteps returns the database migration steps. |
309 func MigrationSteps() []database.MigrationStep { | 323 func MigrationSteps() []database.MigrationStep { |
310 return migrationSteps | 324 return migrationSteps |
311 } | 325 } |
OLD | NEW |