dkutin/fantasytracker

Migrate Schemas from MySQL to MongoDB

dkutin opened this issue · 2 comments

dkutin commented

Currently, this project uses a MySQL database to store data. While convenient, acquiring hosting and future improvements are made more difficult.

This task is to migrate all schemas from MySQL to MongoDB, leveraging node.js, and mongoose.

AC:

  • All Schemas in created in the codebase.
  • MongoDB connection set up.
  • PR merged.
philip commented

Curious to try this (attempting to see if a functional PHP tool to access Yahoo's fantasy API exists in the universe); do you have a schema available so we can create the MySQL database?

dkutin commented

@philip It has been quite a while since I took a look at this project (and used it mostly for learning), though I found some information about the schema in the API wrapper I was building. The relevant files can be found below for the player and stats schemas:

https://github.com/dkutin/fantasytracker-api/blob/master/src/api/stat/v1/stat.model.js
https://github.com/dkutin/fantasytracker-api/blob/master/src/api/player/v1/player.model.js

Feel free to take a look. In the meantime, I will try and see if I can find more info about it as well...