//

// cloudsync_sqlite.c

// cloudsync

//

// Created by Marco Bambini on 05/12/25.

//

#include "cloudsync_sqlite.h"

#include "cloudsync_changes_sqlite.h"

#include "../pk.h"

#include "../cloudsync.h"

#include "../block.h"

#include "../database.h"

#include "../dbutils.h"

#ifndef CLOUDSYNC_OMIT_NETWORK

#include "../network/network.h"

#endif

#ifndef SQLITE_CORE

SQLITE_EXTENSION_INIT1

#endif

#ifndef UNUSED_PARAMETER

#define UNUSED_PARAMETER(X) (void)(X)

#endif

#ifdef _WIN32

#define APIEXPORT __declspec(dllexport)

#else

#define APIEXPORT

#endif

typedef struct {

sqlite3_context *context;

int index;

} cloudsync_pk_decode_context;

typedef struct {

sqlite3_value *table_name;

sqlite3_value **new_values;

sqlite3_value **old_values;

int count;

int capacity;

} cloudsync_update_payload;

void dbsync_set_error (sqlite3_context *context, const char *format, ...) {

char buffer[2048];

va_list arg;

va_start (arg, format);

vsnprintf(buffer, sizeof(buffer), format, arg);

va_end (arg);

if (context) sqlite3_result_error(context, buffer, -1);

}

// MARK: - Public -

void dbsync_version (sqlite3_context *context, int argc, sqlite3_value **argv) {

DEBUG_FUNCTION("cloudsync_version");

UNUSED_PARAMETER(argc);

UNUSED_PARAMETER(argv);

sqlite3_result_text(context, CLOUDSYNC_VERSION, -1, SQLITE_STATIC);

}

void dbsync_siteid (sqlite3_context *context, int argc, sqlite3_value **argv) {

DEBUG_FUNCTION("cloudsync_siteid");

UNUSED_PARAMETER(argc);

UNUSED_PARAMETER(argv);

cloudsync_context *data = (cloudsync_context *)sqlite3_user_data(context);

sqlite3_result_blob(context, cloudsync_siteid(data), UUID_LEN, SQLITE_STATIC);

}

void dbsync_db_version (sqlite3_context *context, int argc, sqlite3_value **argv) {

DEBUG_FUNCTION("cloudsync_db_version");

UNUSED_PARAMETER(argc);

UNUSED_PARAMETER(argv);

// retrieve context

cloudsync_context *data = (cloudsync_context *)sqlite3_user_data(context);

int rc = cloudsync_dbversion_check_uptodate(data);

if (rc != SQLITE_OK) {

dbsync_set_error(context, "Unable to retrieve db_version (%s).", database_errmsg(data));

return;

}

sqlite3_result_int64(context, cloudsync_dbversion(data));

}

void dbsync_db_version_next (sqlite3_context *context, int argc, sqlite3_value **argv) {

DEBUG_FUNCTION("cloudsync_db_version_next");

// retrieve context

cloudsync_context *data = (cloudsync_context *)sqlite3_user_data(context);

sqlite3_int64 merging_version = (argc == 1) ? database_value_int(argv[0]) : CLOUDSYNC_VALUE_NOTSET;

sqlite3_int64 value = cloudsync_dbversion_next(data, merging_version);

if (value == -1) {

dbsync_set_error(context, "Unable to retrieve next_db_version (%s).", database_errmsg(data));

return;

}

sqlite3_result_int64(context, value);

}

void dbsync_seq (sqlite3_context *context, int argc, sqlite3_value **argv) {

DEBUG_FUNCTION("cloudsync_seq");

// retrieve context

cloudsync_context *data = (cloudsync_context *)sqlite3_user_data(context);

sqlite3_result_int(context, cloudsync_bumpseq(data));

}

void dbsync_uuid (sqlite3_context *context, int argc, sqlite3_value **argv) {

DEBUG_FUNCTION("cloudsync_uuid");

char value[UUID_STR_MAXLEN];

char *uuid = cloudsync_uuid_v7_string(value, true);

sqlite3_result_text(context, uuid, -1, SQLITE_TRANSIENT);

}

// MARK: -

void dbsync_set (sqlite3_context *context, int argc, sqlite3_value **argv) {

DEBUG_FUNCTION("cloudsync_set");

// sanity check parameters

const char *key = (const char *)database_value_text(argv[0]);

const char *value = (const char *)database_value_text(argv[1]);

// silently fails

if (key == NULL) return;

cloudsync_context *data = (cloudsync_context *)sqlite3_user_data(context);

dbutils_settings_set_key_value(data, key, value);

}

