class CicloProduccion(models.Model):
ciclosDeProduccion = models.IntegerField()
fechaDeCorte = models.DateField()
rendimiento = models.ManyToOneRel(Rendimiento)
cosecha = models.ManyToOneRel(Cosecha)
def getiter(self):
return iter(self.from_db(self))
def __str__(self):
return "num" + self.ciclosDeProduccion.__str__(
) + self.fechaDeCorte.__str__()
def __get_FIELD_display(self, field):
return super()._get_FIELD_display(field)
#
# class Caña(models.Model):
# fotosintesis = models.IntegerField()
# crecimiento = models.IntegerField()
# floracion = models.IntegerField()
# respiracion = models.IntegerField()
# absorcionMineral = models.IntegerField()
# elongacion = models.IntegerField()
# factoresExternos = FactoresExternos
# materialGenetico = MaterialGenetico
# densidadCañera = DensidadCañera
#
#
# #simulacion Cultivo
class Course(models.Model):
courseName = models.CharField(max_length=64)
department = models.CharField(max_length=64)
courseNumber = models.IntegerField()
instructor = models.ForeignKey(Users, on_delete=models.CASCADE)
TAs = models.ManyToOneRel(TA)
labs = models.ManyToOneRel(Lab)
class SimulacionCultivo(models.Model):
nombreSimulacionCultivo = models.CharField(max_length=30)
fechaSiembra = models.DateField()
fc = models.ManyToOneRel(FactorControlable)
ca = models.ManyToOneRel(CondicionAnual)
dc = models.ManyToOneRel(DensidadCañera)
mg = models.ManyToManyRel(MaterialGenetico)
class Oferta(models.Model):
imagen_portada = models.ImageField(
default='img/ofertas/por_defecto/oferta-img.jpg',
upload_to=get_image_path,
null=True,
blank=True)
ofertante = models.ForeignKey(User,
on_delete=models.CASCADE,
related_name='ofertas')
titulo = models.CharField(max_length=150)
descripcion = models.TextField(default="Sin descripción",
null=True,
blank=True)
precio = models.IntegerField(null=True, blank=True)
categorias = models.ManyToManyField(Categoria,
related_name="ofertas",
blank=True)
creado = models.DateTimeField(auto_now_add=True)
actualizado = models.DateTimeField(auto_now=True)
imagenes = models.ManyToOneRel(field='oferta',
to=ImagenOferta,
field_name='oferta')
def __str__(self):
return self.titulo
class FactorControlable(models.Model):
profundidadSiembra = models.IntegerField()
anteriorUsoDelSuelo = models.IntegerField()
aplica = models.ForeignKey(ManejoDelSuelo)
rs14 = models.ManyToOneRel(ManejoDelSuelo)
requiere = models.ManyToOneRel(Suelo)
def getiter(self):
return iter(self.from_db(self))
def __str__(self):
tx = "Prof: " + self.profundidadSiembra.__str__()
return tx + "mm, uso: " + self.anteriorUsoDelSuelo.__str__() + " años"
def __get_FIELD_display(self, field):
return super()._get_FIELD_display(field)
class ArtigoCientifico(models.Model):
titulo = models.CharField(max_length=150)
autores = models.CharField(max_length=250)
evento = models.ManyToOneRel(EventoCientifico,
on_delete=models.CASCADE,
field_name=EventoCientifico,
to=Evento.nome)
class Cosecha(models.Model):
nombreSimulacionCosecha = models.CharField(max_length=30)
edadDeCorta = models.IntegerField()
esCorteManual = models.BooleanField()
esQuemada = models.BooleanField()
simulacionCultivo = models.ManyToOneRel(SimulacionCultivo)
ciclosDeProduccion = models.ForeignKey(CicloProduccion)
class ModelYandexUsers(models.Model):
user_id = models.ForeignKey(User)
users = models.ManyToOneRel('username', User, user_id)
y_login = models.CharField(max_length=255, null=True)
y_password = models.CharField(max_length=255, null=True)
cookies = models.CharField(max_length=255)
count = models.IntegerField()
status = models.IntegerField()
class Video(models.Model):
id = models.AutoField('id', primary_key=True, db_index=True)
nick = models.CharField(max_length=300, verbose_name="Гарчиг")
desc = models.TextField(verbose_name="Тухай")
createdDate = models.DateTimeField(verbose_name="Огноо", auto_now_add=False)
has_game = models.ManyToOneRel(Game, verbose_name="Тоглоом", blank=True)
has_players = models.ManyToManyField(Player, verbose_name="Тоглогч", blank=True)
has_caster = models.ManyToManyField(Player, related_name="caster", verbose_name="Тайлбарлагч", blank=True)
class SimulacionCultivo(models.Model):
nombreSimulacionCultivo = models.CharField(max_length=50)
fechaDeSiembra = models.DateField()
fechaDeSimulacion = models.DateField()
fc = models.ManyToOneRel(FactorControlable)
ca = models.ManyToOneRel(CondicionAnual)
dc = models.ManyToOneRel(DensidadCañera)
mg = models.ManyToOneRel(MaterialGenetico)
pyenp = models.ManyToManyRel(PlagaYEnfermedadDeLaPlanta)
def getiter(self):
return iter(self.from_db(self))
def __str__(self):
return self.nombreSimulacionCultivo
def __get_FIELD_display(self, field):
return super()._get_FIELD_display(field)
def test_many_to_one_relation(self):
field = models.ManyToOneRel(
models.ForeignKey(Project, on_delete=models.CASCADE), Project,
"projects")
field.related_model = (
Project # set this manually because django does not initialize the model
)
input_field = get_input_field(field, _registry)
self.assertTrue(isinstance(input_field, graphene.List))
self.assertEqual(input_field.of_type._meta.name, "ID") # type:ignore
class FunctionRequirement(AbstractBasicModel):
"""A Function Requirement referred to a software project"""
task = models.ManyToOneRel(Task, on_delete=models.CASCADE, field_name="Task")
# full_estimation_time = calculated field with sum of all estimation_time of this Software Version
# full_log_work = calculated field with sum of all log_works of this Software Version
class Meta:
"""Meta data for Function Requirement model"""
verbose_name = 'function requirement'
verbose_name_plural = 'function requirements'
class Privilege(models.Model):
priv_id = models.AutoField(db_column="priv_id", primary_key=True)
priv_name = models.CharField(db_column="priv_name", max_length=100)
role = models.ManyToOneRel(to=Role,
field_name="role_id",
field="role_id",
on_delete=NotImplementedError)
class Meta:
# set table name here
db_table = "privileges"
class CondicionAnual(models.Model):
anomaliasEnLaPlantacion = models.CharField(max_lenght=50)
diasEnEmerger = models.IntegerField()
tieneMalezas = models.BooleanField()
fenomenoClimatico = models.ManyToOneRel(Clima)
def getiter(self):
return iter(self.from_db(self))
def __get_FIELD_display(self, field):
return super()._get_FIELD_display(field)
class EmailAddress(models.Model):
user_id = models.ManyToOneRel(User,
to='user_id',
field_name='id',
on_delete=models.CASCADE)
email = models.EmailField(max_length=100, unique=True, db_index=True)
primary = models.BooleanField(default=False)
class Meta:
verbose_name = "User email adresses"
verbose_name_plural = "User email adresses"
class BookInLibrary(models.Model):
id = models.AutoField(primary_key=True)
book = models.ManyToManyField(Book,
related_name="is_avaiable",
blank=False)
borrowed_by = models.ManyToOneRel(User, blank=True)
# Metadata
date_created = models.DateTimeField(auto_now_add=True)
date_modified = models.DateTimeField(auto_now=True)
class Comment(models.Model):
user = models.CharField(max_length=200)
email = models.EmailField()
body = models.TextField()
# created = models.TimeField(auto_now_add=True)
approved = models.BooleanField(default=False)
post = models.ForeignKey(post, on_delete=models.CASCADE, default=None)
postrelation = models.ManyToOneRel(post,
on_delete=models.CASCADE,
to=post,
field_name="post")
class Task(AbstractBasicModel):
"""A task that a person executes in a software project"""
estimation_time = models.FloatField(
null=False, blank=False, verbose_name='Estimation Time (in hours)')
log_work = models.ManyToOneRel(LogWork,
on_delete=models.CASCADE,
field_name='Log Work')
# total_log_works: calculated field with sum of all log_works of this task
class Meta:
"""Meta data for Task model"""
verbose_name = 'task'
verbose_name_plural = 'tasks'
class NotaAlumno(BaseModel):
alumno_aula = models.ForeignKey(AlumnoAula,
on_delete=models.CASCADE,
related_name="alumno_aula")
componente = models.ForeignKey(Componente, on_delete=models.CASCADE)
titulo = models.CharField(max_length=150)
resultado = models.CharField(max_length=150, null=True, blank=True)
observaciones = models.TextField(null=True, blank=True)
evidencias = models.ManyToOneRel('EvidenciaNotaAlumno',
field_name='evidencias',
to='')
class Meta:
db_table = "NotasAlumno"
class ManejoDelSuelo(models.Model):
muestreo = models.CharField(max_length=10)
recuperacion = models.BooleanField()
espaciamiento = models.IntegerField()
periodoRiego = models.IntegerField()
utiliza = models.ManyToOneRel(Fertilizante)
def getiter(self):
return iter(self.from_db(self))
def __str__(self):
return self.muestreo
def __get_FIELD_display(self, field):
return super()._get_FIELD_display(field)
class SoftwareVersion(AbstractBasicModel):
"""A Software Version referred to a software project"""
function_requirement = models.ManyToOneRel(
FunctionRequirement,
on_delete=models.CASCADE,
field_name='Function Requirement')
# full_estimation_time = calculated field with sum of all estimation_time of this Software Version
# full_log_work = calculated field with sum of all log_works of this Software Version
# full_tasks = calculated field with sum of all tasks of this Software Version
class Meta:
"""Meta data for Software Version model"""
verbose_name = 'software version'
verbose_name_plural = 'software versions'
class Software(AbstractBasicModel):
"""A Software referred to a software project"""
software_version = models.ManyToOneRel(SoftwareVersion,
on_delete=models.CASCADE,
field_name='Software Version')
# full_estimation_time = calculated field with sum of all estimation_time of this Software
# full_log_work = calculated field with sum of all log_works of this Software
# full_task = calculated field with list of all the tasks of this Software
# full_function_requirement = calculated field with list of all the function requirements of this Software
class Meta:
"""Meta data for Software model"""
verbose_name = 'software'
verbose_name_plural = 'software'
class SubCategory(models.Model):
name = models.CharField(max_length=50, unique=True, db_index=True)
slug = models.SlugField(max_length=50, unique=True, db_index=True)
parent_category = models.ManyToOneRel(Category)
class Meta:
ordering = ['name']
verbose_name_plural = "Sub_Categories"
def __str__(self):
return '%s' % self.title
@permalink
def get_absolute_url(self):
return 'view_frik_sub_cat', None, {'slug': self.slug}
class Cosecha(models.Model):
nombreSimulacionCosecha = models.CharField(max_length=50)
edad = models.IntegerField()
esCorteManual = models.BooleanField()
esQuemada = models.BooleanField()
simulacionCultivo = models.ManyToOneRel(SimulacionCultivo)
def getiter(self):
return iter(self.from_db(self))
def __str__(self):
return self.nombreSimulacionCosecha
def __get_FIELD_display(self, field):
return super()._get_FIELD_display(field)
class Evento(models.Model):
nome = models.CharField(max_length=100)
descricao = models.TextField()
sigla = models.CharField(max_length=10)
numero = models.IntegerField(max_length=10)
realizador = models.ManyToOneRel(PessoaFisica,
on_delete=models.CASCADE,
field_name=PessoaFisica,
to=nome)
logo = models.CharField(max_length=10)
data_de_inicio = models.DateField(max_length=10)
data_de_fim = models.DateField(max_length=10)
def __str__(self):
return self.nome
class Suelo(models.Model):
tipoSuelo = models.CharField(max_lenght=30)
esHomogeneo = models.BooleanField()
textura = models.IntegerField()
degradacion = models.IntegerField()
ventilacion = models.IntegerField()
genera = models.ManyToOneRel(Topografia)
def getiter(self):
return iter(self.from_db())
def __str__(self):
return self.tipoSuelo
def __get_FIELD_display(self, field):
return super()._get_FIELD_display(field)
class GoalStatus(models.Model):
status = {
('WT', 'weekly Target'),
('DT', 'daily target'),
('V', 'Verified'),
('D', 'Done'),
}
recent_goal = models.ManyToOneRel('ScrummyGoals',
on_delete=models.CASCADE,
field_name='goals',
to=ScrummyGoals)
# weekly_target = models.OneToOneField('ScrummyGoals', on_delete=models.CASCADE, unique=True)
daily_target = models.OneToOneField('ScrummyGoals',
on_delete=models.CASCADE,
unique=True)
class Meta:
verbose_name_plural = 'GoalStatus'
verify = models.CharField(max_length=200, default="verified")
class Provider(models.Model):
name = models.CharField(max_length=15)
desc = models.CharField(max_length=150)
domains = models.ManyToOneRel("core:Domain",
field_name="domains",
related_name="domains",
to="domains")
cnpj = models.CharField(max_length=11, unique=True)
address = models.CharField(max_length=40)
api_link = models.TextField(null=True)
website_link = models.TextField(null=True)
# managers, one by Provider API
objects = models.Manager()
giant_bomb = GiantBombManager()
def __str__(self):
return self.cnpj
def __repr__(self):
return self.cnpj
class partNumb(models.Model):
PartCode = models.CharField(max_length=100)
Descripcion = models.CharField(max_length=500)
partnumt = models.ManyToOneRel(partNumTipo, on_delete=models.CASCADE)
activo = models.BooleanField(default=True)
class Replay(models.Model):
id = models.AutoField('id', primary_key=True, db_index=True)
createdDate = models.DateTimeField(verbose_name="Огноо", auto_now_add=False)
has_game = models.ManyToOneRel(Game, verbose_name="Тоглоом", blank=True)
has_players = models.ManyToManyField(Player, verbose_name="Тоглогч", blank=True)
