insert into database MySQL Django

Question

My data is not being saved inside the DB.

Here is my views.py file

def rr_reply(request):


    cc_user = request.user.id
    conversation_id = request.GET.get('conversation_id','')
    b_id = request.GET.get('b_id','')


    if request.method == 'POST': 
        form = CcReply(request.POST) 
        if form.is_valid():
            date_time = datetime.datetime.now()
            reply = form.cleaned_data['reply']

            queries = WebQuery.objects.using('launchg').filter(conversation_id = conversation_id)

            for query in queries:
                q_id = query.query_id               

            cc_chat_data_obj = CcChatData(conversation_id = conversation_id , reply_from = request.user.id , 
                b_id = b_id, q_id = q_id)
            web_reply_obj = WebReply(query_id = q_id, conversation_id = conversation_id , b_id = b_id, 
                u_query = reply , date_time = date_time.strftime("%Y-%m-%d %H:%M:%S"),diff = 0)

            cc_chat_data_obj.save()
            web_reply_obj.save()


    else:
        form = CcReply()

Yes. The form is valid .Prints True when the form is submitted. — Praful Bagai
– Praful Bagai, Commented Jul 19, 2013 at 5:40

Victor Castillo Torres · Accepted Answer · 2013-10-05 20:22:02Z

3

Try this:

 cc_chat_data_obj = CcChatData.objects.create(conversation_id = conversation_id , reply_from = request.user.id , b_id = b_id, q_id = q_id)
 web_reply_obj = WebReply.objects.create(query_id = q_id, conversation_id = conversation_id , b_id = b_id, u_query = reply , date_time = date_time.strftime("%Y-%m-%d %H:%M:%S"),diff = 0)

edited Oct 5, 2013 at 20:22

answered Jul 19, 2013 at 16:23

Victor Castillo Torres

10.9k7 gold badges43 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

eugene · Accepted Answer · 2013-07-18 23:58:03Z

0

Did you check if your form is indeed valid? (is_valid)

Your current code does nothing when the form isn't valid.

answered Jul 18, 2013 at 23:58

eugene

42.1k77 gold badges284 silver badges538 bronze badges

1 Comment

Praful Bagai Over a year ago

Yes. The form is valid .Prints True when the form is submitted. Any suggestions please!!!

Collectives™ on Stack Overflow

insert into database MySQL Django

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related