void dbsync_set_column (sqlite3_context *context, int argc, sqlite3_value **argv) {

DEBUG_FUNCTION("cloudsync_set_column");

const char *tbl = (const char *)database_value_text(argv[0]);

const char *col = (const char *)database_value_text(argv[1]);

const char *key = (const char *)database_value_text(argv[2]);

const char *value = (const char *)database_value_text(argv[3]);

cloudsync_context *data = (cloudsync_context *)sqlite3_user_data(context);

// Handle block column setup: cloudsync_set_column('tbl', 'col', 'algo', 'block')

if (key && value && strcmp(key, "algo") == 0 && strcmp(value, "block") == 0) {

int rc = cloudsync_setup_block_column(data, tbl, col, NULL);

if (rc != DBRES_OK) {

sqlite3_result_error(context, cloudsync_errmsg(data), -1);

}

return;

}

// Handle delimiter setting: cloudsync_set_column('tbl', 'col', 'delimiter', '\n\n')

if (key && strcmp(key, "delimiter") == 0) {

cloudsync_table_context *table = table_lookup(data, tbl);

if (table) {

int col_idx = table_col_index(table, col);

if (col_idx >= 0 && table_col_algo(table, col_idx) == col_algo_block) {

table_set_col_delimiter(table, col_idx, value);

}

}

}

dbutils_table_settings_set_key_value(data, tbl, col, key, value);

}

void dbsync_set_table (sqlite3_context *context, int argc, sqlite3_value **argv) {

DEBUG_FUNCTION("cloudsync_set_table");

const char *tbl = (const char *)database_value_text(argv[0]);

const char *key = (const char *)database_value_text(argv[1]);

const char *value = (const char *)database_value_text(argv[2]);

cloudsync_context *data = (cloudsync_context *)sqlite3_user_data(context);

dbutils_table_settings_set_key_value(data, tbl, "*", key, value);

}

void dbsync_set_schema (sqlite3_context *context, int argc, sqlite3_value **argv) {

DEBUG_FUNCTION("dbsync_set_schema");

const char *schema = (const char *)database_value_text(argv[0]);

cloudsync_context *data = (cloudsync_context *)sqlite3_user_data(context);

cloudsync_set_schema(data, schema);

}

void dbsync_schema (sqlite3_context *context, int argc, sqlite3_value **argv) {

DEBUG_FUNCTION("dbsync_schema");

cloudsync_context *data = (cloudsync_context *)sqlite3_user_data(context);

const char *schema = cloudsync_schema(data);

(schema) ? sqlite3_result_text(context, schema, -1, NULL) : sqlite3_result_null(context);

}

void dbsync_table_schema (sqlite3_context *context, int argc, sqlite3_value **argv) {

DEBUG_FUNCTION("dbsync_table_schema");

cloudsync_context *data = (cloudsync_context *)sqlite3_user_data(context);

const char *table_name = (const char *)database_value_text(argv[0]);

const char *schema = cloudsync_table_schema(data, table_name);

(schema) ? sqlite3_result_text(context, schema, -1, NULL) : sqlite3_result_null(context);

}

void dbsync_is_sync (sqlite3_context *context, int argc, sqlite3_value **argv) {

DEBUG_FUNCTION("cloudsync_is_sync");

cloudsync_context *data = (cloudsync_context *)sqlite3_user_data(context);

if (cloudsync_insync(data)) {

sqlite3_result_int(context, 1);

return;

}

const char *table_name = (const char *)database_value_text(argv[0]);

cloudsync_table_context *table = table_lookup(data, table_name);

sqlite3_result_int(context, (table) ? (table_enabled(table) == 0) : 0);

}

void dbsync_col_value (sqlite3_context *context, int argc, sqlite3_value **argv) {

// DEBUG_FUNCTION("cloudsync_col_value");

// argv[0] -> table name

// argv[1] -> column name

// argv[2] -> encoded pk

// retrieve column name

const char *col_name = (const char *)database_value_text(argv[1]);

if (!col_name) {

dbsync_set_error(context, "Column name cannot be NULL");

return;

}

// check for special tombstone value

if (strcmp(col_name, CLOUDSYNC_TOMBSTONE_VALUE) == 0) {

sqlite3_result_null(context);

return;

}

// lookup table

const char *table_name = (const char *)database_value_text(argv[0]);

cloudsync_context *data = (cloudsync_context *)sqlite3_user_data(context);

cloudsync_table_context *table = table_lookup(data, table_name);

if (!table) {

dbsync_set_error(context, "Unable to retrieve table name %s in clousdsync_colvalue.", table_name);

return;

}

// Block column: if col_name contains \x1F, read from blocks table

if (block_is_block_colname(col_name) && table_has_block_cols(table)) {

dbvm_t *bvm = table_block_value_read_stmt(table);

if (!bvm) {

sqlite3_result_null(context);

return;

}

int rc = databasevm_bind_blob(bvm, 1, database_value_blob(argv[2]), database_value_bytes(argv[2]));

if (rc != DBRES_OK) { databasevm_reset(bvm); sqlite3_result_error(context, database_errmsg(data), -1); return; }

rc = databasevm_bind_text(bvm, 2, col_name, -1);

if (rc != DBRES_OK) { databasevm_reset(bvm); sqlite3_result_error(context, database_errmsg(data), -1); return; }

rc = databasevm_step(bvm);

if (rc == SQLITE_ROW) {

sqlite3_result_value(context, database_column_value(bvm, 0));

} else if (rc == SQLITE_DONE) {

sqlite3_result_null(context);

} else {

sqlite3_result_error(context, database_errmsg(data), -1);

}

databasevm_reset(bvm);

return;

}

// extract the right col_value vm associated to the column name

sqlite3_stmt *vm = table_column_lookup(table, col_name, false, NULL);

if (!vm) {

sqlite3_result_error(context, "Unable to retrieve column value precompiled statement in clousdsync_colvalue.", -1);

return;

}

// bind primary key values

int rc = pk_decode_prikey((char *)database_value_blob(argv[2]), (size_t)database_value_bytes(argv[2]), pk_decode_bind_callback, (void *)vm);

if (rc < 0) goto cleanup;

// execute vm

rc = databasevm_step(vm);

if (rc == SQLITE_DONE) {

rc = SQLITE_OK;

sqlite3_result_text(context, CLOUDSYNC_RLS_RESTRICTED_VALUE, -1, SQLITE_STATIC);

} else if (rc == SQLITE_ROW) {

// store value result

rc = SQLITE_OK;

sqlite3_result_value(context, database_column_value(vm, 0));

}

cleanup:

if (rc != SQLITE_OK) {

sqlite3_result_error(context, database_errmsg(data), -1);

}

databasevm_reset(vm);

}

