SiteAnalyzer\HitDAO

Complexity

Total Complexity

9

Size/Duplication

Total Lines	63
Duplicated Lines	0 %

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	checkHitTable()	0	9	2
A	countHit()	0	17	3
A	getAllHits()	0	15	4

<?php
/**
 *
 * (c) Ruben Dorado <ruben.dorados@google.com>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */
namespace SiteAnalyzer;
use Exception;
/**
 * class HitDAO
 *
 * @package   SiteAnalyzer
 * @author    Ruben Dorado <ruben.dorados@gmail.com>
 * @copyright 2018 Ruben Dorado
 * @license   http://www.opensource.org/licenses/MIT The MIT License
 */
class HitDAO
{

    /*
     * @param $pdo \PDO
     * @param $config Configuration
     */
    public static function checkHitTable($pdo, $config) {
        try {
            $db_hit_table = $config->getHitTableName();
            $stmt = $pdo->prepare("SELECT * FROM $db_hit_table WHERE 1==0");
            $stmt->execute();            
        } catch (Exception $e) {
            return false;
        }
        return true;        
    }
    
    /*
     * @param $pdo \PDO
     * @param $config Configuration
     *
     */
    public static function countHit($pdo, $config, $id, $options = []) {

The parameter $options is not used and could be removed.

        $db_hit_table = $config->getHitTableName();
        $db_url_table = $config->getUrlTableName();


        $stmt = $pdo->prepare("UPDATE $db_hit_table SET count = count + 1 WHERE id = ?");
        $stmt->execute([$id]);
        if ($stmt->rowCount()==0) {
            $stmt = $pdo->prepare("INSERT INTO $db_hit_table (id, count) VALUES (?, 1)");
            $stmt->execute([$id]);
        }

        $stmt = $pdo->prepare("UPDATE $db_url_table SET count = count + 1 WHERE id = ? and url = ?");
        $stmt->execute([$id, $url]);

The variable $url seems to be never defined.

        if ($stmt->rowCount()==0) {
            $stmt = $pdo->prepare("INSERT INTO $db_url_table (id, url, count) VALUES (?, ?, 1)");
            $stmt->execute([$id, $url]);
        }
    }
    
    /*
     * @param $pdo \PDO
     * @param $config Configuration
     *
     */
    public static function getAllHits($pdo, $config) {        
        $resp = [];
        try {
            $dbtable = $config->getHitTableName();
            $stmt = $pdo->prepare("SELECT id,count FROM $dbtable");
            if ($stmt->execute()) {
                while ($row = $stmt->fetch()) {
                    $resp[] = [$row['id'], $row['count']];
                }
            }
            
        } catch (Exception $e) {
            throw new Exception("Error executing function 'getAllHits'. ".$e->getMessage());
        }
        return $resp;        
    }

}