{"id":1496,"date":"2023-02-14T15:20:37","date_gmt":"2023-02-14T07:20:37","guid":{"rendered":"http:\/\/175.24.184.226\/?p=1496"},"modified":"2023-02-14T15:20:37","modified_gmt":"2023-02-14T07:20:37","slug":"django-db-utils-programmingerror-eoias_company_credit_rating-is-not-a-sequence","status":"publish","type":"post","link":"\/?p=1496","title":{"rendered":"django.db.utils.ProgrammingError: &#8220;eoias_company_credit_rating&#8221; is not a sequence"},"content":{"rendered":"<p><strong>django.db.utils.ProgrammingError: &quot;eoias_company_credit_rating&quot; is not a sequence<\/strong><\/p>\n<p>\u4f7f\u7528django\u63d2\u5165\u6570\u636e\u7684\u65f6\u5019\u51fa\u73b0\u8fd9\u4e2a\u9519\u8bef<\/p>\n<p>\u5148\u8d34\u6e90\u4ee3\u7801\uff1a<\/p>\n<pre><code class=\"language-python\">store_results = [CreditRating(**j, company_name_id=company_name_id, company_name=company_name) for j in results]\nif info.data_credit_rating:\n    CreditRating.objects.filter(company_name_id=company_name_id).delete()\nCreditRating.objects.bulk_create(store_results)<\/code><\/pre>\n<p>\u8d77\u521d\u662f\u6000\u7591<code>bulk_create<\/code>\u8fd9\u4e2a\u591a\u63d2\u5165\u7684\u65b9\u6cd5\u6709\u95ee\u9898\uff0c\u4ee5\u4e3a\u54ea\u91cc\u6ca1\u7528\u597d\uff0c\u60f3debug\u6e90\u4ee3\u7801\u7684\uff0c\u4f46\u662f\u672c\u9879\u76ee\u662f\u8fdc\u7a0b\u8c03\u8bd5\uff0c\u65e0\u6cd5debug\u670d\u52a1\u5668\u7aef\u7684django\u6e90\u4ee3\u7801<\/p>\n<p>\u540e\u6765\u8fd8\u662f\u6253\u7b97\u6392\u9664\u662f\u4e0d\u662fsql\u6709\u95ee\u9898\uff0c\u5c31\u5728settiings.py\u4e2d\u914d\u7f6elogger,\u4f7f\u5f97\u80fd\u591f\u6253\u5370django\u7684\u65e5\u5fd7\uff0c<\/p>\n<p>\u65b9\u6cd5\u53c2\u8003<a href=\"http:\/\/175.24.184.226\/?p=1136\">\u8c03\u8bd5Django\u65f6\u6253\u5370SQL\u8bed\u53e5\u7684\u65e5\u5fd7 \u2013 lemon_guess<\/a><\/p>\n<p><img src=\"https:\/\/lemon-guess.oss-cn-hangzhou.aliyuncs.com\/img\/202302141511410.png\" alt=\"image-20230214151122965\" \/> <\/p>\n<p>\u53ef\u89c1django\u6e90\u4ee3\u7801\u7684\u76f8\u5173\u8bbe\u7f6e\uff1a<\/p>\n<p><code>\/\/python3.6site-package\/django\/db\/backends\/utils.py<\/code><\/p>\n<p><img src=\"https:\/\/lemon-guess.oss-cn-hangzhou.aliyuncs.com\/img\/202302141515885.png\" alt=\"image-20230214151510150\" \/><\/p>\n<p>\u6253\u5370\u51fa\u6765sql\u4ee5\u53ca\u76f8\u5173\u62a5\u9519\u65e5\u5fd7:<\/p>\n<p><img src=\"https:\/\/lemon-guess.oss-cn-hangzhou.aliyuncs.com\/img\/202302141519807.png\" alt=\"image-20230214151615560\" \/><\/p>\n<p><img src=\"https:\/\/lemon-guess.oss-cn-hangzhou.aliyuncs.com\/img\/202302141519430.png\" alt=\"image-20230214151634122\" \/><\/p>\n<p>\u5c06sql\u590d\u5236\uff0c\u5728navicat\u4e2d\u6267\u884c\uff1a<\/p>\n<p><img src=\"https:\/\/lemon-guess.oss-cn-hangzhou.aliyuncs.com\/img\/202302141517904.png\" alt=\"image-20230214151714697\" \/><\/p>\n<p>\u6240\u4ee5\u7834\u6848\u7684\uff0c\u95ee\u9898\u4e0d\u662f\u51fa\u5728django\u8eab\u4e0a\uff0c\u800c\u662f\u8868\u672c\u8eab\u3002<\/p>\n<p>\u7136\u540e\u5728\u767e\u5ea6\u4e0a\u67e5\u8be2\u5f97\u77e5\uff0c\u5f88\u53ef\u80fd\u5c31\u662f\u5e8f\u5217\u6ca1\u8bbe\u7f6e\u597did\u81ea\u589e\uff0c\u68c0\u67e5\u4e00\u4e0b\u679c\u7136\u5982\u6b64\uff0c\u518d\u66f4\u6539id\u81ea\u589e\u5e8f\u5217\u5c31\u597d\u4e86<\/p>\n<p><img src=\"https:\/\/lemon-guess.oss-cn-hangzhou.aliyuncs.com\/img\/202302141518866.png\" alt=\"image-20230214151833318\" \/> <\/p>\n<p>\u5e8f\u5217\u521b\u5efa\u53c2\u8003\uff1a<a href=\"http:\/\/175.24.184.226\/?p=1493\">Navicat\u521b\u5efaPG\u5e93id\u81ea\u589e\u5e8f\u5217 \u2013 lemon_guess<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>django.db.utils.ProgrammingError: &quot;eoias_company_credit_rating&#038;   \u2026 &#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0},"categories":[40],"tags":[],"_links":{"self":[{"href":"\/index.php?rest_route=\/wp\/v2\/posts\/1496"}],"collection":[{"href":"\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1496"}],"version-history":[{"count":1,"href":"\/index.php?rest_route=\/wp\/v2\/posts\/1496\/revisions"}],"predecessor-version":[{"id":1497,"href":"\/index.php?rest_route=\/wp\/v2\/posts\/1496\/revisions\/1497"}],"wp:attachment":[{"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1496"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1496"},{"taxonomy":"post_tag","embeddable":true,"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1496"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}