sql.h

#pragma once
#include <stddef.h>
#include <sqlite3.h>
#include <yyjson.h>
 
/* Owned declaration data. All strings use SQLite's allocator. */
typedef enum { VT_UNKNOWN, VT_INTEGER, VT_REAL, VT_TEXT, VT_NUMERIC, VT_BLOB } vt_type;
typedef struct {
    char *key;
    size_t index;
    int is_index;
} vt_step;
typedef struct {
    char *name;
    char *type_name;
    vt_type type;
    char *path;
    vt_step *steps;
    size_t step_count;
} vt_column;
typedef struct { char *name, *value; } vt_header;
typedef struct {
    char *url;
    vt_header *headers;
    size_t header_count;
    vt_column *columns;
    size_t column_count;
} vt_config;
 
void vt_config_free(vt_config *cfg);
int vt_parse(int argc, const char *const *argv, vt_config *cfg, char **error);
int vt_add_column(vt_config *cfg, const char *name, const char *type,
                  const char *path, char **error);
yyjson_val *vt_column_value(const vt_column *column, yyjson_val *row);