void dbsync_pk_encode (sqlite3_context *context, int argc, sqlite3_value **argv) {

size_t bsize = 0;

char *buffer = pk_encode_prikey((dbvalue_t **)argv, argc, NULL, &bsize);

if (!buffer || buffer == PRIKEY_NULL_CONSTRAINT_ERROR) {

sqlite3_result_null(context);

return;

}

sqlite3_result_blob(context, (const void *)buffer, (int)bsize, SQLITE_TRANSIENT);

cloudsync_memory_free(buffer);

}

int dbsync_pk_decode_set_result_callback (void *xdata, int index, int type, int64_t ival, double dval, char *pval) {

cloudsync_pk_decode_context *decode_context = (cloudsync_pk_decode_context *)xdata;

// decode_context->index is 1 based

// index is 0 based

if (decode_context->index != index+1) return SQLITE_OK;

int rc = 0;

sqlite3_context *context = decode_context->context;

switch (type) {

case SQLITE_INTEGER:

sqlite3_result_int64(context, ival);

break;

case SQLITE_FLOAT:

sqlite3_result_double(context, dval);

break;

case SQLITE_NULL:

sqlite3_result_null(context);

break;

case SQLITE_TEXT:

sqlite3_result_text(context, pval, (int)ival, SQLITE_TRANSIENT);

break;

case SQLITE_BLOB:

sqlite3_result_blob(context, pval, (int)ival, SQLITE_TRANSIENT);

break;

}

return rc;

}

void dbsync_pk_decode (sqlite3_context *context, int argc, sqlite3_value **argv) {

const char *pk = (const char *)database_value_blob(argv[0]);

int pk_len = database_value_bytes(argv[0]);

int i = (int)database_value_int(argv[1]);

cloudsync_pk_decode_context xdata = {.context = context, .index = i};

pk_decode_prikey((char *)pk, (size_t)pk_len, dbsync_pk_decode_set_result_callback, &xdata);

}

// MARK: -

