<?php
/**
 * Persists Connected_Project records. Backed by one wp_options row —
 * deliberately, not a custom table: this plugin runs on ordinary shared
 * hosting where an activation-time dbDelta() migration is one more thing
 * that can fail silently, and the realistic number of connected projects
 * per site (a handful of Lovable projects, not thousands of rows) never
 * approaches the point where a dedicated table would actually earn its
 * keep.
 *
 * @package Esipher
 */

namespace Esipher;

if ( ! defined( 'ABSPATH' ) ) {
	exit;
}

/**
 * Simple keyed CRUD over the 'esipher_github_projects' option.
 */
class Project_Store {

	const OPTION_KEY = 'esipher_github_projects';

	/**
	 * Deterministic ID for a given repo, independent of which project
	 * (if any) is already stored for it — used both to look up an
	 * existing record and to key a brand-new one, so connecting the
	 * same repo twice updates the original record instead of creating
	 * a duplicate.
	 *
	 * @param string $owner GitHub owner/org.
	 * @param string $repo  Repo name.
	 *
	 * @return string
	 */
	public static function id_for( $owner, $repo ) {
		return md5( strtolower( $owner ) . '/' . strtolower( $repo ) );
	}

	/**
	 * @return Connected_Project[] Keyed by id.
	 */
	public function all() {
		$raw = get_option( self::OPTION_KEY, array() );

		if ( ! is_array( $raw ) ) {
			return array();
		}

		$projects = array();

		foreach ( $raw as $id => $data ) {
			if ( is_array( $data ) ) {
				$projects[ $id ] = Connected_Project::from_array( $data );
			}
		}

		return $projects;
	}

	/**
	 * @param string $id Project ID (see id_for()).
	 *
	 * @return Connected_Project|null
	 */
	public function get( $id ) {
		$all = $this->all();

		return isset( $all[ $id ] ) ? $all[ $id ] : null;
	}

	/**
	 * Find the project tracking a given repo, if any — the lookup a
	 * webhook delivery needs, keyed on the payload's own
	 * "owner/repo" rather than a stored numeric ID GitHub's payload
	 * doesn't reliably echo back in the same shape.
	 *
	 * @param string $owner GitHub owner/org.
	 * @param string $repo  Repo name.
	 *
	 * @return Connected_Project|null
	 */
	public function find_by_repo( $owner, $repo ) {
		return $this->get( self::id_for( $owner, $repo ) );
	}

	/**
	 * Create or overwrite a project record.
	 *
	 * @param Connected_Project $project Must have owner/repo set;
	 *                                   $project->id is (re)computed
	 *                                   here rather than trusted.
	 */
	public function save( Connected_Project $project ) {
		$project->id = self::id_for( $project->owner, $project->repo );

		$raw               = get_option( self::OPTION_KEY, array() );
		$raw               = is_array( $raw ) ? $raw : array();
		$raw[ $project->id ] = $project->to_array();

		update_option( self::OPTION_KEY, $raw, false );
	}

	/**
	 * @param string $id Project ID.
	 */
	public function delete( $id ) {
		$raw = get_option( self::OPTION_KEY, array() );

		if ( ! is_array( $raw ) || ! isset( $raw[ $id ] ) ) {
			return;
		}

		unset( $raw[ $id ] );
		update_option( self::OPTION_KEY, $raw, false );
	}
}