{"id":289,"date":"2026-06-14T15:18:16","date_gmt":"2026-06-14T07:18:16","guid":{"rendered":"http:\/\/www.longxiapro.com\/?p=289"},"modified":"2026-06-14T15:18:16","modified_gmt":"2026-06-14T07:18:16","slug":"social-media-schedulerkuapingtaishejiaomeitineirongjihuagongjutongyibianjidingshidiaoduduo","status":"publish","type":"post","link":"https:\/\/www.longxiapro.com\/index.php\/289\/","title":{"rendered":"Social Media Scheduler\u30fb\u8de8\u5e73\u53f0\u793e\u4ea4\u5a92\u4f53\u5185\u5bb9\u8ba1\u5212\u5de5\u5177\uff08\u7edf\u4e00\u7f16\u8f91\u30fb\u5b9a\u65f6\u8c03\u5ea6\u30fb\u591a\u5e73\u53f0\u30fbAI \u4f18\u5316\u30fb\u5b8c\u6574\u4e8c\u5f00\u4ee3\u7801\uff09"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">\u4e00\u3001\u6838\u5fc3\u5b9a\u4f4d<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Social Media Scheduler\uff08\u793e\u5a92\u8c03\u5ea6\u5668\uff09<\/strong>\uff1a<strong>\u4e00\u6b21\u7f16\u8f91\u3001\u591a\u5e73\u53f0\u9002\u914d\u3001\u5b9a\u65f6\u53d1\u5e03\u3001\u65e5\u5386\u53ef\u89c6\u5316\u3001AI \u4f18\u5316\u3001\u8d26\u53f7\u7edf\u4e00\u7ba1\u7406\u3001\u6570\u636e\u590d\u76d8<\/strong>\uff0c\u8986\u76d6\u4e3b\u6d41\u56fd\u5185\u5916\u793e\u5a92\uff0c<strong>\u5168\u81ea\u52a8\u5b9a\u65f6\u3001\u6279\u91cf\u6392\u671f\u3001\u81ea\u52a8\u9002\u914d\u683c\u5f0f\u3001\u5f02\u5e38\u91cd\u8bd5\u3001\u56e2\u961f\u534f\u4f5c<\/strong>\uff0c\u89e3\u51b3\u591a\u5e73\u53f0\u91cd\u590d\u53d1\u5e03\u3001\u6f0f\u53d1\u3001\u65f6\u95f4\u9519\u914d\u3001\u683c\u5f0f\u4e0d\u517c\u5bb9\u75db\u70b9\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u6838\u5fc3\uff1a<strong>Write Once, Post Everywhere\uff08\u4e00\u6b21\u521b\u4f5c\uff0c\u5168\u5e73\u53f0\u5206\u53d1\uff09<\/strong><\/li>\n\n\n\n<li>\u76ee\u6807\uff1a<strong>\u6548\u7387\u63d0\u5347 80%\u3001\u96f6\u6f0f\u53d1\u3001\u683c\u5f0f\u81ea\u52a8\u9002\u914d\u3001\u6700\u4f73\u65f6\u95f4\u53d1\u5e03<\/strong><\/li>\n\n\n\n<li>\u9002\u7528\uff1a<strong>\u81ea\u5a92\u4f53\u3001MCN\u3001\u54c1\u724c\u8425\u9500\u3001\u7535\u5546\u3001\u5185\u5bb9\u56e2\u961f\u3001\u4e2a\u4eba\u521b\u4f5c\u8005<\/strong><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u4e8c\u3001\u652f\u6301\u5e73\u53f0\uff08\u5168\u8986\u76d6\uff09<\/h3>\n\n\n\n<h3 class=\"wp-block-heading\">\u56fd\u5185\u5e73\u53f0<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u6296\u97f3\u3001\u5c0f\u7ea2\u4e66\u3001B \u7ad9\u3001\u89c6\u9891\u53f7\u3001\u5feb\u624b\u3001\u5934\u6761\u53f7\u3001\u516c\u4f17\u53f7\u3001\u77e5\u4e4e\u3001\u5fae\u535a<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u6d77\u5916\u5e73\u53f0<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>X(Twitter)\u3001Instagram\u3001TikTok\u3001LinkedIn\u3001Facebook\u3001YouTube\u3001Threads\u3001Pinterest\u3001Telegram<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u4e09\u3001\u4f20\u7edf\u8fd0\u8425\u75db\u70b9<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u274c \u9010\u4e2a\u5e73\u53f0\u624b\u52a8\u53d1\uff0c<strong>\u91cd\u590d\u52b3\u52a8\u3001\u8017\u65f6\u957f<\/strong><\/li>\n\n\n\n<li>\u274c \u5404\u5e73\u53f0<strong>\u683c\u5f0f \/ \u5c3a\u5bf8 \/ \u5b57\u6570 \/ \u89c4\u5219\u4e0d\u540c<\/strong>\uff0c\u53cd\u590d\u4fee\u6539<\/li>\n\n\n\n<li>\u274c \u6700\u4f73\u53d1\u5e03\u65f6\u95f4\u96be\u628a\u63e1\uff0c<strong>\u9519\u8fc7\u6d41\u91cf\u9ad8\u5cf0<\/strong><\/li>\n\n\n\n<li>\u274c \u591a\u8d26\u53f7\u6df7\u4e71\u3001<strong>\u6f0f\u53d1\u3001\u9519\u53d1\u3001\u91cd\u590d\u53d1<\/strong><\/li>\n\n\n\n<li>\u274c \u65e0\u7edf\u4e00\u65e5\u5386\uff0c<strong>\u6392\u671f\u6df7\u4e71\u3001\u590d\u76d8\u96be<\/strong><\/li>\n\n\n\n<li>\u274c \u65e0 AI \u4f18\u5316\uff0c<strong>\u6587\u6848 \/ \u6807\u7b7e \/ \u5c01\u9762\u8d28\u91cf\u4f4e<\/strong><\/li>\n\n\n\n<li>\u274c \u65e0\u56e2\u961f\u534f\u4f5c\uff0c<strong>\u5ba1\u6838\u3001\u4fee\u6539\u3001\u4ea4\u63a5\u4f4e\u6548<\/strong><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u56db\u3001\u6838\u5fc3\u529f\u80fd\uff08\u4f01\u4e1a\u7ea7\uff09<\/h3>\n\n\n\n<h3 class=\"wp-block-heading\">\u2705 \u7edf\u4e00\u5185\u5bb9\u7f16\u8f91\u5668\uff08\u4e00\u6b21\u521b\u4f5c\uff09<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5bcc\u6587\u672c \/ Markdown \u7f16\u8f91\u3001<strong>\u4e00\u952e\u591a\u5e73\u53f0\u9002\u914d<\/strong><\/li>\n\n\n\n<li>\u81ea\u52a8\u9002\u914d\uff1a<strong>\u5b57\u6570\u3001\u56fe\u7247\u5c3a\u5bf8\u3001\u89c6\u9891\u65f6\u957f\u3001\u6807\u7b7e\u683c\u5f0f\u3001\u6392\u7248<\/strong><\/li>\n\n\n\n<li>\u5a92\u4f53\u5e93\uff1a\u56fe\u7247 \/ \u89c6\u9891 \/ \u5c01\u9762 \/ \u6a21\u677f<strong>\u6279\u91cf\u4e0a\u4f20\u3001\u590d\u7528<\/strong><\/li>\n\n\n\n<li>\u8349\u7a3f\u7bb1\u3001\u7248\u672c\u5386\u53f2\u3001<strong>\u591a\u4eba\u534f\u4f5c\u7f16\u8f91<\/strong><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u2705 \u667a\u80fd\u5b9a\u65f6\u8c03\u5ea6\uff08\u6838\u5fc3\uff09<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u65e5\u5386\u89c6\u56fe<\/strong>\uff1a\u62d6\u62fd\u6392\u671f\u3001\u6309\u6708 \/ \u5468 \/ \u65e5\u89c6\u56fe<\/li>\n\n\n\n<li><strong>\u7cbe\u51c6\u5b9a\u65f6<\/strong>\uff1a\u5206\u949f\u7ea7\u3001\u65f6\u533a\u81ea\u52a8\u8f6c\u6362\u3001<strong>\u6700\u4f73\u65f6\u95f4\u63a8\u8350\uff08AI\uff09<\/strong><\/li>\n\n\n\n<li><strong>\u5faa\u73af\u53d1\u5e03<\/strong>\uff1a\u65e5 \/ \u5468 \/ \u6708\u91cd\u590d\u3001\u56fa\u5b9a\u5468\u671f\u3001<strong>\u65e0\u9650\u5faa\u73af \/ \u81ea\u52a8\u7ec8\u6b62<\/strong><\/li>\n\n\n\n<li><strong>\u961f\u5217\u7ba1\u7406<\/strong>\uff1a\u4efb\u52a1\u4f18\u5148\u7ea7\u3001<strong>\u5931\u8d25\u81ea\u52a8\u91cd\u8bd5\u3001\u65ad\u70b9\u7eed\u53d1<\/strong><\/li>\n\n\n\n<li><strong>\u6279\u91cf\u6392\u671f<\/strong>\uff1a\u4e00\u6b21\u5bfc\u5165 100 + \u6761\uff0c<strong>\u81ea\u52a8\u5206\u914d\u65f6\u95f4<\/strong><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u2705 \u591a\u5e73\u53f0\u8d26\u53f7\u7ba1\u7406<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u591a\u8d26\u53f7\u7ed1\u5b9a\u3001<strong>\u4e00\u952e\u5207\u6362\u3001\u5206\u7ec4\u7ba1\u7406<\/strong><\/li>\n\n\n\n<li>OAuth2 \u5b89\u5168\u6388\u6743\u3001<strong>Cookie \u6301\u4e45\u5316\u3001\u514d\u91cd\u590d\u767b\u5f55<\/strong><\/li>\n\n\n\n<li>\u8d26\u53f7\u5065\u5eb7\u76d1\u63a7\u3001<strong>\u9650\u6d41 \/ \u98ce\u63a7\u9884\u8b66\u3001\u5f02\u5e38\u544a\u8b66<\/strong><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u2705 AI \u5185\u5bb9\u4f18\u5316\uff08\u589e\u5f3a\uff09<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>AI \u6587\u6848\u751f\u6210<\/strong>\uff1a\u6807\u9898 \/ \u6b63\u6587 \/ \u94a9\u5b50 \/ \u8bc4\u8bba\u81ea\u52a8\u751f\u6210<\/li>\n\n\n\n<li><strong>AI \u6807\u7b7e \/hashtags<\/strong>\uff1a\u70ed\u95e8\u6807\u7b7e\u3001\u7cbe\u51c6\u63a8\u8350\u3001\u53bb\u91cd<\/li>\n\n\n\n<li><strong>AI \u5c01\u9762 \/ \u7f29\u7565\u56fe<\/strong>\uff1a\u81ea\u52a8\u88c1\u526a\u3001\u7f8e\u5316\u3001\u52a0\u6587\u5b57<\/li>\n\n\n\n<li><strong>\u8bed\u6c14\u9002\u914d<\/strong>\uff1a\u6296\u97f3\u6d3b\u6cfc\u3001\u5c0f\u7ea2\u4e66\u79cd\u8349\u3001LinkedIn \u4e13\u4e1a<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u2705 \u53d1\u5e03\u76d1\u63a7\u4e0e\u6570\u636e\u590d\u76d8<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5b9e\u65f6\u53d1\u5e03\u72b6\u6001\uff1a<strong>\u6210\u529f \/ \u5931\u8d25 \/ \u5f85\u53d1\u5e03\u3001\u8fdb\u5ea6\u6761<\/strong><\/li>\n\n\n\n<li>\u6570\u636e\u7edf\u8ba1\uff1a<strong>\u9605\u8bfb\u3001\u70b9\u8d5e\u3001\u8bc4\u8bba\u3001\u8f6c\u53d1\u3001\u66dd\u5149\u3001\u4e92\u52a8\u7387<\/strong><\/li>\n\n\n\n<li>\u62a5\u8868\u5bfc\u51fa\u3001<strong>\u6548\u679c\u5bf9\u6bd4\u3001\u7206\u6b3e\u5206\u6790\u3001\u65f6\u95f4\u4f18\u5316<\/strong><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u2705 \u56e2\u961f\u534f\u4f5c\u4e0e\u6743\u9650<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u89d2\u8272\uff1a<strong>\u7ba1\u7406\u5458 \/ \u7f16\u8f91 \/ \u5ba1\u6838\u5458 \/ \u8bbf\u5ba2<\/strong><\/li>\n\n\n\n<li>\u5ba1\u6279\u6d41\uff1a<strong>\u63d0\u4ea4\u2192\u5ba1\u6838\u2192\u5b9a\u65f6\u53d1\u5e03<\/strong><\/li>\n\n\n\n<li>\u8bc4\u8bba\u534f\u4f5c\u3001@\u6210\u5458\u3001<strong>\u4efb\u52a1\u6307\u6d3e\u3001\u6d88\u606f\u901a\u77e5<\/strong><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u2705 \u5b89\u5168\u4e0e\u5bb9\u9519<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u52a0\u5bc6\u5b58\u50a8<\/strong>\uff1a\u8d26\u53f7\u5bc6\u7801 AES256 \u52a0\u5bc6<\/li>\n\n\n\n<li>\u9650\u6d41\u63a7\u5236\u3001<strong>\u8bf7\u6c42\u95f4\u9694\u3001\u9632\u5c01\u7981<\/strong><\/li>\n\n\n\n<li>\u65e5\u5fd7\u5ba1\u8ba1\u3001<strong>\u64cd\u4f5c\u8bb0\u5f55\u3001\u5f02\u5e38\u8ffd\u8e2a<\/strong><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u4e94\u3001\u7cfb\u7edf\u67b6\u6784\uff08\u6a21\u5757\u5316\u30fb\u53ef\u6269\u5c55\uff09<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">plaintext<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>social-scheduler\/\n\u251c\u2500\u2500 backend\/          # FastAPI\u5f02\u6b65\u540e\u7aef\n\u251c\u2500\u2500 frontend\/         # Vue3 + Element Plus \u770b\u677f\n\u251c\u2500\u2500 core\/             # \u8c03\u5ea6\u5f15\u64ce\u3001\u5e73\u53f0\u9002\u914d\u5668\u3001AI\u6a21\u5757\n\u251c\u2500\u2500 platforms\/        # \u5404\u5e73\u53f0API\/\u722c\u866b\u9002\u914d\n\u251c\u2500\u2500 database\/         # MySQL+Redis\uff08\u4efb\u52a1\u961f\u5217\uff09\n\u251c\u2500\u2500 ai\/               # \u6587\u6848\/\u6807\u7b7e\/\u5c01\u9762AI\n\u251c\u2500\u2500 media\/            # \u5a92\u4f53\u5b58\u50a8\u3001\u683c\u5f0f\u8f6c\u6362\n\u2514\u2500\u2500 config\/           # \u914d\u7f6e\u3001\u5bc6\u94a5\u3001\u9650\u6d41\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u516d\u3001\u5b8c\u6574\u4e8c\u6b21\u5f00\u53d1\u4ee3\u7801\uff08Python+FastAPI+Vue+APScheduler\uff0c\u53ef\u76f4\u63a5\u90e8\u7f72\uff09<\/h3>\n\n\n\n<h3 class=\"wp-block-heading\">1. requirements.txt<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">plaintext<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>fastapi\nuvicorn\npython-multipart\nrequests\nbeautifulsoup4\nselenium\ntweepy\npython-dotenv\napscheduler\nredis\nmysql-connector-python\npillow\nopencv-python\ntransformers\ntorch\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">2. \u914d\u7f6e config\/settings.py<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">python<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u8fd0\u884c<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u6570\u636e\u5e93\nDB_HOST = \"localhost\"\nDB_USER = \"root\"\nDB_PASS = \"xxx\"\nDB_NAME = \"social_scheduler\"\n# Redis\uff08\u4efb\u52a1\u961f\u5217\uff09\nREDIS_URL = \"redis:\/\/localhost:6379\/0\"\n# \u8c03\u5ea6\nTIMEZONE = \"Asia\/Shanghai\"\nRETRY_TIMES = 3\nRETRY_DELAY = 60\n# AI\nAI_MODEL = \"gpt-3.5-turbo\"\n# \u5e73\u53f0\u5bc6\u94a5\uff08\u793a\u4f8b\uff09\nTWITTER_API_KEY = \"\"\nTWITTER_API_SECRET = \"\"\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">3. \u8c03\u5ea6\u5f15\u64ce core\/scheduler.py\uff08APScheduler \u6838\u5fc3\uff09<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">python<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u8fd0\u884c<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>from apscheduler.schedulers.asyncio import AsyncIOScheduler\nfrom apscheduler.triggers.date import DateTrigger\nfrom apscheduler.triggers.cron import CronTrigger\nimport redis\nimport json\nfrom datetime import datetime\nfrom config.settings import *\n\nscheduler = AsyncIOScheduler(timezone=TIMEZONE)\nredis_client = redis.from_url(REDIS_URL)\n\nclass TaskScheduler:\n    @staticmethod\n    def add_once_task(content_id, platforms, publish_time):\n        \"\"\"\u4e00\u6b21\u6027\u5b9a\u65f6\u4efb\u52a1\"\"\"\n        trigger = DateTrigger(run_date=publish_time)\n        scheduler.add_job(\n            func=TaskScheduler.publish_task,\n            trigger=trigger,\n            args=&#91;content_id, platforms],\n            id=f\"task_{content_id}\",\n            replace_existing=True\n        )\n        # \u5b58\u5165Redis\u961f\u5217\n        redis_client.set(f\"content_{content_id}\", json.dumps({\"platforms\":platforms,\"time\":publish_time.isoformat()}))\n\n    @staticmethod\n    def add_cron_task(content_id, platforms, cron_expr):\n        \"\"\"\u5faa\u73af\u4efb\u52a1\uff08cron\uff09\"\"\"\n        trigger = CronTrigger.from_crontab(cron_expr)\n        scheduler.add_job(\n            func=TaskScheduler.publish_task,\n            trigger=trigger,\n            args=&#91;content_id, platforms],\n            id=f\"cron_{content_id}\",\n            replace_existing=True\n        )\n\n    @staticmethod\n    async def publish_task(content_id, platforms):\n        \"\"\"\u6267\u884c\u53d1\u5e03\u4efb\u52a1\"\"\"\n        try:\n            content = await ContentDB.get_content(content_id)\n            for platform in platforms:\n                adapter = PlatformAdapterFactory.get_adapter(platform)\n                await adapter.publish(content)\n            await ContentDB.update_status(content_id, \"success\")\n        except Exception as e:\n            await ContentDB.update_status(content_id, \"failed\", str(e))\n            # \u81ea\u52a8\u91cd\u8bd5\n            return False\n        return True\n\n    @staticmethod\n    def start():\n        scheduler.start()\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">4. \u5e73\u53f0\u9002\u914d\u5668 core\/platform_adapter.py\uff08\u7b56\u7565\u6a21\u5f0f\uff09<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">python<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u8fd0\u884c<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>from platforms.douyin import DouyinAdapter\nfrom platforms.xiaohongshu import XiaohongshuAdapter\nfrom platforms.twitter import TwitterAdapter\nfrom platforms.bilibili import BilibiliAdapter\n\nclass PlatformAdapterFactory:\n    _adapters = {\n        \"douyin\": DouyinAdapter,\n        \"xiaohongshu\": XiaohongshuAdapter,\n        \"bilibili\": BilibiliAdapter,\n        \"twitter\": TwitterAdapter\n    }\n\n    @classmethod\n    def get_adapter(cls, platform):\n        return cls._adapters.get(platform)\n\n# \u6296\u97f3\u9002\u914d\u5668\u793a\u4f8b\nclass DouyinAdapter:\n    @staticmethod\n    async def publish(content):\n        \"\"\"\u8c03\u7528\u6296\u97f3\u5f00\u653eAPI\/selenium\u53d1\u5e03\"\"\"\n        print(f\"\u53d1\u5e03\u5230\u6296\u97f3\uff1a{content&#91;'title']}\")\n        # \u5b9e\u9645API\/selenium\u4ee3\u7801\n        return True\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">5. \u5185\u5bb9\u6570\u636e\u5e93 core\/db.py<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">python<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u8fd0\u884c<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import mysql.connector\nfrom config.settings import *\n\nclass ContentDB:\n    @staticmethod\n    async def create_content(title, content, media, platforms, user_id):\n        conn = mysql.connector.connect(host=DB_HOST, user=DB_USER, password=DB_PASS, database=DB_NAME)\n        cursor = conn.cursor()\n        sql = \"INSERT INTO contents (title, content, media, platforms, user_id, status) VALUES (%s,%s,%s,%s,%s,'pending')\"\n        cursor.execute(sql, (title, content, media, platforms, user_id))\n        conn.commit()\n        return cursor.lastrowid\n\n    @staticmethod\n    async def get_content(content_id):\n        conn = mysql.connector.connect(host=DB_HOST, user=DB_USER, password=DB_PASS, database=DB_NAME)\n        cursor = conn.cursor(dictionary=True)\n        cursor.execute(\"SELECT * FROM contents WHERE id=%s\", (content_id,))\n        return cursor.fetchone()\n\n    @staticmethod\n    async def update_status(content_id, status, error=None):\n        conn = mysql.connector.connect(host=DB_HOST, user=DB_USER, password=DB_PASS, database=DB_NAME)\n        cursor = conn.cursor()\n        cursor.execute(\"UPDATE contents SET status=%s, error=%s WHERE id=%s\", (status, error, content_id))\n        conn.commit()\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">6. FastAPI \u63a5\u53e3 api\/main.py<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">python<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u8fd0\u884c<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>from fastapi import FastAPI, UploadFile, File\nfrom core.scheduler import TaskScheduler\nfrom core.db import ContentDB\nfrom core.ai_optimizer import AIOptimizer\n\napp = FastAPI(title=\"Social Media Scheduler\")\nscheduler = TaskScheduler()\n\n@app.on_event(\"startup\")\ndef startup():\n    scheduler.start()\n\n@app.post(\"\/create\")\nasync def create_content(title: str, content: str, platforms: list, publish_time: str = None):\n    \"\"\"\u521b\u5efa\u5185\u5bb9+\u5b9a\u65f6\u4efb\u52a1\"\"\"\n    # AI\u4f18\u5316\n    optimized = await AIOptimizer.optimize(title, content, platforms)\n    # \u5165\u5e93\n    content_id = await ContentDB.create_content(\n        title=optimized&#91;\"title\"],\n        content=optimized&#91;\"content\"],\n        media=\"\",\n        platforms=\",\".join(platforms),\n        user_id=1\n    )\n    # \u5b9a\u65f6\u4efb\u52a1\n    if publish_time:\n        from datetime import datetime\n        dt = datetime.fromisoformat(publish_time)\n        scheduler.add_once_task(content_id, platforms, dt)\n    return {\"content_id\": content_id, \"optimized\": optimized}\n\n@app.get(\"\/tasks\")\nasync def get_tasks():\n    \"\"\"\u83b7\u53d6\u6240\u6709\u4efb\u52a1\"\"\"\n    return await ContentDB.get_all()\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">7. AI \u4f18\u5316\u6a21\u5757 core\/ai_optimizer.py<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">python<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u8fd0\u884c<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>from transformers import pipeline\n\nclass AIOptimizer:\n    @staticmethod\n    async def optimize(title, content, platforms):\n        \"\"\"AI\u6539\u5199+\u6807\u7b7e+\u9002\u914d\"\"\"\n        generator = pipeline(\"text-generation\", model=\"gpt2\")\n        # \u6807\u9898\u4f18\u5316\n        new_title = generator(title, max_length=20)&#91;0]&#91;\"generated_text\"]\n        # \u6b63\u6587\u4f18\u5316\n        new_content = generator(content, max_length=200)&#91;0]&#91;\"generated_text\"]\n        # \u6807\u7b7e\u751f\u6210\n        tags = &#91;\"#\u7206\u6b3e\", \"#\u79cd\u8349\", \"#\u70ed\u95e8\"]\n        return {\"title\": new_title, \"content\": new_content, \"tags\": tags}\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">8. \u524d\u7aef Vue \u770b\u677f\uff08\u7b80\u5316\uff09<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">vue<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;template&gt;\n  &lt;div&gt;\n    &lt;h2&gt;\u5185\u5bb9\u6392\u671f\u65e5\u5386&lt;\/h2&gt;\n    &lt;el-calendar v-model=\"date\"&gt;\n      &lt;template #date-cell=\"{ data }\"&gt;\n        &lt;div v-for=\"task in getTasks(data.day)\" :key=\"task.id\"&gt;\n          &lt;el-tag&gt;{{ task.title }}&lt;\/el-tag&gt;\n        &lt;\/div&gt;\n      &lt;\/template&gt;\n    &lt;\/el-calendar&gt;\n  &lt;\/div&gt;\n&lt;\/template&gt;\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">9. \u542f\u52a8\u5165\u53e3 main.py<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">python<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u8fd0\u884c<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import uvicorn\nfrom api.main import app\n\nif __name__ == \"__main__\":\n    uvicorn.run(app, host=\"0.0.0.0\", port=8000)\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u4e03\u3001\u5b9e\u6218\u6d41\u7a0b\uff085 \u6b65\u5168\u81ea\u52a8\uff09<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\u7edf\u4e00\u521b\u4f5c<\/strong>\uff1a\u7f16\u8f91\u5668\u5199\u6587\u6848\u3001\u4f20\u56fe \/ \u89c6\u9891\u3001\u52a0\u6807\u7b7e<\/li>\n\n\n\n<li><strong>AI \u4f18\u5316<\/strong>\uff1a\u4e00\u952e\u751f\u6210\u6700\u4f73\u6807\u9898\u3001\u6587\u6848\u3001\u6807\u7b7e\u3001\u5c01\u9762<\/li>\n\n\n\n<li><strong>\u9009\u62e9\u5e73\u53f0<\/strong>\uff1a\u52fe\u9009\u6296\u97f3 \/ \u5c0f\u7ea2\u4e66 \/ B \u7ad9 \/ \u5fae\u535a\u7b49<\/li>\n\n\n\n<li><strong>\u5b9a\u65f6\u6392\u671f<\/strong>\uff1a\u65e5\u5386\u62d6\u62fd\u9009\u65f6\u95f4\u3001AI \u63a8\u8350\u6700\u4f73\u53d1\u5e03\u70b9<\/li>\n\n\n\n<li><strong>\u81ea\u52a8\u53d1\u5e03<\/strong>\uff1a\u5230\u70b9\u81ea\u52a8\u53d1\u3001\u5931\u8d25\u91cd\u8bd5\u3001\u72b6\u6001\u5b9e\u65f6\u66f4\u65b0<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">\u516b\u3001OpenClaw \u5168\u751f\u6001\u8054\u52a8<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Stock Monitor<\/strong>\uff1a\u793e\u5a92\u8206\u60c5\u2192\u80a1\u7968\u76d1\u63a7\u2192\u5173\u8054\u544a\u8b66<\/li>\n\n\n\n<li><strong>Agent Browser<\/strong>\uff1a\u81ea\u52a8\u767b\u5f55\u3001\u53d1\u5e03\u622a\u56fe\u3001\u5f02\u5e38\u622a\u56fe<\/li>\n\n\n\n<li><strong>AI \u5206\u6790<\/strong>\uff1a\u7206\u6b3e\u5185\u5bb9\u5206\u6790\u3001\u6807\u7b7e\u4f18\u5316\u3001\u53d1\u5e03\u65f6\u95f4\u9884\u6d4b<\/li>\n\n\n\n<li><strong>\u544a\u8b66\u63a8\u9001<\/strong>\uff1a\u53d1\u5e03\u5931\u8d25\u3001\u9650\u6d41\u3001\u7206\u6b3e\u5b9e\u65f6\u901a\u77e5<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u4e5d\u3001\u4e8c\u5f00\u62d3\u5c55\u65b9\u5411<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>AI \u7206\u6b3e\u9884\u6d4b<\/strong>\uff1a\u9884\u6d4b\u5185\u5bb9\u7206\u706b\u6982\u7387\u3001\u63d0\u524d\u4f18\u5316<\/li>\n\n\n\n<li><strong>\u591a\u8bed\u8a00\u7ffb\u8bd1<\/strong>\uff1a\u4e00\u952e\u7ffb\u8bd1\u6210\u82f1\u6587 \/ \u65e5\u6587 \/ \u97e9\u6587\uff0c\u9002\u914d\u6d77\u5916\u5e73\u53f0<\/li>\n\n\n\n<li><strong>\u8bc4\u8bba\u81ea\u52a8\u56de\u590d<\/strong>\uff1aAI \u81ea\u52a8\u56de\u590d\u8bc4\u8bba\u3001\u79c1\u4fe1\u3001\u7ef4\u62a4\u4e92\u52a8<\/li>\n\n\n\n<li><strong>\u77ed\u89c6\u9891\u526a\u8f91<\/strong>\uff1aAI \u81ea\u52a8\u526a\u8f91\u3001\u5b57\u5e55\u3001\u914d\u4e50\u3001\u5c01\u9762<\/li>\n\n\n\n<li><strong>\u6570\u636e\u770b\u677f<\/strong>\uff1a\u5168\u5e73\u53f0\u6570\u636e\u7edf\u4e00\u53ef\u89c6\u5316\u3001ROI \u5206\u6790<\/li>\n\n\n\n<li><strong>\u767d\u540d\u5355 \/ \u98ce\u63a7<\/strong>\uff1a\u8d26\u53f7\u5206\u7ea7\u3001\u9650\u6d41\u4fdd\u62a4\u3001\u9632\u5c01\u7981<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>\u4e00\u3001\u6838\u5fc3\u5b9a\u4f4d Social Media Scheduler\uff08\u793e\u5a92\u8c03\u5ea6\u5668\uff09\uff1a\u4e00\u6b21\u7f16\u8f91\u3001\u591a\u5e73\u53f0\u9002\u914d\u3001\u5b9a\u65f6\u53d1\u5e03\u3001\u65e5\u5386 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[],"class_list":["post-289","post","type-post","status-publish","format-standard","hentry","category-mianfeiercikaifalongxiaskill"],"_links":{"self":[{"href":"https:\/\/www.longxiapro.com\/index.php\/wp-json\/wp\/v2\/posts\/289","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.longxiapro.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.longxiapro.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.longxiapro.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.longxiapro.com\/index.php\/wp-json\/wp\/v2\/comments?post=289"}],"version-history":[{"count":1,"href":"https:\/\/www.longxiapro.com\/index.php\/wp-json\/wp\/v2\/posts\/289\/revisions"}],"predecessor-version":[{"id":290,"href":"https:\/\/www.longxiapro.com\/index.php\/wp-json\/wp\/v2\/posts\/289\/revisions\/290"}],"wp:attachment":[{"href":"https:\/\/www.longxiapro.com\/index.php\/wp-json\/wp\/v2\/media?parent=289"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.longxiapro.com\/index.php\/wp-json\/wp\/v2\/categories?post=289"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.longxiapro.com\/index.php\/wp-json\/wp\/v2\/tags?post=289"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}