void dbsync_insert (sqlite3_context *context, int argc, sqlite3_value **argv) {

DEBUG_FUNCTION("cloudsync_insert %s", database_value_text(argv[0]));

// debug_values(argc-1, &argv[1]);

// argv[0] is table name

// argv[1]..[N] is primary key(s)

// table_cloudsync

// pk -> encode(argc-1, &argv[1])

// col_name -> name

// col_version -> 0/1 +1

// db_version -> check

// site_id 0

// seq -> sqlite_master

// retrieve context

cloudsync_context *data = (cloudsync_context *)sqlite3_user_data(context);

// lookup table

const char *table_name = (const char *)database_value_text(argv[0]);

cloudsync_table_context *table = table_lookup(data, table_name);

if (!table) {

dbsync_set_error(context, "Unable to retrieve table name %s in cloudsync_insert.", table_name);

return;

}

// encode the primary key values into a buffer

char buffer[1024];

size_t pklen = sizeof(buffer);

char *pk = pk_encode_prikey((dbvalue_t **)&argv[1], table_count_pks(table), buffer, &pklen);

if (!pk) {

sqlite3_result_error(context, "Not enough memory to encode the primary key(s).", -1);

return;

}

if (pk == PRIKEY_NULL_CONSTRAINT_ERROR) {

dbsync_set_error(context, "Insert aborted because primary key in table %s contains NULL values.", table_name);

return;

}

// compute the next database version for tracking changes

int64_t db_version = cloudsync_dbversion_next(data, CLOUDSYNC_VALUE_NOTSET);

// check if a row with the same primary key already exists

// if so, this means the row might have been previously deleted (sentinel)

bool pk_exists = table_pk_exists(table, pk, pklen);

int rc = SQLITE_OK;

if (table_count_cols(table) == 0) {

// if there are no columns other than primary keys, insert a sentinel record

rc = local_mark_insert_sentinel_meta(table, pk, pklen, db_version, cloudsync_bumpseq(data));

if (rc != SQLITE_OK) goto cleanup;

} else if (pk_exists){

// if a row with the same primary key already exists, update the sentinel record

rc = local_update_sentinel(table, pk, pklen, db_version, cloudsync_bumpseq(data));

if (rc != SQLITE_OK) goto cleanup;

}

// process each non-primary key column for insert or update

for (int i=0; i<table_count_cols(table); ++i) {

if (table_col_algo(table, i) == col_algo_block) {

// Block column: read value from base table, split into blocks, store each block

sqlite3_stmt *val_vm = (sqlite3_stmt *)table_column_lookup(table, table_colname(table, i), false, NULL);

if (!val_vm) goto cleanup;

rc = pk_decode_prikey(pk, pklen, pk_decode_bind_callback, (void *)val_vm);

if (rc < 0) { databasevm_reset((dbvm_t *)val_vm); goto cleanup; }

rc = databasevm_step((dbvm_t *)val_vm);

if (rc == DBRES_ROW) {

const char *text = database_column_text((dbvm_t *)val_vm, 0);

const char *delim = table_col_delimiter(table, i);

const char *col = table_colname(table, i);

block_list_t *blocks = block_split(text ? text : "", delim);

if (blocks) {

char **positions = block_initial_positions(blocks->count);

if (positions) {

for (int b = 0; b < blocks->count; b++) {

char *block_cn = block_build_colname(col, positions[b]);

if (block_cn) {

rc = local_mark_insert_or_update_meta(table, pk, pklen, block_cn, db_version, cloudsync_bumpseq(data));

// Store block value in blocks table

dbvm_t *wvm = table_block_value_write_stmt(table);

if (wvm && rc == SQLITE_OK) {

databasevm_bind_blob(wvm, 1, pk, (int)pklen);

databasevm_bind_text(wvm, 2, block_cn, -1);

databasevm_bind_text(wvm, 3, blocks->entries[b].content, -1);

databasevm_step(wvm);

databasevm_reset(wvm);

}

cloudsync_memory_free(block_cn);

}

cloudsync_memory_free(positions[b]);

if (rc != SQLITE_OK) break;

}

cloudsync_memory_free(positions);

}

block_list_free(blocks);

}

}

databasevm_reset((dbvm_t *)val_vm);

if (rc == DBRES_ROW || rc == DBRES_DONE) rc = SQLITE_OK;

if (rc != SQLITE_OK) goto cleanup;

} else {

// Regular column: mark as inserted or updated in the metadata

rc = local_mark_insert_or_update_meta(table, pk, pklen, table_colname(table, i), db_version, cloudsync_bumpseq(data));

if (rc != SQLITE_OK) goto cleanup;

}

}

cleanup:

if (rc != SQLITE_OK) sqlite3_result_error(context, database_errmsg(data), -1);

// free memory if the primary key was dynamically allocated

if (pk != buffer) cloudsync_memory_free(pk);

}

void dbsync_delete (sqlite3_context *context, int argc, sqlite3_value **argv) {

DEBUG_FUNCTION("cloudsync_delete %s", database_value_text(argv[0]));

// debug_values(argc-1, &argv[1]);

// retrieve context

cloudsync_context *data = (cloudsync_context *)sqlite3_user_data(context);

// lookup table

const char *table_name = (const char *)database_value_text(argv[0]);

cloudsync_table_context *table = table_lookup(data, table_name);

if (!table) {

dbsync_set_error(context, "Unable to retrieve table name %s in cloudsync_delete.", table_name);

return;

}

// compute the next database version for tracking changes

int64_t db_version = cloudsync_dbversion_next(data, CLOUDSYNC_VALUE_NOTSET);

int rc = SQLITE_OK;

// encode the primary key values into a buffer

char buffer[1024];

size_t pklen = sizeof(buffer);

char *pk = pk_encode_prikey((dbvalue_t **)&argv[1], table_count_pks(table), buffer, &pklen);

if (!pk) {

sqlite3_result_error(context, "Not enough memory to encode the primary key(s).", -1);

return;

}

if (pk == PRIKEY_NULL_CONSTRAINT_ERROR) {

dbsync_set_error(context, "Delete aborted because primary key in table %s contains NULL values.", table_name);

return;

}

// mark the row as deleted by inserting a delete sentinel into the metadata

rc = local_mark_delete_meta(table, pk, pklen, db_version, cloudsync_bumpseq(data));

if (rc != SQLITE_OK) goto cleanup;

// remove any metadata related to the old rows associated with this primary key

rc = local_drop_meta(table, pk, pklen);

if (rc != SQLITE_OK) goto cleanup;

cleanup:

if (rc != SQLITE_OK) sqlite3_result_error(context, database_errmsg(data), -1);

// free memory if the primary key was dynamically allocated

if (pk != buffer) cloudsync_memory_free(pk);

}

