export declare const sql: {
    readonly catalog: {
        readonly listByLocale: "\n    SELECT\n      d.uuid AS uuid,\n      d.title AS title,\n      d.status AS status,\n      d.draft_slug AS draftSlug,\n      d.published_slug AS publishedSlug,\n      d.template AS template,\n      d.updated_at AS updatedAt\n    FROM documents d\n    ORDER BY d.updated_at DESC\n  ";
        readonly selectWorkspace: "\n    SELECT data_json AS dataJson\n    FROM workspaces\n    WHERE scope = 'documents:pages' AND key = 'folders'\n    LIMIT 1\n  ";
    };
    readonly read: {
        readonly selectByUuid: "\n    SELECT\n      uuid AS uuid,\n      document AS document,\n      template AS template,\n      title AS title,\n      status AS status,\n      draft_slug AS draftSlug,\n      published_slug AS publishedSlug,\n      draft_content AS draftContent,\n      published_content AS publishedContent,\n      published_version_id AS publishedVersionId,\n      created_at AS createdAt,\n      updated_at AS updatedAt,\n      published_at AS publishedAt\n    FROM documents\n    WHERE uuid = ?\n    LIMIT 1\n  ";
        readonly selectWorkspace: "\n    SELECT data_json AS dataJson\n    FROM workspaces\n    WHERE scope = 'documents:pages' AND key = 'folders'\n    LIMIT 1\n  ";
        readonly selectVersionById: "\n    SELECT\n      version_id AS versionId,\n      kind AS kind,\n      snapshot_json AS snapshotJson,\n      created_at AS createdAt,\n      created_by AS createdBy\n    FROM document_versions\n    WHERE document_uuid = ? AND version_id = ?\n    LIMIT 1\n  ";
    };
    readonly page: {
        readonly updateUnpublished: "\n    UPDATE documents\n    SET\n      status = 'draft',\n      updated_at = ?\n    WHERE uuid = ?\n  ";
        readonly updatePublished: "\n    UPDATE documents\n    SET\n      status = 'published',\n      published_slug = ?,\n      published_content = ?,\n      published_version_id = ?,\n      published_at = ?,\n      updated_at = ?\n    WHERE uuid = ?\n  ";
        readonly deleteByUuid: "\n    DELETE FROM documents\n    WHERE uuid = ?\n  ";
        readonly updateDraft: "\n    UPDATE documents\n    SET\n      title = ?,\n      template = ?,\n      draft_slug = ?,\n      status = ?,\n      draft_content = ?,\n      updated_at = ?\n    WHERE uuid = ?\n  ";
        readonly listByLocale: "\n    SELECT\n      d.uuid AS uuid,\n      d.title AS title,\n      d.status AS status,\n      d.draft_slug AS draftSlug,\n      d.published_slug AS publishedSlug,\n      d.template AS template,\n      d.updated_at AS updatedAt\n    FROM documents d\n    ORDER BY d.updated_at DESC\n  ";
        readonly selectByUuid: "\n    SELECT\n      uuid AS uuid,\n      document AS document,\n      template AS template,\n      title AS title,\n      status AS status,\n      draft_slug AS draftSlug,\n      published_slug AS publishedSlug,\n      draft_content AS draftContent,\n      published_content AS publishedContent,\n      published_version_id AS publishedVersionId,\n      created_at AS createdAt,\n      updated_at AS updatedAt,\n      published_at AS publishedAt\n    FROM documents\n    WHERE uuid = ?\n    LIMIT 1\n  ";
        readonly insert: "\n    INSERT INTO documents (\n      uuid,\n      document,\n      template,\n      title,\n      status,\n      draft_slug,\n      published_slug,\n      draft_content,\n      published_content,\n      published_version_id,\n      created_at,\n      updated_at,\n      published_at\n    )\n    VALUES (?, 'page', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n  ";
    };
    readonly route: {
        readonly upsert: "\n    INSERT INTO routes (\n      locale,\n      page_uuid,\n      slug,\n      parent_uuid,\n      is_published\n    )\n    VALUES (?, ?, ?, ?, ?)\n    ON CONFLICT(locale, page_uuid)\n    DO UPDATE SET\n      slug = excluded.slug,\n      parent_uuid = excluded.parent_uuid,\n      is_published = excluded.is_published\n  ";
        readonly updatePublishedState: "\n    UPDATE routes\n    SET is_published = ?\n    WHERE locale = ? AND page_uuid = ?\n  ";
        readonly selectByPageAndLocale: "\n    SELECT\n      slug AS slug,\n      parent_uuid AS parentUuid,\n      is_published AS isPublished\n    FROM routes\n    WHERE page_uuid = ? AND locale = ?\n    LIMIT 1\n  ";
    };
    readonly version: {
        readonly selectById: "\n    SELECT\n      version_id AS versionId,\n      kind AS kind,\n      snapshot_json AS snapshotJson,\n      created_at AS createdAt,\n      created_by AS createdBy\n    FROM document_versions\n    WHERE document_uuid = ? AND version_id = ?\n    LIMIT 1\n  ";
        readonly listByPage: "\n    SELECT\n      version_id AS versionId,\n      kind AS kind,\n      created_at AS createdAt,\n      created_by AS createdBy\n    FROM document_versions\n    WHERE document_uuid = ?\n    ORDER BY created_at DESC\n  ";
        readonly insert: "\n    INSERT INTO document_versions (\n      document_uuid,\n      version_id,\n      kind,\n      snapshot_json,\n      created_at,\n      created_by\n    )\n    VALUES (?, ?, ?, ?, ?, ?)\n  ";
    };
    readonly folder: {
        readonly upsertWorkspace: "\n    INSERT INTO workspaces (\n      scope,\n      key,\n      name,\n      data_json,\n      updated_at\n    )\n    VALUES ('documents:pages', 'folders', 'Page Folders', ?, ?)\n    ON CONFLICT(scope, key)\n    DO UPDATE SET\n      data_json = excluded.data_json,\n      updated_at = excluded.updated_at\n  ";
        readonly selectWorkspace: "\n    SELECT data_json AS dataJson\n    FROM workspaces\n    WHERE scope = 'documents:pages' AND key = 'folders'\n    LIMIT 1\n  ";
    };
};