人大金仓数据库存储过程案例（人大金仓数据库存储过程案例分析）

CREATE OR REPLACE PROCEDURE public.create_task1()

AS

DECLARE i int ;

BEGIN

FOR i IN 1000001 ..5000000 LOOP

INSERT INTO "public"."pm_r_gongzuojilu" VALUES('系统维护', 'admin', 'u!1!', '''2023-08-23 00:00:00''', '', '测试项目KH-035', '64af5ad7d5deb912f38e29ef', NULL, '''2023-08-23 00:00:00''', 'WTC20230008:任务工作上报', '任务工作上报2023-08-000005', CONCAT('64e5800fd5de2889',LPAD(i,8,0)), 'u!1!', 'admin', NULL, NULL, '''2023-08-23 11:42:07.122000''', NULL, 9, '{"action_from":"form"}', '8a03b3648a1d1cf2018a207c3b190105', 'ended', '结束', 'u!1!', 'admin', '系统维护', 'u!1!', '', 0, 1, 'u!1!', 'admin', 'u!1!', 'admin', ',u!1!,#readall,0b40c7b01463429e902ae27d19bc84ad,', '', 1.00, '咋回事', '64b0f949d5deb912f38edf5a', '准备', 60, 0.00, 0.00, '', NULL, NULL, 0.00, '详细地址XXX', '', '成都', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'admin', 'u!1!', '''2023-07-14 00:00:00''', NULL, 'SJ-035', 'WTC20230008', '', 0.00, 1.00, 0.00, ',u!1!,#readall,0b40c7b01463429e902ae27d19bc84ad,', '', 'admin', 'u!1!', '', NULL, NULL, 'Y', NULL, NULL);

INSERT INTO "public"."pm_r_gongzuojilu_mingxi" VALUES(CONCAT('64e34adfd5de1886',LPAD(i,8,0)), CONCAT('64e5800fd5de2889',LPAD(i,8,0)), 0, '上午', 1.00, '咋回事1', 'u!1!', 'admin', NULL, NULL, '''2023-08-23 11:42:07.123000''', NULL);

INSERT INTO "public"."pm_r_gongzuojilu_mingxi" VALUES(CONCAT('64e34a8fd5de1886',LPAD(i,8,0)), CONCAT('64e5800fd5de2889',LPAD(i,8,0)), 1, '下午', 1.00, '咋回事2', 'u!1!', 'admin', NULL, NULL, '''2023-08-23 11:42:07.123000''', NULL);

IF Mod(i, 5000) = 0 THEN

COMMIT;

END IF;

END LOOP ;

COMMIT;

END

;