search

lhayhurst / xwlists

A web site to track X-Wing Miniature Combat lists.
http://lists.starwarsclubhouse.com
MIT License
18 stars 7 forks source link

Full DB Dump #69

Closed JGailor closed 8 years ago

JGailor commented 8 years ago

I was wondering if we could get a full database dump into a single file. There's some problems loading the full dataset/schema from dbs/prod.sql (missing tables, etc). It would be really helpful for running locally.

lhayhurst commented 8 years ago

hey there, I have a hourly cron job that dumps the database to the following end point: starwarsclubhouse.com/static/prod.sql

in addition I've just pushed that fill out to the dbs/prod.sql

please let me know if there is any assistance I can provide on navigating the schema. I do most of my work in sql alchemy but occasionally use the sql. there is a (slightly out of date) schema visualization in dbs/lists.png

JGailor commented 8 years ago

Ah, this is super useful. Thanks so much.

:+1:

lhayhurst commented 8 years ago

I had a bug in my cron job that wasn't pushing the prod dbs into github. this has been fixed. you can still access it via the endpoint too.