1 files changed, 68 insertions, 0 deletions
diff --git a/database/sqlite/sqlite_context.h b/database/sqlite/sqlite_context.h
new file mode 100644
index 00000000..12937fff
--- /dev/null
+++ b/database/sqlite/sqlite_context.h
@@ -0,0 +1,68 @@
+// SPDX-License-Identifier: GPL-3.0-or-later
+
+#ifndef NETDATA_SQLITE_CONTEXT_H
+#define NETDATA_SQLITE_CONTEXT_H
+
+#include "daemon/common.h"
+#include "sqlite3.h"
+
+typedef struct ctx_chart {
+    uuid_t chart_id;
+    const char *id;
+    const char *name;
+    const char *context;
+    const char *title;
+    const char *units;
+    const char *family;
+    int chart_type;
+    int priority;
+    int update_every;
+} SQL_CHART_DATA;
+
+typedef struct ctx_dimension {
+    uuid_t dim_id;
+    char *id;
+    char *name;
+} SQL_DIMENSION_DATA;
+
+typedef struct ctx_label {
+    char *label_key;
+    char *label_value;
+    int label_source;
+} SQL_CLABEL_DATA;
+
+// Structure to store or delete
+typedef struct versioned_context_data {
+    uint64_t version;       // the version of this context as EPOCH in seconds
+
+    const char *id;         // the id of the context
+    const char *title;      // the title of the context
+    const char *chart_type; // the chart_type of the context
+    const char *units;      // the units of the context
+    const char *family;     // the family of the context
+
+    uint64_t priority;      // the chart priority of the context
+
+    uint64_t first_time_t;  // the first entry in the database, in seconds
+    uint64_t last_time_t;   // the last point in the database, in seconds
+
+    bool deleted;           // true when this is deleted
+
+} VERSIONED_CONTEXT_DATA;
+
+extern void ctx_get_context_list(uuid_t *host_uuid, void (*dict_cb)(VERSIONED_CONTEXT_DATA *, void *), void *data);
+
+extern void ctx_get_chart_list(uuid_t *host_uuid, void (*dict_cb)(SQL_CHART_DATA *, void *), void *data);
+extern void ctx_get_label_list(uuid_t *chart_uuid, void (*dict_cb)(SQL_CLABEL_DATA *, void *), void *data);
+extern void ctx_get_dimension_list(uuid_t *chart_uuid, void (*dict_cb)(SQL_DIMENSION_DATA *, void *), void *data);
+
+extern int ctx_store_context(uuid_t *host_uuid, VERSIONED_CONTEXT_DATA *context_data);
+
+#define ctx_update_context(host_uuid, context_data)    ctx_store_context(host_uuid, context_data)
+
+extern int ctx_delete_context(uuid_t *host_id, VERSIONED_CONTEXT_DATA *context_data);
+
+extern int sql_init_context_database(int memory);
+extern void sql_close_context_database(void);
+extern int ctx_unittest(void);
+#endif //NETDATA_SQLITE_CONTEXT_H