Upgraded api tests to breaking changes in Ogooreck #742
Annotations
1 error
Helpdesk.Api.Tests.Incidents.RecordAgentResponseToIncidentTests ► RecordAgentResponseCommand_RecordsResponse:
Sample/Helpdesk/Helpdesk.Api/Program.cs#L251
Failed test found in:
Sample/Helpdesk/Helpdesk.Api.Tests/bin/TestResults/net7.0/test-results.trx
Error:
Marten.Exceptions.MartenSchemaException : DDL Execution for 'All Configured Changes' Failed!
DO $$
BEGIN
IF NOT EXISTS(
SELECT schema_name
FROM information_schema.schemata
WHERE schema_name = 'helpdesk'
)
THEN
EXECUTE 'CREATE SCHEMA helpdesk';
END IF;
END
$$;
DROP TABLE IF EXISTS helpdesk.mt_doc_deadletterevent CASCADE;
CREATE TABLE helpdesk.mt_doc_deadletterevent (
id uuid NOT NULL,
data jsonb NOT NULL,
mt_last_modified timestamp with time zone NULL DEFAULT (transaction_timestamp()),
mt_version uuid NOT NULL DEFAULT (md5(random()::text || clock_timestamp()::text)::uuid),
mt_dotnet_type varchar NULL,
CONSTRAINT pkey_mt_doc_deadletterevent_id PRIMARY KEY (id)
);
CREATE OR REPLACE FUNCTION helpdesk.mt_upsert_deadletterevent(doc JSONB, docDotNetType varchar, docId uuid, docVersion uuid) RETURNS UUID LANGUAGE plpgsql SECURITY INVOKER AS $function$
DECLARE
final_version uuid;
BEGIN
INSERT INTO helpdesk.mt_doc_deadletterevent ("data", "mt_dotnet_type", "id", "mt_version", mt_last_modified) VALUES (doc, docDotNetType, docId, docVersion, transaction_timestamp())
ON CONFLICT (id)
DO UPDATE SET "data" = doc, "mt_dotnet_type" = docDotNetType, "mt_version" = docVersion, mt_last_modified = transaction_timestamp();
SELECT mt_version FROM helpdesk.mt_doc_deadletterevent into final_version WHERE id = docId ;
RETURN final_version;
END;
$function$;
CREATE OR REPLACE FUNCTION helpdesk.mt_insert_deadletterevent(doc JSONB, docDotNetType varchar, docId uuid, docVersion uuid) RETURNS UUID LANGUAGE plpgsql SECURITY INVOKER AS $function$
BEGIN
INSERT INTO helpdesk.mt_doc_deadletterevent ("data", "mt_dotnet_type", "id", "mt_version", mt_last_modified) VALUES (doc, docDotNetType, docId, docVersion, transaction_timestamp());
RETURN docVersion;
END;
$function$;
CREATE OR REPLACE FUNCTION helpdesk.mt_update_deadletterevent(doc JSONB, docDotNetType varchar, docId uuid, docVersion uuid) RETURNS UUID LANGUAGE plpgsql SECURITY INVOKER AS $function$
DECLARE
final_version uuid;
BEGIN
UPDATE helpdesk.mt_doc_deadletterevent SET "data" = doc, "mt_dotnet_type" = docDotNetType, "mt_version" = docVersion, mt_last_modified = transaction_timestamp() where id = docId;
SELECT mt_version FROM helpdesk.mt_doc_deadletterevent into final_version WHERE id = docId ;
RETURN final_version;
END;
$function$;
---- Npgsql.PostgresException : 42P07: relation "mt_doc_deadletterevent" already exists
|