from django.db import models


# Create your models here.




from datetime import datetime

from django_userforeignkey.models.fields import UserForeignKey
from django.contrib.auth import get_user_model  # Para tomar el usuario
from django.utils.translation import gettext_lazy as _  # Traduccion

user = get_user_model()  # Toma el usuario



class Turismo(models.Model):
    index = models.IntegerField(blank=True, null=True)
    fecha = models.TextField(db_column='FECHA', blank=True, null=True)  # Field name made lowercase.
    periodo = models.TextField(db_column='PERIODO', blank=True, null=True)  # Field name made lowercase.
    anyo = models.FloatField(db_column='ANYO', blank=True, null=True)  # Field name made lowercase.
    mes = models.TextField(db_column='MES', blank=True, null=True)  # Field name made lowercase.
    valor = models.FloatField(db_column='VALOR', blank=True, null=True)  # Field name made lowercase.
    valor_12 = models.FloatField(db_column='VALOR_12', blank=True, null=True)  # Field name made lowercase.
    valor_var12 = models.FloatField(db_column='VALOR_VAR12', blank=True, null=True)  # Field name made lowercase.
    cod = models.TextField(db_column='COD', blank=True, null=True)  # Field name made lowercase.
    categoria = models.TextField(db_column='CATEGORIA', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'Turismo'
        #ordering = ["periodo"]



class TurismoCategoria(models.Model):
    index = models.IntegerField(blank=True, null=True)
    cod = models.TextField(db_column='COD', blank=True, null=True)  # Field name made lowercase.
    categoria = models.TextField(db_column='CATEGORIA', blank=True, null=True)  # Field name made lowercase.
    nacional = models.TextField(db_column='NACIONAL', blank=True, null=True)  # Field name made lowercase.
    viajeros = models.TextField(db_column='VIAJEROS', blank=True, null=True)  # Field name made lowercase.
    total = models.TextField(db_column='TOTAL', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'TurismoCategoria'
        #ordering = ["cod"]
       
    # Métodos
    def __str__(self):
        return '{} - {}'.format(self.cod, self.categoria)


class Turismoforecast(models.Model):
    index = models.IntegerField(blank=True, null=True)
    fecha = models.TextField(db_column='FECHA', blank=True, null=True)  # Field name made lowercase. This field type is a guess.
    periodo = models.TextField(db_column='PERIODO', blank=True, null=True)  # Field name made lowercase.
    fcmean = models.FloatField(db_column='FCMEAN', blank=True, null=True)  # Field name made lowercase.
    fcmean_ci_lower = models.FloatField(db_column='FCMEAN_CI_LOWER', blank=True, null=True)  # Field name made lowercase.
    fcmean_ci_upper = models.FloatField(db_column='FCMEAN_CI_UPPER', blank=True, null=True)  # Field name made lowercase.
    vt_12 = models.FloatField(db_column='VT_12', blank=True, null=True)  # Field name made lowercase.
    v_var12 = models.FloatField(db_column='V_VAR12', blank=True, null=True)  # Field name made lowercase.
    cod = models.TextField(db_column='COD', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'TurismoForecast'


class Turismopredict(models.Model):
    index = models.IntegerField(blank=True, null=True)
    fecha = models.TextField(db_column='FECHA', blank=True, null=True)  # Field name made lowercase. This field type is a guess.
    periodo = models.TextField(db_column='PERIODO', blank=True, null=True)  # Field name made lowercase.
    anyo = models.TextField(db_column='ANYO', blank=True, null=True)  # Field name made lowercase.
    mes = models.TextField(db_column='MES', blank=True, null=True)  # Field name made lowercase.
    valor = models.FloatField(db_column='VALOR', blank=True, null=True)  # Field name made lowercase.
    valor_12 = models.FloatField(db_column='VALOR_12', blank=True, null=True)  # Field name made lowercase.
    valor_var12 = models.FloatField(db_column='VALOR_VAR12', blank=True, null=True)  # Field name made lowercase.
    cod = models.TextField(db_column='COD', blank=True, null=True)  # Field name made lowercase.
    categoria = models.TextField(db_column='CATEGORIA', blank=True, null=True)  # Field name made lowercase.
    predict = models.FloatField(db_column='PREDICT', blank=True, null=True)  # Field name made lowercase.
    r2 = models.FloatField(db_column='R2', blank=True, null=True)  # Field name made lowercase.
    tendencia = models.FloatField(db_column='TENDENCIA', blank=True, null=True)  # Field name made lowercase.
    recesion = models.FloatField(db_column='RECESION', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'TurismoPredict'


class Taereoanual(models.Model):
    index = models.IntegerField(blank=True, null=True)
    anyo = models.IntegerField(db_column='ANYO', blank=True, null=True)  # Field name made lowercase.
    tipo = models.TextField(db_column='TIPO', blank=True, null=True)  # Field name made lowercase.
    valor = models.FloatField(db_column='VALOR', blank=True, null=True)  # Field name made lowercase.
    clase = models.TextField(db_column='CLASE', blank=True, null=True)  # Field name made lowercase.
    categoria = models.TextField(db_column='CATEGORIA', blank=True, null=True)  # Field name made lowercase.
    periodo = models.TextField(db_column='PERIODO', blank=True, null=True)  # Field name made lowercase.
    cod = models.IntegerField(db_column='COD', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'TaereoAnual'


class Taereocategorias(models.Model):
    index = models.IntegerField(blank=True, null=True)
    cod = models.IntegerField(db_column='COD', blank=True, null=True)  # Field name made lowercase.
    categoria = models.TextField(db_column='CATEGORIA', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'TaereoCategorias'
    
    # Métodos
    def __str__(self):
        return '{} - {}'.format(self.cod, self.categoria)


class Taereoforecast(models.Model):
    index = models.IntegerField(blank=True, null=True)
    fecha = models.TextField(db_column='FECHA', blank=True, null=True)  # Field name made lowercase. This field type is a guess.
    periodo = models.TextField(db_column='PERIODO', blank=True, null=True)  # Field name made lowercase.
    fcmean = models.FloatField(db_column='FCMEAN', blank=True, null=True)  # Field name made lowercase.
    fcmean_ci_lower = models.FloatField(db_column='FCMEAN_CI_LOWER', blank=True, null=True)  # Field name made lowercase.
    fcmean_ci_upper = models.FloatField(db_column='FCMEAN_CI_UPPER', blank=True, null=True)  # Field name made lowercase.
    vt_12 = models.FloatField(db_column='VT_12', blank=True, null=True)  # Field name made lowercase.
    v_var12 = models.FloatField(db_column='V_VAR12', blank=True, null=True)  # Field name made lowercase.
    categoria = models.TextField(db_column='CATEGORIA', blank=True, null=True)  # Field name made lowercase.
    cod = models.IntegerField(db_column='COD', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'TaereoForecast'


class Taereopredict(models.Model):
    index = models.IntegerField(blank=True, null=True)
    fecha = models.TextField(db_column='FECHA', blank=True, null=True)  # Field name made lowercase. This field type is a guess.
    tipo = models.TextField(db_column='TIPO', blank=True, null=True)  # Field name made lowercase.
    periodo = models.TextField(db_column='PERIODO', blank=True, null=True)  # Field name made lowercase.
    anyo = models.TextField(db_column='ANYO', blank=True, null=True)  # Field name made lowercase.
    mes = models.TextField(db_column='MES', blank=True, null=True)  # Field name made lowercase.
    valor = models.FloatField(db_column='VALOR', blank=True, null=True)  # Field name made lowercase.
    clase = models.TextField(db_column='CLASE', blank=True, null=True)  # Field name made lowercase.
    categoria = models.TextField(db_column='CATEGORIA', blank=True, null=True)  # Field name made lowercase.
    cod = models.IntegerField(db_column='COD', blank=True, null=True)  # Field name made lowercase.
    vt_12 = models.FloatField(db_column='VT_12', blank=True, null=True)  # Field name made lowercase.
    v_var12 = models.FloatField(db_column='V_VAR12', blank=True, null=True)  # Field name made lowercase.
    predict = models.FloatField(db_column='PREDICT', blank=True, null=True)  # Field name made lowercase.
    r2 = models.FloatField(db_column='R2', blank=True, null=True)  # Field name made lowercase.
    tendencia = models.FloatField(db_column='TENDENCIA', blank=True, null=True)  # Field name made lowercase.
    recesion = models.FloatField(db_column='RECESION', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'TaereoPredict'



class Sscategorias(models.Model):
    index = models.IntegerField(blank=True, null=True)
    cod = models.IntegerField(db_column='COD', blank=True, null=True)  # Field name made lowercase.
    categoria = models.TextField(db_column='CATEGORIA', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'SSCategorias'


class Ssforecast(models.Model):
    index = models.IntegerField(blank=True, null=True)
    fecha = models.TextField(db_column='FECHA', blank=True, null=True)  # Field name made lowercase. This field type is a guess.
    periodo = models.TextField(db_column='PERIODO', blank=True, null=True)  # Field name made lowercase.
    fcmean = models.FloatField(db_column='FCMEAN', blank=True, null=True)  # Field name made lowercase.
    fcmean_ci_lower = models.FloatField(db_column='FCMEAN_CI_LOWER', blank=True, null=True)  # Field name made lowercase.
    fcmean_ci_upper = models.FloatField(db_column='FCMEAN_CI_UPPER', blank=True, null=True)  # Field name made lowercase.
    vt_4 = models.FloatField(db_column='VT_4', blank=True, null=True)  # Field name made lowercase.
    v_var4 = models.FloatField(db_column='V_VAR4', blank=True, null=True)  # Field name made lowercase.
    categoria = models.TextField(db_column='CATEGORIA', blank=True, null=True)  # Field name made lowercase.
    cod = models.IntegerField(db_column='COD', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'SSForecast'


class Sspredict(models.Model):
    index = models.IntegerField(blank=True, null=True)
    fecha = models.TextField(db_column='FECHA', blank=True, null=True)  # Field name made lowercase. This field type is a guess.
    periodo = models.TextField(db_column='PERIODO', blank=True, null=True)  # Field name made lowercase.
    tipo = models.TextField(db_column='TIPO', blank=True, null=True)  # Field name made lowercase.
    grupo = models.TextField(db_column='GRUPO', blank=True, null=True)  # Field name made lowercase.
    valor = models.FloatField(db_column='VALOR', blank=True, null=True)  # Field name made lowercase.
    clase = models.TextField(db_column='CLASE', blank=True, null=True)  # Field name made lowercase.
    categoria = models.TextField(db_column='CATEGORIA', blank=True, null=True)  # Field name made lowercase.
    cod = models.IntegerField(db_column='COD', blank=True, null=True)  # Field name made lowercase.
    vt_4 = models.FloatField(db_column='VT_4', blank=True, null=True)  # Field name made lowercase.
    v_var4 = models.FloatField(db_column='V_VAR4', blank=True, null=True)  # Field name made lowercase.
    predict = models.FloatField(db_column='PREDICT', blank=True, null=True)  # Field name made lowercase.
    r2 = models.FloatField(db_column='R2', blank=True, null=True)  # Field name made lowercase.
    tendencia = models.FloatField(db_column='TENDENCIA', blank=True, null=True)  # Field name made lowercase.
    recesion = models.FloatField(db_column='RECESION', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'SSPredict'