#include <stdio.h>
#include <stdlib.h>

#include "db.h"
#include "game.h"




void set_environment() {
	int groundwater, slugs, earthworms;

	/* get weather and last environments to calculate the next one *
	sprintf(query, "select time from simulation");
	db_query(query);
	result = mysql_store_result(conn);
	if (mysql_num_rows(result)) {
		row = mysql_fetch_row(result);
		time = atoi(row[0]);
	}
	mysql_free_result(result);
	*/

	groundwater = 20;
	slugs = 5;
	earthworms = 10;


	/* set weather */
	sprintf(query, " insert into environment \
			(tick, groundwater, slugs, earthworms) \
			values ('%d', '%d', '%d', '%d') ",
			gametime, groundwater, slugs, earthworms);
	db_query(query);
	if (sqlite3_step(stmt) == SQLITE_DONE) {
		printf("environment successful inserted\n");
	} else {
		printf("error: environment insertion failed: %s\n", sqlite3_errmsg(db));
	}

}


int main(int argc, char* argv[]) {
	printf("  --> environment\n");

	/* init */
	if (argc != 2) {
		printf("usage: %s <database>\n", argv[0]);
		exit(1);
	}
	database = argv[1];

	db_connect();
	read_time();

	set_environment();


	db_close();

	printf("  --< environment\n");
	return 0;
}