// MARK: -

void dbsync_update_payload_free (cloudsync_update_payload *payload) {

for (int i=0; i<payload->count; i++) {

database_value_free(payload->new_values[i]);

database_value_free(payload->old_values[i]);

}

cloudsync_memory_free(payload->new_values);

cloudsync_memory_free(payload->old_values);

database_value_free(payload->table_name);

payload->new_values = NULL;

payload->old_values = NULL;

payload->table_name = NULL;

payload->count = 0;

payload->capacity = 0;

}

int dbsync_update_payload_append (cloudsync_update_payload *payload, sqlite3_value *v1, sqlite3_value *v2, sqlite3_value *v3) {

if (payload->count >= payload->capacity) {

int newcap = payload->capacity ? payload->capacity * 2 : 128;

sqlite3_value **new_values_2 = (sqlite3_value **)cloudsync_memory_realloc(payload->new_values, newcap * sizeof(*new_values_2));

if (!new_values_2) return SQLITE_NOMEM;

sqlite3_value **old_values_2 = (sqlite3_value **)cloudsync_memory_realloc(payload->old_values, newcap * sizeof(*old_values_2));

if (!old_values_2) {

// new_values_2 succeeded but old_values failed; keep new_values_2 pointer

// (it's still valid, just larger) but don't update capacity

payload->new_values = new_values_2;

return SQLITE_NOMEM;

}

payload->new_values = new_values_2;

payload->old_values = old_values_2;

payload->capacity = newcap;

}

int index = payload->count;

if (payload->table_name == NULL) payload->table_name = database_value_dup(v1);

else if (dbutils_value_compare(payload->table_name, v1) != 0) return SQLITE_NOMEM;

payload->new_values[index] = database_value_dup(v2);

payload->old_values[index] = database_value_dup(v3);

// sanity check memory allocations before committing count

bool v1_can_be_null = (database_value_type(v1) == SQLITE_NULL);

bool v2_can_be_null = (database_value_type(v2) == SQLITE_NULL);

bool v3_can_be_null = (database_value_type(v3) == SQLITE_NULL);

bool oom = false;

if ((payload->table_name == NULL) && (!v1_can_be_null)) oom = true;

if ((payload->new_values[index] == NULL) && (!v2_can_be_null)) oom = true;

if ((payload->old_values[index] == NULL) && (!v3_can_be_null)) oom = true;

if (oom) {

// clean up partial allocations at this index to prevent leaks

if (payload->new_values[index]) { database_value_free(payload->new_values[index]); payload->new_values[index] = NULL; }

if (payload->old_values[index]) { database_value_free(payload->old_values[index]); payload->old_values[index] = NULL; }

return SQLITE_NOMEM;

}

payload->count++;

return SQLITE_OK;

}

void dbsync_update_step (sqlite3_context *context, int argc, sqlite3_value **argv) {

// argv[0] => table_name

// argv[1] => new_column_value

// argv[2] => old_column_value

// allocate/get the update payload

cloudsync_update_payload *payload = (cloudsync_update_payload *)sqlite3_aggregate_context(context, sizeof(cloudsync_update_payload));

if (!payload) {sqlite3_result_error_nomem(context); return;}

if (dbsync_update_payload_append(payload, argv[0], argv[1], argv[2]) != SQLITE_OK) {

sqlite3_result_error_nomem(context);

}

}

