Databases
StackOverflow2013
Postsdbo
POIn django, how to write a query that selects all possible combinations of four integers?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POIn django, how to write a query that selects all possible combinations of four integers?
    text
    copied!<p>I'm writing a Game Website, where the draw is a series of four digits. e.g 1234</p> <p>I"m trying to write a query in django that will select all winners based on the four digits entered. winners are any combination of the same numbers or the same combination, 1 2 3 4, 2 3 1 4, 4 1 3 2 are all winners.</p> <p>how is the most efficient way to write this query.</p> <p>--------------------- Edit, sorry for not providing model samples here there are below: -----------</p> <pre><code>class Draw(models.Model): digit1 = models.PositiveSmallIntegerField(null=True,blank=True) digit2 = models.PositiveSmallIntegerField(null=True,blank=True) digit3 = models.PositiveSmallIntegerField(null=True,blank=True) digit4 = models.PositiveSmallIntegerField(null=True,blank=True) draw_date = models.DateTimeField() closed = models.BooleanField() winner = models.BooleanField() def __unicode__(self): return "Draw For Week Ending %s" %(self.draw_date) def get_absolute_url(self): return "/draw/%s/" % (self.draw_date) def save(self, force_insert=False, force_update=False): if self.digit1 and self.digit2 and self.digit3 and self.digit4: #check if there are winners try: winners = Ticket.objects.filter(draw=self.id,digit1=self.digit1,digit2=self.digit2,digit3=self.digit3,digit4=self.digit4) self.winner = True except Ticket.DoesNotExist: self.winner = False #close &amp; save draw/winners self.closed = True # Add new Draw for following week. new_date = self.draw_date + datetime.timedelta(hours=168) new_draw= Draw(draw_date=new_date) new_draw.save() super(Draw, self).save(force_insert, force_update) # Call the "real" save() method. class Serial(models.Model): serial = models.CharField(max_length=4) closed = models.BooleanField(unique=False) def __unicode__(self): return "%s" %(self.serial) def get_absolute_url(self): return "/draw/serial/%s/" % (self.serial) class Ticket(models.Model): draw = models.ForeignKey(Draw) digit1 = models.PositiveSmallIntegerField() digit2 = models.PositiveSmallIntegerField() digit3 = models.PositiveSmallIntegerField() digit4 = models.PositiveSmallIntegerField() date = models.DateField(auto_now_add=True,editable=False) active = models.BooleanField(default=True) serial_used = models.ForeignKey(Serial,related_name="ticket_serial_used") def __unicode__(self): return "#: %s - %s" %(self.id,self.draw) def get_absolute_url(self): return "/ticket/%s/" % (self.id) def save(self, force_insert=False, force_update=False): if self.serial_used: serial = Serial.objects.get(pk=self.serial_used.id) serial.closed = True serial.save() super(Ticket, self).save(force_insert, force_update) # Call the "real" save() method. </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload