aonestar.public

Parameters

Name	Type	Mode
force_gen	boolean	IN (DEFAULT false)

Definition

DECLARE
    v_urls_updated           integer;
    v_sys_logs_deleted       integer;
    v_intf_sync_logs_deleted integer;
BEGIN
    UPDATE public.guest_document
    SET image_url = doc.s3_get_signed_url(image_path, 7 * 24 * 60 * 60),
        photo_url = doc.s3_get_signed_url(photo_path, 7 * 24 * 60 * 60),
        url_updated_time = current_timestamp
    WHERE image_path IS NOT NULL
      AND (force_gen OR url_updated_time < current_timestamp - interval '5 days');
    GET DIAGNOSTICS v_urls_updated = ROW_COUNT;

DELETE FROM public.sys_log
    WHERE log_time < current_timestamp - interval '90 days';
    GET DIAGNOSTICS v_sys_logs_deleted = ROW_COUNT;

DELETE FROM public.intf_sync_channel_logs
    WHERE created_at < current_timestamp - interval '7 days';
    GET DIAGNOSTICS v_intf_sync_logs_deleted = ROW_COUNT;

RETURN jsonb_build_object(
        'force_gen', force_gen,
        'guest_document_urls_updated', v_urls_updated,
        'sys_logs_deleted', v_sys_logs_deleted,
        'intf_sync_channel_logs_deleted', v_intf_sync_logs_deleted
    );
END

sp_property_daily_cleanup

Parameters

Definition