void dbsync_update_final (sqlite3_context *context) {

cloudsync_update_payload *payload = (cloudsync_update_payload *)sqlite3_aggregate_context(context, sizeof(cloudsync_update_payload));

if (!payload || payload->count == 0) return;

// retrieve context

cloudsync_context *data = (cloudsync_context *)sqlite3_user_data(context);

// lookup table

const char *table_name = (const char *)database_value_text(payload->table_name);

cloudsync_table_context *table = table_lookup(data, table_name);

if (!table) {

dbsync_set_error(context, "Unable to retrieve table name %s in cloudsync_update.", table_name);

dbsync_update_payload_free(payload);

return;

}

// compute the next database version for tracking changes

int64_t db_version = cloudsync_dbversion_next(data, CLOUDSYNC_VALUE_NOTSET);

int rc = SQLITE_OK;

// Check if the primary key(s) have changed

bool prikey_changed = false;

for (int i=0; i<table_count_pks(table); ++i) {

if (dbutils_value_compare(payload->old_values[i], payload->new_values[i]) != 0) {

prikey_changed = true;

break;

}

}

// encode the NEW primary key values into a buffer (used later for indexing)

char buffer[1024];

char buffer2[1024];

size_t pklen = sizeof(buffer);

size_t oldpklen = sizeof(buffer2);

char *oldpk = NULL;

char *pk = pk_encode_prikey((dbvalue_t **)payload->new_values, table_count_pks(table), buffer, &pklen);

if (!pk) {

sqlite3_result_error(context, "Not enough memory to encode the primary key(s).", -1);

dbsync_update_payload_free(payload);

return;

}

if (pk == PRIKEY_NULL_CONSTRAINT_ERROR) {

dbsync_set_error(context, "Update aborted because primary key in table %s contains NULL values.", table_name);

dbsync_update_payload_free(payload);

return;

}

if (prikey_changed) {

// if the primary key has changed, we need to handle the row differently:

// 1. mark the old row (OLD primary key) as deleted

// 2. create a new row (NEW primary key)

// encode the OLD primary key into a buffer

oldpk = pk_encode_prikey((dbvalue_t **)payload->old_values, table_count_pks(table), buffer2, &oldpklen);

if (!oldpk) {

// no check here about PRIKEY_NULL_CONSTRAINT_ERROR because by design oldpk cannot contain NULL values

if (pk != buffer) cloudsync_memory_free(pk);

sqlite3_result_error(context, "Not enough memory to encode the primary key(s).", -1);

dbsync_update_payload_free(payload);

return;

}

// mark the rows with the old primary key as deleted in the metadata (old row handling)

rc = local_mark_delete_meta(table, oldpk, oldpklen, db_version, cloudsync_bumpseq(data));

if (rc != SQLITE_OK) goto cleanup;

// move non-sentinel metadata entries from OLD primary key to NEW primary key

// handles the case where some metadata is retained across primary key change

// see https://github.com/sqliteai/sqlite-sync/blob/main/docs/PriKey.md for more details

rc = local_update_move_meta(table, pk, pklen, oldpk, oldpklen, db_version);

if (rc != SQLITE_OK) goto cleanup;

// mark a new sentinel row with the new primary key in the metadata

rc = local_mark_insert_sentinel_meta(table, pk, pklen, db_version, cloudsync_bumpseq(data));

if (rc != SQLITE_OK) goto cleanup;

// free memory if the OLD primary key was dynamically allocated

if (oldpk != buffer2) cloudsync_memory_free(oldpk);

oldpk = NULL;

}

// compare NEW and OLD values (excluding primary keys) to handle column updates

for (int i=0; i<table_count_cols(table); i++) {

int col_index = table_count_pks(table) + i; // Regular columns start after primary keys

if (dbutils_value_compare(payload->old_values[col_index], payload->new_values[col_index]) != 0) {

if (table_col_algo(table, i) == col_algo_block) {

// Block column: diff old and new text, emit per-block metadata changes

const char *new_text = (const char *)database_value_text(payload->new_values[col_index]);

const char *delim = table_col_delimiter(table, i);

const char *col = table_colname(table, i);

// Read existing blocks from blocks table

block_list_t *old_blocks = block_list_create_empty();

if (table_block_list_stmt(table)) {

char *like_pattern = block_build_colname(col, "%");

if (like_pattern) {

// Query blocks table directly for existing block names and values

char *list_sql = cloudsync_memory_mprintf(

"SELECT col_name, col_value FROM %s WHERE pk = ?1 AND col_name LIKE ?2 ORDER BY col_name",

table_blocks_ref(table));

if (list_sql) {

dbvm_t *list_vm = NULL;

if (databasevm_prepare(data, list_sql, &list_vm, 0) == DBRES_OK) {

databasevm_bind_blob(list_vm, 1, pk, (int)pklen);

databasevm_bind_text(list_vm, 2, like_pattern, -1);

while (databasevm_step(list_vm) == DBRES_ROW) {

const char *bcn = database_column_text(list_vm, 0);

const char *bval = database_column_text(list_vm, 1);

const char *pos = block_extract_position_id(bcn);

if (pos && old_blocks) {

block_list_add(old_blocks, bval ? bval : "", pos);

}

}

databasevm_finalize(list_vm);

}

cloudsync_memory_free(list_sql);

}

cloudsync_memory_free(like_pattern);

}

}

// Split new text into parts (NULL text = all blocks removed)

block_list_t *new_blocks = new_text ? block_split(new_text, delim) : block_list_create_empty();

if (new_blocks && old_blocks) {

// Build array of new content strings (NULL when count is 0)

const char **new_parts = NULL;

if (new_blocks->count > 0) {

new_parts = (const char **)cloudsync_memory_alloc(

(uint64_t)(new_blocks->count * sizeof(char *)));

if (new_parts) {

for (int b = 0; b < new_blocks->count; b++) {

new_parts[b] = new_blocks->entries[b].content;

}

}

}

if (new_parts || new_blocks->count == 0) {

block_diff_t *diff = block_diff(old_blocks->entries, old_blocks->count,

new_parts, new_blocks->count);

if (diff) {

for (int d = 0; d < diff->count; d++) {

block_diff_entry_t *de = &diff->entries[d];

char *block_cn = block_build_colname(col, de->position_id);

if (!block_cn) continue;

if (de->type == BLOCK_DIFF_ADDED || de->type == BLOCK_DIFF_MODIFIED) {

rc = local_mark_insert_or_update_meta(table, pk, pklen, block_cn,

db_version, cloudsync_bumpseq(data));

// Store block value

if (rc == SQLITE_OK && table_block_value_write_stmt(table)) {

dbvm_t *wvm = table_block_value_write_stmt(table);

databasevm_bind_blob(wvm, 1, pk, (int)pklen);

databasevm_bind_text(wvm, 2, block_cn, -1);

databasevm_bind_text(wvm, 3, de->content, -1);

databasevm_step(wvm);

databasevm_reset(wvm);

}

} else if (de->type == BLOCK_DIFF_REMOVED) {

// Mark block as deleted in metadata (even col_version)

rc = local_mark_delete_block_meta(table, pk, pklen, block_cn,

db_version, cloudsync_bumpseq(data));

// Remove from blocks table

if (rc == SQLITE_OK) {

block_delete_value_external(data, table, pk, pklen, block_cn);

}

}

cloudsync_memory_free(block_cn);

if (rc != SQLITE_OK) break;

}

block_diff_free(diff);

}

if (new_parts) cloudsync_memory_free((void *)new_parts);

}

}

if (new_blocks) block_list_free(new_blocks);

if (old_blocks) block_list_free(old_blocks);

if (rc != SQLITE_OK) goto cleanup;

} else {

// Regular column: mark as updated in the metadata (columns are in cid order)

rc = local_mark_insert_or_update_meta(table, pk, pklen, table_colname(table, i), db_version, cloudsync_bumpseq(data));

if (rc != SQLITE_OK) goto cleanup;

}

}

}

cleanup:

if (rc != SQLITE_OK) sqlite3_result_error(context, database_errmsg(data), -1);

if (pk != buffer) cloudsync_memory_free(pk);

if (oldpk && (oldpk != buffer2)) cloudsync_memory_free(oldpk);

dbsync_update_payload_free(payload);

}

