Notes

CREATE OR REPLACE FUNCTION readyForUpgradeAfterPathMigrate() RETURNS boolean AS
$$
declare
conditionMet boolean;
value bigint;
counter int;
BEGIN
select exists(select from information_schema.columns
where table_name = 'files' and column_name = 'path')
into conditionMet;

if conditionMet = false then
return false;
end if;

select exists(select from information_schema.columns
where table_name = 'files' and column_name = 'parent_guid_device')
into conditionMet;

if conditionMet = false then
raise warning 'column parent_guid_device does not exist in table files';
return true;
end if;

select exists(select from information_schema.columns
where table_name = 'files' and column_name = 'parent_guid_version')
into conditionMet;

if conditionMet = false then
raise warning 'column parent_guid_version does not exist in table files';
return true;
end if;

select exists(select from information_schema.tables
where table_name = 'migrate_path_last_handled_id')
into conditionMet;

if conditionMet = false then
raise warning 'table migrate_path_last_handled_id does not exist';
return true;
end if;

select id from migrate_path_last_handled_id into value;

if value != 0 then
raise warning 'value in migrate_path_last_handled_id different than 0, path migration is still running';
return true;
end if;

select count(*) from migrate_path_last_handled_id into counter;

if counter > 1 then
raise warning 'there are multiple ids in migrate_path_last_handled_id';
return true;
end if;

select exists(select from information_schema.tables
where table_name = 'migrate_path_additional_id_to_handle')
into conditionMet;

if conditionMet = false then
raise warning 'table migrate_path_additional_id_to_handle does not exist';
return true;
end if;

select not exists(select id from migrate_path_additional_id_to_handle)
into conditionMet;

if conditionMet = false then
raise warning 'migrate_path_additional_id_to_handle contains ids, not all files migrated';
return true;
end if;

select exists(select from pg_indexes
where tablename = 'files' and indexname = 'npn')
into conditionMet;

if conditionMet = false then
raise warning 'index npn on table files does not exist';
return true;
end if;

select exists(select from pg_indexes
where tablename = 'files' and indexname = 'guid_index')
into conditionMet;

if conditionMet = false then
raise warning 'index guid_index on table files does not exist';
return true;
end if;

if not (exists(select * from pg_trigger where tgname = 'verify_path_matches_parent' and tgenabled != 'D')
and exists(select * from pg_trigger where tgname = 'mark_files_in_ctera_deleted_dir' and tgenabled != 'D')
and exists(select * from pg_trigger where tgname = 'verify_folder_not_parent' and tgenabled != 'D')) then
raise warning 'path migration triggers on table files do not exist or disabled';
return true;
end if;

return false;
END;
$$ LANGUAGE plpgsql