text:
token_url=https://cp-console.apps.9.20.212.178.nip.io/idprovider/v1/auth/identitytoken

export client_secret=ibm-odm-vtt-odm-oidc-client-id-secret-value
export client_id=ibm-odm-vtt-odm-oidc-client-id
username=odmAdmin
password=odmAdmin

scope=openid

curl -v -k -H "Content-Type: application/x-www-form-urlencoded;charset=UTF-8" \
     -d "scope=${scope}&grant_type=password&client_id=${client_id}&client_secret=${client_secret}&username=${username}&password=${password}" \
     ${token_url}

echo ""


text:
#ifndef TENSORFLOW_KERNELS_VARIABLE_OPS_H_
#define TENSORFLOW_KERNELS_VARIABLE_OPS_H_

#include "tensorflow/core/framework/op_kernel.h"
#include "tensorflow/core/framework/register_types.h"
#include "tensorflow/core/framework/resource_mgr.h"
#include "tensorflow/core/lib/core/errors.h"
#include "tensorflow/core/platform/macros.h"
#include "tensorflow/core/platform/mutex.h"
#include "tensorflow/core/platform/types.h"

namespace tensorflow {

class VariableOp : public OpKernel {
 public:
  explicit VariableOp(OpKernelConstruction* context) : OpKernel(context) {
    OP_REQUIRES_OK(context, context->GetAttr("shape", &shape_));
    dtype_ = RemoveRefType(context->output_type(0));
  }

  ~VariableOp() override {
    if (var_) var_->Unref();
  }

  void Compute(OpKernelContext* ctx) override {
    mutex_lock l(init_mu_);
    if (var_ == nullptr) {
      OP_REQUIRES_OK(ctx, cinfo_.Init(ctx->resource_manager(), def(),
                                      true /* use name() */));
      auto creator = [this](Var** var) {
        *var = new Var(dtype_);
        (*var)->tensor()->set_shape(shape_);
        return Status::OK();
      };
      OP_REQUIRES_OK(ctx,
                     cinfo_.resource_manager()->LookupOrCreate<Var>(
                         cinfo_.container(), cinfo_.name(), &var_, creator));
    }
    // Output a reference to our tensor, so it may be updated.
    //
    // As long as *this is alive, the ref we return here is valid
    // because *this owns a ref on var_.
    ctx->set_output_ref(0, var_->mu(), var_->tensor());
  }

 private:
  class Var : public ResourceBase {
   public:
    explicit Var(DataType dtype) : tensor_(dtype) {}
    mutex* mu() { return &mu_; }
    Tensor* tensor() { return &tensor_; }

    string DebugString() override {
      return strings::StrCat(DataTypeString(tensor_.dtype()), "/",
                             tensor_.shape().DebugString());
    }

   private:
    mutex mu_;
    Tensor tensor_;

    ~Var() override {}
    TF_DISALLOW_COPY_AND_ASSIGN(Var);
  };

  DataType dtype_;
  TensorShape shape_;

  mutex init_mu_;
  ContainerInfo cinfo_ GUARDED_BY(init_mu_);
  Var* var_ GUARDED_BY(init_mu_) = nullptr;

  TF_DISALLOW_COPY_AND_ASSIGN(VariableOp);
};

class TemporaryVariableOp : public OpKernel {
 public:
  explicit TemporaryVariableOp(OpKernelConstruction* context)
      : OpKernel(context) {
    OP_REQUIRES_OK(context, context->GetAttr("shape", &shape_));
    OP_REQUIRES_OK(context, context->GetAttr("dtype", &dtype_));
    OP_REQUIRES_OK(context, context->GetAttr("var_name", &var_name_));
    // Variable name defaults to op name if not specified explicitly.
    if (var_name_ == "") var_name_ = name();
  }

  void Compute(OpKernelContext* context) override {
    Status s;
    ResourceMgr* rm = context->step_resource_manager();
    OP_REQUIRES(context, rm, errors::Internal("No per-step resource manager."));
    auto* tmp_var = new TmpVar;
    OP_REQUIRES(context, tmp_var,
                errors::ResourceExhausted("Could not allocate TmpVar."));
    tmp_var->name = var_name_;
    s = context->allocate_temp(dtype_, shape_, &tmp_var->val);
    if (!s.ok()) tmp_var->Unref();
    OP_REQUIRES_OK(context, s);
    OP_REQUIRES_OK(context, rm->Create("tmp_var", var_name_, tmp_var));
    context->set_output_ref(0, &tmp_var->mu, &tmp_var->val);
  }

 private:
  // Refcounted temporary variable resource.
  friend class DestroyTemporaryVariableOp;
  struct TmpVar : public ResourceBase {
    mutex mu;
    Tensor val;
    string name;
    string DebugString() override { return name; }
    ~TmpVar() override { VLOG(3) << "TmpVar " << name << " deleted"; }
  };

  TensorShape shape_;
  DataType dtype_;
  string var_name_;
};

class DestroyTemporaryVariableOp : public OpKernel {
 public:
  explicit DestroyTemporaryVariableOp(OpKernelConstruction* context)
      : OpKernel(context) {
    OP_REQUIRES(context, IsRefType(context->input_type(0)),
                errors::InvalidArgument("lhs input needs to be a ref type"))
    OP_REQUIRES_OK(context, context->GetAttr("var_name", &var_name_));
    OP_REQUIRES(context, var_name_ != "",
                errors::InvalidArgument("Missing var_name attribute"));
  }

  void Compute(OpKernelContext* context) override {
    // NOTE(pbar): All other mutators of the Tensor Ref *must* have completed
    // their execution before this DestroyTemporaryVariable op executes.
    // This is typically achieved using control dependencies.
    CHECK(IsRefType(context->input_dtype(0)));
    Tensor tmpvar = context->mutable_input(0, false);
    context->set_output(0, tmpvar);
    ResourceMgr* rm = context->step_resource_manager();
    OP_REQUIRES(context, rm, errors::Internal("No per-step resource manager."));
    OP_REQUIRES_OK(
        context, rm->Delete<TemporaryVariableOp::TmpVar>("tmp_var", var_name_));
  }

 private:
  string var_name_;
};

}  // namespace tensorflow

#endif  // TENSORFLOW_KERNELS_VARIABLE_OPS_H_

redpajama_set_name: RedPajamaGithub


text:
'use strict';

angular.module('ta.bootstrap.twa').config(['$translateProvider',
function($translateProvider) {
	$translateProvider.translations('en-US', {
		TA_TWA_INSERT : "Insert Twemoji Icon",
		TA_TWA_TOOLTIP : 'Insert Twemoji Icon',
		TA_TWA_OK : 'Ok',
		TA_TWA_CANCEL : 'Cancel',

		TA_TWA_SIZE_DEFAULT : 'Default Size',
		TA_TWA_SIZE_LG : '1.3x',
		TA_TWA_SIZE_2X : '2x',
		TA_TWA_SIZE_3X : '3x',
		TA_TWA_SIZE_4X : '4x',
		TA_TWA_SIZE_5X : '5x',

		EMOJI_PEOPLE : 'People',
		EMOJI_PEOPLE_FACES : 'Faces',
		EMOJI_PEOPLE_CAT_FACES : 'Cats',
		EMOJI_PEOPLE_OTHER_FACES : 'Others',
		EMOJI_PEOPLE_MISC : 'Misc',
		EMOJI_PEOPLE_CLOTHES_AND_ACCESSORIES : 'Clothes and Accessories',
		EMOJI_PEOPLE_HEARTS : 'Hearts',

		EMOJI_NATURE : 'Nature',
		EMOJI_NATURE_ANIMALS : 'Animals',
		EMOJI_NATURE_PLANTS_AND_FLOWERS : 'Plants and Flowers',
		EMOJI_NATURE_SCIENCE_AND_WEATHER : 'Scence and Weather',

		EMOJI_OBJECTS : 'Objects',
		EMOJI_OBJECTS_TOYS_TOOLS_AND_TECHNOLOGY : 'Toys, Tools and Technology',
		EMOJI_OBJECTS_BOOKS_ENVELOPES_AND_STATIONERY : 'Books, Envelopes and Stationery',
		EMOJI_OBJECTS_MUSIC_AND_ARTS : 'Music and Arts',
		EMOJI_OBJECTS_SPORTS_AND_GAMES : 'Sports and Games',
		EMOJI_OBJECTS_FOOD_AND_DRINK : 'Food and Drink',
		EMOJI_OBJECTS_FRUIT_AND_VEGETABLES : 'Fruit and Vegetables',

		EMOJI_PLACES : 'Places',
		EMOJI_PLACES_BUILDINGS_LOCATIONS_AND_LANDMARKS : 'Buildings, Locations and Landmarks',
		EMOJI_PLACES_TRANSPORT : 'Transport',
		EMOJI_PLACES_FLAGS : 'Flags',

		EMOJI_SYMBOLS : 'Symbols',
		EMOJI_SYMBOLS_NUMBERS_AND_ARROWS : 'Numbers and Arrows',
		EMOJI_SYMBOLS_TEXT_AND_LABELS : 'Text and Labels',
		EMOJI_SYMBOLS_ASTROLOGICAL_ZODIAC_SIGNS : 'Astrological, Zodiac and Signs',
		EMOJI_SYMBOLS_OTHER_SYMBOLS_AND_CHARACTERS : 'Others and Characters'
	});
}]);


text:
TEST(header_only_2)
{
	xml_document doc;
	CHECK(doc.load_string(STR("<node/>")));
	CHECK_STRING(doc.first_child().name(), STR("node"));

#ifndef PUGIXML_NO_XPATH
	CHECK(doc.first_child() == doc.select_node(STR("//*")).node());
#endif
}


text:
<?php
/**
 * Created by PhpStorm.
 * User: gry260
 * Date: 5/1/14
 * Time: 2:04 PM
 */
namespace DailyExpenses\Model;

use Zend\InputFilter\InputFilterAwareInterface;
use Zend\InputFilter\Factory as InputFactory;
use Zend\InputFilter\InputFilter;
use Zend\InputFilter\InputFilterInterface;

class Profile implements InputFilterAwareInterface
{
  protected $inputFilter;
  public function exchangeArray($data)
  {
    $this->profilename = (isset($data['profilename'])) ? $data['profilename'] : null;
    $this->fileupload = (isset($data['fileupload'])) ? $data['fileupload'] : null;
  }

  public function setInputFilter(InputFilterInterface $inputFilter)
  {
    throw new \Exception("Not used");
  }

  public function getInputFilter()
  {
    if (!$this->inputFilter) {
      $inputFilter = new InputFilter();
      $factory = new InputFactory();
      $inputFilter->add(
        $factory->createInput(array(
          'name' => 'Name',
          'required' => true,
          'filters' => array(
            array('name' => 'StripTags'),
            array('name' => 'StringTrim'),
          ),
          'validators' => array(
            array(
              'name' => 'Regex',
              'options' => array(
                'pattern' => '/^[0-9A-Za-z\s]+$/',
                'message' => array('Please remove the special characters in the Name field.')
              ),
            ),
          ),
        ))
      );

      $inputFilter->add(
        $factory->createInput(array(
          'name' => 'Price',
          'required' => true,
          'filters' => array(
            array('name' => 'StripTags'),
            array('name' => 'StringTrim'),
          ),
          'validators' => array(
            array(
              'name' => 'Regex',
              'options' => array(
                'pattern' => '/^([1-9][0-9]*|0)(\.[0-9]{2})?$/',
                'message' => array('Price must be numeric in the Price field.')
              ),
            ),
          ),
        ))
      );

      $inputFilter->add(
            $factory->createInput(array(
                'name' => 'type_id',
                'required' => true,
                'filters' => array(
                    array('name' => 'StripTags'),
                    array('name' => 'StringTrim'),
                ),
                'validators' => array(
                    array(
                        'name' => 'Regex',
                        'options' => array(
                            'pattern' => '/^[0-9]+$/',
                            'message' => array('Type id must be given.')
                        ),
                    ),
                ),
            ))
        );

      $inputFilter->add(
        $factory->createInput(array(
          'name' => 'Note',
          'required' => false,
          'filters' => array(
            array('name' => 'StripTags'),
            array('name' => 'StringTrim'),
          ),
          'validators' => array(
            array(
              'name' => 'Regex',
              'options' => array(
                'pattern' => '/^[0-9A-Za-z\s]+$/',
                'message' => array('Please remove the special characters in the Note field.')
              ),
            ),
          ),
        ))
      );

      $inputFilter->add(
        $factory->createInput(array(
          'name' => 'Date',
          'required' => true,
          'filters' => array(
            array('name' => 'StripTags'),
            array('name' => 'StringTrim'),
          ),
          'validators' => array(
            array(
              'name' => 'Regex',
              'options' => array(
                'pattern' => '/^[0-9]{1,2}\/[0-9]{1,2}\/[0-9]{4}$/',
                'message' => array('Please select a date from the datePicker.')
              ),
            ),
          ),
        ))
      );
      $this->inputFilter = $inputFilter;
    }

    return $this->inputFilter;
  }
}


text:
#import <Bolts/BFTask.h>
#import "GINIUserCenterManagerMock.h"
#import "GINIUser.h"
#import "GINISession.h"
#import "GINIError.h"

@implementation GINIUserCenterManagerMock {

}

+ (instancetype)userCenterManagerWithURLSession:(id <GINIURLSession>)urlSession clientID:(NSString *)clientID clientSecret:(NSString *)clientSecret baseURL:(NSURL *)baseURL notificationCenter:(NSNotificationCenter *)notificationCenter {
    return [[GINIUserCenterManagerMock alloc] initWithURLSession:urlSession clientID:clientID clientSecret:clientSecret baseURL:baseURL notificationCenter:nil];
}

- (instancetype)initWithURLSession:(id <GINIURLSession>)urlSession clientID:(NSString *)clientID clientSecret:(NSString *)clientSecret baseURL:(NSURL *)baseURL notificationCenter:(NSNotificationCenter *)notificationCenter {
    // Raise an exception to prevent that someone accidentally uses the mock instead of the real thing.
    @throw [NSException exceptionWithName:@"invalid initializer" reason:@"mock" userInfo:nil];
    return nil;
}

