Longman\TelegramBot\BotanDB

Complexity

Total Complexity

8

Size/Duplication

Total Lines	82
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
A	selectShortUrl()	0	23	3
B	insertShortUrl()	0	26	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 string  $url
     * @param integer $user_id
     *
     * @return array|bool
     * @throws \Longman\TelegramBot\Exception\TelegramException
     */
    public static function selectShortUrl($url, $user_id)
    {
        if (!self::isDbConnected()) {
            return false;
        }

        try {
            $sth = self::$pdo->prepare('
                SELECT `short_url` 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();

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

    /**
     * Insert shortened URL into the database
     *
     * @param string  $url
     * @param integer $user_id
     * @param string  $short_url
     *
     * @return bool
     * @throws \Longman\TelegramBot\Exception\TelegramException
     */
    public static function insertShortUrl($url, $user_id, $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, PDO::PARAM_INT);
            $sth->bindParam(':url', $url, PDO::PARAM_STR);
            $sth->bindParam(':short_url', $short_url, PDO::PARAM_STR);
            $sth->bindParam(':date', $created_at, PDO::PARAM_STR);

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