canax / database

     *

     * @return this

     */

    public function findWhere($where, $value)

    {

        $this->checkDb();

        $params = is_array($value) ? $value : [$value];

        return $this->db->connect()

                        ->select()

                        ->from($this->tableName)

                        ->where($where)

                        ->execute($params)

                        ->fetchInto($this);

    }

     *

     * @return array of object of this class

     */

    public function findAllWhere($where, $value)

    {

        $this->checkDb();

        $params = is_array($value) ? $value : [$value];

        return $this->db->connect()

                        ->select()

                        ->from($this->tableName)

                        ->where($where)

                        ->execute($params)

                        ->fetchAllClass(get_class($this));

    }

     *

     * @return void

     */

    public function deleteWhere($where, $value)

    {

        $this->checkDb();

        $params = is_array($value) ? $value : [$value];

        $this->db->connect()

                 ->deleteFrom($this->tableName)

                 ->where($where)

                 ->execute($params);

        $this->id = null;

    }

}