games-development-ai/game-cloud/scripts/p3bB_scaffold_gen9304.sql
zizi c99014c243 test(aigc-3b-B): 派发面 e2e 真证安全面+全自动管线闭合(HMAC双向),P5 生成质量转 L1
3b-B e2e(mini-desktop 真跑·证据 wg1/gen-worker/evidence-3bB/):

 P0-P4 安全面+全自动管线=真证闭合(铁证 backend-callback-hmac.log + p4*.txt):
- HMAC 双向证:缺签名头→HTTP 401 / 错签(deadbeef≠482147b5)→HTTP 401 / 正签→过门(走到下游"任务不存在"非401)
  =关死 /dify/callback-internal 裸 @PermitAll 缺口
- 全自动派发链真通:执行器认领 taskId→dispatchGeneric 投 §6.1 job→worker 真生成(真烧模型)→
  HMAC 签名回调→验签通过→handleCallback 落库(gen-9303/9304/9305 三轮齐全)

 P5 一句话真生成=未达终局:三款全 nine_gate_failed。但截图(gen-9303-after-play.png)证生成
  真出 on-theme 可渲可动的「点击小怪物」游戏(Score/3s 倒计时/多彩怪物 monsters/targetScore=12),
  仅点击→计分坏(Score 仍 0)→九门确定性地板正确拦截「看着像但玩不了」=质量门正确履职、拒发不可玩。

判:L0 交付(管线+安全+质量门)已完成且证;缺=便宜模型把「点击命中→计分」写对=L1 生成域
  (prompt 点击坑+模型档+player/calibration,run_studio 自修 max_repairs 未救回)→转 L1 v3 迭代。

附带:serve-and-play.sh 跨平台 Chrome 探测(CHROME_BIN 覆盖>Linux /usr/bin>macOS>PATH 兜底,
  Linux 在前因 mini-desktop x86 是权威 e2e 机);p3bB_*.sql 发布四态/翻 feed 桩。

Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
2026-06-14 16:20:28 +00:00

44 lines
2.6 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

USE `ruoyi-vue-pro`;
SET NAMES utf8mb4;
START TRANSACTION;
DELETE FROM game_aigc_task WHERE trace_id = 'wg1-3bB-gen9304-001';
DELETE FROM game_feed_rank WHERE game_id = 9304;
DELETE FROM game_runtime_package WHERE game_id = 9304;
DELETE FROM game_version WHERE game_id = 9304;
DELETE FROM game_project WHERE id = 9304;
INSERT INTO game_project
(id, creator_user_id, title, summary, cover_url, tags, template_id, age_rating,
status, current_version_id, launch_zone_id, featured, play_count, like_count,
creator, create_time, updater, update_time, deleted, tenant_id)
VALUES
(9304, 1, '接球弹球(generic 真生成·回调入feed)', 'P3 3b-B 派发面终局 e2e一句话创意经 worker 真生成过九门,回调携 engineBundle 入 feed',
'data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==',
'P3,3b-B,dispatch,generic,real-gen', 'generic', 'all',
4, 93040, NULL, b'0', 0, 0, '0', NOW(), '0', NOW(), b'0', 0);
INSERT INTO game_version
(id, game_id, version_no, gen_task_id, package_url, bundle_size, checksum,
status, creator, create_time, updater, update_time, deleted, tenant_id)
VALUES (93040, 9304, 1, NULL, '', 0, '', 3, '0', NOW(), '0', NOW(), b'0', 0);
INSERT INTO game_runtime_package
(id, game_id, version_id, template_id, package_url, entry, runtime_version, preload_policy,
bundle_size, checksum, sandbox_attr, allow_origins, status,
creator, create_time, updater, update_time, deleted, tenant_id, package_json)
VALUES (93040, 9304, 93040, 'generic', '', 'index.html', '1.0.0', 'eager',
0, '', 'allow-scripts', '', 1, '0', NOW(), '0', NOW(), b'0', 0, NULL);
INSERT INTO game_feed_rank
(id, game_id, version_id, zone_id, quality_score, boost, sort_score, pinned, status,
creator, create_time, updater, update_time, deleted, tenant_id)
VALUES (93040, 9304, 93040, 0, 0.0000, 0.0000, 0.0000, 0, 1, '0', NOW(), '0', NOW(), b'0', 0);
INSERT INTO game_aigc_task
(creator_user_id, game_id, version_id, template_id, prompt, prompt_hash,
status, progress, quality_score, failure_reason, result_package_url, retry_of, trace_id,
creator, create_time, updater, update_time, finish_time, deleted, tenant_id)
VALUES
(1, 9304, NULL, 'generic', '左右移动挡板接住不断下落的小球,接住得分,漏球则游戏结束',
'0000000000000000000000000000000000000000000000000000000000000001',
0, 0, NULL, '', '', NULL, 'wg1-3bB-gen9304-001',
'0', NOW(), '0', NOW(), NULL, b'0', 0);
COMMIT;
SELECT 'aigc_task' k, id, status, game_id, template_id, prompt, trace_id
FROM game_aigc_task WHERE trace_id='wg1-3bB-gen9304-001';