{"id":2326,"date":"2022-08-30T15:23:56","date_gmt":"2022-08-30T15:23:56","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2014\/01\/05\/cannot-create-new-django-model-object-within-ajax-post-request-collection-of-common-programming-errors\/"},"modified":"2022-08-30T15:23:56","modified_gmt":"2022-08-30T15:23:56","slug":"cannot-create-new-django-model-object-within-ajax-post-request-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2022\/08\/30\/cannot-create-new-django-model-object-within-ajax-post-request-collection-of-common-programming-errors\/","title":{"rendered":"Cannot create new Django model object within Ajax post request-Collection of common programming errors"},"content":{"rendered":"

This is kind of “I already lost x hours debugging this” kind of problem\/question \ud83d\ude41<\/p>\n

Following jQuery js code is initiating POST request upon button click<\/p>\n

$(\"#btn_create_tag\").click(function(evt) {\n$.post(\"\/tag\/createAjax\", { \n    tagname: $(\"#txt_tag_name\").val()       \n    },\n    function(data) {\n    }\n);\n});\n<\/code><\/pre>\n
Django code that is performed on this call is:<\/p>\n
@suppress_logging_output\n@login_required\ndef createAjax(request):\n    if request.is_ajax() and request.method == 'POST':\n        tagName = request.POST[\"tagname\"]\n        new_tag = Tag()\n        new_tag.name = tagName\n        new_tag.save()\n        print \"new tag with id %s has been created\" % new_tag.id\n<\/code><\/pre>\n
That code is executed successfully (I’m doing checks for empty or already existing name, but didn’t wrote here to be more clear), but new Tag object is NOT created. I’m even getting “”new tag with id %s has been created” printed on devserver’s prompt, and every time ID is increased for one, as suppossed to, but objects are not stored in db.<\/p>\n
When I execute<\/p>\n
new_tag = Tag()\nnew_tag.name = tagName\nnew_tag.save()\n<\/code><\/pre>\n
from Django shell, new Tag object is regulary created, but from jQuery request, it’s not created.<\/p>\n
Have any idea what’s wront, what to check, how to debug this….<\/p>\n
DB behind is PostgresSQL 8.3.<\/p>\n
Any suggestion is more then welcome \ud83d\ude42<\/p>\n
Update<\/strong>:<\/p>\n
I wrote UnitTest which is working:<\/p>\n
class AjaxTestCase(TestCase):\n    def testAjaxCreateTag(self):\n        tagNum = Tag.objects.filter(name=\"TEST_TAG\").count()\n        self.assertEqual(tagNum, 0)\n        c = Client()\n        c.post('\/lookup\/tag\/createAjax', {'tagname': 'TEST_TAG'}, HTTP_X_REQUESTED_WITH='XMLHttpRequest')\n        tagNum = Tag.objects.filter(name=\"TEST_TAG\").count()\n        self.assertEqual(tagNum, 1)\n<\/code><\/pre>\n
Update2<\/strong>:<\/p>\n
Hum, this morning, it seems that everything is working fine, but code hasn’t changed. I don’t like this at all \ud83d\ude41<\/p>\n
    \n
  1. \n
    This sounds very strange. Can you double check your database settings? Ensure that you are using the correct database inside settings.py<\/code>? Also write an unit test to exercise the code using Django’s test client. In your test method remember to send the HTTP_X_REQUESTED_WITH<\/code> header for is_ajax()<\/code> to work.<\/p>\n<\/li>\n
  2. \n
    try<\/p>\n
    new_tag=Tag(name=tagName)\nnew_tag.save()\n<\/code><\/pre>\n
    BTW – you should sanitize the new tagname and not take it directly from the POST<\/p>\n<\/li>\n<\/ol>\n
    Originally posted 2014-01-05 10:10:33. <\/small><\/p>","protected":false},"excerpt":{"rendered":"
    This is kind of “I already lost x hours debugging this” kind of problem\/question \ud83d\ude41 Following jQuery js code is initiating POST request upon button click $(“#btn_create_tag”).click(function(evt) { $.post(“\/tag\/createAjax”, { tagname: $(“#txt_tag_name”).val() }, function(data) { } ); }); Django code that is performed on this call is: @suppress_logging_output @login_required def createAjax(request): if request.is_ajax() and request.method […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2326","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/2326","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=2326"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/2326\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=2326"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=2326"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=2326"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}