MetastringsTable.php

Go to the documentation of this file.

<?php
namespace Elgg\Database;

use Elgg\Cache\Pool;
use Elgg\Database;


class MetastringsTable {

    private $cache;

    private $db;

    public function __construct(Pool $cache, Database $db) {
        $this->cache = $cache;
        $this->db = $db;
    }

    function getId($string, $case_sensitive = true) {
        if ($case_sensitive) {
            return $this->getIdCaseSensitive($string);
        } else {
            return $this->getIdCaseInsensitive($string);
        }
    }
    
    private function getIdCaseSensitive($string) {
        $string = (string)$string;
        return $this->cache->get($string, function() use ($string) {
            $escaped_string = $this->db->sanitizeString($string);
            $query = "SELECT * FROM {$this->getTableName()} WHERE string = BINARY '$escaped_string' LIMIT 1";
            $results = $this->db->getData($query);
            if (isset($results[0])) {
                return $results[0]->id;
            } else {
                return $this->add($string);
            }
        });
    }
    
    private function getIdCaseInsensitive($string) {
        $string = (string)$string;
        // caching doesn't work for case insensitive requests
        $escaped_string = $this->db->sanitizeString($string);
        $query = "SELECT * FROM {$this->getTableName()} WHERE string = '$escaped_string'";
        $results = $this->db->getData($query);
        $ids = array();
        foreach ($results as $result) {
            $ids[] = $result->id;
        }
        if (empty($ids)) {
            $ids[] = $this->add($string);
        }
        return $ids;
    }   
    
    function add($string) {
        $escaped_string = $this->db->sanitizeString(trim($string));
    
        return $this->db->insertData("INSERT INTO {$this->getTableName()} (string) VALUES ('$escaped_string')");
    }
    
    public function getTableName() {
        return $this->db->getTablePrefix() . "metastrings";
    }
}