From 9e5f7be1c5142b1cdafc7e7c79d88d8538265d36 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子Li <15040126243@163.com>
Date: 星期二, 30 四月 2024 15:52:12 +0800
Subject: [PATCH] update 增加 job 测试demo数据
---
script/sql/oracle/easy_retry_oracle.sql | 26 +++++++++++++++-----------
1 files changed, 15 insertions(+), 11 deletions(-)
diff --git a/script/sql/oracle/easy_retry_oracle.sql b/script/sql/oracle/easy_retry_oracle.sql
index 06f7662..78ef6ca 100644
--- a/script/sql/oracle/easy_retry_oracle.sql
+++ b/script/sql/oracle/easy_retry_oracle.sql
@@ -23,8 +23,9 @@
COMMENT ON COLUMN er_namespace.update_dt IS '淇敼鏃堕棿';
COMMENT ON COLUMN er_namespace.deleted IS '閫昏緫鍒犻櫎 1銆佸垹闄�';
-INSERT INTO er_namespace VALUES (1, 'Development', 'dev', '', sysdate, sysdate, 0);
-INSERT INTO er_namespace VALUES (2, 'Production', 'prod', '', sysdate, sysdate, 0);
+-- id 涓� IDENTITY 绫诲瀷, 涓嶈兘鎻掑叆
+INSERT INTO er_namespace(name, unique_id, description, create_dt, update_dt, deleted) VALUES('Development', 'dev', '', SYSDATE, SYSDATE, 0 );
+INSERT INTO er_namespace(name, unique_id, description, create_dt, update_dt, deleted) VALUES ('Production', 'prod', '', sysdate, sysdate, 0);
-- er_group_config
CREATE TABLE er_group_config
@@ -61,7 +62,7 @@
COMMENT ON COLUMN er_group_config.create_dt IS '鍒涘缓鏃堕棿';
COMMENT ON COLUMN er_group_config.update_dt IS '淇敼鏃堕棿';
-INSERT INTO er_group_config VALUES (1, 'dev', 'ruoyi_group', '', 'ER_cKqBTPzCsWA3VyuCfFoccmuIEGXjr5KT', 1, 1, 0, 1, 1, 4, sysdate, sysdate);
+INSERT INTO er_group_config(namespace_id, group_name, description, token, group_status, version, group_partition, id_generator_mode, init_scene, bucket_index, create_dt, update_dt) VALUES ('dev', 'ruoyi_group', '', 'ER_cKqBTPzCsWA3VyuCfFoccmuIEGXjr5KT', 1, 1, 0, 1, 1, 4, SYSDATE, SYSDATE );
-- er_notify_config
CREATE TABLE er_notify_config
@@ -229,13 +230,13 @@
CREATE TABLE er_retry_task_log_message
(
id NUMBER GENERATED ALWAYS AS IDENTITY,
- namespace_id VARCHAR2(64) DEFAULT '764d604ec6fc45f68cd92514c40e9e1a',
+ namespace_id VARCHAR2(64) DEFAULT '764d604ec6fc45f68cd92514c40e9e1a',
group_name VARCHAR2(64) NOT NULL,
unique_id VARCHAR2(64) NOT NULL,
- create_dt TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
- message CLOB DEFAULT '',
- log_num INT DEFAULT 1,
- real_time NUMERIC(13) DEFAULT 0
+ create_dt TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+ message CLOB DEFAULT '',
+ log_num INT DEFAULT 1,
+ real_time NUMERIC(13) DEFAULT 0
);
CREATE INDEX idx_retry_task_log_message_1 ON er_retry_task_log_message (namespace_id, group_name, unique_id);
@@ -368,8 +369,8 @@
COMMENT ON COLUMN er_system_user.create_dt IS '鍒涘缓鏃堕棿';
COMMENT ON COLUMN er_system_user.update_dt IS '淇敼鏃堕棿';
--- er_pwd: admin
-INSERT INTO er_system_user VALUES (1, 'admin', '465c194afb65670f38322df087f0a9bb225cc257e43eb4ac5a0c98ef5b3173ac', 2, sysdate, sysdate);
+-- pwd: admin
+INSERT INTO er_system_user(username, password, role, create_dt, update_dt) VALUES ('admin', '465c194afb65670f38322df087f0a9bb225cc257e43eb4ac5a0c98ef5b3173ac', 2, SYSDATE, SYSDATE);
-- er_system_user_permission
CREATE TABLE er_system_user_permission
@@ -473,8 +474,11 @@
COMMENT ON COLUMN er_job.description IS '鎻忚堪';
COMMENT ON COLUMN er_job.ext_attrs IS '鎵╁睍瀛楁';
COMMENT ON COLUMN er_job.create_dt IS '鍒涘缓鏃堕棿';
-COMMENT ON COLUMN er_job.deleted IS '閫昏緫鍒犻櫎 1銆佸垹闄�';
COMMENT ON COLUMN er_job.update_dt IS '鏇存柊鏃堕棿';
+COMMENT ON COLUMN er_job.deleted IS '閫昏緫鍒犻櫎 1銆佸垹闄�';
+
+INSERT INTO er_job (namespace_id, group_name, job_name, args_str, args_type, next_trigger_at, job_status, task_type, route_key, executor_type, executor_info, trigger_type, trigger_interval, block_strategy,executor_timeout, max_retry_times, parallel_num, retry_interval, bucket_index, resident, description, ext_attrs, create_dt, update_dt, deleted)
+VALUES ('dev', 'ruoyi_group', 'demo-job', NULL, 1, 1710344035622, 1, 1, 4, 1, 'testJobExecutor', 2, '60', 1, 60, 3, 1, 1, 116, 0, '', '', SYSDATE, SYSDATE, 0);
-- er_job_log_message
CREATE TABLE er_job_log_message
--
Gitblit v1.9.3