Skip to content

(feat): Added clustered recs to vitess db and added repository #2364

Fausto Arcidiacono requested to merge feat/vitess-cluster-recs-2364 into master

Ticket(s) / Related Merge Requests

#2364 (closed)

Summary of Changes

Added clustered recs table to Vitess and created repository to query data from it

Testing Considerations

  • The cUrl request below will return a list of recommendations without accounting for demoting the score of seen entities. The order of the entities returned should be:
    1. 1074399905432211457
    2. 1317481353725349902
curl --location --request GET 'https://feat-vitess-cluster-recs-2364.minds.io/api/v3/newsfeed/feed/clustered-recommendations?limit=100' \
--header 'X-XSRF-TOKEN: 404ef0fd6390db70c77ca3e5c277e70e2a8dc3d1bbed80dfb9d7328b7c8cc0c23edaa20e2bc1ddd1784d53bf800be2acaf3ddbea324f5ffe23ed3a991f82fd72' \
--header 'Cookie: socket_jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJndWlkIjoiMTI5NDY1MTg5OTEzMTIwMzYwNCIsImV4cGlyZXMiOjE2NTk2MDk3MTQsInNlc3Npb25JZCI6IjczMGIwYzY3MGI0YTc2NWU0YmE0MjM0MTcxNzdmMzBhOGM2YjViYTUzYjhjYmM3YmY4ZThiMWU1OWViZDBlMTdiOTZjNDMwYmZkYTljNWQ2NWM1YmRmYTBmYTczMmMyMjVjMGRmNDJiNDYzOWEzNzQ2OTY5MDBjMjU4NjBiNjg1In0.Mn7ZjLStCQXinxosbBFqcCWamla1twQ1813sNUANZ5A; XSRF-TOKEN=ffb99b0a73980818980f7752f7153ca17e7869055b2139fb59f509eee19645eab75f9be6a66342086b80b3ca98716325bb6fab86dd84469913adf4226e86e52c; canary=0; experiments_id=exp-62eb9023f10d28.67668115; hl=en; minds-traefik-engine=http://192.168.161.154:80; minds_pseudoid=wojkqixmpusfqf5unwyyhw; minds_sess=eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzUxMiIsImp0aSI6IjczMGIwYzY3MGI0YTc2NWU0YmE0MjM0MTcxNzdmMzBhOGM2YjViYTUzYjhjYmM3YmY4ZThiMWU1OWViZDBlMTdiOTZjNDMwYmZkYTljNWQ2NWM1YmRmYTBmYTczMmMyMjVjMGRmNDJiNDYzOWEzNzQ2OTY5MDBjMjU4NjBiNjg1In0.eyJqdGkiOiI3MzBiMGM2NzBiNGE3NjVlNGJhNDIzNDE3MTc3ZjMwYThjNmI1YmE1M2I4Y2JjN2JmOGU4YjFlNTllYmQwZTE3Yjk2YzQzMGJmZGE5YzVkNjVjNWJkZmEwZmE3MzJjMjI1YzBkZjQyYjQ2MzlhMzc0Njk2OTAwYzI1ODYwYjY4NSIsImV4cCI6MTY2MjE5NzAxNC41MTQwODIsInVzZXJfZ3VpZCI6IjEyOTQ2NTE4OTkxMzEyMDM2MDQifQ.dd3d45PLHsrDlbPtTQIJmFeAUZuQ6UhjF6dk8pTIp_jIgdpt00xlbPHV--VDxteutWDKWFHIAmwgH_GLXYpLvBCwEq9-TAvaWR2tazZWGqnaoe1AYsT_8hUEvORWQMnvk7V95EhTtpQ4U6IjTvOIiI9uJTF4MOQ9j0_7ICM3bYEaCOIhN8MJyB-FnzEIl4UbRSR1PfYpH_XDkrSa7yP3bv61F_bLeVHdZJMlLmmsu0wnH-nXGi_Js5_1S4DuSAUUjdytNKlggMiTEzMTnyBvxodYPU6-dHlDlAviEtd8vHYvSAcFqFEzlI6s3WLeaWXIxRZGrAAGCVIfplC3Gs3roXyk2yQNB_LSkbgbdUJfittDzjSJ-tL8RaRm7eSJMVEWWEn40IHXKoQY-upxHZkFDNnm2qhbkq9O87jOibgL2SLEXltjk-eWHKk8B94WEVE8Fn0AsluRI1sZfRqQr1cBwJPbWkEnP8UuSL3fiDAJF_gpH_eBAYVpJ7K2vJnR1KPownofgMmJ8Sd_e3nSbIkeIucDD_3KQhCq3NmmudPLEp6sSStTk_zc1vqXbhWrmK7ETSZTXmCfoFwg_323jOneFnetmWGhsSVhK5zaUIzAk2nR7UERka2dAxUSySrCquKTeTKuvttWOSTMAYX8-RXWMyWs1Y3ZduAyvm1LxsUcNIE'
  • The cUrl request below will return a list of recommendations accounting for demoting the score of seen entities. The order of the entities returned should be:
    1. 1317481353725349902
    2. 1074399905432211457
