{"id":10020652,"date":"2025-02-10T17:12:59","date_gmt":"2025-02-10T09:12:59","guid":{"rendered":"https:\/\/itmax.cn\/?p=10020652"},"modified":"2025-02-10T17:12:59","modified_gmt":"2025-02-10T09:12:59","slug":"peewee-%e7%9a%84-get%e3%80%81get_or_none%e3%80%81get_or_create-%e9%81%87%e5%88%b0%e5%a4%9a%e4%b8%aa%e5%80%bc%ef%bc%8c%e6%98%af%e6%8a%a5%e9%94%99%e8%bf%98%e6%98%af-limit1-%ef%bc%9f","status":"publish","type":"post","link":"https:\/\/itmax.cn\/?p=10020652","title":{"rendered":"peewee \u7684 get\u3001get_or_none\u3001get_or_create \u9047\u5230\u591a\u4e2a\u503c\uff0c\u662f\u62a5\u9519\u8fd8\u662f limit1 \uff1f"},"content":{"rendered":"
CREATE TABLE `found_video_cover_image_ocr_count` (\n  `id` bigint NOT NULL AUTO_INCREMENT,\n  `video_id` int NOT NULL,\n  `search_count` int NOT NULL,\n  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,\n  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;<\/code><\/pre>\n
\u6d4b\u8bd5\u6570\u636e\u5982\u4e0b\uff1a<\/p>\n
video_id \u6ca1\u6709\u6dfb\u52a0\u552f\u4e00\u7ea6\u675f\uff0c\u4e14\u5b58\u5728\u591a\u4e2a\u4e00\u6837\u7684\u503c<\/p>\n
\"\u56fe\u7247.png\"<\/p>\n\n\n\n\n\n\n\n\n
id<\/th>\nvideo_id<\/th>\nsearch_count<\/th>\ncreated_at<\/th>\nupdated_at<\/th>\n<\/tr>\n<\/thead>\n
1<\/td>\n2147483647<\/td>\n0<\/td>\n2024-10-31 09:54:35<\/td>\n2024-10-31 09:54:35<\/td>\n<\/tr>\n
2<\/td>\n2147483647<\/td>\n0<\/td>\n2024-10-31 09:54:36<\/td>\n2024-10-31 09:54:36<\/td>\n<\/tr>\n
3<\/td>\n2147483647<\/td>\n0<\/td>\n2024-10-31 09:54:37<\/td>\n2024-10-31 09:54:37<\/td>\n<\/tr>\n
4<\/td>\n2147483647<\/td>\n0<\/td>\n2024-10-31 09:54:39<\/td>\n2024-10-31 09:54:39<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\u5bf9\u4e8e get_or_create<\/h2>\n
\u7b54\u6848\u662f limit 1<\/p>\n
\u793a\u4f8b\u4ee3\u7801\uff1a<\/p>\n
from loguru import logger\nfrom core.mysql.models import FoundedVideoCoverImageOcrCountTable\n\n\nvideo_id = 2147483647\n\nfvcisc, fvcisc_created = FoundedVideoCoverImageOcrCountTable.get_or_create(\n    video_id=video_id)\n<\/code><\/pre>\n
\u4f7f\u7528 wireshark \u6293\u5305\uff0c\u53d1\u73b0<\/p>\n
\"\u56fe\u7247.png\"<\/p>\n
SELECT\n    `t1`.`id`,\n    `t1`.`video_id`,\n    `t1`.`search_count`,\n    `t1`.`created_at`,\n    `t1`.`updated_at`\nFROM\n    `found_video_cover_image_ocr_count` AS `t1`\nWHERE\n    (`t1`.`video_id` = 2147483647)\nLIMIT\n    1 OFFSET 0<\/code><\/pre>\n
\u5bf9\u4e8e get_or_none<\/h2>\n
\u7b54\u6848\u548c get_or_create \u662f\u4e00\u6a21\u4e00\u6837\u7684<\/p>\n
\u5bf9\u4e8e get<\/h2>\n
\u7b54\u6848\u548c get_or_create \u662f\u4e00\u6a21\u4e00\u6837\u7684<\/p>\n
https:\/\/segmentfault.com\/a\/1190000046093860<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
CREATE TABLE `found_video_cover_image_ocr_count` ( `id` […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-10020652","post","type-post","status-publish","format-standard","hentry","category-share"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/posts\/10020652","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10020652"}],"version-history":[{"count":0,"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/posts\/10020652\/revisions"}],"wp:attachment":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10020652"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10020652"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10020652"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}