search

carleton-cs-energy-analytics / energy-analytics-comps

Revolutionizing the way Carleton notices that a building is being heated/cooled simultaneously!
1 stars 0 forks source link

Can now post to api with data #46

Closed jacklightbody closed 6 years ago

jacklightbody commented 6 years ago

Lets you post to the api with Siemens csv files, and refactors Siemens readers to use streams which should reduce file interaction overhead.

Example query: curl -i -X POST http://energycomps.its.carleton.edu/api/index.php/values/Hulings/siemens -H "Content-Type: text/xml" --data-binary "@path/to/csv/file"

jacklightbody commented 6 years ago

Sample spreadsheet that runs quickly to demo: https://docs.google.com/spreadsheets/d/1JUIqE4Efgdi7YHrOyw5ZeAONuTUunL8GsOuA-urbQbU/edit#gid=1444208002 Verify inserted with select * from pointvalues where PointTimestamp < '2016-10-15'; Delete with delete from pointvalues where PointTimestamp < '2016-10-15';