


"""simple docstring"""







import contextlib
import os
import sqlitea

import pytest

from datasets import Dataset, Features, Value
from datasets.io.sql import SqlDatasetReader, SqlDatasetWriter

from ..utils import assert_arrow_memory_doesnt_increase, assert_arrow_memory_increases, require_sqlalchemy
def 					a__			(				SCREAMING_SNAKE_CASE    :    int				,      SCREAMING_SNAKE_CASE    :    Dict				):


  '''simple docstring'''







  assert isinstance(SCREAMING_SNAKE_CASE				,      SCREAMING_SNAKE_CASE				)
  assert dataset.num_rows == 4
  assert dataset.num_columns == 3
  assert dataset.column_names == ["col_1", "col_2", "col_3"]
  for feature, expected_dtype in expected_features.items():
    assert dataset.features[feature].dtype == expected_dtype
@require_sqlalchemy
@pytest.mark.parametrize("keep_in_memory"				,      [False, True]				)
def 					a__			(				SCREAMING_SNAKE_CASE    :    Tuple				,      SCREAMING_SNAKE_CASE    :    str				,      SCREAMING_SNAKE_CASE    :    Union[str, Any]				,      SCREAMING_SNAKE_CASE    :    List[Any]				):


  '''simple docstring'''







  lowerCAmelCase     :     Optional[Any]								=							tmp_path / "cache"
  lowerCAmelCase     :     List[Any]								=							{"col_1": "string", "col_2": "int64", "col_3": "float64"}
  with assert_arrow_memory_increases() if keep_in_memory else assert_arrow_memory_doesnt_increase():
    lowerCAmelCase     :     List[str]								=							SqlDatasetReader(
        "dataset"				,      "sqlite:///" + sqlite_path				,      cache_dir=SCREAMING_SNAKE_CASE				,      keep_in_memory=SCREAMING_SNAKE_CASE				).read()
  _check_sql_dataset(SCREAMING_SNAKE_CASE				,      SCREAMING_SNAKE_CASE				)
@require_sqlalchemy
@pytest.mark.parametrize(
    "features"				,      [
        None,
        {"col_1": "string", "col_2": "int64", "col_3": "float64"},
        {"col_1": "string", "col_2": "string", "col_3": "string"},
        {"col_1": "int32", "col_2": "int32", "col_3": "int32"},
        {"col_1": "float32", "col_2": "float32", "col_3": "float32"},
    ]				,      )
def 					a__			(				SCREAMING_SNAKE_CASE    :    List[Any]				,      SCREAMING_SNAKE_CASE    :    Any				,      SCREAMING_SNAKE_CASE    :    Any				,      SCREAMING_SNAKE_CASE    :    int				):


  '''simple docstring'''







  lowerCAmelCase     :     Optional[Any]								=							tmp_path / "cache"
  lowerCAmelCase     :     Dict								=							{"col_1": "string", "col_2": "int64", "col_3": "float64"}
  lowerCAmelCase     :     Optional[Any]								=							features.copy() if features else default_expected_features
  lowerCAmelCase     :     Tuple								=							(
      Features({feature: Value(SCREAMING_SNAKE_CASE				) for feature, dtype in features.items()}				) if features is not None else None
  )
  lowerCAmelCase     :     List[Any]								=							SqlDatasetReader("dataset"				,      "sqlite:///" + sqlite_path				,      features=SCREAMING_SNAKE_CASE				,      cache_dir=SCREAMING_SNAKE_CASE				).read()
  _check_sql_dataset(SCREAMING_SNAKE_CASE				,      SCREAMING_SNAKE_CASE				)
def 					a__			(				SCREAMING_SNAKE_CASE    :    Optional[Any]				):


  '''simple docstring'''







  with contextlib.closing(sqlitea.connect(SCREAMING_SNAKE_CASE				)				) as con:
    lowerCAmelCase     :     int								=							con.cursor()
    cur.execute("SELECT * FROM dataset"				)
    for row in cur:
      yield row
