Longman\TelegramBot\BotanDB

Complexity

Total Complexity

9

Size/Duplication

Total Lines	89
Duplicated Lines	0 %

Coupling/Cohesion

Components	2
Dependencies	2

Test Coverage

Coverage

0%

Importance

Changes	1
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	initializeBotanDb()	0	6	2
B	selectShortUrl()	0	28	4
B	insertShortUrl()	0	28	3

<?php
/**
 * This file is part of the TelegramBot package.
 *
 * (c) Avtandil Kikabidze aka LONGMAN <akalongman@gmail.com>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */

namespace Longman\TelegramBot;

use Exception;
use Longman\TelegramBot\Exception\TelegramException;
use PDO;

/**
 * Class BotanDB
 */
class BotanDB extends DB
{
    /**
     * Initilize botan shortener table
     */
    public static function initializeBotanDb()
    {
        if (!defined('TB_BOTAN_SHORTENER')) {
            define('TB_BOTAN_SHORTENER', self::$table_prefix . 'botan_shortener');
        }
    }

    /**
     * Select cached shortened URL from the database
     *
     * @param  $user_id
     * @param  $url
     *
     * @return array|bool
     * @throws \Longman\TelegramBot\Exception\TelegramException
     */
    public static function selectShortUrl($user_id, $url)
    {
        if (!self::isDbConnected()) {
            return false;
        }

        try {
            $sth = self::$pdo->prepare('SELECT * FROM `' . TB_BOTAN_SHORTENER . '`
                WHERE `user_id` = :user_id AND `url` = :url
                ORDER BY `created_at` DESC
                LIMIT 1
            ');

            $sth->bindParam(':user_id', $user_id, PDO::PARAM_INT);
            $sth->bindParam(':url', $url, PDO::PARAM_STR);
            $sth->execute();

            $result = $sth->fetchAll(PDO::FETCH_ASSOC);

            if (isset($result[0]['short_url'])) {
                return $result[0]['short_url'];
            }

            return $result;
        } catch (Exception $e) {
            throw new TelegramException($e->getMessage());
        }
    }

    /**
     * Insert shortened URL into the database
     *
     * @param $user_id
     * @param $url
     * @param $short_url
     *
     * @return bool
     * @throws \Longman\TelegramBot\Exception\TelegramException
     */
    public static function insertShortUrl($user_id, $url, $short_url)
    {
        if (!self::isDbConnected()) {
            return false;
        }

        try {
            $sth = self::$pdo->prepare('INSERT INTO `' . TB_BOTAN_SHORTENER . '`
                (
                `user_id`, `url`, `short_url`, `created_at`
                )
                VALUES (
                :user_id, :url, :short_url, :date
                )
            ');

            $created_at = self::getTimestamp();

            $sth->bindParam(':user_id', $user_id);
            $sth->bindParam(':url', $url);
            $sth->bindParam(':short_url', $short_url);
            $sth->bindParam(':date', $created_at);

            return $sth->execute();
        } catch (Exception $e) {
            throw new TelegramException($e->getMessage());
        }
    }
}