import { insertOnUpdate } from '@evershop/postgres-query-builder'; import { error } from '../../../../lib/log/logger.js'; import { pool } from '../../../../lib/postgres/connection.js'; /** * Re-upsert the blog post's url_rewrite row on update (url_key may have changed). * The entity_uuid conflict key replaces the existing request_path. */ export default async (data: { uuid: string; url_key?: string; }): Promise => { try { if (!data?.url_key) { return; } await insertOnUpdate('url_rewrite', ['entity_uuid']) .given({ entity_type: 'blog_post', entity_uuid: data.uuid, request_path: `/blog/${data.url_key}`, target_path: `/blogPost/${data.uuid}` }) .execute(pool); } catch (e) { error(e); } };