Method editCommunityProperty

server/src/db/property-db.ts:598–692

* Edit a hosted property with revision tracking. * Rejects edits to authoritative (has matching discovered_properties) or pending records.

(
    domain: string,
    input: {
      adagents_json?: Record<string, unknown>;
      edit_summary: string;
      editor_user_id: string;
      editor_email?: string;
      editor_name?: string;
    }
  )

   * Rejects edits to authoritative (has matching discovered_properties) or pending records.
   */
  async editCommunityProperty(
    domain: string,
    input: {
      adagents_json?: Record<string, unknown>;
      edit_summary: string;
      editor_user_id: string;
      editor_email?: string;
      editor_name?: string;
    }
  ): Promise<{ property: HostedProperty; revision_number: number }> {
    const client = await getClient();
    try {
      await client.query('BEGIN');

      // Lock the row
      const lockResult = await client.query<HostedProperty>(
        'SELECT * FROM hosted_properties WHERE publisher_domain = $1 FOR UPDATE',
        [domain.toLowerCase()]
      );
      if (lockResult.rows.length === 0) {
        throw new Error(`Property not found: ${domain}`);
      }

      const current = lockResult.rows[0];

      // Check for authoritative lock (discovered adagents.json exists)
      const authCheck = await client.query(
        'SELECT 1 FROM discovered_properties WHERE publisher_domain = $1 LIMIT 1',
        [domain.toLowerCase()]
      );
      if (authCheck.rows.length > 0) {
        throw new Error('Cannot edit authoritative property (managed via adagents.json)');
      }

      if (current.review_status === 'pending') {
        throw new Error('Cannot edit property pending review');
      }

      // Get next revision number
      const revResult = await client.query<{ next_rev: number }>(
        'SELECT COALESCE(MAX(revision_number), 0) + 1 as next_rev FROM property_revisions WHERE publisher_domain = $1',
        [domain.toLowerCase()]
      );
      const revisionNumber = revResult.rows[0].next_rev;

      // Snapshot current state as revision
      await client.query(
        `INSERT INTO property_revisions (
          publisher_domain, revision_number, snapshot,
          editor_user_id, editor_email, editor_name, edit_summary
        ) VALUES ($1, $2, $3, $4, $5, $6, $7)`,
        [
          domain.toLowerCase(),
          revisionNumber,
          JSON.stringify(current),
          input.editor_user_id,
          input.editor_email || null,
          input.editor_name || null,