models.py 1.2 KB

1234567891011121314151617181920212223242526272829303132
  1. from django.db import models
  2. # Create your models here.
  3. class Question (models.Model):
  4. ID = models.AutoField(primary_key=True)
  5. q = models.CharField(max_length=128)
  6. a1 = models.CharField(max_length=128)
  7. a2 = models.CharField(max_length=128)
  8. a3 = models.CharField(max_length=128)
  9. a4 = models.CharField(max_length=128)
  10. answer = models.IntegerField()
  11. def get_random_question():
  12. return Question.objects.order_by('?')[:1]
  13. def search_id(self):
  14. return Question.objects.filter(ID=self.ID)
  15. class AnswerRecord (models.Model):
  16. user = models.CharField(max_length=128)
  17. mobile = models.IntegerField()
  18. question = models.CharField(max_length=128)
  19. result = models.CharField(max_length=8)
  20. your_answer = models.CharField(max_length=128)
  21. correct_answer = models.CharField(max_length=128, null=True)
  22. def add_record(self):
  23. AnswerRecord.objects.create(user=self.user, mobile=self.mobile, question=self.question, result=self.result,
  24. your_answer=self.your_answer, correct_answer=self.correct_answer)
  25. def get_record(self):
  26. return AnswerRecord.objects.filter(user=self.user, mobile=self.mobile)