1 #include <stdio.h>

2 #include <stdlib.h>

3 #include "db.h"

4

5

6

7 void db_connect() {

8 if (sqlite3_open(database, &db) != SQLITE_OK) {

9 fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));

10 sqlite3_close(db);

11 exit(1);

12 }

13 }

14

15

16 void db_close() {

17 sqlite3_close(db);

18 }

19

20

21 sqlite3_stmt* db_query(char* query) {

22 int error;

23 sqlite3_stmt* stmt;

24

25 error = sqlite3_prepare(db, query, -1, &stmt, NULL);

26 if (error) {

27 fprintf(stderr, "SQL error: %s\n", sqlite3_errmsg(db));

28 }

29 return stmt;

30 }

31

32

33

34 int db_update(char* query) {

35 int error;

36 sqlite3_stmt* stmt;

37

38 error = sqlite3_prepare(db, query, -1, &stmt, NULL);

39 if (error || sqlite3_step(stmt) != SQLITE_DONE) {

40 fprintf(stderr, "SQL error: %s\n", sqlite3_errmsg(db));

41 return 0;

42 }

43 return 1;

44 }

45

46

47 int db_rows(sqlite3_stmt* stmt) {

48 int i = 0;

49

50 sqlite3_reset(stmt);

51 while (sqlite3_step(stmt) == SQLITE_ROW) {

52 i++;

53 }

54 sqlite3_reset(stmt);

55 return i;

56 }

57

58

59 int read_time() {

60 sprintf(query, "select time from game;");

61 stmt = db_query(query);

62 if (sqlite3_step(stmt) != SQLITE_ROW) {

63 printf("error: %s\n", sqlite3_errmsg(db));

64 exit(1);

65 }

66 gametime = sqlite3_column_int(stmt, 0);

67 sqlite3_finalize(stmt);

68 return gametime;

69 }

70

71

72 void db_error(char* info) {

73 fprintf(stderr, "%s%sSQL error: %s\n", (info) ? info : "", (info) ? ": " : "", sqlite3_errmsg(db));

74 }