Use same interface to allow an upload of a particular allocation run.

ucd-cws / dwrat-app

MIT License

1 stars 0 forks source link

Use same interface to allow an upload of a particular allocation run. #12

Closed qjhart closed 8 years ago

qjhart commented 9 years ago

Can we build a simple interface where an administrator can upload a particular allocation run to the server, so that it is publicly available. I can think of two ways to do this:

We build a postgres function that reads in a CSV, and then build a little script to upload the CSV.
(In the manner that with our new hammer, everything is a nail :) That would cause the submission of one CSV file as a pull request to a data repository. This would allow anyone to sumbit, but requires an additional admin step to approve, and repopulate the DB.

jrmerz commented 9 years ago

Can you send me a sample CSV, I seemed to have lost mine.

qjhart commented 9 years ago

@brmagnuson We need some example allocation files to see about admining this drought-app.

brmagnuson commented 9 years ago

Am requesting these; will get them to you shortly.

brmagnuson commented 9 years ago

Sent you an example; let me know if you need more examples or anything else.

jrmerz commented 9 years ago

@qjhart is the calvindb repo (bitbucket) up to date and where I can find the latest code for the postgres calvin instance? I want to make sure I am up to speed before I comment further.

qjhart commented 9 years ago

@jrmerz, the current drought stuff was integared directly in the calvindb bitbuck account, because originally there was some notion that they woud be together, but I don't think that's the case, and I think we can probably seperate it. I wonder why not move it all to this repo?

jrmerz commented 9 years ago

@qjhart what about moving to a data repo with csv files and sqlite backend as we have talked about before? Both checked into repo. Then all data is public and query-able. Only issue would be if using pull requests is too complex. Could there be a simpler way to add/update csv's?

brmagnuson commented 9 years ago

Just checking in on the status of this. The State Board is starting to murmur about getting started on porting the website over to their side rather than perpetually maintaining it at Davis, which I believe was the intent all along. I said you guys had some improvements you still wanted to make (mainly this issue) and I would check in and see how it was going.

qjhart commented 9 years ago

Yes, I've copied some of this over to #15 , so we can discuss moving the service to SWRCB.