1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
|
/*
* Copyright (C) 2016 Intel Corporation
*
* Author: Todor Minchev <todor.minchev@linux.intel.com>
*
* This program is free software; you can redistribute it and/or modify it
* under the terms and conditions of the GNU General Public License,
* version 2, or (at your option) any later version, as published by
* the Free Software Foundation.
*
* This program is distributed in the hope it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
* FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
* more details.
*/
#include "globals.h"
#include <stdlib.h>
#include <sqlite3.h>
#include "codi_db.h"
#include "codi_list.h"
static sqlite3 *codi_db;
/* connect */
int db_connect(void)
{
int result;
result = sqlite3_open(CODI_DB, &codi_db);
if (result != SQLITE_OK ) {
INFO("SQL error: %s\n", sqlite3_errmsg(codi_db));
sqlite3_close(codi_db);
return -1;
}
return init_db();
}
int init_db(void)
{
int result;
char *err = 0;
char *qry = "CREATE TABLE IF NOT EXISTS nodes(id TEXT UNIQUE NOT NULL \
CHECK(id <> ''), ip TEXT NOT NULL CHECK(ip <> ''), port TEXT NOT NULL \
CHECK(port <> ''), date TEXT NOT NULL CHECK(date <> ''));";
result = sqlite3_exec(codi_db, qry, 0, 0, &err);
if (result != SQLITE_OK) {
INFO("SQL error: %s\n", err);
sqlite3_free(err);
sqlite3_close(codi_db);
return 1;
}
return 0;
}
/* insert node */
int db_insert_node(char *id, char *ip, char *port)
{
int result;
char *qry, *err = 0;
turff_node *node;
node = find_turff_node(id);
/* if a node with this id exists just update it*/
if (node != NULL) {
asprintf(&qry, "UPDATE nodes SET ip = '%s', port = '%s', date = \
datetime(CURRENT_TIMESTAMP, 'localtime') WHERE ID = '%s';", ip, port, id);
}
else {
asprintf(&qry, "INSERT INTO nodes (id, ip, port, date) VALUES ('%s','%s', \
'%s', datetime(CURRENT_TIMESTAMP, 'localtime'));", id, ip, port);
}
result = exec_db_query(qry, 0, 0, &err);
free(qry);
return result;
}
int exec_db_query(const char *sql, int (*callback)(void*, int, char**, char**), \
void *callback_arg, char **errmsg)
{
int result;
if (db_connect() != 0)
return -1;
result = sqlite3_exec(codi_db, sql, callback, callback_arg, errmsg);
if (result != SQLITE_OK) {
INFO("SQL insert error: %s\n", *errmsg);
sqlite3_free(*errmsg);
sqlite3_close(codi_db);
return result;
}
sqlite3_close(codi_db);
return SQLITE_OK;
}
static int find_node_callback(void *dummy, int argc, char **argv, char **col_name)
{
int i;
/* no records were found */
if(argc == 0)
return 1;
add_turff_node(argv[0], argv[1], argv[2], argv[3]);
return 0;
}
/* find node(s) - gets all nodes if id is NULL */
int get_db_nodes(char *id)
{
int result;
char *qry, *err = 0;
/* remove all nodes from the list before reading them from the db*/
free_turff_nodes_list();
/* get all nodes */
if (id == NULL)
asprintf(&qry, "SELECT * FROM nodes;");
else
asprintf(&qry, "SELECT * from nodes WHERE id='%s';", id);
result = exec_db_query(qry, find_node_callback, 0, &err);
free(qry);
return result;
}
|
