--- /dev/null
+<?php
+
+namespace Drupal\migrate_drupal\Plugin\migrate\source\d7;
+
+use Drupal\Core\Entity\EntityManagerInterface;
+use Drupal\Core\State\StateInterface;
+use Drupal\migrate\Plugin\MigrationInterface;
+use Drupal\migrate_drupal\Plugin\migrate\source\DrupalSqlBase;
+
+/**
+ * Gets Drupal variable_store source from database.
+ *
+ * @MigrateSource(
+ * id = "d7_variable_translation",
+ * source_module = "i18n_variable",
+ * )
+ */
+class VariableTranslation extends DrupalSqlBase {
+ /**
+ * The variable names to fetch.
+ *
+ * @var array
+ */
+ protected $variables;
+
+ /**
+ * {@inheritdoc}
+ */
+ public function __construct(array $configuration, $plugin_id, $plugin_definition, MigrationInterface $migration, StateInterface $state, EntityManagerInterface $entity_manager) {
+ parent::__construct($configuration, $plugin_id, $plugin_definition, $migration, $state, $entity_manager);
+ $this->variables = $this->configuration['variables'];
+ }
+
+ /**
+ * {@inheritdoc}
+ */
+ protected function initializeIterator() {
+ return new \ArrayIterator($this->values());
+ }
+
+ /**
+ * Return the values of the variables specified in the plugin configuration.
+ *
+ * @return array
+ * An associative array where the keys are the variables specified in the
+ * plugin configuration and the values are the values found in the source.
+ * A key/value pair is added for the language code. Only those values are
+ * returned that are actually in the database.
+ */
+ protected function values() {
+ $values = [];
+ $result = $this->prepareQuery()->execute()->FetchAllAssoc('realm_key');
+ foreach ($result as $variable_store) {
+ $values[]['language'] = $variable_store['realm_key'];
+ }
+ $result = $this->prepareQuery()->execute()->FetchAll();
+ foreach ($result as $variable_store) {
+ foreach ($values as $key => $value) {
+ if ($values[$key]['language'] === $variable_store['realm_key']) {
+ if ($variable_store['serialized']) {
+ $values[$key][$variable_store['name']] = unserialize($variable_store['value']);
+ break;
+ }
+ else {
+ $values[$key][$variable_store['name']] = $variable_store['value'];
+ break;
+ }
+ }
+ }
+ }
+ return $values;
+ }
+
+ /**
+ * {@inheritdoc}
+ */
+ public function count($refresh = FALSE) {
+ return $this->initializeIterator()->count();
+ }
+
+ /**
+ * {@inheritdoc}
+ */
+ public function fields() {
+ return array_combine($this->variables, $this->variables);
+ }
+
+ /**
+ * {@inheritdoc}
+ */
+ public function getIds() {
+ $ids['language']['type'] = 'string';
+ return $ids;
+ }
+
+ /**
+ * {@inheritdoc}
+ */
+ public function query() {
+ return $this->select('variable_store', 'vs')
+ ->fields('vs')
+ ->condition('realm', 'language')
+ ->condition('name', (array) $this->configuration['variables'], 'IN');
+ }
+
+}