DbMessageSource::init() - Code Metrics - Inspection of "Switch travis OR from precise to trusty" - yiisoft/yii2 - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — prepare-travis-for-js ( a7ee60 )

by Carsten

created 2016-12-01 09:28 UTC

DbMessageSource::init() A

↳ Parent: DbMessageSource

Complexity

Conditions	2
Paths	2

Size

Total Lines	8
Code Lines	5

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	6

Importance

Changes

Metric	Value
dl	0
loc	8
ccs	0
cts	8
cp	0
rs	9.4285
c	0
b	0
f	0
cc	2
eloc	5
nc	2
nop	0
crap	6

<?php
/**
 * @link http://www.yiiframework.com/
 * @copyright Copyright (c) 2008 Yii Software LLC
 * @license http://www.yiiframework.com/license/
 */

namespace yii\i18n;

use Yii;
use yii\base\InvalidConfigException;
use yii\db\Expression;
use yii\di\Instance;
use yii\helpers\ArrayHelper;
use yii\caching\Cache;
use yii\db\Connection;
use yii\db\Query;

/**
 * DbMessageSource extends [[MessageSource]] and represents a message source that stores translated
 * messages in database.
 *
 * The database must contain the following two tables: source_message and message.
 *
 * The `source_message` table stores the messages to be translated, and the `message` table stores
 * the translated messages. The name of these two tables can be customized by setting [[sourceMessageTable]]
 * and [[messageTable]], respectively.
 *
 * The database connection is specified by [[db]]. Database schema could be initialized by applying migration:
 *
 * ```
 * yii migrate --migrationPath=@yii/i18n/migrations/
 * ```
 *
 * If you don't want to use migration and need SQL instead, files for all databases are in migrations directory.
 *
 * @author resurtm <[email protected]>
 * @since 2.0
 */
class DbMessageSource extends MessageSource
{
    /**
     * Prefix which would be used when generating cache key.
     * @deprecated This constant has never been used and will be removed in 2.1.0.
     */
    const CACHE_KEY_PREFIX = 'DbMessageSource';

    /**
     * @var Connection|array|string the DB connection object or the application component ID of the DB connection.
     *
     * After the DbMessageSource object is created, if you want to change this property, you should only assign
     * it with a DB connection object.
     *
     * Starting from version 2.0.2, this can also be a configuration array for creating the object.
     */
    public $db = 'db';
    /**
     * @var Cache|array|string the cache object or the application component ID of the cache object.
     * The messages data will be cached using this cache object.
     * Note, that to enable caching you have to set [[enableCaching]] to `true`, otherwise setting this property has no effect.
     *
     * After the DbMessageSource object is created, if you want to change this property, you should only assign
     * it with a cache object.
     *
     * Starting from version 2.0.2, this can also be a configuration array for creating the object.
     * @see cachingDuration
     * @see enableCaching
     */
    public $cache = 'cache';
    /**
     * @var string the name of the source message table.
     */
    public $sourceMessageTable = '{{%source_message}}';
    /**
     * @var string the name of the translated message table.
     */
    public $messageTable = '{{%message}}';
    /**
     * @var int the time in seconds that the messages can remain valid in cache.
     * Use 0 to indicate that the cached data will never expire.
     * @see enableCaching
     */
    public $cachingDuration = 0;
    /**
     * @var bool whether to enable caching translated messages
     */
    public $enableCaching = false;


    /**
     * Initializes the DbMessageSource component.
     * This method will initialize the [[db]] property to make sure it refers to a valid DB connection.
     * Configured [[cache]] component would also be initialized.
     * @throws InvalidConfigException if [[db]] is invalid or [[cache]] is invalid.
     */
    public function init()
    {
        parent::init();
        $this->db = Instance::ensure($this->db, Connection::className());
        if ($this->enableCaching) {
            $this->cache = Instance::ensure($this->cache, Cache::className());
        }
    }

    /**
     * Loads the message translation for the specified language and category.
     * If translation for specific locale code such as `en-US` isn't found it
     * tries more generic `en`.
     *
     * @param string $category the message category
     * @param string $language the target language
     * @return array the loaded messages. The keys are original messages, and the values
     * are translated messages.
     */
    protected function loadMessages($category, $language)
    {
        if ($this->enableCaching) {
            $key = [
                __CLASS__,
                $category,
                $language,
            ];
            $messages = $this->cache->get($key);
            if ($messages === false) {
                $messages = $this->loadMessagesFromDb($category, $language);
                $this->cache->set($key, $messages, $this->cachingDuration);
            }

            return $messages;
        } else {
            return $this->loadMessagesFromDb($category, $language);
        }
    }

