Mercurial > garten

annotate weather.c @ 11:176ee28e7464

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
switched from mysql to sqlite; (+ some cleanups)
author meillo@marmaro.de
date Wed, 23 Jul 2008 11:41:38 +0200
parents 9bd0a2100694
children 8db6497d6065
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
3
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
1 #include <stdio.h>
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
2 #include <stdlib.h>
8
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
3 #include <time.h>
3
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
4
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
5 #include "db.h"
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
6 #include "game.h"
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
7
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
8
8
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
9 enum {
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
10 Nlast = 2,
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
11 };
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
12
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
13 enum { Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec };
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
14
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
15 struct weather {
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
16 float temp;
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
17 float sun;
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
18 float rain;
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
19 float wind;
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
20 float hum;
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
21 };
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
22
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
23 float mean_temp[12] = {1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0, 9.0, 10.0, 11.0, 12.0};
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
24 float mean_sun[12] = {1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0, 9.0, 10.0, 11.0, 12.0};
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
25 float mean_rain[12] = {1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0, 9.0, 10.0, 11.0, 12.0};
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
26 float mean_wind[12] = {1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0, 9.0, 10.0, 11.0, 12.0};
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
27 float mean_hum[12] = {1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0, 9.0, 10.0, 11.0, 12.0};
3
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
28
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
29
8
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
30 float rand_limit(float limit) {
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
31 /* generates random number between -limit and +limit */
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
32 int r;
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
33
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
34 r = rand() / ( ((float) RAND_MAX + 1) / (2*limit) );
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
35 return r - limit;
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
36 }
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
37
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
38
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
39
3
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
40
8
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
41 void getlastweather(struct weather lastw[], int nlast) {
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
42 char query[512];
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
43 int i;
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
44
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
45 sprintf(query,
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
46 " select temp, sun, rain, wind, hum from weather "
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
47 " order by tick desc "
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
48 " limit %d "
11
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 8
diff changeset
49 , nlast);
3
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
50 db_query(query);
11
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 8
diff changeset
51 for (i = 0; i < nlast && sqlite3_step(stmt) == SQLITE_ROW; i++) {
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 8
diff changeset
52 lastw[i].temp = sqlite3_column_double(stmt, 0);
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 8
diff changeset
53 lastw[i].sun = sqlite3_column_double(stmt, 1);
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 8
diff changeset
54 lastw[i].rain = sqlite3_column_double(stmt, 2);
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 8
diff changeset
55 lastw[i].wind = sqlite3_column_double(stmt, 3);
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 8
diff changeset
56 lastw[i].hum = sqlite3_column_double(stmt, 4);
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 8
diff changeset
57 }
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 8
diff changeset
58 sqlite3_finalize(stmt);
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 8
diff changeset
59
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 8
diff changeset
60 /*
3
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
61 result = mysql_store_result(conn);
8
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
62 for (i = 0; i < nlast && (row = mysql_fetch_row(result)); i++) {
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
63 lastw[i].temp = atof(row[0]);
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
64 lastw[i].sun = atof(row[1]);
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
65 lastw[i].rain = atof(row[2]);
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
66 lastw[i].wind = atof(row[3]);
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
67 lastw[i].hum = atof(row[4]);
3
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
68 }
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
69 mysql_free_result(result);
11
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 8
diff changeset
70 */
3
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
71
8
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
72 }
3
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
73
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
74
8
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
75 void genweather(struct weather* w, struct weather lastw[], int nlast, int month) {
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
76 w->temp = 0.2 * mean_temp[month] + 0.4 * lastw[0].temp + 0.2 * lastw[1].temp + 0.08 * rand_limit(10); // + 0.02 * rand_limit(100);
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
77 w->sun = 0.2 * mean_sun[month] + 0.4 * lastw[0].sun + 0.2 * lastw[1].sun + 0.08 * rand_limit(10); // + 0.02 * rand_limit(100);
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
78 w->rain = 0.2 * mean_rain[month] + 0.4 * lastw[0].rain + 0.2 * lastw[1].rain + 0.08 * rand_limit(10); // + 0.02 * rand_limit(100);
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
79 w->wind = 0.2 * mean_wind[month] + 0.4 * lastw[0].wind + 0.2 * lastw[1].wind + 0.08 * rand_limit(10); // + 0.02 * rand_limit(100);
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
80 w->hum = 0.2 * mean_hum[month] + 0.4 * lastw[0].hum + 0.2 * lastw[1].hum + 0.08 * rand_limit(10); // + 0.02 * rand_limit(100);
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
81 }
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
82
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
83
11
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 8
diff changeset
84 void setweather(struct weather* w) {
8
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
85 char query[512];
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
86 sprintf(query,
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
87 " insert into weather "
11
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 8
diff changeset
88 " (tick, temp, sun, rain, wind, hum) "
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 8
diff changeset
89 " values ('%d', '%f', '%f', '%f', '%f', '%f') "
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 8
diff changeset
90 , gametime, w->temp, w->sun, w->rain, w->wind, w->hum);
3
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
91 db_query(query);
8
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
92 puts(query);
11
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 8
diff changeset
93 if (sqlite3_step(stmt) == SQLITE_DONE) {
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 8
diff changeset
94 printf("weather successful inserted\n");
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 8
diff changeset
95 } else {
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 8
diff changeset
96 printf("error: weather insertion failed: %s\n", sqlite3_errmsg(db));
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 8
diff changeset
97 }
3
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
98 }
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
99
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
100
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
101 int main(int argc, char* argv[]) {
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
102 printf(" --> weather\n");
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
103
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
104 /* init */
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
105 if (argc != 2) {
11
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 8
diff changeset
106 printf("usage: %s <database>\n", argv[0]);
3
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
107 exit(1);
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
108 }
11
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 8
diff changeset
109 database = argv[1];
3
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
110
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
111 db_connect();
11
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 8
diff changeset
112 read_time();
3
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
113
8
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
114 srand((unsigned int) time(NULL));
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
115
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
116
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
117 struct weather w;
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
118 struct weather lastn[Nlast];
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
119
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
120 getlastweather(lastn, Nlast);
9bd0a2100694 new weather implementation
meillo@marmaro.de
parents: 3
diff changeset
121 genweather(&w, lastn, Nlast, May);
11
176ee28e7464 switched from mysql to sqlite; (+ some cleanups)
meillo@marmaro.de
parents: 8
diff changeset
122 setweather(&w);
3
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
123
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
124 db_close();
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
125
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
126 printf(" --< weather\n");
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
127 return 0;
0c19ad487f02 first weather implementation (static values)
meillo@marmaro.de
parents:
diff changeset
128 }