- (instancetype)init {
    if (self = [super init]) {
        _createUserEnabled = YES;
        _getInfoEnabled = YES;
        _loginEnabled = YES;
        _raiseWrongCredentialsOnLogin = NO;
        _createUserCalled = 0;
    }
    return self;
}

- (BFTask *)getUserInfo:(NSString *)userID {
    if (!_getInfoEnabled) {
        [[NSException exceptionWithName:@"Not allowed" reason:@"Disallowed by mock" userInfo:nil] raise];
    }
    return [BFTask taskWithResult:[GINIUser userWithEmail:@"foo@example.comm" userId:@"1234-5678-9012"]];
}

- (BFTask *)loginUser:(NSString *)userName password:(NSString *)password {
    if (!_loginEnabled) {
        [[NSException exceptionWithName:@"Not allowed" reason:@"Disallowed by mock" userInfo:nil] raise];
    }
    if (_raiseWrongCredentialsOnLogin) {
        return [BFTask taskWithError:[GINIError errorWithCode:GINIErrorInvalidCredentials userInfo:nil]];
    } if (_sessionForNextLogin) {
        BFTask *task = [BFTask taskWithResult:_sessionForNextLogin];
        _sessionForNextLogin = nil;
        return task;
    } else {
        return [BFTask taskWithResult:[[GINISession alloc] initWithAccessToken:@"1234-456" refreshToken:nil expirationDate:[NSDate dateWithTimeIntervalSinceNow:600]]];
    }
}

- (BFTask *)createUserWithEmail:(NSString *)email password:(NSString *)password {
    _createUserCalled += 1;
    if (!_createUserEnabled) {
        [[NSException exceptionWithName:@"Not allowed" reason:@"Disallowed by mock" userInfo:nil] raise];
    }
    if (_raiseHTTPErrorOnCreateUser) {
        // Connection lost error.
        return [BFTask taskWithError:[NSError errorWithDomain:NSURLErrorDomain code:-1005 userInfo:nil]];
    }
    GINIUser *user = [GINIUser userWithEmail:email userId:@"1234-5678-9012"];
    return [BFTask taskWithResult:user];
}

- (BFTask *)updateEmail:(NSString *)newEmail
               oldEmail:(NSString *)oldEmail
         giniApiSession:(GINISession *)giniApiSession {
    return [BFTask taskWithResult:nil];
   }

@end


text:
"""
======================================================================
Common pitfalls in the interpretation of coefficients of linear models
======================================================================

In linear models, the target value is modeled as
a linear combination of the features (see the :ref:`linear_model` User Guide
section for a description of a set of linear models available in
scikit-learn).
Coefficients in multiple linear models represent the relationship between the
given feature, :math:`X_i` and the target, :math:`y`, assuming that all the
other features remain constant (`conditional dependence
<https://en.wikipedia.org/wiki/Conditional_dependence>`_).
This is different from plotting :math:`X_i` versus :math:`y` and fitting a
linear relationship: in that case all possible values of the other features are
taken into account in the estimation (marginal dependence).

This example will provide some hints in interpreting coefficient in linear
models, pointing at problems that arise when either the linear model is not
appropriate to describe the dataset, or when features are correlated.

We will use data from the `"Current Population Survey"
<https://www.openml.org/d/534>`_ from 1985 to predict
wage as a function of various features such as experience, age, or education.

.. contents::
   :local:
   :depth: 1

"""

import numpy as np
import scipy as sp
import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns

# %%
# The dataset: wages
# ------------------
#
# We fetch the data from `OpenML <http://openml.org/>`_.
# Note that setting the parameter `as_frame` to True will retrieve the data
# as a pandas dataframe.

from sklearn.datasets import fetch_openml

survey = fetch_openml(data_id=534, as_frame=True)

# %%
# Then, we identify features `X` and targets `y`: the column WAGE is our
# target variable (i.e., the variable which we want to predict).
#
X = survey.data[survey.feature_names]
X.describe(include="all")

# %%
# Note that the dataset contains categorical and numerical variables.
# We will need to take this into account when preprocessing the dataset
# thereafter.

X.head()

# %%
# Our target for prediction: the wage.
# Wages are described as floating-point number in dollars per hour.
y = survey.target.values.ravel()
survey.target.head()

# %%
# We split the sample into a train and a test dataset.
# Only the train dataset will be used in the following exploratory analysis.
# This is a way to emulate a real situation where predictions are performed on
# an unknown target, and we don't want our analysis and decisions to be biased
# by our knowledge of the test data.

from sklearn.model_selection import train_test_split

X_train, X_test, y_train, y_test = train_test_split(X, y, random_state=42)

# %%
# First, let's get some insights by looking at the variable distributions and
# at the pairwise relationships between them. Only numerical
# variables will be used. In the following plot, each dot represents a sample.
#
#   .. _marginal_dependencies:

train_dataset = X_train.copy()
train_dataset.insert(0, "WAGE", y_train)
_ = sns.pairplot(train_dataset, kind="reg", diag_kind="kde")

# %%
# Looking closely at the WAGE distribution reveals that it has a
# long tail. For this reason, we should take its logarithm
# to turn it approximately into a normal distribution (linear models such
# as ridge or lasso work best for a normal distribution of error).
#
# The WAGE is increasing when EDUCATION is increasing.
# Note that the dependence between WAGE and EDUCATION
# represented here is a marginal dependence, i.e., it describes the behavior
# of a specific variable without keeping the others fixed.
#
# Also, the EXPERIENCE and AGE are strongly linearly correlated.
#
# .. _the-pipeline:
#
# The machine-learning pipeline
# -----------------------------
#
# To design our machine-learning pipeline, we first manually
# check the type of data that we are dealing with:

survey.data.info()

# %%
# As seen previously, the dataset contains columns with different data types
# and we need to apply a specific preprocessing for each data types.
# In particular categorical variables cannot be included in linear model if not
# coded as integers first. In addition, to avoid categorical features to be
# treated as ordered values, we need to one-hot-encode them.
# Our pre-processor will
#
# - one-hot encode (i.e., generate a column by category) the categorical
#   columns;
# - as a first approach (we will see after how the normalisation of numerical
#   values will affect our discussion), keep numerical values as they are.

from sklearn.compose import make_column_transformer
from sklearn.preprocessing import OneHotEncoder

categorical_columns = ["RACE", "OCCUPATION", "SECTOR", "MARR", "UNION", "SEX", "SOUTH"]
numerical_columns = ["EDUCATION", "EXPERIENCE", "AGE"]

preprocessor = make_column_transformer(
    (OneHotEncoder(drop="if_binary"), categorical_columns),
    remainder="passthrough",
    verbose_feature_names_out=False,
)

# %%
# To describe the dataset as a linear model we use a ridge regressor
# with a very small regularization and to model the logarithm of the WAGE.

from sklearn.pipeline import make_pipeline
from sklearn.linear_model import Ridge
from sklearn.compose import TransformedTargetRegressor

model = make_pipeline(
    preprocessor,
    TransformedTargetRegressor(
        regressor=Ridge(alpha=1e-10), func=np.log10, inverse_func=sp.special.exp10
    ),
)

# %%
# Processing the dataset
# ----------------------
#
# First, we fit the model.

_ = model.fit(X_train, y_train)

# %%
# Then we check the performance of the computed model plotting its predictions
# on the test set and computing,
# for example, the median absolute error of the model.

from sklearn.metrics import median_absolute_error

y_pred = model.predict(X_train)

mae = median_absolute_error(y_train, y_pred)
string_score = f"MAE on training set: {mae:.2f} $/hour"
y_pred = model.predict(X_test)
mae = median_absolute_error(y_test, y_pred)
string_score += f"\nMAE on testing set: {mae:.2f} $/hour"
fig, ax = plt.subplots(figsize=(5, 5))
plt.scatter(y_test, y_pred)
ax.plot([0, 1], [0, 1], transform=ax.transAxes, ls="--", c="red")
plt.text(3, 20, string_score)
plt.title("Ridge model, small regularization")
plt.ylabel("Model predictions")
plt.xlabel("Truths")
plt.xlim([0, 27])
_ = plt.ylim([0, 27])

# %%
# The model learnt is far from being a good model making accurate predictions:
# this is obvious when looking at the plot above, where good predictions
# should lie on the red line.
#
# In the following section, we will interpret the coefficients of the model.
# While we do so, we should keep in mind that any conclusion we draw is
# about the model that we build, rather than about the true (real-world)
# generative process of the data.
#
# Interpreting coefficients: scale matters
# ---------------------------------------------
#
# First of all, we can take a look to the values of the coefficients of the
# regressor we have fitted.
feature_names = model[:-1].get_feature_names_out()

coefs = pd.DataFrame(
    model.named_steps["transformedtargetregressor"].regressor_.coef_,
    columns=["Coefficients"],
    index=feature_names,
)

coefs

# %%
# The AGE coefficient is expressed in "dollars/hour per living years" while the
# EDUCATION one is expressed in "dollars/hour per years of education". This
# representation of the coefficients has the benefit of making clear the
# practical predictions of the model: an increase of :math:`1` year in AGE
# means a decrease of :math:`0.030867` dollars/hour, while an increase of
# :math:`1` year in EDUCATION means an increase of :math:`0.054699`
# dollars/hour. On the other hand, categorical variables (as UNION or SEX) are
# adimensional numbers taking either the value 0 or 1. Their coefficients
# are expressed in dollars/hour. Then, we cannot compare the magnitude of
# different coefficients since the features have different natural scales, and
# hence value ranges, because of their different unit of measure. This is more
# visible if we plot the coefficients.

coefs.plot(kind="barh", figsize=(9, 7))
plt.title("Ridge model, small regularization")
plt.axvline(x=0, color=".5")
plt.subplots_adjust(left=0.3)

# %%
# Indeed, from the plot above the most important factor in determining WAGE
# appears to be the
# variable UNION, even if our intuition might tell us that variables
# like EXPERIENCE should have more impact.
#
# Looking at the coefficient plot to gauge feature importance can be
# misleading as some of them vary on a small scale, while others, like AGE,
# varies a lot more, several decades.
#
# This is visible if we compare the standard deviations of different
# features.

X_train_preprocessed = pd.DataFrame(
    model.named_steps["columntransformer"].transform(X_train), columns=feature_names
)

X_train_preprocessed.std(axis=0).plot(kind="barh", figsize=(9, 7))
plt.title("Features std. dev.")
plt.subplots_adjust(left=0.3)

# %%
# Multiplying the coefficients by the standard deviation of the related
# feature would reduce all the coefficients to the same unit of measure.
# As we will see :ref:`after<scaling_num>` this is equivalent to normalize
# numerical variables to their standard deviation,
# as :math:`y = \sum{coef_i \times X_i} =
# \sum{(coef_i \times std_i) \times (X_i / std_i)}`.
#
# In that way, we emphasize that the
# greater the variance of a feature, the larger the weight of the corresponding
# coefficient on the output, all else being equal.

coefs = pd.DataFrame(
    model.named_steps["transformedtargetregressor"].regressor_.coef_
    * X_train_preprocessed.std(axis=0),
    columns=["Coefficient importance"],
    index=feature_names,
)
coefs.plot(kind="barh", figsize=(9, 7))
plt.title("Ridge model, small regularization")
plt.axvline(x=0, color=".5")
plt.subplots_adjust(left=0.3)

# %%
# Now that the coefficients have been scaled, we can safely compare them.
#
# .. warning::
#
#   Why does the plot above suggest that an increase in age leads to a
#   decrease in wage? Why the :ref:`initial pairplot
#   <marginal_dependencies>` is telling the opposite?
#
# The plot above tells us about dependencies between a specific feature and
# the target when all other features remain constant, i.e., **conditional
# dependencies**. An increase of the AGE will induce a decrease
# of the WAGE when all other features remain constant. On the contrary, an
# increase of the EXPERIENCE will induce an increase of the WAGE when all
# other features remain constant.
# Also, AGE, EXPERIENCE and EDUCATION are the three variables that most
# influence the model.
#
# Checking the variability of the coefficients
# --------------------------------------------
#
# We can check the coefficient variability through cross-validation:
# it is a form of data perturbation (related to
# `resampling <https://en.wikipedia.org/wiki/Resampling_(statistics)>`_).
#
# If coefficients vary significantly when changing the input dataset
# their robustness is not guaranteed, and they should probably be interpreted
# with caution.

from sklearn.model_selection import cross_validate
from sklearn.model_selection import RepeatedKFold

cv_model = cross_validate(
    model,
    X,
    y,
    cv=RepeatedKFold(n_splits=5, n_repeats=5),
    return_estimator=True,
    n_jobs=2,
)
coefs = pd.DataFrame(
    [
        est.named_steps["transformedtargetregressor"].regressor_.coef_
        * X_train_preprocessed.std(axis=0)
        for est in cv_model["estimator"]
    ],
    columns=feature_names,
)
plt.figure(figsize=(9, 7))
sns.stripplot(data=coefs, orient="h", color="k", alpha=0.5)
sns.boxplot(data=coefs, orient="h", color="cyan", saturation=0.5)
plt.axvline(x=0, color=".5")
plt.xlabel("Coefficient importance")
plt.title("Coefficient importance and its variability")
plt.subplots_adjust(left=0.3)

# %%
# The problem of correlated variables
# -----------------------------------
#
# The AGE and EXPERIENCE coefficients are affected by strong variability which
# might be due to the collinearity between the 2 features: as AGE and
# EXPERIENCE vary together in the data, their effect is difficult to tease
# apart.
#
# To verify this interpretation we plot the variability of the AGE and
# EXPERIENCE coefficient.
#
# .. _covariation:

plt.ylabel("Age coefficient")
plt.xlabel("Experience coefficient")
plt.grid(True)
plt.xlim(-0.4, 0.5)
plt.ylim(-0.4, 0.5)
plt.scatter(coefs["AGE"], coefs["EXPERIENCE"])
_ = plt.title("Co-variations of coefficients for AGE and EXPERIENCE across folds")

# %%
# Two regions are populated: when the EXPERIENCE coefficient is
# positive the AGE one is negative and vice-versa.
#
# To go further we remove one of the 2 features and check what is the impact
# on the model stability.

column_to_drop = ["AGE"]

