■ ■ ■ ■ ■ ■
migration/103_add_kubepi_version.up.sql
| 1 | + | INSERT INTO |
| 2 | + | `ko`.`ko_cluster_tool_detail`( |
| 3 | + | `id`, |
| 4 | + | `name`, |
| 5 | + | `version`, |
| 6 | + | `chart_version`, |
| 7 | + | `architecture`, |
| 8 | + | `describe`, |
| 9 | + | `vars`, |
| 10 | + | `created_at`, |
| 11 | + | `updated_at` |
| 12 | + | ) |
| 13 | + | VALUES |
| 14 | + | ( |
| 15 | + | UUID(), |
| 16 | + | 'kubepi', |
| 17 | + | 'v1.2.0', |
| 18 | + | '0.1.0', |
| 19 | + | 'all', |
| 20 | + | NULL, |
| 21 | + | '{\"kubepi_image_name\":\"kubeoperator/kubepi-server\",\"kubepi_image_tag\":\"v1.2.0\"}', |
| 22 | + | date_add(now(), interval 8 HOUR), |
| 23 | + | date_add(now(), interval 8 HOUR) |
| 24 | + | ); |
| 25 | + | |
| 26 | + | UPDATE |
| 27 | + | `ko`.`ko_cluster_tool` |
| 28 | + | SET |
| 29 | + | `higher_version` = "v1.2.0" |
| 30 | + | WHERE |
| 31 | + | `name` = "kubepi" |
| 32 | + | AND `status` != "Waiting"; |
| 33 | + | |
| 34 | + | UPDATE |
| 35 | + | `ko`.`ko_cluster_tool` |
| 36 | + | SET |
| 37 | + | `version` = "v1.2.0" |
| 38 | + | WHERE |
| 39 | + | `name` = "kubepi" |
| 40 | + | AND `status` = "Waiting"; |
| 41 | + | |
| 42 | + | UPDATE |
| 43 | + | ko_cluster_manifest |
| 44 | + | SET |
| 45 | + | `tool_vars` = '[{"name":"kubepi","version":"v1.2.0"},{"name":"loki","version":"v2.0.0"},{"name":"kubeapps","version":"v1.10.2"},{"name":"prometheus","version":"v2.18.1"},{"name":"chartmuseum","version":"v0.12.0"},{"name":"registry","version":"v2.7.1"},{"name":"grafana","version":"v7.3.3"},{"name":"logging","version":"v7.6.2"}]' |
| 46 | + | WHERE |
| 47 | + | `name` in ( |
| 48 | + | 'v1.18.4-ko1', |
| 49 | + | 'v1.18.6-ko1', |
| 50 | + | 'v1.18.8-ko1', |
| 51 | + | 'v1.18.10-ko1', |
| 52 | + | 'v1.18.12-ko1', |
| 53 | + | 'v1.18.14-ko1' |
| 54 | + | ); |
| 55 | + | |
| 56 | + | UPDATE |
| 57 | + | ko_cluster_manifest |
| 58 | + | SET |
| 59 | + | `tool_vars` = '[{"name":"kubepi","version":"v1.2.0"},{"name":"loki","version":"v2.1.0"},{"name":"kubeapps","version":"v2.0.1"},{"name":"prometheus","version":"v2.20.1"},{"name":"chartmuseum","version":"v0.12.0"},{"name":"registry","version":"v2.7.1"},{"name":"grafana","version":"v7.3.3"},{"name":"logging","version":"v7.6.2"}]' |
| 60 | + | WHERE |
| 61 | + | `name` in ( |
| 62 | + | 'v1.18.15-ko1', |
| 63 | + | 'v1.18.18-ko1', |
| 64 | + | 'v1.18.20-ko1', |
| 65 | + | 'v1.20.4-ko1', |
| 66 | + | 'v1.20.6-ko1', |
| 67 | + | 'v1.20.8-ko1', |
| 68 | + | 'v1.20.10-ko1' |
| 69 | + | ); |