• Home
• org.liquibase
• liquibase-test-harness
• 1.0.11
• source code
• loadUpdateData.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

liquibase.harness.data.expectedSql.db2-luw.loadUpdateData.sql Maven / Gradle / Ivy

BEGIN ATOMIC
DECLARE v_reccount INTEGER
SET v_reccount = (SELECT COUNT(*) FROM "DB2INST1".authors WHERE id = 1)
IF v_reccount = 0 THEN
INSERT INTO "DB2INST1".authors (id, first_name, last_name, email, birthdate, added) VALUES (1, 'Adam', 'Gods', '[email protected]', DATE('1000-02-27'), TIMESTAMP('2000-02-04 02:32:00'))
ELSEIF v_reccount = 1 THEN
UPDATE "DB2INST1".authors SET added = TIMESTAMP('2000-02-04 02:32:00'), birthdate = DATE('1000-02-27'), email = '[email protected]', first_name = 'Adam', last_name = 'Gods' WHERE id = 1
END IF
END
BEGIN ATOMIC
DECLARE v_reccount INTEGER
SET v_reccount = (SELECT COUNT(*) FROM "DB2INST1".authors WHERE id = 7)
IF v_reccount = 0 THEN
INSERT INTO "DB2INST1".authors (id, first_name, last_name, email, birthdate, added) VALUES (7, 'Noah', 'Lamekhs', '[email protected]', DATE('2000-02-27'), TIMESTAMP('1994-12-10 01:00:00'))
ELSEIF v_reccount = 1 THEN
UPDATE "DB2INST1".authors SET added = TIMESTAMP('1994-12-10 01:00:00'), birthdate = DATE('2000-02-27'), email = '[email protected]', first_name = 'Noah', last_name = 'Lamekhs' WHERE id = 7
END IF
END
BEGIN ATOMIC
DECLARE v_reccount INTEGER
SET v_reccount = (SELECT COUNT(*) FROM "DB2INST1".authors WHERE id = 8)
IF v_reccount = 0 THEN
INSERT INTO "DB2INST1".authors (id, first_name, last_name, email, birthdate, added) VALUES (8, 'Muhammad', 'Ibn Abdullah', '[email protected]', DATE('3000-02-27'), TIMESTAMP('2000-12-10 01:00:00'))
ELSEIF v_reccount = 1 THEN
UPDATE "DB2INST1".authors SET added = TIMESTAMP('2000-12-10 01:00:00'), birthdate = DATE('3000-02-27'), email = '[email protected]', first_name = 'Muhammad', last_name = 'Ibn Abdullah' WHERE id = 8
END IF
END