miBadger / miBadger.ActiveRecord

src/AbstractActiveRecord.php

Indentation +233 added lines, -233 removed lines

@@ -17,237 +17,237 @@
  */
 abstract class AbstractActiveRecord implements ActiveRecordInterface
 {
-	/** @var \PDO The PDO object. */
-	private $pdo;
-
-	/** @var null|int The ID. */
-	private $id;
-
-	/**
-	 * Construct an abstract pdo active record with the given pdo.
-	 *
-	 * @param \PDO $pdo
-	 */
-	public function __construct(\PDO $pdo)
-	{
-		$pdo->setAttribute(\PDO::ATTR_DEFAULT_FETCH_MODE, \PDO::FETCH_ASSOC);
-		$pdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
-
-		$this->setPdo($pdo);
-	}
-
-	/**
-	 * {@inheritdoc}
-	 */
-	public function create()
-	{
-		try {
-			$pdoStatement = $this->getPdo()->prepare($this->getCreateQuery());
-			$pdoStatement->execute($this->getActiveRecordData());
-
-			$this->setId(intval($this->getPdo()->lastInsertId()));
-		} catch(\PDOException $e) {
-			throw new ActiveRecordException('Can\'t create the record.', 0, $e);
-		}
-
-		return $this;
-	}
-
-	/**
-	 * Returns the create query.
-	 *
-	 * @return string the create query.
-	 */
-	private function getCreateQuery()
-	{
-		$columns = array_keys($this->getActiveRecordData());
-		$values = [];
-
-		foreach ($columns as $key => $value) {
-			$values[] = ':' . $value;
-		}
-
-		return sprintf('INSERT INTO %s (%s) VALUES (%s)', $this->getActiveRecordName(), implode(', ', $columns), implode(', ', $values));
-	}
-
-	/**
-	 * {@inheritdoc}
-	 */
-	public function read($id)
-	{
-		try {
-			$pdoStatement = $this->getPdo()->prepare($this->getReadQuery());
-			$pdoStatement->execute(['id' => $id]);
-
-			$this->setActiveRecordData($pdoStatement->fetch());
-			$this->setId($id);
-		} catch (\PDOException $e) {
-			throw new ActiveRecordException('Can\'t read the record.', 0, $e);
-		}
-
-		return $this;
-	}
-
-	/**
-	 * Returns the read query.
-	 *
-	 * @return string the read query.
-	 */
-	private function getReadQuery()
-	{
-		return sprintf('SELECT * FROM `%s` WHERE `id` = :id', $this->getActiveRecordName());
-	}
-
-	/**
-	 * {@inheritdoc}
-	 */
-	public function update()
-	{
-		if (!$this->exists()) {
-			throw new ActiveRecordException('Can\'t update a non-existent record.');
-		}
-
-		try {
-			$pdoStatement = $this->getPdo()->prepare($this->getUpdateQuery());
-			$pdoStatement->execute(['id' => $this->getId()] + $this->getActiveRecordData());
-		} catch (\PDOException $e) {
-			throw new ActiveRecordException('Can\'t update the record.', 0, $e);
-		}
-
-		return $this;
-	}
-
-	/**
-	 * Returns the update query.
-	 *
-	 * @return string the update query.
-	 */
-	private function getUpdateQuery()
-	{
-		$values = [];
-
-		foreach (array_keys($this->getActiveRecordData()) as $key => $value) {
-			$values[] = $value . ' = :' . $value;
-		}
-
-		return sprintf('UPDATE %s SET %s WHERE `id` = :id', $this->getActiveRecordName(), implode(', ', $values));
-	}
-
-	/**
-	 * {@inheritdoc}
-	 */
-	public function delete()
-	{
-		if (!$this->exists()) {
-			throw new ActiveRecordException('Can\'t delete a non-existent record.');
-		}
-
-		try {
-			$pdoStatement = $this->getPdo()->prepare($this->getDeleteQuery());
-			$pdoStatement->execute(['id' => $this->getId()]);
-
-			$this->setId(null);
-		} catch (\PDOException $e) {
-			throw new ActiveRecordException('Can\'t delete the record.', 0, $e);
-		}
-
-		return $this;
-	}
-
-	/**
-	 * Returns the delete query.
-	 *
-	 * @return string the delete query.
-	 */
-	private function getDeleteQuery()
-	{
-		return sprintf('DELETE FROM %s WHERE `id` = :id', $this->getActiveRecordName());
-	}
-
-	/**
-	 * {@inheritdoc}
-	 */
-	public function exists()
-	{
-		return $this->getId() !== null;
-	}
-
-	/**
-	 * Returns the PDO.
-	 *
-	 * @return \PDO the PDO.
-	 */
-	public function getPdo()
-	{
-		return $this->pdo;
-	}
-
-	/**
-	 * Set the PDO.
-	 *
-	 * @param \PDO $pdo
-	 * @return $this
-	 */
-	protected function setPdo($pdo)
-	{
-		$this->pdo = $pdo;
-
-		return $this;
-	}
-
-	/**
-	 * Returns the ID.
-	 *
-	 * @return null|int The ID.
-	 */
-	public function getId()
-	{
-		return $this->id;
-	}
-
-	/**
-	 * Set the ID.
-	 *
-	 * @param int $id
-	 * @return $this
-	 */
-	protected function setId($id)
-	{
-		$this->id = $id;
-
-		return $this;
-	}
-
-	/**
-	 * Returns the active record name.
-	 *
-	 * @return string the active record name.
-	 */
-	abstract protected function getActiveRecordName();
-
-	/**
-	 * Returns the active record data.
-	 *
-	 * @return array the active record data.
-	 */
-	abstract protected function getActiveRecordData();
-
-	/**
-	 * Set the active record data.
-	 *
-	 * @param array $fetch
-	 * @return null
-	 */
-	protected function setActiveRecordData(array $fetch)
-	{
-		$data = $this->getActiveRecordData();
-
-		foreach ($data as $key => &$value) {
-			if (!isset($fetch[$key])) {
-				throw new ActiveRecordException(sprintf('Can\'t read the expected column "%s". It\'s not returnd by the database', $key));
-			}
-
-			$value = $fetch[$key];
-		}
-	}
+    /** @var \PDO The PDO object. */
+    private $pdo;
+
+    /** @var null|int The ID. */
+    private $id;
+
+    /**
+     * Construct an abstract pdo active record with the given pdo.
+     *
+     * @param \PDO $pdo
+     */
+    public function __construct(\PDO $pdo)
+    {
+        $pdo->setAttribute(\PDO::ATTR_DEFAULT_FETCH_MODE, \PDO::FETCH_ASSOC);
+        $pdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
+
+        $this->setPdo($pdo);
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function create()
+    {
+        try {
+            $pdoStatement = $this->getPdo()->prepare($this->getCreateQuery());
+            $pdoStatement->execute($this->getActiveRecordData());
+
+            $this->setId(intval($this->getPdo()->lastInsertId()));
+        } catch(\PDOException $e) {
+            throw new ActiveRecordException('Can\'t create the record.', 0, $e);
+        }
+
+        return $this;
+    }
+
+    /**
+     * Returns the create query.
+     *
+     * @return string the create query.
+     */
+    private function getCreateQuery()
+    {
+        $columns = array_keys($this->getActiveRecordData());
+        $values = [];
+
+        foreach ($columns as $key => $value) {
+            $values[] = ':' . $value;
+        }
+
+        return sprintf('INSERT INTO %s (%s) VALUES (%s)', $this->getActiveRecordName(), implode(', ', $columns), implode(', ', $values));
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function read($id)
+    {
+        try {
+            $pdoStatement = $this->getPdo()->prepare($this->getReadQuery());
+            $pdoStatement->execute(['id' => $id]);
+
+            $this->setActiveRecordData($pdoStatement->fetch());
+            $this->setId($id);
+        } catch (\PDOException $e) {
+            throw new ActiveRecordException('Can\'t read the record.', 0, $e);
+        }
+
+        return $this;
+    }
+
+    /**
+     * Returns the read query.
+     *
+     * @return string the read query.
+     */
+    private function getReadQuery()
+    {
+        return sprintf('SELECT * FROM `%s` WHERE `id` = :id', $this->getActiveRecordName());
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function update()
+    {
+        if (!$this->exists()) {
+            throw new ActiveRecordException('Can\'t update a non-existent record.');
+        }
+
+        try {
+            $pdoStatement = $this->getPdo()->prepare($this->getUpdateQuery());
+            $pdoStatement->execute(['id' => $this->getId()] + $this->getActiveRecordData());
+        } catch (\PDOException $e) {
+            throw new ActiveRecordException('Can\'t update the record.', 0, $e);
+        }
+
+        return $this;
+    }
+
+    /**
+     * Returns the update query.
+     *
+     * @return string the update query.
+     */
+    private function getUpdateQuery()
+    {
+        $values = [];
+
+        foreach (array_keys($this->getActiveRecordData()) as $key => $value) {
+            $values[] = $value . ' = :' . $value;
+        }
+
+        return sprintf('UPDATE %s SET %s WHERE `id` = :id', $this->getActiveRecordName(), implode(', ', $values));
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function delete()
+    {
+        if (!$this->exists()) {
+            throw new ActiveRecordException('Can\'t delete a non-existent record.');
+        }
+
+        try {
+            $pdoStatement = $this->getPdo()->prepare($this->getDeleteQuery());
+            $pdoStatement->execute(['id' => $this->getId()]);
+
+            $this->setId(null);
+        } catch (\PDOException $e) {
+            throw new ActiveRecordException('Can\'t delete the record.', 0, $e);
+        }
+
+        return $this;
+    }
+
+    /**
+     * Returns the delete query.
+     *
+     * @return string the delete query.
+     */
+    private function getDeleteQuery()
+    {
+        return sprintf('DELETE FROM %s WHERE `id` = :id', $this->getActiveRecordName());
+    }
+
+    /**
+     * {@inheritdoc}
+     */
+    public function exists()
+    {
+        return $this->getId() !== null;
+    }
+
+    /**
+     * Returns the PDO.
+     *
+     * @return \PDO the PDO.
+     */
+    public function getPdo()
+    {
+        return $this->pdo;
+    }
+
+    /**
+     * Set the PDO.
+     *
+     * @param \PDO $pdo
+     * @return $this
+     */
+    protected function setPdo($pdo)
+    {
+        $this->pdo = $pdo;
+
+        return $this;
+    }
+
+    /**
+     * Returns the ID.
+     *
+     * @return null|int The ID.
+     */
+    public function getId()
+    {
+        return $this->id;
+    }
+
+    /**
+     * Set the ID.
+     *
+     * @param int $id
+     * @return $this
+     */
+    protected function setId($id)
+    {
+        $this->id = $id;
+
+        return $this;
+    }
+
+    /**
+     * Returns the active record name.
+     *
+     * @return string the active record name.
+     */
+    abstract protected function getActiveRecordName();
+
+    /**
+     * Returns the active record data.
+     *
+     * @return array the active record data.
+     */
+    abstract protected function getActiveRecordData();
+
+    /**
+     * Set the active record data.
+     *
+     * @param array $fetch
+     * @return null
+     */
+    protected function setActiveRecordData(array $fetch)
+    {
+        $data = $this->getActiveRecordData();
+
+        foreach ($data as $key => &$value) {
+            if (!isset($fetch[$key])) {
+                throw new ActiveRecordException(sprintf('Can\'t read the expected column "%s". It\'s not returnd by the database', $key));
+            }
+
+            $value = $fetch[$key];
+        }
+    }
 }

Spacing +1 added lines, -1 removed lines

@@ -46,7 +46,7 @@
 			$pdoStatement->execute($this->getActiveRecordData());
 
 			$this->setId(intval($this->getPdo()->lastInsertId()));
-		} catch(\PDOException $e) {
+		} catch (\PDOException $e) {
 			throw new ActiveRecordException('Can\'t create the record.', 0, $e);
 		}
 

src/AbstractActiveRecordSearch.php

Indentation +51 added lines, -51 removed lines

@@ -17,65 +17,65 @@
  */
 abstract class AbstractActiveRecordSearch extends AbstractActiveRecord
 {
-	/**
-	 * {@inheritdoc}
-	 */
-	public function search($options = [])
-	{
-		try {
-			$pdoStatement = $this->getPdo()->prepare($this->getSearchQuery($options));
-			array_walk_recursive($options, function (&$value) use ($pdoStatement) {
-				static $index = 1;
+    /**
+     * {@inheritdoc}
+     */
+    public function search($options = [])
+    {
+        try {
+            $pdoStatement = $this->getPdo()->prepare($this->getSearchQuery($options));
+            array_walk_recursive($options, function (&$value) use ($pdoStatement) {
+                static $index = 1;
 
-				$pdoStatement->bindParam($index++, $value);
-			});
+                $pdoStatement->bindParam($index++, $value);
+            });
 
-			$pdoStatement->execute();
-			$result = [];
+            $pdoStatement->execute();
+            $result = [];
 
-			while ($fetch = $pdoStatement->fetch()) {
-				$new = new static($this->getPdo());
+            while ($fetch = $pdoStatement->fetch()) {
+                $new = new static($this->getPdo());
 
-				$new->setId(intval($fetch['id']));
-				$new->setActiveRecordData($fetch);
+                $new->setId(intval($fetch['id']));
+                $new->setActiveRecordData($fetch);
 
-				$result[] = $new;
-			}
+                $result[] = $new;
+            }
 
-			return $result;
-		} catch (\PDOException $e) {
-			throw new ActiveRecordException('Can\'t search the record.', 0, $e);
-		}
-	}
+            return $result;
+        } catch (\PDOException $e) {
+            throw new ActiveRecordException('Can\'t search the record.', 0, $e);
+        }
+    }
 
-	/**
-	 * Returns the search query with the given options.
-	 *
-	 * @param array $options = []
-	 * @return string the search query with the given options.
-	 */
-	private function getSearchQuery($options = [])
-	{
-		$columns = array_keys($this->getActiveRecordData());
-		$columns[] = 'id';
-		$values = [];
+    /**
+     * Returns the search query with the given options.
+     *
+     * @param array $options = []
+     * @return string the search query with the given options.
+     */
+    private function getSearchQuery($options = [])
+    {
+        $columns = array_keys($this->getActiveRecordData());
+        $columns[] = 'id';
+        $values = [];
 
-		foreach ($options as $key => $value) {
-			if (!in_array($key, $columns)) {
-				throw new ActiveRecordException(sprintf('Option key "%s" doesn\'t exists.', $key));
-			}
+        foreach ($options as $key => $value) {
+            if (!in_array($key, $columns)) {
+                throw new ActiveRecordException(sprintf('Option key "%s" doesn\'t exists.', $key));
+            }
 
-			if (is_numeric($value)) {
-				$values[] = $key . ' = ?';
-			} elseif (is_string($value)) {
-				$values[] = $key . ' LIKE ?';
-			} elseif(is_array($value) && !empty($value)) {
-				$values[] = $key . ' IN(' . implode(',', array_fill(0, count($value), '?')) . ')';
-			} else {
-				throw new ActiveRecordException('Option value not supported.');
-			}
-		}
+            if (is_numeric($value)) {
+                $values[] = $key . ' = ?';
+            } elseif (is_string($value)) {
+                $values[] = $key . ' LIKE ?';
+            } elseif(is_array($value) && !empty($value)) {
+                $values[] = $key . ' IN(' . implode(',', array_fill(0, count($value), '?')) . ')';
+            } else {
+                throw new ActiveRecordException('Option value not supported.');
+            }
+        }
 
-		return sprintf('SELECT * FROM %s %s %s', $this->getActiveRecordName(), empty($values) ? '' : 'WHERE', implode(' AND ', $values));
-	}
+        return sprintf('SELECT * FROM %s %s %s', $this->getActiveRecordName(), empty($values) ? '' : 'WHERE', implode(' AND ', $values));
+    }
 }

Spacing +2 added lines, -2 removed lines

@@ -24,7 +24,7 @@ 
 	{
 		try {
 			$pdoStatement = $this->getPdo()->prepare($this->getSearchQuery($options));
-			array_walk_recursive($options, function (&$value) use ($pdoStatement) {
+			array_walk_recursive($options, function(&$value) use ($pdoStatement) {
 				static $index = 1;
 
 				$pdoStatement->bindParam($index++, $value);
@@ -69,7 +69,7 @@ 
 				$values[] = $key . ' = ?';
 			} elseif (is_string($value)) {
 				$values[] = $key . ' LIKE ?';
-			} elseif(is_array($value) && !empty($value)) {
+			} elseif (is_array($value) && !empty($value)) {
 				$values[] = $key . ' IN(' . implode(',', array_fill(0, count($value), '?')) . ')';
 			} else {
 				throw new ActiveRecordException('Option value not supported.');