cv_model = cross_validate(
    model,
    X.drop(columns=column_to_drop),
    y,
    cv=RepeatedKFold(n_splits=5, n_repeats=5),
    return_estimator=True,
    n_jobs=2,
)
coefs = pd.DataFrame(
    [
        est.named_steps["transformedtargetregressor"].regressor_.coef_
        * X_train_preprocessed.drop(columns=column_to_drop).std(axis=0)
        for est in cv_model["estimator"]
    ],
    columns=feature_names[:-1],
)
plt.figure(figsize=(9, 7))
sns.stripplot(data=coefs, orient="h", color="k", alpha=0.5)
sns.boxplot(data=coefs, orient="h", color="cyan", saturation=0.5)
plt.axvline(x=0, color=".5")
plt.title("Coefficient importance and its variability")
plt.xlabel("Coefficient importance")
plt.subplots_adjust(left=0.3)

# %%
# The estimation of the EXPERIENCE coefficient is now less variable and
# remain important for all models trained during cross-validation.
#
# .. _scaling_num:
#
# Preprocessing numerical variables
# ---------------------------------
#
# As said above (see ":ref:`the-pipeline`"), we could also choose to scale
# numerical values before training the model.
# This can be useful to apply a similar amount regularization to all of them
# in the Ridge.
# The preprocessor is redefined in order to subtract the mean and scale
# variables to unit variance.

from sklearn.preprocessing import StandardScaler

preprocessor = make_column_transformer(
    (OneHotEncoder(drop="if_binary"), categorical_columns),
    (StandardScaler(), numerical_columns),
    remainder="passthrough",
)

# %%
# The model will stay unchanged.

model = make_pipeline(
    preprocessor,
    TransformedTargetRegressor(
        regressor=Ridge(alpha=1e-10), func=np.log10, inverse_func=sp.special.exp10
    ),
)

_ = model.fit(X_train, y_train)

# %%
# Again, we check the performance of the computed
# model using, for example, the median absolute error of the model and the R
# squared coefficient.

y_pred = model.predict(X_train)
mae = median_absolute_error(y_train, y_pred)
string_score = f"MAE on training set: {mae:.2f} $/hour"
y_pred = model.predict(X_test)
mae = median_absolute_error(y_test, y_pred)
string_score += f"\nMAE on testing set: {mae:.2f} $/hour"
fig, ax = plt.subplots(figsize=(6, 6))
plt.scatter(y_test, y_pred)
ax.plot([0, 1], [0, 1], transform=ax.transAxes, ls="--", c="red")

plt.text(3, 20, string_score)

plt.title("Ridge model, small regularization, normalized variables")
plt.ylabel("Model predictions")
plt.xlabel("Truths")
plt.xlim([0, 27])
_ = plt.ylim([0, 27])

# %%
# For the coefficient analysis, scaling is not needed this time.

coefs = pd.DataFrame(
    model.named_steps["transformedtargetregressor"].regressor_.coef_,
    columns=["Coefficients"],
    index=feature_names,
)
coefs.plot(kind="barh", figsize=(9, 7))
plt.title("Ridge model, small regularization, normalized variables")
plt.axvline(x=0, color=".5")
plt.subplots_adjust(left=0.3)

# %%
# We now inspect the coefficients across several cross-validation folds.

cv_model = cross_validate(
    model,
    X,
    y,
    cv=RepeatedKFold(n_splits=5, n_repeats=5),
    return_estimator=True,
    n_jobs=2,
)
coefs = pd.DataFrame(
    [
        est.named_steps["transformedtargetregressor"].regressor_.coef_
        for est in cv_model["estimator"]
    ],
    columns=feature_names,
)
plt.figure(figsize=(9, 7))
sns.stripplot(data=coefs, orient="h", color="k", alpha=0.5)
sns.boxplot(data=coefs, orient="h", color="cyan", saturation=0.5)
plt.axvline(x=0, color=".5")
plt.title("Coefficient variability")
plt.subplots_adjust(left=0.3)

# %%
# The result is quite similar to the non-normalized case.
#
# Linear models with regularization
# ---------------------------------
#
# In machine-learning practice, Ridge Regression is more often used with
# non-negligible regularization.
#
# Above, we limited this regularization to a very little amount.
# Regularization improves the conditioning of the problem and reduces the
# variance of the estimates. RidgeCV applies cross validation in order to
# determine which value of the regularization parameter (`alpha`) is best
# suited for prediction.

from sklearn.linear_model import RidgeCV

model = make_pipeline(
    preprocessor,
    TransformedTargetRegressor(
        regressor=RidgeCV(alphas=np.logspace(-10, 10, 21)),
        func=np.log10,
        inverse_func=sp.special.exp10,
    ),
)

_ = model.fit(X_train, y_train)

# %%
# First we check which value of :math:`\alpha` has been selected.

model[-1].regressor_.alpha_

# %%
# Then we check the quality of the predictions.

y_pred = model.predict(X_train)
mae = median_absolute_error(y_train, y_pred)
string_score = f"MAE on training set: {mae:.2f} $/hour"
y_pred = model.predict(X_test)
mae = median_absolute_error(y_test, y_pred)
string_score += f"\nMAE on testing set: {mae:.2f} $/hour"

fig, ax = plt.subplots(figsize=(6, 6))
plt.scatter(y_test, y_pred)
ax.plot([0, 1], [0, 1], transform=ax.transAxes, ls="--", c="red")

plt.text(3, 20, string_score)

plt.title("Ridge model, regularization, normalized variables")
plt.ylabel("Model predictions")
plt.xlabel("Truths")
plt.xlim([0, 27])
_ = plt.ylim([0, 27])

# %%
# The ability to reproduce the data of the regularized model is similar to
# the one of the non-regularized model.

coefs = pd.DataFrame(
    model.named_steps["transformedtargetregressor"].regressor_.coef_,
    columns=["Coefficients"],
    index=feature_names,
)
coefs.plot(kind="barh", figsize=(9, 7))
plt.title("Ridge model, regularization, normalized variables")
plt.axvline(x=0, color=".5")
plt.subplots_adjust(left=0.3)

# %%
# The coefficients are significantly different.
# AGE and EXPERIENCE coefficients are both positive but they now have less
# influence on the prediction.
#
# The regularization reduces the influence of correlated
# variables on the model because the weight is shared between the two
# predictive variables, so neither alone would have strong weights.
#
# On the other hand, the weights obtained with regularization are more
# stable  (see the :ref:`ridge_regression` User Guide section). This
# increased stability is visible from the plot, obtained from data
# perturbations, in a cross validation. This plot can  be compared with
# the :ref:`previous one<covariation>`.

cv_model = cross_validate(
    model,
    X,
    y,
    cv=RepeatedKFold(n_splits=5, n_repeats=5),
    return_estimator=True,
    n_jobs=2,
)
coefs = pd.DataFrame(
    [
        est.named_steps["transformedtargetregressor"].regressor_.coef_
        * X_train_preprocessed.std(axis=0)
        for est in cv_model["estimator"]
    ],
    columns=feature_names,
)

plt.ylabel("Age coefficient")
plt.xlabel("Experience coefficient")
plt.grid(True)
plt.xlim(-0.4, 0.5)
plt.ylim(-0.4, 0.5)
plt.scatter(coefs["AGE"], coefs["EXPERIENCE"])
_ = plt.title("Co-variations of coefficients for AGE and EXPERIENCE across folds")

# %%
# Linear models with sparse coefficients
# --------------------------------------
#
# Another possibility to take into account correlated variables in the dataset,
# is to estimate sparse coefficients. In some way we already did it manually
# when we dropped the AGE column in a previous Ridge estimation.
#
# Lasso models (see the :ref:`lasso` User Guide section) estimates sparse
# coefficients. LassoCV applies cross validation in order to
# determine which value of the regularization parameter (`alpha`) is best
# suited for the model estimation.

from sklearn.linear_model import LassoCV

model = make_pipeline(
    preprocessor,
    TransformedTargetRegressor(
        regressor=LassoCV(alphas=np.logspace(-10, 10, 21), max_iter=100000),
        func=np.log10,
        inverse_func=sp.special.exp10,
    ),
)

_ = model.fit(X_train, y_train)

# %%
# First we verify which value of :math:`\alpha` has been selected.

model[-1].regressor_.alpha_

# %%
# Then we check the quality of the predictions.

y_pred = model.predict(X_train)
mae = median_absolute_error(y_train, y_pred)
string_score = f"MAE on training set: {mae:.2f} $/hour"
y_pred = model.predict(X_test)
mae = median_absolute_error(y_test, y_pred)
string_score += f"\nMAE on testing set: {mae:.2f} $/hour"

fig, ax = plt.subplots(figsize=(6, 6))
plt.scatter(y_test, y_pred)
ax.plot([0, 1], [0, 1], transform=ax.transAxes, ls="--", c="red")

plt.text(3, 20, string_score)

plt.title("Lasso model, regularization, normalized variables")
plt.ylabel("Model predictions")
plt.xlabel("Truths")
plt.xlim([0, 27])
_ = plt.ylim([0, 27])

# %%
# For our dataset, again the model is not very predictive.

coefs = pd.DataFrame(
    model.named_steps["transformedtargetregressor"].regressor_.coef_,
    columns=["Coefficients"],
    index=feature_names,
)
coefs.plot(kind="barh", figsize=(9, 7))
plt.title("Lasso model, regularization, normalized variables")
plt.axvline(x=0, color=".5")
plt.subplots_adjust(left=0.3)

# %%
# A Lasso model identifies the correlation between
# AGE and EXPERIENCE and suppresses one of them for the sake of the prediction.
#
# It is important to keep in mind that the coefficients that have been
# dropped may still be related to the outcome by themselves: the model
# chose to suppress them because they bring little or no additional
# information on top of the other features. Additionally, this selection
# is unstable for correlated features, and should be interpreted with
# caution.
#
# Lessons learned
# ---------------
#
# * Coefficients must be scaled to the same unit of measure to retrieve
#   feature importance. Scaling them with the standard-deviation of the
#   feature is a useful proxy.
# * Coefficients in multivariate linear models represent the dependency
#   between a given feature and the target, **conditional** on the other
#   features.
# * Correlated features induce instabilities in the coefficients of linear
#   models and their effects cannot be well teased apart.
# * Different linear models respond differently to feature correlation and
#   coefficients could significantly vary from one another.
# * Inspecting coefficients across the folds of a cross-validation loop
#   gives an idea of their stability.


text:
FROM      ubuntu

# Copy testrun.sh files into the container

ADD .   /src/

run ls -la /src

run cp /src/folderA/testAddFolder.sh /usr/local/bin/ && chmod +x /usr/local/bin/testAddFolder.sh

CMD ["testAddFolder.sh"]


text:
<?php
	abstract class DSSingleton {
		protected static $instance;

		protected static function getInstance() {
			return is_null($this->instance) ? null : $this->instance;
		}

		protected final function __construct() {}
		private final function __clone() {}
	}
?>