@require_sqlalchemy
def 					a__			(				SCREAMING_SNAKE_CASE    :    Any				,      SCREAMING_SNAKE_CASE    :    Optional[int]				,      SCREAMING_SNAKE_CASE    :    List[Any]				):


  '''simple docstring'''







  lowerCAmelCase     :     Optional[int]								=							tmp_path / "cache"
  lowerCAmelCase     :     Union[str, Any]								=							os.path.join(SCREAMING_SNAKE_CASE				,      "tmp.sql"				)
  lowerCAmelCase     :     Optional[Any]								=							SqlDatasetReader("dataset"				,      "sqlite:///" + sqlite_path				,      cache_dir=SCREAMING_SNAKE_CASE				).read()
  SqlDatasetWriter(SCREAMING_SNAKE_CASE				,      "dataset"				,      "sqlite:///" + output_sqlite_path				,      num_proc=1				).write()

  lowerCAmelCase     :     List[Any]								=							iter_sql_file(SCREAMING_SNAKE_CASE				)
  lowerCAmelCase     :     Tuple								=							iter_sql_file(SCREAMING_SNAKE_CASE				)

  for rowa, rowa in zip(SCREAMING_SNAKE_CASE				,      SCREAMING_SNAKE_CASE				):
    assert rowa == rowa
@require_sqlalchemy
def 					a__			(				SCREAMING_SNAKE_CASE    :    Tuple				,      SCREAMING_SNAKE_CASE    :    Optional[int]				,      SCREAMING_SNAKE_CASE    :    List[str]				):


  '''simple docstring'''







  lowerCAmelCase     :     Any								=							tmp_path / "cache"
  lowerCAmelCase     :     Optional[Any]								=							os.path.join(SCREAMING_SNAKE_CASE				,      "tmp.sql"				)
  lowerCAmelCase     :     List[Any]								=							SqlDatasetReader("dataset"				,      "sqlite:///" + sqlite_path				,      cache_dir=SCREAMING_SNAKE_CASE				).read()
  SqlDatasetWriter(SCREAMING_SNAKE_CASE				,      "dataset"				,      "sqlite:///" + output_sqlite_path				,      num_proc=2				).write()

  lowerCAmelCase     :     Any								=							iter_sql_file(SCREAMING_SNAKE_CASE				)
  lowerCAmelCase     :     List[Any]								=							iter_sql_file(SCREAMING_SNAKE_CASE				)

  for rowa, rowa in zip(SCREAMING_SNAKE_CASE				,      SCREAMING_SNAKE_CASE				):
    assert rowa == rowa





@require_sqlalchemy
def 					a__			(				SCREAMING_SNAKE_CASE    :    str				,      SCREAMING_SNAKE_CASE    :    Any				,      SCREAMING_SNAKE_CASE    :    Dict				):


  '''simple docstring'''







  lowerCAmelCase     :     str								=							tmp_path / "cache"
  lowerCAmelCase     :     List[Any]								=							os.path.join(SCREAMING_SNAKE_CASE				,      "tmp.sql"				)
  lowerCAmelCase     :     Any								=							SqlDatasetReader("dataset"				,      "sqlite:///" + sqlite_path				,      cache_dir=SCREAMING_SNAKE_CASE				).read()
  with pytest.raises(SCREAMING_SNAKE_CASE				):
    SqlDatasetWriter(SCREAMING_SNAKE_CASE				,      "dataset"				,      "sqlite:///" + output_sqlite_path				,      num_proc=0				).write()









"""simple docstring"""







from typing import Any, Dict, List, Optional, Tuple, Union

import torch
from torch import nn
from torch.utils.data import DistributedSampler, RandomSampler

from transformers import PreTrainedModel, Trainer, logging
from transformers.integrations import is_fairscale_available
from transformers.models.fsmt.configuration_fsmt import FSMTConfig
from transformers.optimization import (
    Adafactor,
    AdamW,
    get_constant_schedule,
    get_constant_schedule_with_warmup,
    get_cosine_schedule_with_warmup,
    get_cosine_with_hard_restarts_schedule_with_warmup,
    get_linear_schedule_with_warmup,
    get_polynomial_decay_schedule_with_warmup,
)
from transformers.trainer_pt_utils import get_tpu_sampler
from transformers.training_args import ParallelMode
from transformers.utils import is_torch_tpu_available


if is_fairscale_available():
     from fairscale.optim import OSS


lowerCAmelCase__      				=   logging.get_logger(__name__)

lowerCAmelCase__      				=   {
    '''linear''': get_linear_schedule_with_warmup,
    '''cosine''': get_cosine_schedule_with_warmup,
    '''cosine_w_restarts''': get_cosine_with_hard_restarts_schedule_with_warmup,
    '''polynomial''': get_polynomial_decay_schedule_with_warmup,
    '''constant''': get_constant_schedule,
    '''constant_w_warmup''': get_constant_schedule_with_warmup,
}


