JAQB\Operations\Fetchable

Complexity

Total Complexity

13

Size/Duplication

Total Lines	74
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Importance

Changes	1
Bugs	0	Features	0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	one()	0	10	2
A	all()	0	10	2
A	column()	0	10	2
A	scalar()	0	10	2

<?php

/**
 * @author Jared King <j@jaredtking.com>
 *
 * @link http://jaredtking.com
 *
 * @copyright 2015 Jared King
 * @license MIT
 */
namespace JAQB\Operations;

use PDO;

trait Fetchable
{
    /**
     * Executes a query and returns the first row.
     *
     * @param int $style PDO fetch style
     *
     * @return mixed|bool result
     */
    public function one($style = PDO::FETCH_ASSOC)
    {
        $stmt = $this->execute();

        if ($stmt) {
            return $stmt->fetch($style);
        } else {
            return false;
        }
    }

    /**
     * Executes a query and returns all of the rows.
     *
     * @param int $style PDO fetch style
     *
     * @return mixed|bool result
     */
    public function all($style = PDO::FETCH_ASSOC)
    {
        $stmt = $this->execute();

        if ($stmt) {
            return $stmt->fetchAll($style);
        } else {
            return false;
        }
    }

    /**
     * Executes a query and returns a column from all rows.
     *
     * @param int $index zero-indexed column to fetch
     *
     * @return mixed|bool result
     */
    public function column($index = 0)
    {
        $stmt = $this->execute();

        if ($stmt) {
            return $stmt->fetchAll(PDO::FETCH_COLUMN, $index);
        } else {
            return false;
        }
    }

    /**
     * Executes a query and returns a value from the first row.
     *
     * @param int $index zero-indexed column to fetch
     *
     * @return mixed|bool result
     */
    public function scalar($index = 0)
    {
        $stmt = $this->execute();

        if ($stmt) {
            return $stmt->fetchColumn($index);
        } else {
            return false;
        }
    }
}