抖音采集数据统计

{
  "type": "搞笑",
  "author_id": "123456",
  "video_id": "789012",
  "content": "这是一个搞笑视频"
}

{
  "success": true,
  "message": "添加成功",
  "video_id": "789012"
}

{
  "video_id": "789012",
  "content": "这是一个搞笑视频的文案内容"
}

{
  "success": true,
  "message": "文案内容更新成功",
  "video_id": "789012"
}

{
  "video_id": "789012",
  "video_text": "这是视频中的语音转文字内容..."
}

{
  "success": true,
  "message": "视频文本内容更新成功",
  "video_id": "789012"
}

{
  "video_id": "789012",
  "comments": "评论1\n评论2\n评论3..."
}

{
  "success": true,
  "message": "评论内容更新成功",
  "video_id": "789012"
}

GET /api.php?action=get_empty_content&limit=10&offset=0

{
  "success": true,
  "total": 50,
  "count": 10,
  "data": [
    {
      "video_id": "789012",
      "author_id": "123456",
      "type": "搞笑",
      "created_at": "2024-01-01 12:00:00"
    }
  ]
}

GET /api.php?action=get_empty_video_text&limit=10&offset=0

{
  "success": true,
  "total": 75,
  "count": 10,
  "data": [
    {
      "video_id": "789012",
      "author_id": "123456",
      "type": "搞笑",
      "created_at": "2024-01-01 12:00:00"
    }
  ]
}

GET /api.php?action=get_empty_comments&limit=10&offset=0

{
  "success": true,
  "total": 80,
  "count": 10,
  "data": [
    {
      "video_id": "789012",
      "author_id": "123456",
      "type": "搞笑",
      "created_at": "2024-01-01 12:00:00"
    }
  ]
}

{
  "video_id": "789012",
  "type": "美食",
  "content": "更新后的文案内容"
}

{
  "success": true,
  "message": "更新成功",
  "video_id": "789012",
  "updated_fields": ["type", "content"]
}

{
  "videos": [
    {
      "type": "搞笑",
      "author_id": "123456",
      "video_id": "789012",
      "content": "第一个视频"
    },
    {
      "type": "美食",
      "author_id": "123456",
      "video_id": "789013",
      "content": "第二个视频"
    }
  ]
}

{
  "success": true,
  "message": "批量添加完成",
  "success_count": 2,
  "failed_count": 0,
  "errors": []
}

GET /api.php?action=get&video_id=789012

{
  "success": true,
  "data": {
    "id": 1,
    "author_id": "123456",
    "video_id": "789012",
    "content": "这是一个搞笑视频",
    "video_text": "视频文本内容",
    "comments": "评论内容",
    "type": "搞笑",
    "count": 0,
    "created_at": "2024-01-01 12:00:00",
    "updated_at": "2024-01-01 12:00:00"
  }
}

GET /api.php?action=list&type=搞笑&limit=10&order_by=created_at&order_dir=DESC

{
  "success": true,
  "total": 100,
  "count": 10,
  "data": [
    {
      "id": 1,
      "author_id": "123456",
      "video_id": "789012",
      "content": "这是一个搞笑视频",
      "type": "搞笑",
      "created_at": "2024-01-01 12:00:00"
    }
  ]
}

无需参数

GET /api.php?action=get_stats

{
  "success": true,
  "data": {
    "total_videos": 100,
    "empty_content": 30,
    "empty_video_text": 40,
    "empty_comments": 45,
    "completed_content": 70,
    "completed_video_text": 60,
    "completed_comments": 55,
    "content_progress": 70.00,
    "video_text_progress": 60.00,
    "comments_progress": 55.00
  }
}

{
  "type": "搞笑",
  "video_ids": [
    "123456789",
    "987654321",
    "456789123"
  ]
}

{
  "success": true,
  "message": "批量添加完成",
  "success_count": 3,
  "failed_count": 0,
  "errors": []
}

GET /api.php?action=get_author_ids&type=搞笑&limit=10

{
  "success": true,
  "total": 50,
  "count": 10,
  "data": [
    {
      "id": 1,
      "video_id": "123456789",
      "type": "搞笑",
      "updated_at": "2018-01-01 00:00:00",
      "created_at": "2024-01-01 12:00:00"
    }
  ]
}

POST /api.php?action=get_oldest_author_ids&limit=5

{
  "success": true,
  "message": "获取成功并已更新时间",
  "count": 5,
  "data": [
    {
      "id": 1,
      "video_id": "123456789",
      "type": "搞笑",
      "old_updated_at": "2018-01-01 00:00:00"
    }
  ]
}

• 此接口会自动更新获取到的作者ID的更新时间为当前时间
• 返回的数据中包含 old_updated_at 字段，表示更新前的时间
• 适合用于轮询处理，每次获取最久未处理的作者ID

DELETE /api.php?action=delete_author_id&id=1

{
  "success": true,
  "message": "删除成功"
}

无需参数

GET /api.php?action=get_types

{
  "success": true,
  "data": [
    "搞笑",
    "美食",
    "旅游",
    "音乐"
  ]
}