dmagda/movies_recommendations_snippet.md

## movies_recommendations_snippet.md

      
    Raw
  

              movies_recommendations_snippet.md
            
          
    "Movies Recommendations"
client.sql(
    "SELECT id, title, overview, vote_average " +
    "FROM movie WHERE vote_average >= 7 " +
    "AND genres @> \'[{\"name\": \"Science Fiction\"}]\'" +
    "AND 1 - (overview_vector <=> :prompt_vector::vector) >= 0.7 " +
    "ORDER BY overview_vector <=> :prompt_vector::vector LIMIT 3")
    .param("prompt_vector", promptEmbedding.toString())
    .query(Movie.class).list();