Method migrate

pkg/memory/logic/store_postgres.go:65–104

migrate 创建表结构

()

// migrate 创建表结构
func (s *PostgreSQLStore) migrate() error {
	query := fmt.Sprintf(`
		CREATE TABLE IF NOT EXISTS %s (
			id VARCHAR(64) PRIMARY KEY,
			namespace VARCHAR(255) NOT NULL,
			scope VARCHAR(20) NOT NULL,
			type VARCHAR(100) NOT NULL,
			category VARCHAR(100),
			key VARCHAR(255) NOT NULL,
			value JSONB NOT NULL DEFAULT '{}',
			description TEXT,
			source_type VARCHAR(50),
			confidence DECIMAL(5,4) DEFAULT 0,
			sources JSONB DEFAULT '[]',
			provenance_created_at TIMESTAMP,
			provenance_updated_at TIMESTAMP,
			provenance_version INT DEFAULT 0,
			access_count INT DEFAULT 0,
			last_accessed TIMESTAMP,
			metadata JSONB DEFAULT '{}',
			created_at TIMESTAMP NOT NULL DEFAULT NOW(),
			updated_at TIMESTAMP NOT NULL DEFAULT NOW(),
			UNIQUE(namespace, key)
		);

		CREATE INDEX IF NOT EXISTS idx_%s_namespace ON %s(namespace);
		CREATE INDEX IF NOT EXISTS idx_%s_namespace_type ON %s(namespace, type);
		CREATE INDEX IF NOT EXISTS idx_%s_scope ON %s(scope);
		CREATE INDEX IF NOT EXISTS idx_%s_confidence ON %s(confidence);
		CREATE INDEX IF NOT EXISTS idx_%s_last_accessed ON %s(last_accessed);
	`, s.tableName,
		s.tableName, s.tableName,
		s.tableName, s.tableName,
		s.tableName, s.tableName,
		s.tableName, s.tableName,
		s.tableName, s.tableName)

	_, err := s.db.Exec(query)
	return err
}

// Save 保存或更新 Memory
func (s *PostgreSQLStore) Save(ctx context.Context, mem *LogicMemory) error {