You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by wu...@apache.org on 2021/01/01 15:09:32 UTC
[shardingsphere] branch master updated: Remove useless sql scripts
(#8858)
This is an automated email from the ASF dual-hosted git repository.
wuweijie pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new 47e8e16 Remove useless sql scripts (#8858)
47e8e16 is described below
commit 47e8e16d14d37d38d7db8271cad8493be19bbdcb
Author: Liang Zhang <te...@163.com>
AuthorDate: Fri Jan 1 23:09:06 2021 +0800
Remove useless sql scripts (#8858)
---
.../integrate/cases/jdbc/encrypt_data.sql | 24 ----------------
.../resources/integrate/cases/jdbc/jdbc_data.sql | 33 ----------------------
.../resources/integrate/cases/jdbc/jdbc_init.sql | 25 ----------------
3 files changed, 82 deletions(-)
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/cases/jdbc/encrypt_data.sql b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/cases/jdbc/encrypt_data.sql
deleted file mode 100644
index b6565b3..0000000
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/cases/jdbc/encrypt_data.sql
+++ /dev/null
@@ -1,24 +0,0 @@
-/*
- * Licensed to the Apache Software Foundation (ASF) under one or more
- * contributor license agreements. See the NOTICE file distributed with
- * this work for additional information regarding copyright ownership.
- * The ASF licenses this file to You 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.
- */
-
-DELETE FROM t_encrypt;
-DELETE FROM t_query_encrypt;
-INSERT INTO t_encrypt VALUES(1, 'encryptValue');
-INSERT INTO t_encrypt VALUES(5, 'encryptValue');
-INSERT INTO t_query_encrypt VALUES(1, 'encryptValue', 'assistedEncryptValue');
-INSERT INTO t_query_encrypt VALUES(5, 'encryptValue', 'assistedEncryptValue');
-
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/cases/jdbc/jdbc_data.sql b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/cases/jdbc/jdbc_data.sql
deleted file mode 100644
index 66d629d..0000000
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/cases/jdbc/jdbc_data.sql
+++ /dev/null
@@ -1,33 +0,0 @@
-/*
- * Licensed to the Apache Software Foundation (ASF) under one or more
- * contributor license agreements. See the NOTICE file distributed with
- * this work for additional information regarding copyright ownership.
- * The ASF licenses this file to You 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.
- */
-
-DELETE FROM t_order;
-DELETE FROM t_order_item;
-DELETE FROM t_config;
-INSERT INTO t_order VALUES(1000, 10, 'init');
-INSERT INTO t_order VALUES(1001, 10, 'init');
-INSERT INTO t_order VALUES(1100, 11, 'init');
-INSERT INTO t_order VALUES(1101, 11, 'init');
-INSERT INTO t_order_item VALUES(100000, 1000, 10, 'init');
-INSERT INTO t_order_item VALUES(100001, 1000, 10, 'init');
-INSERT INTO t_order_item VALUES(100100, 1001, 10, 'init');
-INSERT INTO t_order_item VALUES(100101, 1001, 10, 'init');
-INSERT INTO t_order_item VALUES(110000, 1100, 11, 'init');
-INSERT INTO t_order_item VALUES(110001, 1100, 11, 'init');
-INSERT INTO t_order_item VALUES(110100, 1101, 11, 'init');
-INSERT INTO t_order_item VALUES(110101, 1101, 11, 'init');
-INSERT INTO t_config VALUES(1, 'init');
diff --git a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/cases/jdbc/jdbc_init.sql b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/cases/jdbc/jdbc_init.sql
deleted file mode 100644
index 3d8f66b..0000000
--- a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/cases/jdbc/jdbc_init.sql
+++ /dev/null
@@ -1,25 +0,0 @@
-/*
- * Licensed to the Apache Software Foundation (ASF) under one or more
- * contributor license agreements. See the NOTICE file distributed with
- * this work for additional information regarding copyright ownership.
- * The ASF licenses this file to You 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.
- */
-
-CREATE TABLE IF NOT EXISTS t_order_0 (order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (order_id));
-CREATE TABLE IF NOT EXISTS t_order_1 (order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (order_id));
-CREATE TABLE IF NOT EXISTS t_order_item_0 (item_id INT NOT NULL, order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (item_id));
-CREATE TABLE IF NOT EXISTS t_order_item_1 (item_id INT NOT NULL, order_id INT NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (item_id));
-CREATE TABLE IF NOT EXISTS t_config (id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (id));
-CREATE TABLE IF NOT EXISTS t_global (id INT NOT NULL, status VARCHAR(45) NULL, PRIMARY KEY (id));
-CREATE TABLE IF NOT EXISTS t_encrypt (id INT NOT NULL AUTO_INCREMENT, pwd VARCHAR(45) NULL, PRIMARY KEY (id));
-CREATE TABLE IF NOT EXISTS t_query_encrypt (id INT NOT NULL AUTO_INCREMENT, pwd VARCHAR(45) NULL, assist_pwd VARCHAR(45) NULL, PRIMARY KEY (id));
\ No newline at end of file