Esempio n. 1
0
 /**
  * On retire un piste des favoris de l'utilisateur
  *
  * @return void
  */
 public function removeSongFromFavorites($song_id)
 {
     if ($song = $this->song->find($song_id)) {
         $statement = QueryBuilder::delete("favorites")->where("user_id = :user_id")->where("song_id = :song_id")->make();
         $user_id = $this->id;
         return $this->execute($statement, compact('user_id', 'song_id'));
     }
     return false;
 }
Esempio n. 2
0
 /**
  * Récuparation d'une entité via sa clé primaire
  *
  * @return Model
  */
 public function find($id)
 {
     $statement = QueryBuilder::select("*")->from($this->table)->where("{$this->primaryKey} = :id")->make();
     return $this->fetchOne($statement, compact('id'));
 }
Esempio n. 3
0
 /**
  * Récupération des pistes favorites d'un utilisateur
  *
  * @return array
  */
 public function getFavoritesByUserId($user_id)
 {
     $statement = QueryBuilder::select("{$this->table}.*")->from($this->table)->join("favorites", "favorites.song_id = {$this->table}.{$this->primaryKey}")->where("favorites.user_id = :user_id")->make();
     return $this->fetchAll($statement, compact('user_id'));
 }