def question_edit(request, question_id):
question = get_object_or_404(Question, pk=question_id)
if request.method == 'POST':
form = QuestionForm(request.POST, instance=question)
if form.is_valid():
form.save()
con = lite.connect('C:/Users/fpan/PY-Programs/BrowsingOR/jumpingintodjango/jumpingintodjango/db/db.sqlite')
cur = con.cursor()
for row in cur.execute("SELECT * FROM questionsandanswers_question WHERE id=?", question_id):
a = row[0]
b = row[3]
# print a
# print b
con = lite.connect('C:/Users/fpan/PY-Programs/BrowsingOR/jumpingintodjango/jumpingintodjango/db/db.sqlite')
with con:
cur = con.cursor()
lid = cur.execute('SELECT max(id) FROM questionsandanswers_answer')
max_id = lid.fetchone()[0] + 1
# lid = cur.lastrowid
print max_id
#c = int(lid) + 1
cur.execute("INSERT INTO questionsandanswers_answer VALUES(?,?,?,?)",(max_id,b,a,a))
con.commit()
# print a
# print b
return redirect('question_detail', question_id)
else:
form = QuestionForm(instance=question)
return render_to_response('question_edit.html',{'form': form},context_instance=RequestContext(request))
def question_create(request):
if request.method == 'POST':
form = QuestionForm(request.POST)
if form.is_valid():
form.save()
return redirect('/questions')
else:
form = QuestionForm()
return render_to_response('questionsandanswers/question_create.html', {'form': form}, context_instance=RequestContext(request))
def question_edit(request, question_id):
question = get_object_or_404(Question, pk=question_id)
if request.method=='POST':
form = QuestionForm(request.POST, instance=question)
if form.is_valid():
form.save()
return redirect('question_detail', question_id)
else:
form = QuestionForm(instance=question)
return render_to_response('questionsandanswers/question_edit.html', {'form': form}, context_instance=RequestContext(request))
