mirror of
https://github.com/memohai/Memoh.git
synced 2026-04-27 07:16:19 +09:00
BBQ
bc374fe8cd
* refactor(attachment): multimodal attachment refactor with snapshot schema and storage layer - Add snapshot schema migration (0008) and update init/versions/snapshots - Add internal/attachment and internal/channel normalize for unified attachment handling - Move containerfs provider from internal/media to internal/storage - Update agent types, channel adapters (Telegram/Feishu), inbound and handlers - Add containerd snapshot lineage and local_channel tests - Regenerate sqlc, swagger and SDK * refactor(media): content-addressed asset system with unified naming - Replace asset_id foreign key with content_hash as sole identifier for bot_history_message_assets (pure soft-link model) - Remove mime, size_bytes, storage_key from DB; derive at read time via media.Resolve from actual storage - Merge migrations 0008/0009 into single 0008; keep 0001 as canonical schema - Add Docker initdb script for deterministic migration execution order - Fix cross-channel real-time image display (Telegram → WebUI SSE) - Fix message disappearing on refresh (null assets fallback) - Fix file icon instead of image preview (mime derivation from storage) - Unify AssetID → ContentHash naming across Go, Agent, and Frontend - Change storage key prefix from 4-char to 2-char for directory sharding - Add server-entrypoint.sh for Docker deployment migration handling * refactor(infra): embedded migrations, Docker simplification, and config consolidation - Embed SQL migrations into Go binary, removing shell-based migration scripts - Consolidate config files into conf/ directory (app.example.toml, app.docker.toml, app.dev.toml) - Simplify Docker setup: remove initdb.d scripts, streamline nginx config and entrypoint - Remove legacy CLI, feishu-echo commands, and obsolete incremental migration files - Update install script and docs to require sudo for one-click install - Add mise tasks for dev environment orchestration * chore: recover migrations --------- Co-authored-by: Acbox <acbox0328@gmail.com>
64 lines
1.5 KiB
SQL
64 lines
1.5 KiB
SQL
-- name: UpsertSnapshot :one
|
|
INSERT INTO snapshots (
|
|
container_id,
|
|
runtime_snapshot_name,
|
|
parent_runtime_snapshot_name,
|
|
snapshotter,
|
|
source
|
|
)
|
|
VALUES (
|
|
sqlc.arg(container_id),
|
|
sqlc.arg(runtime_snapshot_name),
|
|
sqlc.arg(parent_runtime_snapshot_name),
|
|
sqlc.arg(snapshotter),
|
|
sqlc.arg(source)
|
|
)
|
|
ON CONFLICT (container_id, runtime_snapshot_name) DO UPDATE
|
|
SET
|
|
parent_runtime_snapshot_name = EXCLUDED.parent_runtime_snapshot_name,
|
|
snapshotter = EXCLUDED.snapshotter,
|
|
source = EXCLUDED.source
|
|
RETURNING id, container_id, runtime_snapshot_name, parent_runtime_snapshot_name, snapshotter, source, created_at;
|
|
|
|
-- name: ListSnapshotsByContainerID :many
|
|
SELECT
|
|
id,
|
|
container_id,
|
|
runtime_snapshot_name,
|
|
parent_runtime_snapshot_name,
|
|
snapshotter,
|
|
source,
|
|
created_at
|
|
FROM snapshots
|
|
WHERE container_id = sqlc.arg(container_id)
|
|
ORDER BY created_at DESC;
|
|
|
|
-- name: ListSnapshotsWithVersionByContainerID :many
|
|
SELECT
|
|
s.id,
|
|
s.container_id,
|
|
s.runtime_snapshot_name,
|
|
s.parent_runtime_snapshot_name,
|
|
s.snapshotter,
|
|
s.source,
|
|
s.created_at,
|
|
cv.version
|
|
FROM snapshots s
|
|
LEFT JOIN container_versions cv ON cv.snapshot_id = s.id
|
|
WHERE s.container_id = sqlc.arg(container_id)
|
|
ORDER BY s.created_at DESC;
|
|
|
|
-- name: GetSnapshotByContainerAndRuntimeName :one
|
|
SELECT
|
|
id,
|
|
container_id,
|
|
runtime_snapshot_name,
|
|
parent_runtime_snapshot_name,
|
|
snapshotter,
|
|
source,
|
|
created_at
|
|
FROM snapshots
|
|
WHERE container_id = sqlc.arg(container_id)
|
|
AND runtime_snapshot_name = sqlc.arg(runtime_snapshot_name)
|
|
LIMIT 1;
|