text:
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(240) NOT NULL,
  `email` varchar(240) NOT NULL,
  `password` varchar(240) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ip` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1, 'PHP Gang solve your problems', 'a@aasdf.com', 'ef7b0f97cf7fa82954ed1c23dde5ae1d', '2013-11-19 13:18:53');


text:
using content::BrowserThread;

namespace extensions {

namespace {

const events::HistogramValue kHistogramValue = events::FOR_TEST;
const char kEventName[] = "event_name";

class MockEventRouterForwarder : public EventRouterForwarder {
 public:
  MOCK_METHOD6(CallEventRouter,
               void(Profile*,
                    const std::string&,
                    events::HistogramValue,
                    const std::string&,
                    Profile*,
                    const GURL&));

  void CallEventRouter(Profile* profile,
                       const std::string& extension_id,
                       events::HistogramValue histogram_value,
                       const std::string& event_name,
                       std::unique_ptr<base::ListValue> event_args,
                       Profile* restrict_to_profile,
                       const GURL& event_url) override {
    CallEventRouter(profile, extension_id, histogram_value, event_name,
                    restrict_to_profile, event_url);
  }

 protected:
  ~MockEventRouterForwarder() override {}
};

static void BroadcastEventToRenderers(
    EventRouterForwarder* event_router,
    events::HistogramValue histogram_value,
    const std::string& event_name,
    const GURL& url,
    bool dispatch_to_off_the_record_profiles) {
  std::unique_ptr<base::ListValue> args(new base::ListValue());
  event_router->BroadcastEventToRenderers(histogram_value, event_name,
                                          std::move(args), url,
                                          dispatch_to_off_the_record_profiles);
}

static void DispatchEventToRenderers(EventRouterForwarder* event_router,
                                     events::HistogramValue histogram_value,
                                     const std::string& event_name,
                                     void* profile,
                                     bool use_profile_to_restrict_events,
                                     const GURL& url,
                                     bool dispatch_to_off_the_record_profiles) {
  std::unique_ptr<base::ListValue> args(new base::ListValue());
  event_router->DispatchEventToRenderers(
      histogram_value, event_name, std::move(args), profile,
      use_profile_to_restrict_events, url, dispatch_to_off_the_record_profiles);
}

}  // namespace

class EventRouterForwarderTest : public testing::Test {
 protected:
  EventRouterForwarderTest()
      : task_environment_(content::BrowserTaskEnvironment::REAL_IO_THREAD),
        profile_manager_(TestingBrowserProcess::GetGlobal()) {
    std::unique_ptr<base::PowerMonitorSource> power_monitor_source(
        new base::PowerMonitorDeviceSource());
    base::PowerMonitor::Initialize(std::move(power_monitor_source));
  }

  ~EventRouterForwarderTest() override {
    base::PowerMonitor::ShutdownForTesting();
  }

  void SetUp() override {
    ASSERT_TRUE(profile_manager_.SetUp());

    // Inject a BrowserProcess with a ProfileManager.
    profile1_ = profile_manager_.CreateTestingProfile("one");
    profile2_ = profile_manager_.CreateTestingProfile("two");
  }

  content::BrowserTaskEnvironment task_environment_;
  TestingProfileManager profile_manager_;
  // Profiles are weak pointers, owned by ProfileManager in |browser_process_|.
  TestingProfile* profile1_;
  TestingProfile* profile2_;
};

TEST_F(EventRouterForwarderTest, BroadcastRendererUI) {
  scoped_refptr<MockEventRouterForwarder> event_router(
      new MockEventRouterForwarder);
  GURL url;
  EXPECT_CALL(*event_router, CallEventRouter(profile1_, "", kHistogramValue,
                                             kEventName, profile1_, url));
  EXPECT_CALL(*event_router, CallEventRouter(profile2_, "", kHistogramValue,
                                             kEventName, profile2_, url));
  BroadcastEventToRenderers(event_router.get(), kHistogramValue, kEventName,
                            url, false);
}

TEST_F(EventRouterForwarderTest, BroadcastRendererUIIncognito) {
  scoped_refptr<MockEventRouterForwarder> event_router(
      new MockEventRouterForwarder);
  using ::testing::_;
  GURL url;
  Profile* incognito = profile1_->GetOffTheRecordProfile();
  EXPECT_CALL(*event_router, CallEventRouter(profile1_, "", kHistogramValue,
                                             kEventName, profile1_, url));
  EXPECT_CALL(*event_router, CallEventRouter(incognito, _, _, _, _, _))
      .Times(0);
  EXPECT_CALL(*event_router, CallEventRouter(profile2_, "", kHistogramValue,
                                             kEventName, profile2_, url));
  BroadcastEventToRenderers(event_router.get(), kHistogramValue, kEventName,
                            url, false);
}

TEST_F(EventRouterForwarderTest,
       BroadcastRendererUIIncognitoWithDispatchToOffTheRecordProfiles) {
  scoped_refptr<MockEventRouterForwarder> event_router(
      new MockEventRouterForwarder);
  using ::testing::_;
  GURL url;
  Profile* incognito1 = profile1_->GetOffTheRecordProfile();
  Profile* incognito2 = profile2_->GetOffTheRecordProfile();
  EXPECT_CALL(*event_router, CallEventRouter(profile1_, "", kHistogramValue,
                                             kEventName, profile1_, url));
  EXPECT_CALL(*event_router, CallEventRouter(incognito1, _, _, _, _, _));
  EXPECT_CALL(*event_router, CallEventRouter(profile2_, "", kHistogramValue,
                                             kEventName, profile2_, url));
  EXPECT_CALL(*event_router, CallEventRouter(incognito2, _, _, _, _, _));
  BroadcastEventToRenderers(event_router.get(), kHistogramValue, kEventName,
                            url, true);
}

// This is the canonical test for passing control flow from the IO thread
// to the UI thread. Repeating this for all public functions of
// EventRouterForwarder would not increase coverage.
TEST_F(EventRouterForwarderTest, BroadcastRendererIO) {
  scoped_refptr<MockEventRouterForwarder> event_router(
      new MockEventRouterForwarder);
  GURL url;
  EXPECT_CALL(*event_router, CallEventRouter(profile1_, "", kHistogramValue,
                                             kEventName, profile1_, url));
  EXPECT_CALL(*event_router, CallEventRouter(profile2_, "", kHistogramValue,
                                             kEventName, profile2_, url));
  base::PostTask(FROM_HERE, {BrowserThread::IO},
                 base::BindOnce(&BroadcastEventToRenderers,
                                base::Unretained(event_router.get()),
                                kHistogramValue, kEventName, url, false));

  // Wait for IO thread's message loop to be processed
  scoped_refptr<base::ThreadTestHelper> helper(new base::ThreadTestHelper(
      base::CreateSingleThreadTaskRunner({BrowserThread::IO}).get()));
  ASSERT_TRUE(helper->Run());

  base::RunLoop().RunUntilIdle();
}

TEST_F(EventRouterForwarderTest, UnicastRendererUIRestricted) {
  scoped_refptr<MockEventRouterForwarder> event_router(
      new MockEventRouterForwarder);
  using ::testing::_;
  GURL url;
  EXPECT_CALL(*event_router, CallEventRouter(profile1_, "", kHistogramValue,
                                             kEventName, profile1_, url));
  EXPECT_CALL(*event_router, CallEventRouter(profile2_, _, _, _, _, _))
      .Times(0);
  DispatchEventToRenderers(event_router.get(), kHistogramValue, kEventName,
                           profile1_, true, url, false);
}

TEST_F(EventRouterForwarderTest, UnicastRendererUIRestrictedIncognito1) {
  scoped_refptr<MockEventRouterForwarder> event_router(
      new MockEventRouterForwarder);
  Profile* incognito = profile1_->GetOffTheRecordProfile();
  using ::testing::_;
  GURL url;
  EXPECT_CALL(*event_router, CallEventRouter(profile1_, "", kHistogramValue,
                                             kEventName, profile1_, url));
  EXPECT_CALL(*event_router, CallEventRouter(incognito, _, _, _, _, _))
      .Times(0);
  EXPECT_CALL(*event_router, CallEventRouter(profile2_, _, _, _, _, _))
      .Times(0);
  DispatchEventToRenderers(event_router.get(), kHistogramValue, kEventName,
                           profile1_, true, url, false);
}

TEST_F(
    EventRouterForwarderTest,
    UnicastRendererUIRestrictedIncognito1WithDispatchToOffTheRecordProfiles) {
  scoped_refptr<MockEventRouterForwarder> event_router(
      new MockEventRouterForwarder);
  Profile* incognito1 = profile1_->GetOffTheRecordProfile();
  Profile* incognito2 = profile2_->GetOffTheRecordProfile();
  using ::testing::_;
  GURL url;
  EXPECT_CALL(*event_router, CallEventRouter(profile1_, "", kHistogramValue,
                                             kEventName, profile1_, url));
  EXPECT_CALL(*event_router, CallEventRouter(incognito1, _, _, _, _, _));
  EXPECT_CALL(*event_router, CallEventRouter(profile2_, _, _, _, _, _))
      .Times(0);
  EXPECT_CALL(*event_router, CallEventRouter(incognito2, _, _, _, _, _))
      .Times(0);
  DispatchEventToRenderers(event_router.get(), kHistogramValue, kEventName,
                           profile1_, true, url, true);
}

TEST_F(EventRouterForwarderTest, UnicastRendererUIRestrictedIncognito2) {
  scoped_refptr<MockEventRouterForwarder> event_router(
      new MockEventRouterForwarder);
  Profile* incognito = profile1_->GetOffTheRecordProfile();
  using ::testing::_;
  GURL url;
  EXPECT_CALL(*event_router, CallEventRouter(profile1_, _, _, _, _, _))
      .Times(0);
  EXPECT_CALL(*event_router, CallEventRouter(incognito, "", kHistogramValue,
                                             kEventName, incognito, url));
  EXPECT_CALL(*event_router, CallEventRouter(profile2_, _, _, _, _, _))
      .Times(0);
  DispatchEventToRenderers(event_router.get(), kHistogramValue, kEventName,
                           incognito, true, url, false);
}

TEST_F(EventRouterForwarderTest, UnicastRendererUIUnrestricted) {
  scoped_refptr<MockEventRouterForwarder> event_router(
      new MockEventRouterForwarder);
  using ::testing::_;
  GURL url;
  EXPECT_CALL(*event_router, CallEventRouter(profile1_, "", kHistogramValue,
                                             kEventName, NULL, url));
  EXPECT_CALL(*event_router, CallEventRouter(profile2_, _, _, _, _, _))
      .Times(0);
  DispatchEventToRenderers(event_router.get(), kHistogramValue, kEventName,
                           profile1_, false, url, false);
}

TEST_F(EventRouterForwarderTest, UnicastRendererUIUnrestrictedIncognito) {
  scoped_refptr<MockEventRouterForwarder> event_router(
      new MockEventRouterForwarder);
  Profile* incognito = profile1_->GetOffTheRecordProfile();
  using ::testing::_;
  GURL url;
  EXPECT_CALL(*event_router, CallEventRouter(profile1_, "", kHistogramValue,
                                             kEventName, NULL, url));
  EXPECT_CALL(*event_router, CallEventRouter(incognito, _, _, _, _, _))
      .Times(0);
  EXPECT_CALL(*event_router, CallEventRouter(profile2_, _, _, _, _, _))
      .Times(0);
  DispatchEventToRenderers(event_router.get(), kHistogramValue, kEventName,
                           profile1_, false, url, false);
}

}  // namespace extensions


text:
CREATE TABLE list (id VARCHAR(2) NOT NULL, value VARCHAR(64) NOT NULL, PRIMARY KEY(id));

INSERT INTO "list" ("id", "value") VALUES (E'af', E'afrikaans');
INSERT INTO "list" ("id", "value") VALUES (E'af_NA', E'afrikaans (Namibia)');
INSERT INTO "list" ("id", "value") VALUES (E'af_ZA', E'afrikaans (Sør-Afrika)');
INSERT INTO "list" ("id", "value") VALUES (E'ak', E'akan');
INSERT INTO "list" ("id", "value") VALUES (E'ak_GH', E'akan (Ghana)');
INSERT INTO "list" ("id", "value") VALUES (E'sq', E'albansk');
INSERT INTO "list" ("id", "value") VALUES (E'sq_AL', E'albansk (Albania)');
INSERT INTO "list" ("id", "value") VALUES (E'sq_XK', E'albansk (Kosovo)');
INSERT INTO "list" ("id", "value") VALUES (E'sq_MK', E'albansk (Makedonia)');
INSERT INTO "list" ("id", "value") VALUES (E'am', E'amharisk');
INSERT INTO "list" ("id", "value") VALUES (E'am_ET', E'amharisk (Etiopia)');
INSERT INTO "list" ("id", "value") VALUES (E'ar', E'arabisk');
INSERT INTO "list" ("id", "value") VALUES (E'ar_DZ', E'arabisk (Algerie)');
INSERT INTO "list" ("id", "value") VALUES (E'ar_BH', E'arabisk (Bahrain)');
INSERT INTO "list" ("id", "value") VALUES (E'ar_AE', E'arabisk (De forente arabiske emirater)');
INSERT INTO "list" ("id", "value") VALUES (E'ar_PS', E'arabisk (Det palestinske området)');
INSERT INTO "list" ("id", "value") VALUES (E'ar_DJ', E'arabisk (Djibouti)');
INSERT INTO "list" ("id", "value") VALUES (E'ar_EG', E'arabisk (Egypt)');
INSERT INTO "list" ("id", "value") VALUES (E'ar_ER', E'arabisk (Eritrea)');
INSERT INTO "list" ("id", "value") VALUES (E'ar_IQ', E'arabisk (Irak)');
INSERT INTO "list" ("id", "value") VALUES (E'ar_IL', E'arabisk (Israel)');
INSERT INTO "list" ("id", "value") VALUES (E'ar_YE', E'arabisk (Jemen)');
INSERT INTO "list" ("id", "value") VALUES (E'ar_JO', E'arabisk (Jordan)');
INSERT INTO "list" ("id", "value") VALUES (E'ar_KM', E'arabisk (Komorene)');
INSERT INTO "list" ("id", "value") VALUES (E'ar_KW', E'arabisk (Kuwait)');
INSERT INTO "list" ("id", "value") VALUES (E'ar_LB', E'arabisk (Libanon)');
INSERT INTO "list" ("id", "value") VALUES (E'ar_LY', E'arabisk (Libya)');
INSERT INTO "list" ("id", "value") VALUES (E'ar_MA', E'arabisk (Marokko)');
INSERT INTO "list" ("id", "value") VALUES (E'ar_MR', E'arabisk (Mauritania)');
INSERT INTO "list" ("id", "value") VALUES (E'ar_OM', E'arabisk (Oman)');
INSERT INTO "list" ("id", "value") VALUES (E'ar_QA', E'arabisk (Qatar)');
INSERT INTO "list" ("id", "value") VALUES (E'ar_SA', E'arabisk (Saudi-Arabia)');
INSERT INTO "list" ("id", "value") VALUES (E'ar_SO', E'arabisk (Somalia)');
INSERT INTO "list" ("id", "value") VALUES (E'ar_SD', E'arabisk (Sudan)');
INSERT INTO "list" ("id", "value") VALUES (E'ar_SY', E'arabisk (Syria)');
INSERT INTO "list" ("id", "value") VALUES (E'ar_SS', E'arabisk (Sør-Sudan)');
INSERT INTO "list" ("id", "value") VALUES (E'ar_TD', E'arabisk (Tsjad)');
INSERT INTO "list" ("id", "value") VALUES (E'ar_TN', E'arabisk (Tunisia)');
INSERT INTO "list" ("id", "value") VALUES (E'ar_EH', E'arabisk (Vest-Sahara)');
INSERT INTO "list" ("id", "value") VALUES (E'hy', E'armensk');
INSERT INTO "list" ("id", "value") VALUES (E'hy_AM', E'armensk (Armenia)');
INSERT INTO "list" ("id", "value") VALUES (E'az', E'aserbajdsjansk');
INSERT INTO "list" ("id", "value") VALUES (E'az_AZ', E'aserbajdsjansk (Aserbajdsjan)');
INSERT INTO "list" ("id", "value") VALUES (E'az_Cyrl_AZ', E'aserbajdsjansk (kyrillisk, Aserbajdsjan)');
INSERT INTO "list" ("id", "value") VALUES (E'az_Cyrl', E'aserbajdsjansk (kyrillisk)');
INSERT INTO "list" ("id", "value") VALUES (E'az_Latn_AZ', E'aserbajdsjansk (latinsk, Aserbajdsjan)');
INSERT INTO "list" ("id", "value") VALUES (E'az_Latn', E'aserbajdsjansk (latinsk)');
INSERT INTO "list" ("id", "value") VALUES (E'as', E'assamisk');
INSERT INTO "list" ("id", "value") VALUES (E'as_IN', E'assamisk (India)');
INSERT INTO "list" ("id", "value") VALUES (E'bm', E'bambara');
INSERT INTO "list" ("id", "value") VALUES (E'bm_Latn_ML', E'bambara (latinsk, Mali)');
INSERT INTO "list" ("id", "value") VALUES (E'bm_Latn', E'bambara (latinsk)');
INSERT INTO "list" ("id", "value") VALUES (E'eu', E'baskisk');
INSERT INTO "list" ("id", "value") VALUES (E'eu_ES', E'baskisk (Spania)');
INSERT INTO "list" ("id", "value") VALUES (E'bn', E'bengali');
INSERT INTO "list" ("id", "value") VALUES (E'bn_BD', E'bengali (Bangladesh)');
INSERT INTO "list" ("id", "value") VALUES (E'bn_IN', E'bengali (India)');
INSERT INTO "list" ("id", "value") VALUES (E'bs', E'bosnisk');
INSERT INTO "list" ("id", "value") VALUES (E'bs_BA', E'bosnisk (Bosnia-Hercegovina)');
INSERT INTO "list" ("id", "value") VALUES (E'bs_Cyrl_BA', E'bosnisk (kyrillisk, Bosnia-Hercegovina)');
INSERT INTO "list" ("id", "value") VALUES (E'bs_Cyrl', E'bosnisk (kyrillisk)');
INSERT INTO "list" ("id", "value") VALUES (E'bs_Latn_BA', E'bosnisk (latinsk, Bosnia-Hercegovina)');
INSERT INTO "list" ("id", "value") VALUES (E'bs_Latn', E'bosnisk (latinsk)');
INSERT INTO "list" ("id", "value") VALUES (E'br', E'bretonsk');
INSERT INTO "list" ("id", "value") VALUES (E'br_FR', E'bretonsk (Frankrike)');
INSERT INTO "list" ("id", "value") VALUES (E'bg', E'bulgarsk');
INSERT INTO "list" ("id", "value") VALUES (E'bg_BG', E'bulgarsk (Bulgaria)');
INSERT INTO "list" ("id", "value") VALUES (E'my', E'burmesisk');
INSERT INTO "list" ("id", "value") VALUES (E'my_MM', E'burmesisk (Myanmar (Burma))');
INSERT INTO "list" ("id", "value") VALUES (E'da', E'dansk');
INSERT INTO "list" ("id", "value") VALUES (E'da_DK', E'dansk (Danmark)');
INSERT INTO "list" ("id", "value") VALUES (E'da_GL', E'dansk (Grønland)');
INSERT INTO "list" ("id", "value") VALUES (E'dz', E'dzongkha');
INSERT INTO "list" ("id", "value") VALUES (E'dz_BT', E'dzongkha (Bhutan)');
INSERT INTO "list" ("id", "value") VALUES (E'en', E'engelsk');
INSERT INTO "list" ("id", "value") VALUES (E'en_AS', E'engelsk (Amerikansk Samoa)');
INSERT INTO "list" ("id", "value") VALUES (E'en_AI', E'engelsk (Anguilla)');
INSERT INTO "list" ("id", "value") VALUES (E'en_AG', E'engelsk (Antigua og Barbuda)');
INSERT INTO "list" ("id", "value") VALUES (E'en_AU', E'engelsk (Australia)');
INSERT INTO "list" ("id", "value") VALUES (E'en_BS', E'engelsk (Bahamas)');
INSERT INTO "list" ("id", "value") VALUES (E'en_BB', E'engelsk (Barbados)');
INSERT INTO "list" ("id", "value") VALUES (E'en_BE', E'engelsk (Belgia)');
INSERT INTO "list" ("id", "value") VALUES (E'en_BZ', E'engelsk (Belize)');
INSERT INTO "list" ("id", "value") VALUES (E'en_BM', E'engelsk (Bermuda)');
INSERT INTO "list" ("id", "value") VALUES (E'en_BW', E'engelsk (Botswana)');
INSERT INTO "list" ("id", "value") VALUES (E'en_IO', E'engelsk (Britiske territorier i Indiahavet)');
INSERT INTO "list" ("id", "value") VALUES (E'en_CA', E'engelsk (Canada)');
INSERT INTO "list" ("id", "value") VALUES (E'en_KY', E'engelsk (Caymanøyene)');
INSERT INTO "list" ("id", "value") VALUES (E'en_CX', E'engelsk (Christmasøya)');
INSERT INTO "list" ("id", "value") VALUES (E'en_CK', E'engelsk (Cookøyene)');
INSERT INTO "list" ("id", "value") VALUES (E'en_VI', E'engelsk (De amerikanske jomfruøyene)');
INSERT INTO "list" ("id", "value") VALUES (E'en_VG', E'engelsk (De britiske jomfruøyene)');
INSERT INTO "list" ("id", "value") VALUES (E'en_DG', E'engelsk (Diego Garcia)');
INSERT INTO "list" ("id", "value") VALUES (E'en_DM', E'engelsk (Dominica)');
INSERT INTO "list" ("id", "value") VALUES (E'en_ER', E'engelsk (Eritrea)');
INSERT INTO "list" ("id", "value") VALUES (E'en_FK', E'engelsk (Falklandsøyene)');
INSERT INTO "list" ("id", "value") VALUES (E'en_FJ', E'engelsk (Fiji)');
INSERT INTO "list" ("id", "value") VALUES (E'en_PH', E'engelsk (Filippinene)');
INSERT INTO "list" ("id", "value") VALUES (E'en_GM', E'engelsk (Gambia)');
INSERT INTO "list" ("id", "value") VALUES (E'en_GH', E'engelsk (Ghana)');
INSERT INTO "list" ("id", "value") VALUES (E'en_GI', E'engelsk (Gibraltar)');
INSERT INTO "list" ("id", "value") VALUES (E'en_GD', E'engelsk (Grenada)');
INSERT INTO "list" ("id", "value") VALUES (E'en_GU', E'engelsk (Guam)');
INSERT INTO "list" ("id", "value") VALUES (E'en_GG', E'engelsk (Guernsey)');
INSERT INTO "list" ("id", "value") VALUES (E'en_GY', E'engelsk (Guyana)');
INSERT INTO "list" ("id", "value") VALUES (E'en_HK', E'engelsk (Hongkong S.A.R. Kina)');
INSERT INTO "list" ("id", "value") VALUES (E'en_IN', E'engelsk (India)');
INSERT INTO "list" ("id", "value") VALUES (E'en_IE', E'engelsk (Irland)');
INSERT INTO "list" ("id", "value") VALUES (E'en_JM', E'engelsk (Jamaica)');
INSERT INTO "list" ("id", "value") VALUES (E'en_JE', E'engelsk (Jersey)');
INSERT INTO "list" ("id", "value") VALUES (E'en_CM', E'engelsk (Kamerun)');
INSERT INTO "list" ("id", "value") VALUES (E'en_KE', E'engelsk (Kenya)');
INSERT INTO "list" ("id", "value") VALUES (E'en_KI', E'engelsk (Kiribati)');
INSERT INTO "list" ("id", "value") VALUES (E'en_CC', E'engelsk (Kokosøyene)');
INSERT INTO "list" ("id", "value") VALUES (E'en_LS', E'engelsk (Lesotho)');
INSERT INTO "list" ("id", "value") VALUES (E'en_LR', E'engelsk (Liberia)');
INSERT INTO "list" ("id", "value") VALUES (E'en_MO', E'engelsk (Macao S.A.R. Kina)');
INSERT INTO "list" ("id", "value") VALUES (E'en_MG', E'engelsk (Madagaskar)');
INSERT INTO "list" ("id", "value") VALUES (E'en_MW', E'engelsk (Malawi)');
INSERT INTO "list" ("id", "value") VALUES (E'en_MY', E'engelsk (Malaysia)');
INSERT INTO "list" ("id", "value") VALUES (E'en_MT', E'engelsk (Malta)');
INSERT INTO "list" ("id", "value") VALUES (E'en_IM', E'engelsk (Man)');
INSERT INTO "list" ("id", "value") VALUES (E'en_MH', E'engelsk (Marshalløyene)');
INSERT INTO "list" ("id", "value") VALUES (E'en_MU', E'engelsk (Mauritius)');
INSERT INTO "list" ("id", "value") VALUES (E'en_FM', E'engelsk (Mikronesiaføderasjonen)');
INSERT INTO "list" ("id", "value") VALUES (E'en_MS', E'engelsk (Montserrat)');
INSERT INTO "list" ("id", "value") VALUES (E'en_NA', E'engelsk (Namibia)');
INSERT INTO "list" ("id", "value") VALUES (E'en_NR', E'engelsk (Nauru)');
INSERT INTO "list" ("id", "value") VALUES (E'en_NZ', E'engelsk (New Zealand)');
INSERT INTO "list" ("id", "value") VALUES (E'en_NG', E'engelsk (Nigeria)');
INSERT INTO "list" ("id", "value") VALUES (E'en_NU', E'engelsk (Niue)');
INSERT INTO "list" ("id", "value") VALUES (E'en_MP', E'engelsk (Nord-Marianene)');
INSERT INTO "list" ("id", "value") VALUES (E'en_NF', E'engelsk (Norfolkøya)');
INSERT INTO "list" ("id", "value") VALUES (E'en_PK', E'engelsk (Pakistan)');
INSERT INTO "list" ("id", "value") VALUES (E'en_PW', E'engelsk (Palau)');
INSERT INTO "list" ("id", "value") VALUES (E'en_PG', E'engelsk (Papua Ny-Guinea)');
INSERT INTO "list" ("id", "value") VALUES (E'en_PN', E'engelsk (Pitcairn)');
INSERT INTO "list" ("id", "value") VALUES (E'en_PR', E'engelsk (Puerto Rico)');
INSERT INTO "list" ("id", "value") VALUES (E'en_RW', E'engelsk (Rwanda)');
INSERT INTO "list" ("id", "value") VALUES (E'en_SB', E'engelsk (Salomonøyene)');
INSERT INTO "list" ("id", "value") VALUES (E'en_WS', E'engelsk (Samoa)');
INSERT INTO "list" ("id", "value") VALUES (E'en_SC', E'engelsk (Seychellene)');
INSERT INTO "list" ("id", "value") VALUES (E'en_SL', E'engelsk (Sierra Leone)');
INSERT INTO "list" ("id", "value") VALUES (E'en_SG', E'engelsk (Singapore)');
INSERT INTO "list" ("id", "value") VALUES (E'en_SX', E'engelsk (Sint Maarten)');
INSERT INTO "list" ("id", "value") VALUES (E'en_SH', E'engelsk (St. Helena)');
INSERT INTO "list" ("id", "value") VALUES (E'en_KN', E'engelsk (St. Kitts og Nevis)');
INSERT INTO "list" ("id", "value") VALUES (E'en_LC', E'engelsk (St. Lucia)');
INSERT INTO "list" ("id", "value") VALUES (E'en_VC', E'engelsk (St. Vincent og Grenadinene)');
INSERT INTO "list" ("id", "value") VALUES (E'en_GB', E'engelsk (Storbritannia)');
INSERT INTO "list" ("id", "value") VALUES (E'en_SD', E'engelsk (Sudan)');
INSERT INTO "list" ("id", "value") VALUES (E'en_SZ', E'engelsk (Swaziland)');
INSERT INTO "list" ("id", "value") VALUES (E'en_ZA', E'engelsk (Sør-Afrika)');
INSERT INTO "list" ("id", "value") VALUES (E'en_SS', E'engelsk (Sør-Sudan)');
INSERT INTO "list" ("id", "value") VALUES (E'en_TZ', E'engelsk (Tanzania)');
INSERT INTO "list" ("id", "value") VALUES (E'en_TK', E'engelsk (Tokelau)');
INSERT INTO "list" ("id", "value") VALUES (E'en_TO', E'engelsk (Tonga)');
INSERT INTO "list" ("id", "value") VALUES (E'en_TT', E'engelsk (Trinidad og Tobago)');
INSERT INTO "list" ("id", "value") VALUES (E'en_TC', E'engelsk (Turks- og Caicosøyene)');
INSERT INTO "list" ("id", "value") VALUES (E'en_TV', E'engelsk (Tuvalu)');
INSERT INTO "list" ("id", "value") VALUES (E'en_UG', E'engelsk (Uganda)');
INSERT INTO "list" ("id", "value") VALUES (E'en_US', E'engelsk (USA)');
INSERT INTO "list" ("id", "value") VALUES (E'en_UM', E'engelsk (USAs ytre øyer)');
INSERT INTO "list" ("id", "value") VALUES (E'en_VU', E'engelsk (Vanuatu)');
INSERT INTO "list" ("id", "value") VALUES (E'en_ZM', E'engelsk (Zambia)');
INSERT INTO "list" ("id", "value") VALUES (E'en_ZW', E'engelsk (Zimbabwe)');
INSERT INTO "list" ("id", "value") VALUES (E'eo', E'esperanto');
INSERT INTO "list" ("id", "value") VALUES (E'et', E'estisk');
INSERT INTO "list" ("id", "value") VALUES (E'et_EE', E'estisk (Estland)');
INSERT INTO "list" ("id", "value") VALUES (E'ee', E'ewe');
INSERT INTO "list" ("id", "value") VALUES (E'ee_GH', E'ewe (Ghana)');
INSERT INTO "list" ("id", "value") VALUES (E'ee_TG', E'ewe (Togo)');
INSERT INTO "list" ("id", "value") VALUES (E'fi', E'finsk');
INSERT INTO "list" ("id", "value") VALUES (E'fi_FI', E'finsk (Finland)');
INSERT INTO "list" ("id", "value") VALUES (E'fr', E'fransk');
INSERT INTO "list" ("id", "value") VALUES (E'fr_DZ', E'fransk (Algerie)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_BE', E'fransk (Belgia)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_BJ', E'fransk (Benin)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_BF', E'fransk (Burkina Faso)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_BI', E'fransk (Burundi)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_CA', E'fransk (Canada)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_CF', E'fransk (Den sentralafrikanske republikk)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_DJ', E'fransk (Djibouti)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_GQ', E'fransk (Ekvatorial-Guinea)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_CI', E'fransk (Elfenbenskysten)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_FR', E'fransk (Frankrike)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_GF', E'fransk (Fransk Guyana)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_PF', E'fransk (Fransk Polynesia)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_GA', E'fransk (Gabon)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_GP', E'fransk (Guadeloupe)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_GN', E'fransk (Guinea)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_HT', E'fransk (Haiti)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_CM', E'fransk (Kamerun)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_KM', E'fransk (Komorene)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_CG', E'fransk (Kongo-Brazzaville)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_CD', E'fransk (Kongo-Kinshasa)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_LU', E'fransk (Luxemburg)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_MG', E'fransk (Madagaskar)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_ML', E'fransk (Mali)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_MA', E'fransk (Marokko)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_MQ', E'fransk (Martinique)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_MR', E'fransk (Mauritania)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_MU', E'fransk (Mauritius)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_YT', E'fransk (Mayotte)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_MC', E'fransk (Monaco)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_NE', E'fransk (Niger)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_NC', E'fransk (Ny-Caledonia)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_RE', E'fransk (Réunion)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_RW', E'fransk (Rwanda)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_BL', E'fransk (Saint-Barthélemy)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_MF', E'fransk (Saint-Martin)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_SN', E'fransk (Senegal)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_SC', E'fransk (Seychellene)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_PM', E'fransk (St. Pierre og Miquelon)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_CH', E'fransk (Sveits)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_SY', E'fransk (Syria)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_TG', E'fransk (Togo)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_TD', E'fransk (Tsjad)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_TN', E'fransk (Tunisia)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_VU', E'fransk (Vanuatu)');
INSERT INTO "list" ("id", "value") VALUES (E'fr_WF', E'fransk (Wallis og Futuna)');
INSERT INTO "list" ("id", "value") VALUES (E'ff', E'fulani');
INSERT INTO "list" ("id", "value") VALUES (E'ff_GN', E'fulani (Guinea)');
INSERT INTO "list" ("id", "value") VALUES (E'ff_CM', E'fulani (Kamerun)');
INSERT INTO "list" ("id", "value") VALUES (E'ff_MR', E'fulani (Mauritania)');
INSERT INTO "list" ("id", "value") VALUES (E'ff_SN', E'fulani (Senegal)');
INSERT INTO "list" ("id", "value") VALUES (E'fo', E'færøysk');
INSERT INTO "list" ("id", "value") VALUES (E'fo_FO', E'færøysk (Færøyene)');
INSERT INTO "list" ("id", "value") VALUES (E'gl', E'galisisk');
INSERT INTO "list" ("id", "value") VALUES (E'gl_ES', E'galisisk (Spania)');
INSERT INTO "list" ("id", "value") VALUES (E'lg', E'ganda');
INSERT INTO "list" ("id", "value") VALUES (E'lg_UG', E'ganda (Uganda)');
INSERT INTO "list" ("id", "value") VALUES (E'ka', E'georgisk');
INSERT INTO "list" ("id", "value") VALUES (E'ka_GE', E'georgisk (Georgia)');
INSERT INTO "list" ("id", "value") VALUES (E'el', E'gresk');
INSERT INTO "list" ("id", "value") VALUES (E'el_GR', E'gresk (Hellas)');
INSERT INTO "list" ("id", "value") VALUES (E'el_CY', E'gresk (Kypros)');
INSERT INTO "list" ("id", "value") VALUES (E'kl', E'grønlandsk');
INSERT INTO "list" ("id", "value") VALUES (E'kl_GL', E'grønlandsk (Grønland)');
INSERT INTO "list" ("id", "value") VALUES (E'gu', E'gujarati');
INSERT INTO "list" ("id", "value") VALUES (E'gu_IN', E'gujarati (India)');
INSERT INTO "list" ("id", "value") VALUES (E'ha', E'hausa');
INSERT INTO "list" ("id", "value") VALUES (E'ha_GH', E'hausa (Ghana)');
INSERT INTO "list" ("id", "value") VALUES (E'ha_Latn_GH', E'hausa (latinsk, Ghana)');
INSERT INTO "list" ("id", "value") VALUES (E'ha_Latn_NE', E'hausa (latinsk, Niger)');
INSERT INTO "list" ("id", "value") VALUES (E'ha_Latn_NG', E'hausa (latinsk, Nigeria)');
INSERT INTO "list" ("id", "value") VALUES (E'ha_Latn', E'hausa (latinsk)');
INSERT INTO "list" ("id", "value") VALUES (E'ha_NE', E'hausa (Niger)');
INSERT INTO "list" ("id", "value") VALUES (E'ha_NG', E'hausa (Nigeria)');
INSERT INTO "list" ("id", "value") VALUES (E'he', E'hebraisk');
INSERT INTO "list" ("id", "value") VALUES (E'he_IL', E'hebraisk (Israel)');
INSERT INTO "list" ("id", "value") VALUES (E'hi', E'hindi');
INSERT INTO "list" ("id", "value") VALUES (E'hi_IN', E'hindi (India)');
INSERT INTO "list" ("id", "value") VALUES (E'be', E'hviterussisk');
INSERT INTO "list" ("id", "value") VALUES (E'be_BY', E'hviterussisk (Hviterussland)');
INSERT INTO "list" ("id", "value") VALUES (E'ig', E'ibo');
INSERT INTO "list" ("id", "value") VALUES (E'ig_NG', E'ibo (Nigeria)');
INSERT INTO "list" ("id", "value") VALUES (E'id', E'indonesisk');
INSERT INTO "list" ("id", "value") VALUES (E'id_ID', E'indonesisk (Indonesia)');
INSERT INTO "list" ("id", "value") VALUES (E'ga', E'irsk');
INSERT INTO "list" ("id", "value") VALUES (E'ga_IE', E'irsk (Irland)');
INSERT INTO "list" ("id", "value") VALUES (E'is', E'islandsk');
INSERT INTO "list" ("id", "value") VALUES (E'is_IS', E'islandsk (Island)');
INSERT INTO "list" ("id", "value") VALUES (E'it', E'italiensk');
INSERT INTO "list" ("id", "value") VALUES (E'it_IT', E'italiensk (Italia)');
INSERT INTO "list" ("id", "value") VALUES (E'it_SM', E'italiensk (San Marino)');
INSERT INTO "list" ("id", "value") VALUES (E'it_CH', E'italiensk (Sveits)');
INSERT INTO "list" ("id", "value") VALUES (E'ja', E'japansk');
INSERT INTO "list" ("id", "value") VALUES (E'ja_JP', E'japansk (Japan)');
INSERT INTO "list" ("id", "value") VALUES (E'yi', E'jiddisk');
INSERT INTO "list" ("id", "value") VALUES (E'yo', E'joruba');
INSERT INTO "list" ("id", "value") VALUES (E'yo_BJ', E'joruba (Benin)');
INSERT INTO "list" ("id", "value") VALUES (E'yo_NG', E'joruba (Nigeria)');
INSERT INTO "list" ("id", "value") VALUES (E'kn', E'kannada');
INSERT INTO "list" ("id", "value") VALUES (E'kn_IN', E'kannada (India)');
INSERT INTO "list" ("id", "value") VALUES (E'kk', E'kasakhisk');
INSERT INTO "list" ("id", "value") VALUES (E'kk_KZ', E'kasakhisk (Kasakhstan)');
INSERT INTO "list" ("id", "value") VALUES (E'kk_Cyrl_KZ', E'kasakhisk (kyrillisk, Kasakhstan)');
INSERT INTO "list" ("id", "value") VALUES (E'kk_Cyrl', E'kasakhisk (kyrillisk)');
INSERT INTO "list" ("id", "value") VALUES (E'ks', E'kasjmiri');
INSERT INTO "list" ("id", "value") VALUES (E'ks_Arab_IN', E'kasjmiri (arabisk, India)');
INSERT INTO "list" ("id", "value") VALUES (E'ks_Arab', E'kasjmiri (arabisk)');
INSERT INTO "list" ("id", "value") VALUES (E'ks_IN', E'kasjmiri (India)');
INSERT INTO "list" ("id", "value") VALUES (E'ca', E'katalansk');
INSERT INTO "list" ("id", "value") VALUES (E'ca_AD', E'katalansk (Andorra)');
INSERT INTO "list" ("id", "value") VALUES (E'ca_FR', E'katalansk (Frankrike)');
INSERT INTO "list" ("id", "value") VALUES (E'ca_IT', E'katalansk (Italia)');
INSERT INTO "list" ("id", "value") VALUES (E'ca_ES', E'katalansk (Spania)');
INSERT INTO "list" ("id", "value") VALUES (E'km', E'khmer');
INSERT INTO "list" ("id", "value") VALUES (E'km_KH', E'khmer (Kambodsja)');
INSERT INTO "list" ("id", "value") VALUES (E'ki', E'kikuyu');
INSERT INTO "list" ("id", "value") VALUES (E'ki_KE', E'kikuyu (Kenya)');
INSERT INTO "list" ("id", "value") VALUES (E'zh', E'kinesisk');
INSERT INTO "list" ("id", "value") VALUES (E'zh_Hans_HK', E'kinesisk (forenklet, Hongkong S.A.R. Kina)');
INSERT INTO "list" ("id", "value") VALUES (E'zh_Hans_CN', E'kinesisk (forenklet, Kina)');
INSERT INTO "list" ("id", "value") VALUES (E'zh_Hans_MO', E'kinesisk (forenklet, Macao S.A.R. Kina)');
INSERT INTO "list" ("id", "value") VALUES (E'zh_Hans_SG', E'kinesisk (forenklet, Singapore)');
INSERT INTO "list" ("id", "value") VALUES (E'zh_Hans', E'kinesisk (forenklet)');
INSERT INTO "list" ("id", "value") VALUES (E'zh_HK', E'kinesisk (Hongkong S.A.R. Kina)');
INSERT INTO "list" ("id", "value") VALUES (E'zh_CN', E'kinesisk (Kina)');
INSERT INTO "list" ("id", "value") VALUES (E'zh_MO', E'kinesisk (Macao S.A.R. Kina)');
INSERT INTO "list" ("id", "value") VALUES (E'zh_SG', E'kinesisk (Singapore)');
INSERT INTO "list" ("id", "value") VALUES (E'zh_TW', E'kinesisk (Taiwan)');
INSERT INTO "list" ("id", "value") VALUES (E'zh_Hant_HK', E'kinesisk (tradisjonell, Hongkong S.A.R. Kina)');
INSERT INTO "list" ("id", "value") VALUES (E'zh_Hant_MO', E'kinesisk (tradisjonell, Macao S.A.R. Kina)');
INSERT INTO "list" ("id", "value") VALUES (E'zh_Hant_TW', E'kinesisk (tradisjonell, Taiwan)');
INSERT INTO "list" ("id", "value") VALUES (E'zh_Hant', E'kinesisk (tradisjonell)');
INSERT INTO "list" ("id", "value") VALUES (E'rw', E'kinyarwanda');
INSERT INTO "list" ("id", "value") VALUES (E'rw_RW', E'kinyarwanda (Rwanda)');
INSERT INTO "list" ("id", "value") VALUES (E'ky', E'kirgisisk');
INSERT INTO "list" ("id", "value") VALUES (E'ky_KG', E'kirgisisk (Kirgisistan)');
INSERT INTO "list" ("id", "value") VALUES (E'ky_Cyrl_KG', E'kirgisisk (kyrillisk, Kirgisistan)');
INSERT INTO "list" ("id", "value") VALUES (E'ky_Cyrl', E'kirgisisk (kyrillisk)');
INSERT INTO "list" ("id", "value") VALUES (E'ko', E'koreansk');
INSERT INTO "list" ("id", "value") VALUES (E'ko_KP', E'koreansk (Nord-Korea)');
INSERT INTO "list" ("id", "value") VALUES (E'ko_KR', E'koreansk (Sør-Korea)');
INSERT INTO "list" ("id", "value") VALUES (E'kw', E'kornisk');
INSERT INTO "list" ("id", "value") VALUES (E'kw_GB', E'kornisk (Storbritannia)');
INSERT INTO "list" ("id", "value") VALUES (E'hr', E'kroatisk');
INSERT INTO "list" ("id", "value") VALUES (E'hr_BA', E'kroatisk (Bosnia-Hercegovina)');
INSERT INTO "list" ("id", "value") VALUES (E'hr_HR', E'kroatisk (Kroatia)');
INSERT INTO "list" ("id", "value") VALUES (E'lo', E'laotisk');
INSERT INTO "list" ("id", "value") VALUES (E'lo_LA', E'laotisk (Laos)');
INSERT INTO "list" ("id", "value") VALUES (E'lv', E'latvisk');
INSERT INTO "list" ("id", "value") VALUES (E'lv_LV', E'latvisk (Latvia)');
INSERT INTO "list" ("id", "value") VALUES (E'ln', E'lingala');
INSERT INTO "list" ("id", "value") VALUES (E'ln_AO', E'lingala (Angola)');
INSERT INTO "list" ("id", "value") VALUES (E'ln_CF', E'lingala (Den sentralafrikanske republikk)');
INSERT INTO "list" ("id", "value") VALUES (E'ln_CG', E'lingala (Kongo-Brazzaville)');
INSERT INTO "list" ("id", "value") VALUES (E'ln_CD', E'lingala (Kongo-Kinshasa)');
INSERT INTO "list" ("id", "value") VALUES (E'lt', E'litauisk');
INSERT INTO "list" ("id", "value") VALUES (E'lt_LT', E'litauisk (Litauen)');
INSERT INTO "list" ("id", "value") VALUES (E'lu', E'luba-katanga');
INSERT INTO "list" ("id", "value") VALUES (E'lu_CD', E'luba-katanga (Kongo-Kinshasa)');
INSERT INTO "list" ("id", "value") VALUES (E'lb', E'luxemburgsk');
INSERT INTO "list" ("id", "value") VALUES (E'lb_LU', E'luxemburgsk (Luxemburg)');
INSERT INTO "list" ("id", "value") VALUES (E'mg', E'madagassisk');
INSERT INTO "list" ("id", "value") VALUES (E'mg_MG', E'madagassisk (Madagaskar)');
INSERT INTO "list" ("id", "value") VALUES (E'mk', E'makedonsk');
INSERT INTO "list" ("id", "value") VALUES (E'mk_MK', E'makedonsk (Makedonia)');
INSERT INTO "list" ("id", "value") VALUES (E'ml', E'malayalam');
INSERT INTO "list" ("id", "value") VALUES (E'ml_IN', E'malayalam (India)');
INSERT INTO "list" ("id", "value") VALUES (E'ms', E'malayisk');
INSERT INTO "list" ("id", "value") VALUES (E'ms_BN', E'malayisk (Brunei)');
INSERT INTO "list" ("id", "value") VALUES (E'ms_Latn_BN', E'malayisk (latinsk, Brunei)');
INSERT INTO "list" ("id", "value") VALUES (E'ms_Latn_MY', E'malayisk (latinsk, Malaysia)');
INSERT INTO "list" ("id", "value") VALUES (E'ms_Latn_SG', E'malayisk (latinsk, Singapore)');
INSERT INTO "list" ("id", "value") VALUES (E'ms_Latn', E'malayisk (latinsk)');
INSERT INTO "list" ("id", "value") VALUES (E'ms_MY', E'malayisk (Malaysia)');
INSERT INTO "list" ("id", "value") VALUES (E'ms_SG', E'malayisk (Singapore)');
INSERT INTO "list" ("id", "value") VALUES (E'mt', E'maltesisk');
INSERT INTO "list" ("id", "value") VALUES (E'mt_MT', E'maltesisk (Malta)');
INSERT INTO "list" ("id", "value") VALUES (E'gv', E'mansk');
INSERT INTO "list" ("id", "value") VALUES (E'gv_IM', E'mansk (Man)');
INSERT INTO "list" ("id", "value") VALUES (E'mr', E'marathi');
INSERT INTO "list" ("id", "value") VALUES (E'mr_IN', E'marathi (India)');
INSERT INTO "list" ("id", "value") VALUES (E'mn', E'mongolsk');
INSERT INTO "list" ("id", "value") VALUES (E'mn_Cyrl_MN', E'mongolsk (kyrillisk, Mongolia)');
INSERT INTO "list" ("id", "value") VALUES (E'mn_Cyrl', E'mongolsk (kyrillisk)');
INSERT INTO "list" ("id", "value") VALUES (E'mn_MN', E'mongolsk (Mongolia)');
INSERT INTO "list" ("id", "value") VALUES (E'nl', E'nederlandsk');
INSERT INTO "list" ("id", "value") VALUES (E'nl_AW', E'nederlandsk (Aruba)');
INSERT INTO "list" ("id", "value") VALUES (E'nl_BE', E'nederlandsk (Belgia)');
INSERT INTO "list" ("id", "value") VALUES (E'nl_CW', E'nederlandsk (Curaçao)');
INSERT INTO "list" ("id", "value") VALUES (E'nl_BQ', E'nederlandsk (Karibisk Nederland)');
INSERT INTO "list" ("id", "value") VALUES (E'nl_NL', E'nederlandsk (Nederland)');
INSERT INTO "list" ("id", "value") VALUES (E'nl_SX', E'nederlandsk (Sint Maarten)');
INSERT INTO "list" ("id", "value") VALUES (E'nl_SR', E'nederlandsk (Surinam)');
INSERT INTO "list" ("id", "value") VALUES (E'ne', E'nepali');
INSERT INTO "list" ("id", "value") VALUES (E'ne_IN', E'nepali (India)');
INSERT INTO "list" ("id", "value") VALUES (E'ne_NP', E'nepali (Nepal)');
INSERT INTO "list" ("id", "value") VALUES (E'nd', E'nord-ndebele');
INSERT INTO "list" ("id", "value") VALUES (E'nd_ZW', E'nord-ndebele (Zimbabwe)');
INSERT INTO "list" ("id", "value") VALUES (E'se', E'nordsamisk');
INSERT INTO "list" ("id", "value") VALUES (E'se_FI', E'nordsamisk (Finland)');
INSERT INTO "list" ("id", "value") VALUES (E'se_NO', E'nordsamisk (Norge)');
INSERT INTO "list" ("id", "value") VALUES (E'se_SE', E'nordsamisk (Sverige)');
INSERT INTO "list" ("id", "value") VALUES (E'no', E'norsk');
INSERT INTO "list" ("id", "value") VALUES (E'no_NO', E'norsk (Norge)');
INSERT INTO "list" ("id", "value") VALUES (E'nb', E'norsk bokmål');
INSERT INTO "list" ("id", "value") VALUES (E'nb_NO', E'norsk bokmål (Norge)');
INSERT INTO "list" ("id", "value") VALUES (E'nb_SJ', E'norsk bokmål (Svalbard og Jan Mayen)');
INSERT INTO "list" ("id", "value") VALUES (E'nn', E'norsk nynorsk');
INSERT INTO "list" ("id", "value") VALUES (E'nn_NO', E'norsk nynorsk (Norge)');
INSERT INTO "list" ("id", "value") VALUES (E'or', E'oriya');
INSERT INTO "list" ("id", "value") VALUES (E'or_IN', E'oriya (India)');
INSERT INTO "list" ("id", "value") VALUES (E'om', E'oromo');
INSERT INTO "list" ("id", "value") VALUES (E'om_ET', E'oromo (Etiopia)');
INSERT INTO "list" ("id", "value") VALUES (E'om_KE', E'oromo (Kenya)');
INSERT INTO "list" ("id", "value") VALUES (E'os', E'ossetisk');
INSERT INTO "list" ("id", "value") VALUES (E'os_GE', E'ossetisk (Georgia)');
INSERT INTO "list" ("id", "value") VALUES (E'os_RU', E'ossetisk (Russland)');
INSERT INTO "list" ("id", "value") VALUES (E'ps', E'pashto');
INSERT INTO "list" ("id", "value") VALUES (E'ps_AF', E'pashto (Afghanistan)');
INSERT INTO "list" ("id", "value") VALUES (E'fa', E'persisk');
INSERT INTO "list" ("id", "value") VALUES (E'fa_AF', E'persisk (Afghanistan)');
INSERT INTO "list" ("id", "value") VALUES (E'fa_IR', E'persisk (Iran)');
INSERT INTO "list" ("id", "value") VALUES (E'pl', E'polsk');
INSERT INTO "list" ("id", "value") VALUES (E'pl_PL', E'polsk (Polen)');
INSERT INTO "list" ("id", "value") VALUES (E'pt', E'portugisisk');
INSERT INTO "list" ("id", "value") VALUES (E'pt_AO', E'portugisisk (Angola)');
INSERT INTO "list" ("id", "value") VALUES (E'pt_BR', E'portugisisk (Brasil)');
INSERT INTO "list" ("id", "value") VALUES (E'pt_GW', E'portugisisk (Guinea-Bissau)');
INSERT INTO "list" ("id", "value") VALUES (E'pt_CV', E'portugisisk (Kapp Verde)');
INSERT INTO "list" ("id", "value") VALUES (E'pt_MO', E'portugisisk (Macao S.A.R. Kina)');
INSERT INTO "list" ("id", "value") VALUES (E'pt_MZ', E'portugisisk (Mosambik)');
INSERT INTO "list" ("id", "value") VALUES (E'pt_PT', E'portugisisk (Portugal)');
INSERT INTO "list" ("id", "value") VALUES (E'pt_ST', E'portugisisk (São Tomé og Príncipe)');
INSERT INTO "list" ("id", "value") VALUES (E'pt_TL', E'portugisisk (Øst-Timor)');
INSERT INTO "list" ("id", "value") VALUES (E'pa', E'punjabi');
INSERT INTO "list" ("id", "value") VALUES (E'pa_Arab_PK', E'punjabi (arabisk, Pakistan)');
INSERT INTO "list" ("id", "value") VALUES (E'pa_Arab', E'punjabi (arabisk)');
INSERT INTO "list" ("id", "value") VALUES (E'pa_Guru_IN', E'punjabi (gurmukhi, India)');
INSERT INTO "list" ("id", "value") VALUES (E'pa_Guru', E'punjabi (gurmukhi)');
INSERT INTO "list" ("id", "value") VALUES (E'pa_IN', E'punjabi (India)');
INSERT INTO "list" ("id", "value") VALUES (E'pa_PK', E'punjabi (Pakistan)');
INSERT INTO "list" ("id", "value") VALUES (E'qu', E'quechua');
INSERT INTO "list" ("id", "value") VALUES (E'qu_BO', E'quechua (Bolivia)');
INSERT INTO "list" ("id", "value") VALUES (E'qu_EC', E'quechua (Ecuador)');
INSERT INTO "list" ("id", "value") VALUES (E'qu_PE', E'quechua (Peru)');
INSERT INTO "list" ("id", "value") VALUES (E'rm', E'retoromansk');
INSERT INTO "list" ("id", "value") VALUES (E'rm_CH', E'retoromansk (Sveits)');
INSERT INTO "list" ("id", "value") VALUES (E'ro', E'rumensk');
INSERT INTO "list" ("id", "value") VALUES (E'ro_MD', E'rumensk (Moldova)');
INSERT INTO "list" ("id", "value") VALUES (E'ro_RO', E'rumensk (Romania)');
INSERT INTO "list" ("id", "value") VALUES (E'rn', E'rundi');
INSERT INTO "list" ("id", "value") VALUES (E'rn_BI', E'rundi (Burundi)');
INSERT INTO "list" ("id", "value") VALUES (E'ru', E'russisk');
INSERT INTO "list" ("id", "value") VALUES (E'ru_BY', E'russisk (Hviterussland)');
INSERT INTO "list" ("id", "value") VALUES (E'ru_KZ', E'russisk (Kasakhstan)');
INSERT INTO "list" ("id", "value") VALUES (E'ru_KG', E'russisk (Kirgisistan)');
INSERT INTO "list" ("id", "value") VALUES (E'ru_MD', E'russisk (Moldova)');
INSERT INTO "list" ("id", "value") VALUES (E'ru_RU', E'russisk (Russland)');
INSERT INTO "list" ("id", "value") VALUES (E'ru_UA', E'russisk (Ukraina)');
INSERT INTO "list" ("id", "value") VALUES (E'sg', E'sango');
INSERT INTO "list" ("id", "value") VALUES (E'sg_CF', E'sango (Den sentralafrikanske republikk)');
INSERT INTO "list" ("id", "value") VALUES (E'sr', E'serbisk');
INSERT INTO "list" ("id", "value") VALUES (E'sr_BA', E'serbisk (Bosnia-Hercegovina)');
INSERT INTO "list" ("id", "value") VALUES (E'sr_XK', E'serbisk (Kosovo)');
INSERT INTO "list" ("id", "value") VALUES (E'sr_Cyrl_BA', E'serbisk (kyrillisk, Bosnia-Hercegovina)');
INSERT INTO "list" ("id", "value") VALUES (E'sr_Cyrl_XK', E'serbisk (kyrillisk, Kosovo)');
INSERT INTO "list" ("id", "value") VALUES (E'sr_Cyrl_ME', E'serbisk (kyrillisk, Montenegro)');
INSERT INTO "list" ("id", "value") VALUES (E'sr_Cyrl_RS', E'serbisk (kyrillisk, Serbia)');
INSERT INTO "list" ("id", "value") VALUES (E'sr_Cyrl', E'serbisk (kyrillisk)');
INSERT INTO "list" ("id", "value") VALUES (E'sr_Latn_BA', E'serbisk (latinsk, Bosnia-Hercegovina)');
INSERT INTO "list" ("id", "value") VALUES (E'sr_Latn_XK', E'serbisk (latinsk, Kosovo)');
INSERT INTO "list" ("id", "value") VALUES (E'sr_Latn_ME', E'serbisk (latinsk, Montenegro)');
INSERT INTO "list" ("id", "value") VALUES (E'sr_Latn_RS', E'serbisk (latinsk, Serbia)');
INSERT INTO "list" ("id", "value") VALUES (E'sr_Latn', E'serbisk (latinsk)');
INSERT INTO "list" ("id", "value") VALUES (E'sr_ME', E'serbisk (Montenegro)');
INSERT INTO "list" ("id", "value") VALUES (E'sr_RS', E'serbisk (Serbia)');
INSERT INTO "list" ("id", "value") VALUES (E'sh', E'serbokroatisk');
INSERT INTO "list" ("id", "value") VALUES (E'sh_BA', E'serbokroatisk (Bosnia-Hercegovina)');
INSERT INTO "list" ("id", "value") VALUES (E'sn', E'shona');
INSERT INTO "list" ("id", "value") VALUES (E'sn_ZW', E'shona (Zimbabwe)');
INSERT INTO "list" ("id", "value") VALUES (E'ii', E'sichuan-yi');
INSERT INTO "list" ("id", "value") VALUES (E'ii_CN', E'sichuan-yi (Kina)');
INSERT INTO "list" ("id", "value") VALUES (E'si', E'singalesisk');
INSERT INTO "list" ("id", "value") VALUES (E'si_LK', E'singalesisk (Sri Lanka)');
INSERT INTO "list" ("id", "value") VALUES (E'gd', E'skotsk gælisk');
INSERT INTO "list" ("id", "value") VALUES (E'gd_GB', E'skotsk gælisk (Storbritannia)');
INSERT INTO "list" ("id", "value") VALUES (E'sk', E'slovakisk');
INSERT INTO "list" ("id", "value") VALUES (E'sk_SK', E'slovakisk (Slovakia)');
INSERT INTO "list" ("id", "value") VALUES (E'sl', E'slovensk');
INSERT INTO "list" ("id", "value") VALUES (E'sl_SI', E'slovensk (Slovenia)');
INSERT INTO "list" ("id", "value") VALUES (E'so', E'somali');
INSERT INTO "list" ("id", "value") VALUES (E'so_DJ', E'somali (Djibouti)');
INSERT INTO "list" ("id", "value") VALUES (E'so_ET', E'somali (Etiopia)');
INSERT INTO "list" ("id", "value") VALUES (E'so_KE', E'somali (Kenya)');
INSERT INTO "list" ("id", "value") VALUES (E'so_SO', E'somali (Somalia)');
INSERT INTO "list" ("id", "value") VALUES (E'es', E'spansk');
INSERT INTO "list" ("id", "value") VALUES (E'es_AR', E'spansk (Argentina)');
INSERT INTO "list" ("id", "value") VALUES (E'es_BO', E'spansk (Bolivia)');
INSERT INTO "list" ("id", "value") VALUES (E'es_EA', E'spansk (Ceuta og Melilla)');
INSERT INTO "list" ("id", "value") VALUES (E'es_CL', E'spansk (Chile)');
INSERT INTO "list" ("id", "value") VALUES (E'es_CO', E'spansk (Colombia)');
INSERT INTO "list" ("id", "value") VALUES (E'es_CR', E'spansk (Costa Rica)');
INSERT INTO "list" ("id", "value") VALUES (E'es_CU', E'spansk (Cuba)');
INSERT INTO "list" ("id", "value") VALUES (E'es_DO', E'spansk (Den dominikanske republikk)');
INSERT INTO "list" ("id", "value") VALUES (E'es_EC', E'spansk (Ecuador)');
INSERT INTO "list" ("id", "value") VALUES (E'es_GQ', E'spansk (Ekvatorial-Guinea)');
INSERT INTO "list" ("id", "value") VALUES (E'es_SV', E'spansk (El Salvador)');
INSERT INTO "list" ("id", "value") VALUES (E'es_PH', E'spansk (Filippinene)');
INSERT INTO "list" ("id", "value") VALUES (E'es_GT', E'spansk (Guatemala)');
INSERT INTO "list" ("id", "value") VALUES (E'es_HN', E'spansk (Honduras)');
INSERT INTO "list" ("id", "value") VALUES (E'es_IC', E'spansk (Kanariøyene)');
INSERT INTO "list" ("id", "value") VALUES (E'es_MX', E'spansk (Mexico)');
INSERT INTO "list" ("id", "value") VALUES (E'es_NI', E'spansk (Nicaragua)');
INSERT INTO "list" ("id", "value") VALUES (E'es_PA', E'spansk (Panama)');
INSERT INTO "list" ("id", "value") VALUES (E'es_PY', E'spansk (Paraguay)');
INSERT INTO "list" ("id", "value") VALUES (E'es_PE', E'spansk (Peru)');
INSERT INTO "list" ("id", "value") VALUES (E'es_PR', E'spansk (Puerto Rico)');
INSERT INTO "list" ("id", "value") VALUES (E'es_ES', E'spansk (Spania)');
INSERT INTO "list" ("id", "value") VALUES (E'es_UY', E'spansk (Uruguay)');
INSERT INTO "list" ("id", "value") VALUES (E'es_US', E'spansk (USA)');
INSERT INTO "list" ("id", "value") VALUES (E'es_VE', E'spansk (Venezuela)');
INSERT INTO "list" ("id", "value") VALUES (E'sv', E'svensk');
INSERT INTO "list" ("id", "value") VALUES (E'sv_FI', E'svensk (Finland)');
INSERT INTO "list" ("id", "value") VALUES (E'sv_SE', E'svensk (Sverige)');
INSERT INTO "list" ("id", "value") VALUES (E'sv_AX', E'svensk (Åland)');
INSERT INTO "list" ("id", "value") VALUES (E'sw', E'swahili');
INSERT INTO "list" ("id", "value") VALUES (E'sw_KE', E'swahili (Kenya)');
INSERT INTO "list" ("id", "value") VALUES (E'sw_TZ', E'swahili (Tanzania)');
INSERT INTO "list" ("id", "value") VALUES (E'sw_UG', E'swahili (Uganda)');
INSERT INTO "list" ("id", "value") VALUES (E'tl', E'tagalog');
INSERT INTO "list" ("id", "value") VALUES (E'tl_PH', E'tagalog (Filippinene)');
INSERT INTO "list" ("id", "value") VALUES (E'ta', E'tamilsk');
INSERT INTO "list" ("id", "value") VALUES (E'ta_IN', E'tamilsk (India)');
INSERT INTO "list" ("id", "value") VALUES (E'ta_MY', E'tamilsk (Malaysia)');
INSERT INTO "list" ("id", "value") VALUES (E'ta_SG', E'tamilsk (Singapore)');
INSERT INTO "list" ("id", "value") VALUES (E'ta_LK', E'tamilsk (Sri Lanka)');
INSERT INTO "list" ("id", "value") VALUES (E'te', E'telugu');
INSERT INTO "list" ("id", "value") VALUES (E'te_IN', E'telugu (India)');
INSERT INTO "list" ("id", "value") VALUES (E'th', E'thai');
INSERT INTO "list" ("id", "value") VALUES (E'th_TH', E'thai (Thailand)');
INSERT INTO "list" ("id", "value") VALUES (E'bo', E'tibetansk');
INSERT INTO "list" ("id", "value") VALUES (E'bo_IN', E'tibetansk (India)');
INSERT INTO "list" ("id", "value") VALUES (E'bo_CN', E'tibetansk (Kina)');
INSERT INTO "list" ("id", "value") VALUES (E'ti', E'tigrinja');
INSERT INTO "list" ("id", "value") VALUES (E'ti_ER', E'tigrinja (Eritrea)');
INSERT INTO "list" ("id", "value") VALUES (E'ti_ET', E'tigrinja (Etiopia)');
INSERT INTO "list" ("id", "value") VALUES (E'to', E'tongansk');
INSERT INTO "list" ("id", "value") VALUES (E'to_TO', E'tongansk (Tonga)');
INSERT INTO "list" ("id", "value") VALUES (E'cs', E'tsjekkisk');
INSERT INTO "list" ("id", "value") VALUES (E'cs_CZ', E'tsjekkisk (Tsjekkia)');
INSERT INTO "list" ("id", "value") VALUES (E'tr', E'tyrkisk');
INSERT INTO "list" ("id", "value") VALUES (E'tr_CY', E'tyrkisk (Kypros)');
INSERT INTO "list" ("id", "value") VALUES (E'tr_TR', E'tyrkisk (Tyrkia)');
INSERT INTO "list" ("id", "value") VALUES (E'de', E'tysk');
INSERT INTO "list" ("id", "value") VALUES (E'de_BE', E'tysk (Belgia)');
INSERT INTO "list" ("id", "value") VALUES (E'de_LI', E'tysk (Liechtenstein)');
INSERT INTO "list" ("id", "value") VALUES (E'de_LU', E'tysk (Luxemburg)');
INSERT INTO "list" ("id", "value") VALUES (E'de_CH', E'tysk (Sveits)');
INSERT INTO "list" ("id", "value") VALUES (E'de_DE', E'tysk (Tyskland)');
INSERT INTO "list" ("id", "value") VALUES (E'de_AT', E'tysk (Østerrike)');
INSERT INTO "list" ("id", "value") VALUES (E'ug', E'uigurisk');
INSERT INTO "list" ("id", "value") VALUES (E'ug_Arab_CN', E'uigurisk (arabisk, Kina)');
INSERT INTO "list" ("id", "value") VALUES (E'ug_Arab', E'uigurisk (arabisk)');
INSERT INTO "list" ("id", "value") VALUES (E'ug_CN', E'uigurisk (Kina)');
INSERT INTO "list" ("id", "value") VALUES (E'uk', E'ukrainsk');
INSERT INTO "list" ("id", "value") VALUES (E'uk_UA', E'ukrainsk (Ukraina)');
INSERT INTO "list" ("id", "value") VALUES (E'hu', E'ungarsk');
INSERT INTO "list" ("id", "value") VALUES (E'hu_HU', E'ungarsk (Ungarn)');
INSERT INTO "list" ("id", "value") VALUES (E'ur', E'urdu');
INSERT INTO "list" ("id", "value") VALUES (E'ur_IN', E'urdu (India)');
INSERT INTO "list" ("id", "value") VALUES (E'ur_PK', E'urdu (Pakistan)');
INSERT INTO "list" ("id", "value") VALUES (E'uz', E'usbekisk');
INSERT INTO "list" ("id", "value") VALUES (E'uz_AF', E'usbekisk (Afghanistan)');
INSERT INTO "list" ("id", "value") VALUES (E'uz_Arab_AF', E'usbekisk (arabisk, Afghanistan)');
INSERT INTO "list" ("id", "value") VALUES (E'uz_Arab', E'usbekisk (arabisk)');
INSERT INTO "list" ("id", "value") VALUES (E'uz_Cyrl_UZ', E'usbekisk (kyrillisk, Usbekistan)');
INSERT INTO "list" ("id", "value") VALUES (E'uz_Cyrl', E'usbekisk (kyrillisk)');
INSERT INTO "list" ("id", "value") VALUES (E'uz_Latn_UZ', E'usbekisk (latinsk, Usbekistan)');
INSERT INTO "list" ("id", "value") VALUES (E'uz_Latn', E'usbekisk (latinsk)');
INSERT INTO "list" ("id", "value") VALUES (E'uz_UZ', E'usbekisk (Usbekistan)');
INSERT INTO "list" ("id", "value") VALUES (E'fy', E'vestfrisisk');
INSERT INTO "list" ("id", "value") VALUES (E'fy_NL', E'vestfrisisk (Nederland)');
INSERT INTO "list" ("id", "value") VALUES (E'vi', E'vietnamesisk');
INSERT INTO "list" ("id", "value") VALUES (E'vi_VN', E'vietnamesisk (Vietnam)');
INSERT INTO "list" ("id", "value") VALUES (E'cy', E'walisisk');
INSERT INTO "list" ("id", "value") VALUES (E'cy_GB', E'walisisk (Storbritannia)');
INSERT INTO "list" ("id", "value") VALUES (E'zu', E'zulu');
INSERT INTO "list" ("id", "value") VALUES (E'zu_ZA', E'zulu (Sør-Afrika)');


text:
<!DOCTYPE html>

        <meta charset="utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
        <title>Anvil - Make your phone happy!</title>
        <meta name="description" content="">
        <meta name="viewport" content="width=device-width">

        <link rel='stylesheet' href='css/style.css'>

<input class="hamburger-checkbox" type="checkbox" id="menu">

Never

Gonna

Run

Around

And

Desert

You

let

You

Down

Gonna

Give

You

Up

The hamburger menu is on. To turn it off, simply remove or comment it out from style.scss.

Donec ullamcorper nulla non metus auctor fringilla. Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Etiam porta sem malesuada magna mollis euismod. Maecenas sed diam eget risus varius blandit sit amet non magna. Nulla vitae elit libero, a pharetra augue. Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Nullam id dolor id nibh ultricies vehicula ut id elit.

Donec id elit non mi porta gravida at eget metus. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec ullamcorper nulla non metus auctor fringilla. Sed posuere consectetur est at lobortis.

Nulla vitae elit libero, a pharetra augue. Vivamus sagittis lacus vel augue laoreet rutrum faucibus dolor auctor. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vivamus sagittis lacus vel augue laoreet rutrum faucibus dolor auctor.

Donec ullamcorper nulla non metus auctor fringilla. Integer posuere erat a ante venenatis dapibus posuere velit aliquet. Etiam porta sem malesuada magna mollis euismod. Maecenas sed diam eget risus varius blandit sit amet non magna. Nulla vitae elit libero, a pharetra augue. Fusce dapibus, tellus ac cursus commodo, tortor mauris condimentum nibh, ut fermentum massa justo sit amet risus. Nullam id dolor id nibh ultricies vehicula ut id elit.

Donec id elit non mi porta gravida at eget metus. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Donec ullamcorper nulla non metus auctor fringilla. Sed posuere consectetur est at lobortis.

Nulla vitae elit libero, a pharetra augue. Vivamus sagittis lacus vel augue laoreet rutrum faucibus dolor auctor. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vivamus sagittis lacus vel augue laoreet rutrum faucibus dolor auctor.


text:
package com.gooddata.md;

import org.joda.time.DateTime;
import org.joda.time.DateTimeZone;
import org.testng.annotations.Test;

import java.util.Set;

import static com.gooddata.util.ResourceUtils.readObjectFromResource;
import static java.util.Collections.singleton;
import static net.javacrumbs.jsonunit.JsonMatchers.jsonEquals;
import static net.javacrumbs.jsonunit.core.util.ResourceUtils.resource;
import static org.hamcrest.CoreMatchers.is;
import static org.hamcrest.CoreMatchers.notNullValue;
import static org.hamcrest.MatcherAssert.assertThat;
import static org.hamcrest.text.MatchesPattern.matchesPattern;

public class EntryTest {

    public static final String OBJ_ID = "ENTRY_ID";
    public static final String URI = "/gdc/md/PROJECT_ID/obj/" + OBJ_ID;
    public static final String AUTHOR = "/gdc/account/profile/AUTHOR_USER_ID";
    public static final String CONTRIBUTOR = "/gdc/account/profile/CONTRIBUTOR_USER_ID";
    public static final DateTime CREATED = new DateTime(2014, 4, 11, 13, 45, 54, DateTimeZone.UTC);
    public static final String SUMMARY = "Entry summary";
    public static final String TITLE = "Entry title";
    public static final DateTime UPDATED = new DateTime(2014, 4, 11, 13, 45, 55, DateTimeZone.UTC);
    public static final String CATEGORY = "ENTRY_CATEGORY";
    public static final Set<String> TAGS = singleton("TAG");
    public static final boolean DEPRECATED = true;
    public static final String IDENTIFIER = "ID";
    public static final boolean LOCKED = true;
    public static final boolean UNLISTED = false;

    @SuppressWarnings("deprecation")
    @Test
    public void testDeserialize() throws Exception {
        final Entry entry = readObjectFromResource("/md/entry.json", Entry.class);
        assertThat(entry, is(notNullValue()));
        assertThat(entry.getId(), is(OBJ_ID));
        assertThat(entry.getLink(), is(URI));
        assertThat(entry.getUri(), is(URI));
        assertThat(entry.getTitle(), is(TITLE));
        assertThat(entry.getSummary(), is(SUMMARY));
        assertThat(entry.getCategory(), is(CATEGORY));
        assertThat(entry.getAuthor(), is(AUTHOR));
        assertThat(entry.getContributor(), is(CONTRIBUTOR));
        assertThat(entry.isDeprecated(), is(DEPRECATED));
        assertThat(entry.getIdentifier(), is(IDENTIFIER));
        assertThat(entry.getTags(), is(TAGS));
        assertThat(entry.getCreated(), is(CREATED));
        assertThat(entry.getUpdated(), is(UPDATED));
        assertThat(entry.isLocked(), is(LOCKED));
        assertThat(entry.isUnlisted(), is(UNLISTED));
    }

    @Test
    public void testSerialization() throws Exception {
        final Entry entry = new Entry(URI, TITLE, SUMMARY, CATEGORY, AUTHOR, CONTRIBUTOR, DEPRECATED, IDENTIFIER, TAGS,
                CREATED, UPDATED, LOCKED, UNLISTED);

        assertThat(entry, jsonEquals(resource("md/entry.json")));
    }

    @Test
    public void testToStringFormat() {
        final Entry entry = new Entry(URI, TITLE, SUMMARY, CATEGORY, AUTHOR, CONTRIBUTOR, DEPRECATED, IDENTIFIER, TAGS,
                CREATED, UPDATED, LOCKED, UNLISTED);

        assertThat(entry.toString(), matchesPattern(Entry.class.getSimpleName() + "\\[.*\\]"));
    }

}