Skip to content

Instantly share code, notes, and snippets.

@devMlGUE
Created March 2, 2017 23:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save devMlGUE/385f1248aaa94b9fb7a1ebffe509b7cb to your computer and use it in GitHub Desktop.
Save devMlGUE/385f1248aaa94b9fb7a1ebffe509b7cb to your computer and use it in GitHub Desktop.
Ejemplo de consultas (Queryset) en Django 2017
from django.db import models
# para todos los ejemplos de este gist, vamos a utilizar el modelo "Human"
class Human(models.Model):
'''Modelo de ejemplo que representa
un humano y sus atributos.
'''
first_name = models.CharField(max_length=30)
last_name = models.CharField(max_length=30)
birth_date = models.DateField()
Mother = models.ForeignKey('self', symmetrical=False)
def __str__(self):
return '{} {}: [{}]'.format( self.first_name,
self.last_name,
self.birth_date
)
''' vvv - CONSULTAS DE EJEMPLO - vvv '''
# Consultar todos los objetos de un modelo
h = Human.objects.all
# Consultar un objeto de un modelo por ID (en este caso ID 1)
h = Human.objects.get(pk = 1)
h = Human.objects.get(id = 1)
# consultar todos los objetos que superen una fecha
# en este caso que hayan nacido despues del 01/01/2000
start_date = datetime.date(2000, 1, 1)
end_date = datetime.date.today()
h = Human.objects.filter(birth_date__range=(start_date, end_date))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment