Mercurial > ~darius > hgwebdir.cgi > wh1080
diff db/mkconfig @ 0:9dab44dcb331
Initial commit of Greg's code from http://www.lemis.com/grog/tmp/wh1080.tar.gz
| author | Daniel O'Connor <darius@dons.net.au> |
|---|---|
| date | Tue, 09 Feb 2010 13:44:25 +1030 |
| parents | |
| children |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/db/mkconfig Tue Feb 09 13:44:25 2010 +1030 @@ -0,0 +1,93 @@ +/* + * Create MySQL config + * Edit to appropriate values before running. + * $Id: mkdb,v 1.3 2009/12/20 00:44:15 grog Exp grog $ + */ +insert into config +( version, /* format version number */ + latitude, /* In ° */ + longitude, + elevation, /* metres */ + pressure_error, /* difference between actual and real, hPa */ + poll_interval, + station_id, /* this is the one we use for the database */ + address, /* Address to display on web pages */ + wunderground_station_id, + wunderground_passwd, + wunderground_report_interval, /* how many seconds between reports to Wunderground */ + weatheforyou_station_id, + weatheforyou_passwd, + weatherforyou_report_interval, /* how many seconds between reports to Weather for you */ + website_generation_interval, /* how many seconds between generating PHP header file */ + db_host, /* database on this host */ + db_user, /* user ID on host */ + db_passwd, /* and password */ + db, /* database name */ + db_table, /* table */ + php_header, /* php header file with weather data */ + comparefile) /* file to compare local weather stations */ +values ( + /* version */ 1, /* don't change this */ + /* latitude */ -37.8185, + /* longitude */ 143.739473, + /* elevation */ 340, /* elevation of the station in metres */ + /* pressure_error */ -13.5, /* offset of pressure measurements, hPa */ + /* poll_interval */ 60, /* poll once a minute */ + /* station_id */ "MYID", + /* address */ "MYADDRESS", + /* wunderground_station_id */ "MYID", + /* wunderground_passwd */ "insecure", + /* wunderground_report_interval */ 300, /* how many seconds between reports to Wunderground */ + /* weatheforyou_station_id */ "", + /* weatheforyou_passwd */ "", + /* weatherforyou_report_interval */ 300, /* how many seconds between reports to Weather for you */ + /* website_generation_interval */ 60, /* how many seconds between generating PHP header file */ + /* db_host */ "dereel.lemis.com", + /* db_user */ "grog", + /* db_passwd */ "", + /* db */ "weather", + /* db_table */ "observations", + /* php_header */ "/home/grog/public_html/weather/current.php", + /* comparefile */ "/home/grog/public_html/weather/BoM-compare" +); + + +insert into config +( version, /* format version number */ + latitude, /* In ° */ + longitude, + elevation, /* metres */ + pressure_error, /* difference between actual and real, hPa */ + poll_interval, /* between reading the device */ + station_id, /* this is the one we use for the database */ + address, /* Address to display on web pages */ + wunderground_station_id, + wunderground_passwd, + wunderground_report_interval, /* how many seconds between reports to Wunderground */ + weatheforyou_station_id, + weatheforyou_passwd, + weatherforyou_report_interval, /* how many seconds between reports to Weather for you */ + website_generation_interval, /* how many seconds between generating PHP header file */ + db_table, /* table */ + php_header, /* php header file with weather data */ + comparefile) /* file to compare local weather stations */ +values ( + /* version */ 1, /* don't change this */ + /* latitude */ -37.8185, + /* longitude */ 143.739473, + /* elevation */ 340, /* elevation of the station in metres */ + /* pressure_error */ -13.5, /* offset of pressure measurements, hPa */ + /* poll_interval */ 60, /* poll once a minute */ + /* station_id */ "Dereel", + /* address */ "Dereel, Victoria, Australia", + /* wunderground_station_id */ "IVICTORI124", + /* wunderground_passwd */ "breached", + /* wunderground_report_interval */ 300, /* how many seconds between reports to Wunderground */ + /* weatheforyou_station_id */ "", + /* weatheforyou_passwd */ "", + /* weatherforyou_report_interval */ 300, /* how many seconds between reports to Weather for you */ + /* website_generation_interval */ 60, /* how many seconds between generating PHP header file */ + /* db_table */ "observations", + /* php_header */ "/home/grog/public_html/weather/current.php", + /* comparefile */ "/home/grog/public_html/weather/BoM-compare", +);