// MARK: -

void dbsync_cleanup (sqlite3_context *context, int argc, sqlite3_value **argv) {

DEBUG_FUNCTION("cloudsync_cleanup");

const char *table = (const char *)database_value_text(argv[0]);

cloudsync_context *data = (cloudsync_context *)sqlite3_user_data(context);

int rc = cloudsync_cleanup(data, table);

if (rc != DBRES_OK) {

sqlite3_result_error(context, cloudsync_errmsg(data), -1);

sqlite3_result_error_code(context, rc);

}

}

void dbsync_enable_disable (sqlite3_context *context, const char *table_name, bool value) {

DEBUG_FUNCTION("cloudsync_enable_disable");

cloudsync_context *data = (cloudsync_context *)sqlite3_user_data(context);

cloudsync_table_context *table = table_lookup(data, table_name);

if (!table) return;

table_set_enabled(table, value);

}

void dbsync_enable (sqlite3_context *context, int argc, sqlite3_value **argv) {

DEBUG_FUNCTION("cloudsync_enable");

const char *table = (const char *)database_value_text(argv[0]);

dbsync_enable_disable(context, table, true);

}

void dbsync_disable (sqlite3_context *context, int argc, sqlite3_value **argv) {

DEBUG_FUNCTION("cloudsync_disable");

const char *table = (const char *)database_value_text(argv[0]);

dbsync_enable_disable(context, table, false);

}

void dbsync_is_enabled (sqlite3_context *context, int argc, sqlite3_value **argv) {

DEBUG_FUNCTION("cloudsync_is_enabled");

cloudsync_context *data = (cloudsync_context *)sqlite3_user_data(context);

const char *table_name = (const char *)database_value_text(argv[0]);

cloudsync_table_context *table = table_lookup(data, table_name);

int result = (table && table_enabled(table)) ? 1 : 0;

sqlite3_result_int(context, result);

}

void dbsync_terminate (sqlite3_context *context, int argc, sqlite3_value **argv) {

DEBUG_FUNCTION("cloudsync_terminate");

cloudsync_context *data = (cloudsync_context *)sqlite3_user_data(context);

int rc = cloudsync_terminate(data);

sqlite3_result_int(context, rc);

}

// MARK: -

