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