{"id":10020651,"date":"2025-02-10T17:12:41","date_gmt":"2025-02-10T09:12:41","guid":{"rendered":"https:\/\/itmax.cn\/?p=10020651"},"modified":"2025-02-10T17:12:41","modified_gmt":"2025-02-10T09:12:41","slug":"peewee-%e7%9a%84-save-%e4%bc%9a%e8%a7%a6%e5%8f%91%e5%b8%a6%e6%9c%89-current_timestamp-%e7%9a%84-update_at-%e6%9b%b4%e6%96%b0%e5%90%97%ef%bc%9f","status":"publish","type":"post","link":"https:\/\/itmax.cn\/?p=10020651","title":{"rendered":"peewee \u7684 save \u4f1a\u89e6\u53d1\u5e26\u6709 CURRENT_TIMESTAMP  \u7684 update_at \u66f4\u65b0\u5417\uff1f"},"content":{"rendered":"<p>\u51c6\u5907\u7684\u6570\u636e\u8868<\/p>\n<pre><code class=\"sql\">CREATE TABLE `found_video_cover_image_ocr_count` (\n  `id` bigint NOT NULL AUTO_INCREMENT,\n  `video_id` bigint 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  UNIQUE KEY `foundedvideocoverimageocrcounttable_video_id` (`video_id`)\n) ENGINE=InnoDB AUTO_INCREMENT=151945318 DEFAULT CHARSET=utf8mb3;<\/code><\/pre>\n<p>\u51c6\u5907\u7684\u6570\u636e<\/p>\n<table>\n<thead>\n<tr>\n<th>id<\/th>\n<th>video_id<\/th>\n<th>search_count<\/th>\n<th>created_at<\/th>\n<th>updated_at<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>1<\/td>\n<td>2147483647<\/td>\n<td>0<\/td>\n<td>2024-10-31 09:54:35<\/td>\n<td>2024-10-31 09:54:35<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>2147483647<\/td>\n<td>0<\/td>\n<td>2024-10-31 09:54:36<\/td>\n<td>2024-10-31 09:54:36<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>2147483647<\/td>\n<td>0<\/td>\n<td>2024-10-31 09:54:37<\/td>\n<td>2024-10-31 09:54:37<\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>2147483647<\/td>\n<td>0<\/td>\n<td>2024-10-31 09:54:39<\/td>\n<td>2024-10-31 09:54:39<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u770b\u770b\u6267\u884c\u4e0b\u9762\u7684\u4ee3\u7801\u4e4b\u540e\uff0cupdated_at \u662f\u5426\u4f1a\u53d8\u5316<\/p>\n<pre><code class=\"python\">from loguru import logger\nfrom core.mysql.models import FoundedVideoCoverImageOcrCountTable\n\n\nvideo_id = 2147483647\n\nfvcisc, created = FoundedVideoCoverImageOcrCountTable.get_or_create(\n    video_id=video_id)\n\nfvcisc:FoundedVideoCoverImageOcrCountTable\n\nfvcisc.search_count+=1\nfvcisc.save()\nlogger.info(fvcisc.search_count)\n<\/code><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"723\" height=\"105\" referrerpolicy=\"no-referrer\" src=\"https:\/\/segmentfault.com\/img\/bVdhzin\" alt=\"\u56fe\u7247.png\" title=\"\u56fe\u7247.png\"><\/p>\n<pre><code class=\"sql\">UPDATE\n    `found_video_cover_image_ocr_count`\nSET\n    `video_id` = 2147483647,\n    `search_count` = 1,\n    `created_at` = '2024-10-31 09:54:35',\n    `updated_at` = '2024-10-31 09:54:35'\nWHERE\n    (`found_video_cover_image_ocr_count`.`id` = 1)<\/code><\/pre>\n<p>\u8fd9\u4e2a save \u5e76\u4e0d\u662f\u53ea update \u88ab\u4fee\u6539\u7684\u5b57\u6bb5\uff0c\u800c\u662f\u5168\u91cf\u5b57\u6bb5\u90fd\u505a\u4e86\u4fdd\u5b58\uff0c<\/p>\n<p>\u6240\u4ee5\u4e0d\u4f1a\u89e6\u53d1\u5e26\u6709 CURRENT_TIMESTAMP  \u7684 update_at \u66f4\u65b0<\/p>\n<p><a href=\"https:\/\/segmentfault.com\/a\/1190000046093917\">https:\/\/segmentfault.com\/a\/1190000046093917<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u51c6\u5907\u7684\u6570\u636e\u8868 CREATE TABLE `found_video_cover_image_ocr_count` [&hellip;]<\/p>\n","protected":false},"author":7,"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-10020651","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\/10020651","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\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10020651"}],"version-history":[{"count":0,"href":"https:\/\/itmax.cn\/index.php?rest_route=\/wp\/v2\/posts\/10020651\/revisions"}],"wp:attachment":[{"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10020651"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10020651"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itmax.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10020651"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}