void dbsync_init (sqlite3_context *context, const char *table, const char *algo, bool skip_int_pk_check) {

cloudsync_context *data = (cloudsync_context *)sqlite3_user_data(context);

int rc = database_begin_savepoint(data, "cloudsync_init");

if (rc != SQLITE_OK) {

dbsync_set_error(context, "Unable to create cloudsync_init savepoint. %s", database_errmsg(data));

sqlite3_result_error_code(context, rc);

return;

}

rc = cloudsync_init_table(data, table, algo, skip_int_pk_check);

if (rc == SQLITE_OK) {

rc = database_commit_savepoint(data, "cloudsync_init");

if (rc != SQLITE_OK) {

dbsync_set_error(context, "Unable to release cloudsync_init savepoint. %s", database_errmsg(data));

sqlite3_result_error_code(context, rc);

}

} else {

// in case of error, rollback transaction

sqlite3_result_error(context, cloudsync_errmsg(data), -1);

sqlite3_result_error_code(context, rc);

database_rollback_savepoint(data, "cloudsync_init");

return;

}

cloudsync_update_schema_hash(data);

// returns site_id as TEXT

char buffer[UUID_STR_MAXLEN];

cloudsync_uuid_v7_stringify(cloudsync_siteid(data), buffer, false);

sqlite3_result_text(context, buffer, -1, SQLITE_TRANSIENT);

}

void dbsync_init3 (sqlite3_context *context, int argc, sqlite3_value **argv) {

DEBUG_FUNCTION("cloudsync_init2");

const char *table = (const char *)database_value_text(argv[0]);

const char *algo = (const char *)database_value_text(argv[1]);

bool skip_int_pk_check = (bool)database_value_int(argv[2]);

dbsync_init(context, table, algo, skip_int_pk_check);

}

void dbsync_init2 (sqlite3_context *context, int argc, sqlite3_value **argv) {

DEBUG_FUNCTION("cloudsync_init2");

const char *table = (const char *)database_value_text(argv[0]);

const char *algo = (const char *)database_value_text(argv[1]);

dbsync_init(context, table, algo, false);

}

void dbsync_init1 (sqlite3_context *context, int argc, sqlite3_value **argv) {

DEBUG_FUNCTION("cloudsync_init1");

const char *table = (const char *)database_value_text(argv[0]);

dbsync_init(context, table, NULL, false);

}

// MARK: -

void dbsync_begin_alter (sqlite3_context *context, int argc, sqlite3_value **argv) {

DEBUG_FUNCTION("dbsync_begin_alter");

const char *table_name = (const char *)database_value_text(argv[0]);

cloudsync_context *data = (cloudsync_context *)sqlite3_user_data(context);

int rc = database_begin_savepoint(data, "cloudsync_alter");

if (rc != DBRES_OK) {

sqlite3_result_error(context, "Unable to create cloudsync_alter savepoint", -1);

sqlite3_result_error_code(context, rc);

return;

}

rc = cloudsync_begin_alter(data, table_name);

if (rc != DBRES_OK) {

database_rollback_savepoint(data, "cloudsync_alter");

sqlite3_result_error(context, cloudsync_errmsg(data), -1);

sqlite3_result_error_code(context, rc);

}

}

void dbsync_commit_alter (sqlite3_context *context, int argc, sqlite3_value **argv) {

DEBUG_FUNCTION("cloudsync_commit_alter");

//retrieve table argument

const char *table_name = (const char *)database_value_text(argv[0]);

// retrieve context

cloudsync_context *data = (cloudsync_context *)sqlite3_user_data(context);

int rc = cloudsync_commit_alter(data, table_name);

if (rc != DBRES_OK) {

database_rollback_savepoint(data, "cloudsync_alter");

sqlite3_result_error(context, cloudsync_errmsg(data), -1);

sqlite3_result_error_code(context, rc);

return;

}

rc = database_commit_savepoint(data, "cloudsync_alter");

if (rc != DBRES_OK) {

sqlite3_result_error(context, database_errmsg(data), -1);

sqlite3_result_error_code(context, rc);

return;

}

cloudsync_update_schema_hash(data);

}

// MARK: - Payload -

void dbsync_payload_encode_step (sqlite3_context *context, int argc, sqlite3_value **argv) {

// allocate/get the session context

cloudsync_payload_context *payload = (cloudsync_payload_context *)sqlite3_aggregate_context(context, (int)cloudsync_payload_context_size(NULL));

if (!payload) {

sqlite3_result_error(context, "Not enough memory to allocate payload session context", -1);

sqlite3_result_error_code(context, SQLITE_NOMEM);

return;

}

// retrieve context

cloudsync_context *data = (cloudsync_context *)sqlite3_user_data(context);

int rc = cloudsync_payload_encode_step(payload, data, argc, (dbvalue_t **)argv);

if (rc != SQLITE_OK) {

sqlite3_result_error(context, cloudsync_errmsg(data), -1);

sqlite3_result_error_code(context, rc);

}

}

void dbsync_payload_encode_final (sqlite3_context *context) {

// get the session context

cloudsync_payload_context *payload = (cloudsync_payload_context *)sqlite3_aggregate_context(context, (int)cloudsync_payload_context_size(NULL));

if (!payload) {

sqlite3_result_error(context, "Unable to extract payload session context", -1);

sqlite3_result_error_code(context, SQLITE_NOMEM);

return;

}

// retrieve context

cloudsync_context *data = (cloudsync_context *)sqlite3_user_data(context);