Mercurial > ~darius > hgwebdir.cgi > wh1080
comparison 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 |
comparison
equal
deleted
inserted
replaced
-1:000000000000 | 0:9dab44dcb331 |
---|---|
1 /* | |
2 * Create MySQL config | |
3 * Edit to appropriate values before running. | |
4 * $Id: mkdb,v 1.3 2009/12/20 00:44:15 grog Exp grog $ | |
5 */ | |
6 insert into config | |
7 ( version, /* format version number */ | |
8 latitude, /* In ° */ | |
9 longitude, | |
10 elevation, /* metres */ | |
11 pressure_error, /* difference between actual and real, hPa */ | |
12 poll_interval, | |
13 station_id, /* this is the one we use for the database */ | |
14 address, /* Address to display on web pages */ | |
15 wunderground_station_id, | |
16 wunderground_passwd, | |
17 wunderground_report_interval, /* how many seconds between reports to Wunderground */ | |
18 weatheforyou_station_id, | |
19 weatheforyou_passwd, | |
20 weatherforyou_report_interval, /* how many seconds between reports to Weather for you */ | |
21 website_generation_interval, /* how many seconds between generating PHP header file */ | |
22 db_host, /* database on this host */ | |
23 db_user, /* user ID on host */ | |
24 db_passwd, /* and password */ | |
25 db, /* database name */ | |
26 db_table, /* table */ | |
27 php_header, /* php header file with weather data */ | |
28 comparefile) /* file to compare local weather stations */ | |
29 values ( | |
30 /* version */ 1, /* don't change this */ | |
31 /* latitude */ -37.8185, | |
32 /* longitude */ 143.739473, | |
33 /* elevation */ 340, /* elevation of the station in metres */ | |
34 /* pressure_error */ -13.5, /* offset of pressure measurements, hPa */ | |
35 /* poll_interval */ 60, /* poll once a minute */ | |
36 /* station_id */ "MYID", | |
37 /* address */ "MYADDRESS", | |
38 /* wunderground_station_id */ "MYID", | |
39 /* wunderground_passwd */ "insecure", | |
40 /* wunderground_report_interval */ 300, /* how many seconds between reports to Wunderground */ | |
41 /* weatheforyou_station_id */ "", | |
42 /* weatheforyou_passwd */ "", | |
43 /* weatherforyou_report_interval */ 300, /* how many seconds between reports to Weather for you */ | |
44 /* website_generation_interval */ 60, /* how many seconds between generating PHP header file */ | |
45 /* db_host */ "dereel.lemis.com", | |
46 /* db_user */ "grog", | |
47 /* db_passwd */ "", | |
48 /* db */ "weather", | |
49 /* db_table */ "observations", | |
50 /* php_header */ "/home/grog/public_html/weather/current.php", | |
51 /* comparefile */ "/home/grog/public_html/weather/BoM-compare" | |
52 ); | |
53 | |
54 | |
55 insert into config | |
56 ( version, /* format version number */ | |
57 latitude, /* In ° */ | |
58 longitude, | |
59 elevation, /* metres */ | |
60 pressure_error, /* difference between actual and real, hPa */ | |
61 poll_interval, /* between reading the device */ | |
62 station_id, /* this is the one we use for the database */ | |
63 address, /* Address to display on web pages */ | |
64 wunderground_station_id, | |
65 wunderground_passwd, | |
66 wunderground_report_interval, /* how many seconds between reports to Wunderground */ | |
67 weatheforyou_station_id, | |
68 weatheforyou_passwd, | |
69 weatherforyou_report_interval, /* how many seconds between reports to Weather for you */ | |
70 website_generation_interval, /* how many seconds between generating PHP header file */ | |
71 db_table, /* table */ | |
72 php_header, /* php header file with weather data */ | |
73 comparefile) /* file to compare local weather stations */ | |
74 values ( | |
75 /* version */ 1, /* don't change this */ | |
76 /* latitude */ -37.8185, | |
77 /* longitude */ 143.739473, | |
78 /* elevation */ 340, /* elevation of the station in metres */ | |
79 /* pressure_error */ -13.5, /* offset of pressure measurements, hPa */ | |
80 /* poll_interval */ 60, /* poll once a minute */ | |
81 /* station_id */ "Dereel", | |
82 /* address */ "Dereel, Victoria, Australia", | |
83 /* wunderground_station_id */ "IVICTORI124", | |
84 /* wunderground_passwd */ "breached", | |
85 /* wunderground_report_interval */ 300, /* how many seconds between reports to Wunderground */ | |
86 /* weatheforyou_station_id */ "", | |
87 /* weatheforyou_passwd */ "", | |
88 /* weatherforyou_report_interval */ 300, /* how many seconds between reports to Weather for you */ | |
89 /* website_generation_interval */ 60, /* how many seconds between generating PHP header file */ | |
90 /* db_table */ "observations", | |
91 /* php_header */ "/home/grog/public_html/weather/current.php", | |
92 /* comparefile */ "/home/grog/public_html/weather/BoM-compare", | |
93 ); |