def testdb(request):
if request.method == "POST":
print("Post")
elif request.method == "GET":
print("Get")
aa = request.GET["aa"]
question = Question(question_text=aa, pub_date=datetime.now())
question.save()
print(aa + "_id is " + str(question.id))
# get
question = Question.objects.get(id=1)
# update
question.question_text = datetime.now().strftime("%H:%M:%S")
question.save()
# delete
question = Question(question_text="10086", pub_date=datetime.now())
question.save()
print("10086_id is " + str(question.id))
question.delete()
resp = {'errorcode': 100, 'detail': '数据添加成功！'}
return HttpResponse(json.dumps(resp), content_type="application/json")
def handle(self, *args, **options):
# ...
if options['delete']:
Poll.delete()
for poll_id in options['poll_id']:
try:
poll = Poll.objects.get(pk=poll_id)
except Poll.DoesNotExist:
raise CommandError('Poll "%s" does not exist' % poll_id)
poll.opened = False
poll.save()
self.stdout.write(
self.style.SUCCESS('Successfully closed poll "%s"' % poll_id))
from polls.models import Question, Choice
from django.utils import timezone
import datetime
q1 = Question(question_text="tt",pub_date=timezone.now())
q1.save()
q1.choice_set.create(choice_text='fdsaf',votes=1)
q1.was_published_recently()
q1.delete()
len(Question.objects.all())
q = Question.objects.get(pk=1)
q.choice_set.all()
c=q.choice_set.create(choice_text = 'just fdsa', votes=0)
c.question
q.choice_set.all()
Choice.objects.all()
kk=len(Choice.objects.all())-1
print "key number", c.id,kk
c1 = q.choice_set.get(pk=kk)
print c1
c1.delete()
for sc in Choice.objects.all():
print sc.choice_text,sc.id
<Question: Jaka jest twoja ulubiona pora roku?>
>>> q2.id
>>> q2.id is None
True
>>> q2.save()
>>> q2.id
4
>>> Question.objects.filter(question_text="Nie istnieje").update(pub_date=xyz)
Traceback (most recent call last):
File "<console>", line 1, in <module>
NameError: name 'xyz' is not defined
>>> Question.objects.filter(question_text="Nie istnieje").delete()
(0, {})
>>> q2
<Question: Jaka jest twoja ulubiona pora roku?>
>>> q2.delete()
(1, {'polls.Question': 1})
>>> q2
<Question: Jaka jest twoja ulubiona pora roku?>
>>> Choice.objects.all()
<QuerySet [<Choice: Tak>, <Choice: Nie>, <Choice: 12.00>, <Choice: 12.30>, <Choice: 13.00>, <Choice: Biały>, <Choice: Czarny>, <Choice: Morski>]>
>>>
>>>
>>> Question.objects.all()
<QuerySet [<Question: Czy na Brackiej pada deszcz?>, <Question: O której powinna być przerwa?>, <Question: Jaki jest twój ulubiony kolor?>]>
>>> q1.choice_set.all()
<QuerySet [<Choice: Tak>, <Choice: Nie>]>
>>> q1.choice_set.order_by('choice_text')
<QuerySet [<Choice: Nie>, <Choice: Tak>]>
>>> q1.choice_set.order_by('-choice_text')
<QuerySet [<Choice: Tak>, <Choice: Nie>]>
choicesFor_q = q.choice_set.all()
print " ", choicesFor_q
choicesCount = q.choice_set.count()
print " ", choicesCount
countAfterCreateQ = Question.objects.count()
print " ", countAfterCreateQ
#Delete the Question (q)
qObjs = Question.objects.all()
myListPrint(qObjs)
qCount = Question.objects.count()
print " ", qCount
q.delete()
print " Just Deleted the Question"
qObjs = Question.objects.all()
myListPrint(qObjs)
qCount = Question.objects.count()
print " ", qCount
print " "
print "Dispay a Question and if it exists display its Choices along with additional info"
listID = [1, 5]
for idVal in listID:
print "idVal= ", idVal
try:
q = Question.objects.get(id=idVal)
except Question.DoesNotExist: