frouioui / tagenal

Tagenal is a playground app using Vitess, Redis, Traefik and Jaeger on Kubernetes
https://frouioui.github.io/tagenal/
MIT License
7 stars 0 forks source link

Integration of new tables #45

Closed frouioui closed 3 years ago

frouioui commented 3 years ago

This PR contains the integration of the following new tables:

To integrate these takes, the data generator python script was modified in order to generate better data fitting the new data model. The previous tables user and article were slightly modified to host more coherent datatypes. For example, the timestamp was changed into a BIGINT, and the previous _id column is replaced by the column. The modifications of the 2 tables were reported to the APIs and Frontend.

The read table contains the computed records for the different actions that a user might have done to a given article. The read table contains auto-generated data from the python script. The inserted record of read table will come populate the be_read table thanks to a VRrep stream. The popularity table is updated according to a cron schedule thanks to a CronJob in the Kubernetes cluster.