class       SCREAMING_SNAKE_CASE__				(		lowercase				):
       """simple docstring"""


       def __init__(						self		,     snake_case__=None		,     snake_case__=None		,     *snake_case__		,     **snake_case__						):






         """simple docstring"""





         super().__init__(*snake_case__		,     **snake_case__						)

         if config is None:
           assert isinstance(self.model		,     snake_case__						), (
               "If no `config` is passed the model to be trained has to be of type `PreTrainedModel`, but is"
               f""" {self.model.__class__}"""
           )
           lowerCAmelCase     :     Optional[int]								=							self.model.config
         else:
           lowerCAmelCase     :     List[str]								=							config

         lowerCAmelCase     :     Any								=							data_args
         lowerCAmelCase     :     Tuple								=							self.config.tgt_vocab_size if isinstance(self.config		,     snake_case__						) else self.config.vocab_size

         if self.args.label_smoothing != 0 or (self.data_args is not None and self.data_args.ignore_pad_token_for_loss):
           assert self.config.pad_token_id is not None, (
               "Make sure that `config.pad_token_id` is correcly defined when ignoring `pad_token` for loss"
               " calculation or doing label smoothing."
           )

         if self.config.pad_token_id is None and self.config.eos_token_id is not None:
           logger.warning(
               f"""The `config.pad_token_id` is `None`. Using `config.eos_token_id` = {self.config.eos_token_id} for"""
               " padding.."						)

         if self.args.label_smoothing == 0:
           lowerCAmelCase     :     int								=							torch.nn.CrossEntropyLoss(ignore_index=self.config.pad_token_id						)
         else:
           # dynamically import label_smoothed_nll_loss
           from utils import label_smoothed_nll_loss

           lowerCAmelCase     :     Tuple								=							label_smoothed_nll_loss

       def        lowercase__							(						self		,     snake_case__						):






         """simple docstring"""





         if self.optimizer is None:
           lowerCAmelCase     :     Optional[int]								=							["bias", "LayerNorm.weight"]
           lowerCAmelCase     :     str								=							[
               {
                   "params": [p for n, p in self.model.named_parameters() if not any(nd in n for nd in no_decay						)],
                   "weight_decay": self.args.weight_decay,
               },
               {
                   "params": [p for n, p in self.model.named_parameters() if any(nd in n for nd in no_decay						)],
                   "weight_decay": 0.0,
               },
           ]
           lowerCAmelCase     :     Union[str, Any]								=							Adafactor if self.args.adafactor else AdamW
           if self.args.adafactor:
             lowerCAmelCase     :     Dict								=							Adafactor
             lowerCAmelCase     :     Optional[int]								=							{"scale_parameter": False, "relative_step": False}
           else:
             lowerCAmelCase     :     int								=							AdamW
             lowerCAmelCase     :     int								=							{
                 "betas": (self.args.adam_betaa, self.args.adam_betaa),
                 "eps": self.args.adam_epsilon,
             }
           lowerCAmelCase     :     Any								=							self.args.learning_rate
           if self.sharded_ddp:
             lowerCAmelCase     :     int								=							OSS(
                 params=snake_case__		,     optim=snake_case__		,     **snake_case__		,     )
           else:
             lowerCAmelCase     :     Any								=							optimizer_cls(snake_case__		,     **snake_case__						)

         if self.lr_scheduler is None:
           lowerCAmelCase     :     Tuple								=							self._get_lr_scheduler(snake_case__						)
         else:  # ignoring --lr_scheduler
           logger.warning("scheduler is passed to `Seq2SeqTrainer`, `--lr_scheduler` arg is ignored."						)

       def        lowercase__							(						self		,     snake_case__						):






         """simple docstring"""





         lowerCAmelCase     :     Optional[int]								=							arg_to_scheduler[self.args.lr_scheduler]
         if self.args.lr_scheduler == "constant":
           lowerCAmelCase     :     Tuple								=							schedule_func(self.optimizer						)
         elif self.args.lr_scheduler == "constant_w_warmup":
           lowerCAmelCase     :     Any								=							schedule_func(self.optimizer		,     num_warmup_steps=self.args.warmup_steps						)
         else:
           lowerCAmelCase     :     str								=							schedule_func(
               self.optimizer		,     num_warmup_steps=self.args.warmup_steps		,     num_training_steps=snake_case__						)
         return scheduler

       def        lowercase__							(						self						):






         """simple docstring"""





         if isinstance(self.train_dataset		,     torch.utils.data.IterableDataset						):
           return None
         elif is_torch_tpu_available():
           return get_tpu_sampler(self.train_dataset						)
         else:
           if self.args.sortish_sampler:
             self.train_dataset.make_sortish_sampler(
                 self.args.per_device_train_batch_size		,     distributed=(self.args.parallel_mode == ParallelMode.DISTRIBUTED)		,     )

           return (
               RandomSampler(self.train_dataset						)
               if self.args.local_rank == -1
               else DistributedSampler(self.train_dataset						)
           )

       def        lowercase__							(						self		,     snake_case__		,     snake_case__		,     snake_case__						):






         """simple docstring"""





         if self.args.label_smoothing == 0:
           if self.data_args is not None and self.data_args.ignore_pad_token_for_loss:
             # force training to ignore pad token
             lowerCAmelCase     :     Dict								=							model(**snake_case__		,     use_cache=snake_case__						)[0]
             lowerCAmelCase     :     List[Any]								=							self.loss_fn(logits.view(-1		,     logits.shape[-1]						)		,     labels.view(-1						)						)
           else:
             # compute usual loss via models
             lowerCAmelCase						,  lowerCAmelCase     :     str								=							model(**snake_case__		,     labels=snake_case__		,     use_cache=snake_case__						)[:2]
         else:
           # compute label smoothed loss
           lowerCAmelCase     :     int								=							model(**snake_case__		,     use_cache=snake_case__						)[0]
           lowerCAmelCase     :     List[Any]								=							torch.nn.functional.log_softmax(snake_case__		,     dim=-1						)
           lowerCAmelCase						,  lowerCAmelCase     :     str								=							self.loss_fn(snake_case__		,     snake_case__		,     self.args.label_smoothing		,     ignore_index=self.config.pad_token_id						)
         return loss, logits

       def        lowercase__							(						self		,     snake_case__		,     snake_case__						):






         """simple docstring"""





         lowerCAmelCase     :     Tuple								=							inputs.pop("labels"						)
         lowerCAmelCase						,  lowerCAmelCase     :     str								=							self._compute_loss(snake_case__		,     snake_case__		,     snake_case__						)
         return loss

       def        lowercase__							(						self		,     snake_case__		,     snake_case__		,     snake_case__		,     snake_case__ = None		,     ):






         """simple docstring"""





         lowerCAmelCase     :     List[str]								=							self._prepare_inputs(snake_case__						)

         lowerCAmelCase     :     Union[str, Any]								=							{
             "max_length": self.data_args.val_max_target_length
             if self.data_args is not None
             else self.config.max_length,
             "num_beams": self.data_args.eval_beams if self.data_args is not None else self.config.num_beams,
         }

         if self.args.predict_with_generate and not self.args.prediction_loss_only:
           lowerCAmelCase     :     Dict								=							self.model.generate(
               inputs["input_ids"]		,     attention_mask=inputs["attention_mask"]		,     **snake_case__		,     )
           # in case the batch is shorter than max length, the output should be padded
           if generated_tokens.shape[-1] < gen_kwargs["max_length"]:
             lowerCAmelCase     :     Dict								=							self._pad_tensors_to_max_len(snake_case__		,     gen_kwargs["max_length"]						)

         lowerCAmelCase     :     Optional[Any]								=							inputs.pop("labels"						)
         with torch.no_grad():
           # compute loss on predict data
           lowerCAmelCase						,  lowerCAmelCase     :     Dict								=							self._compute_loss(snake_case__		,     snake_case__		,     snake_case__						)

         lowerCAmelCase     :     List[str]								=							loss.mean().detach()
         if self.args.prediction_loss_only:
           return (loss, None, None)

         lowerCAmelCase     :     int								=							generated_tokens if self.args.predict_with_generate else logits

         if labels.shape[-1] < gen_kwargs["max_length"]:
           lowerCAmelCase     :     Optional[int]								=							self._pad_tensors_to_max_len(snake_case__		,     gen_kwargs["max_length"]						)

         return (loss, logits, labels)







       def        lowercase__							(						self		,     snake_case__		,     snake_case__						):






         """simple docstring"""





         lowerCAmelCase     :     List[Any]								=							self.config.pad_token_id if self.config.pad_token_id is not None else self.config.eos_token_id

         if pad_token_id is None:
           raise ValueError(
               "Make sure that either `config.pad_token_id` or `config.eos_token_id` is defined if tensor has to be"
               f""" padded to `max_length`={max_length}"""						)

         lowerCAmelCase     :     Optional[Any]								=							pad_token_id * torch.ones(
             (tensor.shape[0], max_length)		,     dtype=tensor.dtype		,     device=tensor.device						)
         lowerCAmelCase     :     int								=							tensor
         return padded_tensor