curl --location --request GET 'https://feat-vitess-cluster-recs-2364.minds.io/api/v3/newsfeed/feed/clustered-recommendations?limit=100&unseen=1' \
--header 'X-XSRF-TOKEN: 404ef0fd6390db70c77ca3e5c277e70e2a8dc3d1bbed80dfb9d7328b7c8cc0c23edaa20e2bc1ddd1784d53bf800be2acaf3ddbea324f5ffe23ed3a991f82fd72' \
--header 'Cookie: socket_jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJndWlkIjoiMTI5NDY1MTg5OTEzMTIwMzYwNCIsImV4cGlyZXMiOjE2NTk2MDg3MzIsInNlc3Npb25JZCI6IjczMGIwYzY3MGI0YTc2NWU0YmE0MjM0MTcxNzdmMzBhOGM2YjViYTUzYjhjYmM3YmY4ZThiMWU1OWViZDBlMTdiOTZjNDMwYmZkYTljNWQ2NWM1YmRmYTBmYTczMmMyMjVjMGRmNDJiNDYzOWEzNzQ2OTY5MDBjMjU4NjBiNjg1In0.62JGP5xNU33k9VFrQVZdeYXvdAbsBNXIzhd5qmdGiQE; XSRF-TOKEN=ffb99b0a73980818980f7752f7153ca17e7869055b2139fb59f509eee19645eab75f9be6a66342086b80b3ca98716325bb6fab86dd84469913adf4226e86e52c; canary=0; experiments_id=exp-62eb9023f10d28.67668115; hl=en; minds-traefik-engine=http://192.168.161.154:80; minds_pseudoid=wojkqixmpusfqf5unwyyhw; minds_sess=eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzUxMiIsImp0aSI6IjczMGIwYzY3MGI0YTc2NWU0YmE0MjM0MTcxNzdmMzBhOGM2YjViYTUzYjhjYmM3YmY4ZThiMWU1OWViZDBlMTdiOTZjNDMwYmZkYTljNWQ2NWM1YmRmYTBmYTczMmMyMjVjMGRmNDJiNDYzOWEzNzQ2OTY5MDBjMjU4NjBiNjg1In0.eyJqdGkiOiI3MzBiMGM2NzBiNGE3NjVlNGJhNDIzNDE3MTc3ZjMwYThjNmI1YmE1M2I4Y2JjN2JmOGU4YjFlNTllYmQwZTE3Yjk2YzQzMGJmZGE5YzVkNjVjNWJkZmEwZmE3MzJjMjI1YzBkZjQyYjQ2MzlhMzc0Njk2OTAwYzI1ODYwYjY4NSIsImV4cCI6MTY2MjE5NzAxNC41MTQwODIsInVzZXJfZ3VpZCI6IjEyOTQ2NTE4OTkxMzEyMDM2MDQifQ.dd3d45PLHsrDlbPtTQIJmFeAUZuQ6UhjF6dk8pTIp_jIgdpt00xlbPHV--VDxteutWDKWFHIAmwgH_GLXYpLvBCwEq9-TAvaWR2tazZWGqnaoe1AYsT_8hUEvORWQMnvk7V95EhTtpQ4U6IjTvOIiI9uJTF4MOQ9j0_7ICM3bYEaCOIhN8MJyB-FnzEIl4UbRSR1PfYpH_XDkrSa7yP3bv61F_bLeVHdZJMlLmmsu0wnH-nXGi_Js5_1S4DuSAUUjdytNKlggMiTEzMTnyBvxodYPU6-dHlDlAviEtd8vHYvSAcFqFEzlI6s3WLeaWXIxRZGrAAGCVIfplC3Gs3roXyk2yQNB_LSkbgbdUJfittDzjSJ-tL8RaRm7eSJMVEWWEn40IHXKoQY-upxHZkFDNnm2qhbkq9O87jOibgL2SLEXltjk-eWHKk8B94WEVE8Fn0AsluRI1sZfRqQr1cBwJPbWkEnP8UuSL3fiDAJF_gpH_eBAYVpJ7K2vJnR1KPownofgMmJ8Sd_e3nSbIkeIucDD_3KQhCq3NmmudPLEp6sSStTk_zc1vqXbhWrmK7ETSZTXmCfoFwg_323jOneFnetmWGhsSVhK5zaUIzAk2nR7UERka2dAxUSySrCquKTeTKuvttWOSTMAYX8-RXWMyWs1Y3ZduAyvm1LxsUcNIE'

Deployment Considerations

A new table needs to be added to the Vitess DB.

Regression Scope

Platform Affected (web, mobile, etc)

Developer Testing Completed

Screenshots / Screen Recording

Does this impact

  • Localization
  • Dark/light mode
  • Guest mode

Definition of Done Checklist

  • The Acceptance Criteria has been met
  • Code is tested: Testing includes unit/spec, E2E/automated and manual testing
  • Merge requests description has been filled out
Edited by Fausto Arcidiacono

Merge request reports