This is an automated email from the ASF dual-hosted git repository.
zhangliang 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 f944b1b53ee initialize all demo databases with required tables in
init.sql on examples (#37555)
f944b1b53ee is described below
commit f944b1b53eec01c230102c21d8a976b54646abac
Author: Liang Zhang <[email protected]>
AuthorDate: Sun Dec 28 01:38:47 2025 +0800
initialize all demo databases with required tables in init.sql on examples
(#37555)
---
.../src/main/resources/template/init.ftl | 96 +++++++++++++++++++++-
1 file changed, 95 insertions(+), 1 deletion(-)
diff --git
a/examples/shardingsphere-jdbc-example-generator/src/main/resources/template/init.ftl
b/examples/shardingsphere-jdbc-example-generator/src/main/resources/template/init.ftl
index 0ea7970a5ac..3770f26de51 100644
---
a/examples/shardingsphere-jdbc-example-generator/src/main/resources/template/init.ftl
+++
b/examples/shardingsphere-jdbc-example-generator/src/main/resources/template/init.ftl
@@ -61,7 +61,101 @@ CREATE DATABASE demo_shadow_write_ds;
CREATE DATABASE demo_shadow_read_ds;
CREATE DATABASE demo_read_ds;
-
-- Execute SQL Script through logical-database connection , eg: sharding_db.
Docker samples configuration in the 'conf/database-sharding.yaml' file
-- CREATE TABLE t_order ("order_id" serial4, "user_id" int4 NOT NULL, PRIMARY
KEY ("order_id"));
-- CREATE TABLE t_order_item ("order_item_id" serial4, "order_id" int4 NOT
NULL, "user_id" int4 NOT NULL, "status" varchar(50), PRIMARY KEY
("order_item_id"));
+
+USE demo_ds;
+CREATE TABLE IF NOT EXISTS t_order(order_id BIGINT NOT NULL AUTO_INCREMENT,
order_type INT(11), user_id INT NOT NULL, address_id BIGINT NOT NULL, status
VARCHAR(50), PRIMARY KEY (order_id));
+CREATE TABLE IF NOT EXISTS t_order_item(order_item_id BIGINT NOT NULL
AUTO_INCREMENT, order_id BIGINT NOT NULL, user_id INT NOT NULL, phone
VARCHAR(50), status VARCHAR(50), PRIMARY KEY (order_item_id));
+CREATE TABLE IF NOT EXISTS t_address (address_id BIGINT NOT NULL, address_name
VARCHAR(100) NOT NULL, PRIMARY KEY (address_id));
+
+USE demo_ds_0;
+CREATE TABLE IF NOT EXISTS t_order(order_id BIGINT NOT NULL AUTO_INCREMENT,
order_type INT(11), user_id INT NOT NULL, address_id BIGINT NOT NULL, status
VARCHAR(50), PRIMARY KEY (order_id));
+CREATE TABLE IF NOT EXISTS t_order_item(order_item_id BIGINT NOT NULL
AUTO_INCREMENT, order_id BIGINT NOT NULL, user_id INT NOT NULL, phone
VARCHAR(50), status VARCHAR(50), PRIMARY KEY (order_item_id));
+CREATE TABLE IF NOT EXISTS t_address (address_id BIGINT NOT NULL, address_name
VARCHAR(100) NOT NULL, PRIMARY KEY (address_id));
+
+USE demo_ds_1;
+CREATE TABLE IF NOT EXISTS t_order(order_id BIGINT NOT NULL AUTO_INCREMENT,
order_type INT(11), user_id INT NOT NULL, address_id BIGINT NOT NULL, status
VARCHAR(50), PRIMARY KEY (order_id));
+CREATE TABLE IF NOT EXISTS t_order_item(order_item_id BIGINT NOT NULL
AUTO_INCREMENT, order_id BIGINT NOT NULL, user_id INT NOT NULL, phone
VARCHAR(50), status VARCHAR(50), PRIMARY KEY (order_item_id));
+CREATE TABLE IF NOT EXISTS t_address (address_id BIGINT NOT NULL, address_name
VARCHAR(100) NOT NULL, PRIMARY KEY (address_id));
+
+USE demo_ds_2;
+CREATE TABLE IF NOT EXISTS t_order(order_id BIGINT NOT NULL AUTO_INCREMENT,
order_type INT(11), user_id INT NOT NULL, address_id BIGINT NOT NULL, status
VARCHAR(50), PRIMARY KEY (order_id));
+CREATE TABLE IF NOT EXISTS t_order_item(order_item_id BIGINT NOT NULL
AUTO_INCREMENT, order_id BIGINT NOT NULL, user_id INT NOT NULL, phone
VARCHAR(50), status VARCHAR(50), PRIMARY KEY (order_item_id));
+CREATE TABLE IF NOT EXISTS t_address (address_id BIGINT NOT NULL, address_name
VARCHAR(100) NOT NULL, PRIMARY KEY (address_id));
+
+USE demo_write_ds;
+CREATE TABLE IF NOT EXISTS t_order(order_id BIGINT NOT NULL AUTO_INCREMENT,
order_type INT(11), user_id INT NOT NULL, address_id BIGINT NOT NULL, status
VARCHAR(50), PRIMARY KEY (order_id));
+CREATE TABLE IF NOT EXISTS t_order_item(order_item_id BIGINT NOT NULL
AUTO_INCREMENT, order_id BIGINT NOT NULL, user_id INT NOT NULL, phone
VARCHAR(50), status VARCHAR(50), PRIMARY KEY (order_item_id));
+CREATE TABLE IF NOT EXISTS t_address (address_id BIGINT NOT NULL, address_name
VARCHAR(100) NOT NULL, PRIMARY KEY (address_id));
+
+USE demo_read_ds_0;
+CREATE TABLE IF NOT EXISTS t_order(order_id BIGINT NOT NULL AUTO_INCREMENT,
order_type INT(11), user_id INT NOT NULL, address_id BIGINT NOT NULL, status
VARCHAR(50), PRIMARY KEY (order_id));
+CREATE TABLE IF NOT EXISTS t_order_item(order_item_id BIGINT NOT NULL
AUTO_INCREMENT, order_id BIGINT NOT NULL, user_id INT NOT NULL, phone
VARCHAR(50), status VARCHAR(50), PRIMARY KEY (order_item_id));
+CREATE TABLE IF NOT EXISTS t_address (address_id BIGINT NOT NULL, address_name
VARCHAR(100) NOT NULL, PRIMARY KEY (address_id));
+
+USE demo_read_ds_1;
+CREATE TABLE IF NOT EXISTS t_order(order_id BIGINT NOT NULL AUTO_INCREMENT,
order_type INT(11), user_id INT NOT NULL, address_id BIGINT NOT NULL, status
VARCHAR(50), PRIMARY KEY (order_id));
+CREATE TABLE IF NOT EXISTS t_order_item(order_item_id BIGINT NOT NULL
AUTO_INCREMENT, order_id BIGINT NOT NULL, user_id INT NOT NULL, phone
VARCHAR(50), status VARCHAR(50), PRIMARY KEY (order_item_id));
+CREATE TABLE IF NOT EXISTS t_address (address_id BIGINT NOT NULL, address_name
VARCHAR(100) NOT NULL, PRIMARY KEY (address_id));
+
+USE demo_write_ds_0;
+CREATE TABLE IF NOT EXISTS t_order(order_id BIGINT NOT NULL AUTO_INCREMENT,
order_type INT(11), user_id INT NOT NULL, address_id BIGINT NOT NULL, status
VARCHAR(50), PRIMARY KEY (order_id));
+CREATE TABLE IF NOT EXISTS t_order_item(order_item_id BIGINT NOT NULL
AUTO_INCREMENT, order_id BIGINT NOT NULL, user_id INT NOT NULL, phone
VARCHAR(50), status VARCHAR(50), PRIMARY KEY (order_item_id));
+CREATE TABLE IF NOT EXISTS t_address (address_id BIGINT NOT NULL, address_name
VARCHAR(100) NOT NULL, PRIMARY KEY (address_id));
+
+USE demo_write_ds_0_read_0;
+CREATE TABLE IF NOT EXISTS t_order(order_id BIGINT NOT NULL AUTO_INCREMENT,
order_type INT(11), user_id INT NOT NULL, address_id BIGINT NOT NULL, status
VARCHAR(50), PRIMARY KEY (order_id));
+CREATE TABLE IF NOT EXISTS t_order_item(order_item_id BIGINT NOT NULL
AUTO_INCREMENT, order_id BIGINT NOT NULL, user_id INT NOT NULL, phone
VARCHAR(50), status VARCHAR(50), PRIMARY KEY (order_item_id));
+CREATE TABLE IF NOT EXISTS t_address (address_id BIGINT NOT NULL, address_name
VARCHAR(100) NOT NULL, PRIMARY KEY (address_id));
+
+USE demo_write_ds_0_read_1;
+CREATE TABLE IF NOT EXISTS t_order(order_id BIGINT NOT NULL AUTO_INCREMENT,
order_type INT(11), user_id INT NOT NULL, address_id BIGINT NOT NULL, status
VARCHAR(50), PRIMARY KEY (order_id));
+CREATE TABLE IF NOT EXISTS t_order_item(order_item_id BIGINT NOT NULL
AUTO_INCREMENT, order_id BIGINT NOT NULL, user_id INT NOT NULL, phone
VARCHAR(50), status VARCHAR(50), PRIMARY KEY (order_item_id));
+CREATE TABLE IF NOT EXISTS t_address (address_id BIGINT NOT NULL, address_name
VARCHAR(100) NOT NULL, PRIMARY KEY (address_id));
+
+USE demo_write_ds_1;
+CREATE TABLE IF NOT EXISTS t_order(order_id BIGINT NOT NULL AUTO_INCREMENT,
order_type INT(11), user_id INT NOT NULL, address_id BIGINT NOT NULL, status
VARCHAR(50), PRIMARY KEY (order_id));
+CREATE TABLE IF NOT EXISTS t_order_item(order_item_id BIGINT NOT NULL
AUTO_INCREMENT, order_id BIGINT NOT NULL, user_id INT NOT NULL, phone
VARCHAR(50), status VARCHAR(50), PRIMARY KEY (order_item_id));
+CREATE TABLE IF NOT EXISTS t_address (address_id BIGINT NOT NULL, address_name
VARCHAR(100) NOT NULL, PRIMARY KEY (address_id));
+
+USE demo_write_ds_1_read_0;
+CREATE TABLE IF NOT EXISTS t_order(order_id BIGINT NOT NULL AUTO_INCREMENT,
order_type INT(11), user_id INT NOT NULL, address_id BIGINT NOT NULL, status
VARCHAR(50), PRIMARY KEY (order_id));
+CREATE TABLE IF NOT EXISTS t_order_item(order_item_id BIGINT NOT NULL
AUTO_INCREMENT, order_id BIGINT NOT NULL, user_id INT NOT NULL, phone
VARCHAR(50), status VARCHAR(50), PRIMARY KEY (order_item_id));
+CREATE TABLE IF NOT EXISTS t_address (address_id BIGINT NOT NULL, address_name
VARCHAR(100) NOT NULL, PRIMARY KEY (address_id));
+
+USE demo_write_ds_1_read_1;
+CREATE TABLE IF NOT EXISTS t_order(order_id BIGINT NOT NULL AUTO_INCREMENT,
order_type INT(11), user_id INT NOT NULL, address_id BIGINT NOT NULL, status
VARCHAR(50), PRIMARY KEY (order_id));
+CREATE TABLE IF NOT EXISTS t_order_item(order_item_id BIGINT NOT NULL
AUTO_INCREMENT, order_id BIGINT NOT NULL, user_id INT NOT NULL, phone
VARCHAR(50), status VARCHAR(50), PRIMARY KEY (order_item_id));
+CREATE TABLE IF NOT EXISTS t_address (address_id BIGINT NOT NULL, address_name
VARCHAR(100) NOT NULL, PRIMARY KEY (address_id));
+
+USE shadow_demo_ds;
+CREATE TABLE IF NOT EXISTS t_order(order_id BIGINT NOT NULL AUTO_INCREMENT,
order_type INT(11), user_id INT NOT NULL, address_id BIGINT NOT NULL, status
VARCHAR(50), PRIMARY KEY (order_id));
+CREATE TABLE IF NOT EXISTS t_order_item(order_item_id BIGINT NOT NULL
AUTO_INCREMENT, order_id BIGINT NOT NULL, user_id INT NOT NULL, phone
VARCHAR(50), status VARCHAR(50), PRIMARY KEY (order_item_id));
+CREATE TABLE IF NOT EXISTS t_address (address_id BIGINT NOT NULL, address_name
VARCHAR(100) NOT NULL, PRIMARY KEY (address_id));
+
+USE shadow_demo_ds_0;
+CREATE TABLE IF NOT EXISTS t_order(order_id BIGINT NOT NULL AUTO_INCREMENT,
order_type INT(11), user_id INT NOT NULL, address_id BIGINT NOT NULL, status
VARCHAR(50), PRIMARY KEY (order_id));
+CREATE TABLE IF NOT EXISTS t_order_item(order_item_id BIGINT NOT NULL
AUTO_INCREMENT, order_id BIGINT NOT NULL, user_id INT NOT NULL, phone
VARCHAR(50), status VARCHAR(50), PRIMARY KEY (order_item_id));
+CREATE TABLE IF NOT EXISTS t_address (address_id BIGINT NOT NULL, address_name
VARCHAR(100) NOT NULL, PRIMARY KEY (address_id));
+
+USE shadow_demo_ds_1;
+CREATE TABLE IF NOT EXISTS t_order(order_id BIGINT NOT NULL AUTO_INCREMENT,
order_type INT(11), user_id INT NOT NULL, address_id BIGINT NOT NULL, status
VARCHAR(50), PRIMARY KEY (order_id));
+CREATE TABLE IF NOT EXISTS t_order_item(order_item_id BIGINT NOT NULL
AUTO_INCREMENT, order_id BIGINT NOT NULL, user_id INT NOT NULL, phone
VARCHAR(50), status VARCHAR(50), PRIMARY KEY (order_item_id));
+CREATE TABLE IF NOT EXISTS t_address (address_id BIGINT NOT NULL, address_name
VARCHAR(100) NOT NULL, PRIMARY KEY (address_id));
+
+USE demo_shadow_write_ds;
+CREATE TABLE IF NOT EXISTS t_order(order_id BIGINT NOT NULL AUTO_INCREMENT,
order_type INT(11), user_id INT NOT NULL, address_id BIGINT NOT NULL, status
VARCHAR(50), PRIMARY KEY (order_id));
+CREATE TABLE IF NOT EXISTS t_order_item(order_item_id BIGINT NOT NULL
AUTO_INCREMENT, order_id BIGINT NOT NULL, user_id INT NOT NULL, phone
VARCHAR(50), status VARCHAR(50), PRIMARY KEY (order_item_id));
+CREATE TABLE IF NOT EXISTS t_address (address_id BIGINT NOT NULL, address_name
VARCHAR(100) NOT NULL, PRIMARY KEY (address_id));
+
+USE demo_shadow_read_ds;
+CREATE TABLE IF NOT EXISTS t_order(order_id BIGINT NOT NULL AUTO_INCREMENT,
order_type INT(11), user_id INT NOT NULL, address_id BIGINT NOT NULL, status
VARCHAR(50), PRIMARY KEY (order_id));
+CREATE TABLE IF NOT EXISTS t_order_item(order_item_id BIGINT NOT NULL
AUTO_INCREMENT, order_id BIGINT NOT NULL, user_id INT NOT NULL, phone
VARCHAR(50), status VARCHAR(50), PRIMARY KEY (order_item_id));
+CREATE TABLE IF NOT EXISTS t_address (address_id BIGINT NOT NULL, address_name
VARCHAR(100) NOT NULL, PRIMARY KEY (address_id));
+
+USE demo_read_ds;
+CREATE TABLE IF NOT EXISTS t_order(order_id BIGINT NOT NULL AUTO_INCREMENT,
order_type INT(11), user_id INT NOT NULL, address_id BIGINT NOT NULL, status
VARCHAR(50), PRIMARY KEY (order_id));
+CREATE TABLE IF NOT EXISTS t_order_item(order_item_id BIGINT NOT NULL
AUTO_INCREMENT, order_id BIGINT NOT NULL, user_id INT NOT NULL, phone
VARCHAR(50), status VARCHAR(50), PRIMARY KEY (order_item_id));
+CREATE TABLE IF NOT EXISTS t_address (address_id BIGINT NOT NULL, address_name
VARCHAR(100) NOT NULL, PRIMARY KEY (address_id));
