Medium\Pcetr\ProjectMysqlRepositoy.php

<?php

class ProjectMysqlRepository implements ProjectRepository
{
    /**
     * @param Project $project
     *
     * @return Project
     */
    public function save(Project $project)
    {
        # Build an array from $project
        # If $project->getId() is null then insert, else update based on the key(s)

        $dbTasks = [];
        
        try {
            foreach ($project->getTaskCollection() as $task) {
                $dbTasks[] = $this->taskRepsitory->save($task);
            }
        } catch (TasksAreNotAccessibleException $e) {
            # nothing to do
        }
        
        # We could use UUID as well
        # If we use regular id we can get the last inserted id ($id)
        
        return new DbProject($id, $project->getName(), $dbTasks);
    }
    
    /**
     * @param int $projectId
     *
     * @return Project
     */
    public function findById($projectId)
    {
        # Project select statement
        # If project is not found thrown an exception
        
        return new DbProject($id, $name, null);
    }
    
    /**
     * @param int $projectId
     *
     * @return Project
     */
    public function findByIdWithTasks($projectId)
    {
        # Project select statement
        # If project is not found thrown an exception
        
        $dbTasks = $this->taskRepository->findByProjectId($projectId);
        
        return new DbProject($id, $name, $dbTasks);
    }
}