<?php
namespace ppb\Model;
use ppb\Library\Msg;

class MediaModel extends Database
{
    public function getAll()
    {
        $pdo = $this->linkDB();
        $sql = "SELECT * FROM media";

        try {
            $pdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
            $sth = $pdo->prepare($sql);
            $sth->execute();

            $result = $sth->fetchAll(\PDO::FETCH_ASSOC);

            $sth->closeCursor();
            $pdo = null;

            return $result;
        } catch (\PDOException $e) {
            return ["error" => $e->getMessage()];
        }
    }

    public function insert($data)
    {
        $pdo = $this->linkDB();
        $sql = "INSERT INTO media (uid, tid, name, length) 
                VALUES (:uid, :tid, :name, :length)";

        try {
            $pdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
            $sth = $pdo->prepare($sql);
            $sth->bindValue(':uid', $data['uid']);
            $sth->bindValue(':tid', $data['tid']);
            $sth->bindValue(':name', $data['name']);
            $sth->bindValue(':length', $data['length'] ?? null);
            $sth->execute();

            $sth->closeCursor();
            $pdo = null;

            return ["success" => true, "message" => "Media inserted"];
        } catch (\PDOException $e) {
            return ["error" => $e->getMessage()];
        }
    }

    public function remove($data)
    {
        $pdo = $this->linkDB();
        $sql = "DELETE FROM media WHERE mid = :mid";

        try {
            $pdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
            $sth = $pdo->prepare($sql);
            $sth->bindValue(':mid', $data['mid']);
            $sth->execute();

            $sth->closeCursor();
            $pdo = null;

            return ["success" => true, "message" => "Media removed"];
        } catch (\PDOException $e) {
            return ["error" => $e->getMessage()];
        }
    }
}