- Rewrite GetStyleProfile, FindSimilarUsers, UpsertStyleProfiles SQL queries to use @named parameters instead of positional placeholders - Regenerate sqlc Go files with meaningful parameter names - Update server.go and integration test to use new parameter field names - Fix Similarity int32→float64 type conversion
3 lines
No EOL
261 B
SQL
3 lines
No EOL
261 B
SQL
-- name: GetStyleProfile :one
|
|
SELECT id, user_id, platform, embedding, top_keywords, style_summary, post_count, modified_at, created_at, model_version, schema_version, algorithm_version FROM user_style_profiles
|
|
WHERE user_id = @user_id AND platform = @platform; |