    /**
     * Loads the messages from database.
     * You may override this method to customize the message storage in the database.
     * @param string $category the message category.
     * @param string $language the target language.
     * @return array the messages loaded from database.
     */
    protected function loadMessagesFromDb($category, $language)
    {
        $mainQuery = (new Query())->select(['message' => 't1.message', 'translation' => 't2.translation'])
            ->from(['t1' => $this->sourceMessageTable, 't2' => $this->messageTable])
            ->where([
                't1.id' => new Expression('[[t2.id]]'),
                't1.category' => $category,
                't2.language' => $language,
            ]);

        $fallbackLanguage = substr($language, 0, 2);
        $fallbackSourceLanguage = substr($this->sourceLanguage, 0, 2);

        if ($fallbackLanguage !== $language) {
            $mainQuery->union($this->createFallbackQuery($category, $language, $fallbackLanguage), true);
        } elseif ($language === $fallbackSourceLanguage) {
            $mainQuery->union($this->createFallbackQuery($category, $language, $fallbackSourceLanguage), true);
        }

        $messages = $mainQuery->createCommand($this->db)->queryAll();

        return ArrayHelper::map($messages, 'message', 'translation');
    }

    /**
     * The method builds the [[Query]] object for the fallback language messages search.
     * Normally is called from [[loadMessagesFromDb]].
     *
     * @param string $category the message category
     * @param string $language the originally requested language
     * @param string $fallbackLanguage the target fallback language
     * @return Query
     * @see loadMessagesFromDb
     * @since 2.0.7
     */
    protected function createFallbackQuery($category, $language, $fallbackLanguage)
    {
        return (new Query())->select(['message' => 't1.message', 'translation' => 't2.translation'])
            ->from(['t1' => $this->sourceMessageTable, 't2' => $this->messageTable])
            ->where([
                't1.id' => new Expression('[[t2.id]]'),
                't1.category' => $category,
                't2.language' => $fallbackLanguage,
            ])->andWhere([
                'NOT IN', 't2.id', (new Query())->select('[[id]]')->from($this->messageTable)->where(['language' => $language])
            ]);
    }
}


