• Home
• org.liquibase
• liquibase-test-harness
• 1.0.5
• 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.postgresql.loadUpdateData.sql Maven / Gradle / Ivy

DO
$$
BEGIN
UPDATE public.authors SET added = '2000-02-04 02:32:00', birthdate = '1000-02-27', email = '[email protected]', first_name = 'Adam', last_name = 'Gods' WHERE id = 1
IF not found THEN
INSERT INTO public.authors (id, first_name, last_name, email, birthdate, added) VALUES (1, 'Adam', 'Gods', '[email protected]', '1000-02-27', '2000-02-04 02:32:00')
END IF
END
$$
LANGUAGE plpgsql
DO
$$
BEGIN
UPDATE public.authors SET added = '1994-12-10 01:00:00', birthdate = '2000-02-27', email = '[email protected]', first_name = 'Noah', last_name = 'Lamekhs' WHERE id = 7
IF not found THEN
INSERT INTO public.authors (id, first_name, last_name, email, birthdate, added) VALUES (7, 'Noah', 'Lamekhs', '[email protected]', '2000-02-27', '1994-12-10 01:00:00')
END IF
END
$$
LANGUAGE plpgsql
DO
$$
BEGIN
UPDATE public.authors SET added = '2000-12-10 01:00:00', birthdate = '3000-02-27', email = '[email protected]', first_name = 'Muhammad', last_name = 'Ibn Abdullah' WHERE id = 8
IF not found THEN
INSERT INTO public.authors (id, first_name, last_name, email, birthdate, added) VALUES (8, 'Muhammad', 'Ibn Abdullah', '[email protected]', '3000-02-27', '2000-12-10 01:00:00')
END IF
END
$$
LANGUAGE plpgsql