7 Star 34 Fork 39

EdgeGallery / helm-charts

Create your Gitee Account
Explore and code with more than 6 million developers,Free private repositories !:)
Sign up
Clone or Download
atp-configmap.yaml 5.08 KB
Copy Edit Web IDE Raw Blame History
刘慧玲 authored 2021-08-13 10:12 . init db data migrate to atp code
###########################################################################
# Copyright 2020 Huawei Technologies Co., Ltd.
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
# http://www.apache.org/licenses/LICENSE-2.0
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
############################################################################
apiVersion: v1
kind: ConfigMap
metadata:
name: atp-postgres-initdb-configmap
data:
postgres.sql: |
CREATE TABLE TASK_TABLE (
ID VARCHAR(200) NOT NULL,
APPNAME VARCHAR(200) NULL,
APPVERSION VARCHAR(200) NULL,
STATUS VARCHAR(200) NULL,
TESTCASEDETAIL TEXT NULL,
CREATETIME TIMESTAMP NULL,
ENDTIME TIMESTAMP NULL,
PROVIDERID VARCHAR(200) NULL,
PACKAGEPATH VARCHAR(200) NULL,
USERID VARCHAR(200) NULL,
USERNAME VARCHAR(200) NULL,
REPORTPATH VARCHAR(200) NULL,
CONSTRAINT task_table_pkey PRIMARY KEY (ID)
);
CREATE TABLE TEST_CASE_TABLE (
ID VARCHAR(200) NOT NULL,
NAMECH VARCHAR(200) NULL,
NAMEEN VARCHAR(200) NULL,
TYPE VARCHAR(200) NULL,
CLASSNAME VARCHAR(200) NULL,
HASHCODE TEXT NULL,
DESCRIPTIONCH TEXT NULL,
DESCRIPTIONEN TEXT NULL,
FILEPATH VARCHAR(200) NULL,
CODELANGUAGE VARCHAR(200) NULL,
EXPECTRESULTCH VARCHAR(200) NULL,
EXPECTRESULTEN VARCHAR(200) NULL,
TESTSUITEIDLIST TEXT NULL,
TESTSTEPCH TEXT NULL,
TESTSTEPEN TEXT NULL,
CREATETIME TIMESTAMP NULL,
CONFIGIDLIST TEXT NULL,
CONSTRAINT test_case_table_pkey PRIMARY KEY (ID)
);
CREATE TABLE TEST_SCENARIO_TABLE (
ID VARCHAR(200) NOT NULL,
NAMECH VARCHAR(200) NULL,
NAMEEN VARCHAR(200) NULL,
DESCRIPTIONCh TEXT NULL,
DESCRIPTIONEN TEXT NULL,
LABEL VARCHAR(200) NULL,
CREATETIME TIMESTAMP NULL,
CONSTRAINT test_scenario_table_pkey PRIMARY KEY (ID)
);
CREATE TABLE TEST_SUITE_TABLE (
ID VARCHAR(200) NOT NULL,
NAMECH VARCHAR(200) NULL,
NAMEEN VARCHAR(200) NULL,
DESCRIPTIONCh TEXT NULL,
DESCRIPTIONEN TEXT NULL,
SCENARIOIDLIST VARCHAR(255) NULL,
CREATETIME TIMESTAMP NULL,
CONSTRAINT test_suite_table_pkey PRIMARY KEY (ID)
);
CREATE TABLE FILE_TABLE (
FILEID VARCHAR(200) NOT NULL,
TYPE VARCHAR(200) NOT NULL,
CREATETIME TIMESTAMP NULL,
FILEPATH VARCHAR(200) NULL
);
alter table FILE_TABLE add constraint file_table_pkey unique(FILEID,TYPE);
CREATE TABLE CONTRIBUTION_TABLE (
ID VARCHAR(200) NOT NULL,
NAME VARCHAR(200) NULL,
OBJECTIVE VARCHAR(200) NULL,
STEP TEXT NULL,
EXPECTRESULT TEXT NULL,
TYPE VARCHAR(255) NULL,
CREATETIME TIMESTAMP NULL,
FILEPATH VARCHAR(200) NULL,
CONSTRAINT contribution_table_pkey PRIMARY KEY (ID)
);
CREATE TABLE CONFIG_TABLE (
ID VARCHAR(200) NOT NULL,
NAMECH VARCHAR(200) NULL,
NAMEEN VARCHAR(200) NULL,
DESCRIPTIONCh TEXT NULL,
DESCRIPTIONEN TEXT NULL,
CONFIGURATION TEXT NOT NULL,
CREATETIME TIMESTAMP NULL,
CONSTRAINT config_table_pkey PRIMARY KEY (ID)
);

Comment ( 0 )

Sign in for post a comment

1
https://gitee.com/edgegallery/helm-charts.git
git@gitee.com:edgegallery/helm-charts.git
edgegallery
helm-charts
helm-charts
master

Search