Keep postgres code for adding datasets to the database
Opened this issue · 2 comments
A few issues to address here:
- Instructions for setting up citygram to develop locally are great, except that there's no data--there are no endpoints to subscribe to, and no fixtures to load data from.
- Instructions for manually adding data are hidden in the wiki, aren't complete (how to run commands in the console? What database to connect to?), and don't work (when I copy the given command into
psql, I get a syntax error. - When creating a pull request to add a new city or feed, people aren't specifying their postgres code.
I suggest:
- Add better documentation to installation
- Keep a set of database commands that can be run, to add endpoints.
- Require users to submit a pull request of such a command (it's so easy, with a good example).
I'm looking for two things here: (1) Help on getting some data in my database (so I can properly test things for San Diego), and (2) Improving the experience for future developers who are clueless like me :)
@bcipolli I love all the ideas in this ticket, but my own time is pretty limited as I'm fighting fires in eleven cities in my spare time.
rake publishers:download exists, which can get you some publisher data, and rake publishers:update will update it to give you some data. Where would be a reasonable place to add them?
Understood. Perhaps I can help out? I don't know Ruby, but I know Django and I believe the concepts are similar.
That sounds reasonable to me. If you want, you can assign this issue to me.