Create & populate user schema tables in stattrak db via Python - Githubissues

JackWagner / stattrak

Counter-Strike 2 gameplay aggregator and stat collector

0 stars 0 forks source link

Create & populate user schema tables in stattrak db via Python #8

Closed JackWagner closed 10 months ago

JackWagner commented 10 months ago

BACKGROUND

Context: Databases are used to store information for future retrieval. I have created a Postgres DB on AWS RDS and linked to our EC2.
Problem: We need to store user's information, such as their credentials and their Steam ID/game auth/match codes.
Solution: Create tables in the User schema that can store this information. Populate with an example row. Interact via Python.

STEPS:

[x] Write Python to connect to our stattrak db and execute queries
[x] Create some basic user tables
- [x] Research and implement deidentified credentials
- [x] User level with Steam ID, game authorization code, match code
[x] Populate with me as an example