| 1 | #!/bin/bash | ||
| 2 | #dotcloud postinstall | ||
| 3 | |||
| 4 | curl http://s3-ap-southeast-1.amazonaws.com/busresources/cbrfeed.zip \ | ||
| 5 | -o /home/dotcloud/current/cbrfeed.zip | ||
| 6 | |||
| 7 | #db setup | ||
| 8 | #curl https://github.com/maxious/ACTBus-ui/raw/master/transitdata.cbrfeed.sql.gz -o transitdata.cbrfeed.sql.gz | ||
| 9 | #curl https://github.com/maxious/ACTBus-ui/raw/master/lib/postgis.sql -o postgis.sql | ||
| 10 | #createlang -d transitdata plpgsql | ||
| 11 | #psql -d transitdata -f postgis.sql | ||
| 12 | #gunzip /var/www/transitdata.cbrfeed.sql.gz | ||
| 13 | #psql -d transitdata -f transitdata.cbrfeed.sql | ||
| 14 | #createuser transitdata -SDRP | ||
| 15 | #password transitdata | ||
| 16 | #psql -c \"GRANT SELECT ON TABLE agency,calendar,calendar_dates,routes,stop_times,stops,trips TO transitdata;\" | ||
| 17 |