<?php

class Game extends Model {

   // ===========
   // = Statics =
   // ===========
   protected static $table_name = 'GAME';

   public static function getList()
   {
       $stm = parent::exec('GAME_LIST');
       return $stm->fetchAll();
   }

   public static function getGame($id)
   {
       $stm = parent::exec('GAME_BY_ID', array(':game_id' => $id));
       $res = $stm->fetchAll();
       return $res;
   }

   public static function createGame($values)
   {
        $stm = parent::exec('GAME_CREATE',$values);
        $stmbis = parent::exec('GAME_ID_MAX');
        return $stmbis->fetchAll();
   }

   public static function updateGame($values)
   {
       $stm = parent::exec('GAME_UPDATE',$values);
       return "La game a été uploader";
   }

   public static function deleteGame($id)
   {
       $stm = parent::exec('GAME_DELETE',array(":GAME_ID" => $id));
       return "Game deleted";
   }

   public static function getUsers($id)
   {
       $stm = parent::exec('GAME_GET_USERS', array(":GAME_ID" => $id));
       return $stm->fetchAll();
   }

   public static function addUserGame($values)
   {
       $stm = parent::exec('GAME_ADD_USER', $values);
       return $stm;
   }

   public static function deleteUserGame($values)
   {
       $stm = parent::exec('GAME_DELETE_USER', $values);
       return $stm;
   }

}