Using PRAGMA sync_status in c++

GCh

Hi Bernardo,
I'm trying to incorporate LiteSync in C++ code, where I'm trying to connect the SQLite database.

For connection I'm using a sqlite3pp wrapper (C++ wrapper over sqlite3), where I modified the database::connect method so that it connects via LiteSync (I implemented this what was proposed as a primary node example - C). This part works fine.

As a next step I'd like to ask the database sync status using 'PRAGMA sync_status' and I thought that I could simply use this what was proposed as a basic app example (again C-implementation), however here I have encountered a problem: I couldn't find 'sqlite3_query_value_str' and 'sqlite3_json_get_bool' methods anywhere in the litesync code (I'm relatively new to C/C++, so perhaps I missed something), so naturally the compiler (MS Visual Studio) doesn't recognize them and won't compile.

I'd like to ask if there's some other way to have the text output of 'PRAGMA sync_status'? Having this information is essential in the program I'm actually writing. Thanks for your answer in advance.

Bernardo

Hi!

These functions in C are helper functions that are not present on SQLite itself. I made a long search on my computers and I did not find them to share with you now, so I suggest you to check how to execute any PRAGMA command on SQLite. This one will return the result in JSON format, as you can see in the SQLite shell. You can parse it and check the "db_is_ready" property.

Maybe you can use an already existing SQLite wrapper for C++ and just make it link/use the modified SQLite library containing LiteSync instead of the original one.

I will share the code for that functions once I find it. At least the first one I may have somewhere. I guess it just uses sqlite3_get_table and does a strdup on the result from the first row and first column.

GCh

Hi Bernardo,

first off, thank you for your answer. It would be a great help for me if you could share those help functions that are mentioned in C example of a secondary node. The first one is most important, because as soon as I have the output, I can parse it the way I need. I will also check your other suggestions. Thank you for those as well.

Bernardo

Here it is:

char * sqlite3_query_value_str(sqlite3 *db, char *sql, char **ppErrMsg){
  char *ptr=NULL, **azResult=NULL;
  int  nrows, ncols, retval;

  if (ppErrMsg) *ppErrMsg = NULL;

  retval = sqlite3_get_table(db, sql, &azResult, &nrows, &ncols, ppErrMsg);
  if (retval != SQLITE_OK || *ppErrMsg != NULL) {
    return NULL;
  }

  if (nrows > 0 && ncols > 0) {
    ptr = sqlite3_strdup(azResult[ncols]);
  }

  sqlite3_free_table(azResult);

  return ptr;
}

GCh

Hi Bernardo,

Thank you very much for sharing the code.