创建数据库表
()
| 37 | |
| 38 | // 创建数据库表 |
| 39 | func createDataTables() { |
| 40 | sql_table := ` |
| 41 | CREATE TABLE IF NOT EXISTS "remote" ( |
| 42 | "r_id" INTEGER PRIMARY KEY AUTOINCREMENT, |
| 43 | "r_addr" VARCHAR(256) NULL, |
| 44 | "r_port" int default (22) NOT NULL, |
| 45 | "r_username" VARCHAR(100) NULL, |
| 46 | "r_auth_type" VARCHAR(25) NULL, |
| 47 | "r_password" VARCHAR(100) NULL, |
| 48 | "r_json" TEXT NULL, |
| 49 | "r_is_del" BIT default (0), |
| 50 | "r_created" TIMESTAMP default (datetime('now', 'localtime')) |
| 51 | ); |
| 52 | CREATE TABLE IF NOT EXISTS "workspace" ( |
| 53 | "w_id" INTEGER PRIMARY KEY AUTOINCREMENT, |
| 54 | "w_name" VARCHAR(256) NULL, |
| 55 | "w_workingdir" VARCHAR(256) NULL, |
| 56 | "w_config_file" VARCHAR(256) NULL, |
| 57 | "w_docker_compose_file_path" VARCHAR(256) NULL, |
| 58 | "w_mode" VARCHAR(10) NULL, |
| 59 | "w_git_clone_repo_url" VARCHAR(200) NULL, |
| 60 | "w_git_auth_type" VARCHAR(10) NULL, |
| 61 | "w_git_username" VARCHAR(100) NULL, |
| 62 | "w_git_password" VARCHAR(60) NULL, |
| 63 | "w_git_auth_pat" VARCHAR(10) NULL, |
| 64 | |
| 65 | "w_branch" VARCHAR(50) NULL, |
| 66 | "w_json" TEXT NULL, |
| 67 | "w_config_content" text NULL, |
| 68 | "w_link_compose_content" text NULL, |
| 69 | "w_temp_compose_content" text NULL, |
| 70 | |
| 71 | "r_id" INTEGER NULL, |
| 72 | "w_is_del" BIT default (0), |
| 73 | "w_created" TIMESTAMP default (datetime('now', 'localtime')), |
| 74 | FOREIGN KEY (r_id) REFERENCES remote(r_id) |
| 75 | ); |
| 76 | CREATE TABLE IF NOT EXISTS "k8s" ( |
| 77 | "k_id" INTEGER PRIMARY KEY AUTOINCREMENT, |
| 78 | "k_kubeconfig" VARCHAR(500) NULL, |
| 79 | "k_context" VARCHAR(50) NULL, |
| 80 | "k_namespace" VARCHAR(50) NULL, |
| 81 | "k_deployment" VARCHAR(50) NULL, |
| 82 | "k_pvc" VARCHAR(50) NULL, |
| 83 | "k_is_del" BIT default (0), |
| 84 | "k_created" TIMESTAMP default (datetime('now', 'localtime')) |
| 85 | ); |
| 86 | |
| 87 | ` |
| 88 | |
| 89 | db, err := connection() |
| 90 | if err != nil { |
| 91 | db.Close() |
| 92 | common.CheckError(err) |
| 93 | } |
| 94 | defer db.Close() |
| 95 | |
| 96 | _, err = db.Exec(sql_table) |
no test coverage detected