Anonymous column in ipoid has be created as VARBINARY(5)
However as per spurs documentation it is supposed to be a bolean.
AC:
Update anonymous column to in the schema to a boolean match what is in the documentation.
Description
Description
Details
Details
Related Changes in GitLab:
| Title | Reference | Author | Source Branch | Dest Branch | |
|---|---|---|---|---|---|
| Update(schema) anonymous column on tunnels table | repos/mediawiki/services/ipoid!34 | tsepothoabala | T341880 | main |
Related Objects
Related Objects
Event Timeline
Comment Actions
tsepothoabala opened https://gitlab.wikimedia.org/repos/mediawiki/services/ipoid/-/merge_requests/34
Update(schema) anonymous column on tunnels table
Comment Actions
Thanks for this @TThoabala, I've tested the schema change DB with reprod data from T341605 or T339325 and running
docker compose exec web node init-db.js
docker compose exec -e FEED_PATH=./tmp/reprod.json.gz web node import-data.js
I'm getting the following error:
If I'm using reprod data from T339359, I do not get an error but the Anonymous values are "NULL".
Comment Actions
stran merged https://gitlab.wikimedia.org/repos/mediawiki/services/ipoid/-/merge_requests/34
Update(schema) anonymous column on tunnels table
Comment Actions
@TThoabala I did not come across any errors when testing the anonymous column as seen in the screenshots below. The task will be moved to Done. Thanks for all your work!
False
{"as": {}, "client": {"behaviors": [], "concentration": {}, "count": false, "countries": null, "proxies": [], "spread": null, "types": ["DESKTOP"]}, "infrastructure": false, "location": {}, "organization": false, "risks": ["TUNNEL"], "services": [], "tunnels": [{"operator”:”test”z,”type":"VPN","anonymous":false}], "ip": "633f9bba-6d4f-40d5-ba34-f15ac42743d3"}
True
{"as": {}, "client": {"behaviors": [], "concentration": {}, "count": false, "countries": null, "proxies": [], "spread": null, "types": ["DESKTOP"]}, "infrastructure": false, "location": {}, "organization": false, "risks": ["TUNNEL"], "services": [], "tunnels": [{"operator": "True_test", "type":"VPN", "anonymous": true}], "ip": "633f9bba-6d4f-40d5-ba34-f15ac42743d3"}
Null
{"as": {}, "client": {"behaviors": [], "concentration": {}, "count": false, "countries": null, "proxies": [], "spread": null, "types": ["DESKTOP"]}, "infrastructure": false, "location": {}, "organization": false, "risks": ["TUNNEL"], "services": [], "tunnels": [{"operator": "True_Null", "type":"VPN"}], "ip": "633f9bba-6d4f-40d5-ba34-f15ac42743d3"}