1			<?php
2			/**
3			* @link http://www.yiiframework.com/
4			* @copyright Copyright (c) 2008 Yii Software LLC
5			* @license http://www.yiiframework.com/license/
6			*/
7
8			namespace yii\i18n;
9
10			use Yii;
11			use yii\base\InvalidConfigException;
12			use yii\db\Expression;
13			use yii\di\Instance;
14			use yii\helpers\ArrayHelper;
15			use yii\caching\Cache;
16			use yii\db\Connection;
17			use yii\db\Query;
18
19			/**
20			* DbMessageSource extends [[MessageSource]] and represents a message source that stores translated
21			* messages in database.
22			*
23			* The database must contain the following two tables: source_message and message.
24			*
25			* The `source_message` table stores the messages to be translated, and the `message` table stores
26			* the translated messages. The name of these two tables can be customized by setting [[sourceMessageTable]]
27			* and [[messageTable]], respectively.
28			*
29			* The database connection is specified by [[db]]. Database schema could be initialized by applying migration:
30			*
31			* ```
32			* yii migrate --migrationPath=@yii/i18n/migrations/
33			* ```
34			*
35			* If you don't want to use migration and need SQL instead, files for all databases are in migrations directory.
36			*
37			* @author resurtm <[email protected]>
38			* @since 2.0
39			*/
40			class DbMessageSource extends MessageSource
41			{
42			/**
43			* Prefix which would be used when generating cache key.
44			* @deprecated This constant has never been used and will be removed in 2.1.0.
45			*/
46			const CACHE_KEY_PREFIX = 'DbMessageSource';
47
48			/**
49			* @var Connection\|array\|string the DB connection object or the application component ID of the DB connection.
50			*
51			* After the DbMessageSource object is created, if you want to change this property, you should only assign
52			* it with a DB connection object.
53			*
54			* Starting from version 2.0.2, this can also be a configuration array for creating the object.
55			*/
56			public $db = 'db';
57			/**
58			* @var Cache\|array\|string the cache object or the application component ID of the cache object.
59			* The messages data will be cached using this cache object.
60			* Note, that to enable caching you have to set [[enableCaching]] to `true`, otherwise setting this property has no effect.
61			*
62			* After the DbMessageSource object is created, if you want to change this property, you should only assign
63			* it with a cache object.
64			*
65			* Starting from version 2.0.2, this can also be a configuration array for creating the object.
66			* @see cachingDuration
67			* @see enableCaching
68			*/
69			public $cache = 'cache';
70			/**
71			* @var string the name of the source message table.
72			*/
73			public $sourceMessageTable = '{{%source_message}}';
74			/**
75			* @var string the name of the translated message table.
76			*/
77			public $messageTable = '{{%message}}';
78			/**
79			* @var int the time in seconds that the messages can remain valid in cache.
80			* Use 0 to indicate that the cached data will never expire.
81			* @see enableCaching
82			*/
83			public $cachingDuration = 0;
84			/**
85			* @var bool whether to enable caching translated messages
86			*/
87			public $enableCaching = false;
88
89
90			/**
91			* Initializes the DbMessageSource component.
92			* This method will initialize the [[db]] property to make sure it refers to a valid DB connection.
93			* Configured [[cache]] component would also be initialized.
94			* @throws InvalidConfigException if [[db]] is invalid or [[cache]] is invalid.
95			*/
96			public function init()
97			{
98			parent::init();
99			$this->db = Instance::ensure($this->db, Connection::className());
100			if ($this->enableCaching) {
101			$this->cache = Instance::ensure($this->cache, Cache::className());
102			}
103			}
104
105			/**
106			* Loads the message translation for the specified language and category.
107			* If translation for specific locale code such as `en-US` isn't found it
108			* tries more generic `en`.
109			*
110			* @param string $category the message category
111			* @param string $language the target language
112			* @return array the loaded messages. The keys are original messages, and the values
113			* are translated messages.
114			*/
115			protected function loadMessages($category, $language)
116			{
117			if ($this->enableCaching) {
118			$key = [
119			__CLASS__,
120			$category,
121			$language,
122			];
123			$messages = $this->cache->get($key);
124			if ($messages === false) {
125			$messages = $this->loadMessagesFromDb($category, $language);
126			$this->cache->set($key, $messages, $this->cachingDuration);
127			}
128
129			return $messages;
130			} else {
131			return $this->loadMessagesFromDb($category, $language);
132			}
133			}
134
135			/**
136			* Loads the messages from database.
137			* You may override this method to customize the message storage in the database.
138			* @param string $category the message category.
139			* @param string $language the target language.
140			* @return array the messages loaded from database.
141			*/
142			protected function loadMessagesFromDb($category, $language)
143			{
144			$mainQuery = (new Query())->select(['message' => 't1.message', 'translation' => 't2.translation'])
145			->from(['t1' => $this->sourceMessageTable, 't2' => $this->messageTable])
146			->where([
147			't1.id' => new Expression('[[t2.id]]'),
148			't1.category' => $category,
149			't2.language' => $language,
150			]);
151
152			$fallbackLanguage = substr($language, 0, 2);
153			$fallbackSourceLanguage = substr($this->sourceLanguage, 0, 2);
154
155			if ($fallbackLanguage !== $language) {
156			$mainQuery->union($this->createFallbackQuery($category, $language, $fallbackLanguage), true);
157			} elseif ($language === $fallbackSourceLanguage) {
158			$mainQuery->union($this->createFallbackQuery($category, $language, $fallbackSourceLanguage), true);
159			}
160
161			$messages = $mainQuery->createCommand($this->db)->queryAll();
162
163			return ArrayHelper::map($messages, 'message', 'translation');
164			}
165
166			/**
167			* The method builds the [[Query]] object for the fallback language messages search.
168			* Normally is called from [[loadMessagesFromDb]].
169			*
170			* @param string $category the message category
171			* @param string $language the originally requested language
172			* @param string $fallbackLanguage the target fallback language
173			* @return Query
174			* @see loadMessagesFromDb
175			* @since 2.0.7
176			*/
177			protected function createFallbackQuery($category, $language, $fallbackLanguage)
178			{
179			return (new Query())->select(['message' => 't1.message', 'translation' => 't2.translation'])
180			->from(['t1' => $this->sourceMessageTable, 't2' => $this->messageTable])
181			->where([
182			't1.id' => new Expression('[[t2.id]]'),
183			't1.category' => $category,
184			't2.language' => $fallbackLanguage,
185			])->andWhere([
186			'NOT IN', 't2.id', (new Query())->select('[[id]]')->from($this->messageTable)->where(['language' => $language])
187			]);
188			}
189			}
190

yiisoft / yii2

Push — prepare-travis-for-js ( a7ee60 )

DbMessageSource::init() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like