get5loader icon indicating copy to clipboard operation
get5loader copied to clipboard

Published 20 hours ago • verified publisher icon FlowingSPDG

[API/DB] Use delimitted string insted of pickled Py array for team auths on DB

Open FlowingSPDG opened this issue 5 years ago • 4 comments

https://github.com/splewis/get5-web/issues/175 I need to create migration files and support back-compatiblity

FlowingSPDG avatar Dec 29 '19 03:12 FlowingSPDG

I've added new column steamids on team table. this should be comma-separeted strings like this : "76561198192393190,76561198072054549,76561198261049877"

API should try to find steamids first,and if its empty(NULL), try to find auths which is old one. New team registration and edit should push both of auths and steamids for back compatibility.

FlowingSPDG avatar Feb 15 '20 21:02 FlowingSPDG

Supported "steamids" writing. "steamids" READING will implemented more late stable version(to hold compatibility).

FlowingSPDG avatar Feb 16 '20 06:02 FlowingSPDG

Basically using arrays with MySQL is not good design. So I probably need to think about other DB system such as Mongo.

FlowingSPDG avatar Apr 29 '20 19:04 FlowingSPDG

...or, I can add new table like "player" and let it contain ID(pk),steamid,teamid information so it won't be array anymore

FlowingSPDG avatar May 03 '20 02:05 FlowingSPDG

Refactor table with non-get5-compatible table schema.

FlowingSPDG avatar Aug 04 '23 12:08 FlowingSPDG