#include <stdio.h>
static int csExecCb(
void *pCtx,
int nStr,
char **azStr,
char **azCol
){
if( azStr ){
int ii;
const char *zSep = "";
for(ii=0; ii<nStr; ii++){
fprintf(stdout, "%s%s", zSep, azStr[ii] ? azStr[ii] : "(null)");
zSep = "|";
}
fprintf(stdout, "\n");
}
return 0;
}
#include "blockcachevfs.h"
#include "sqlite3.h"
#define CS_STORAGE "azure?emulator=127.0.0.1:10000"
#define CS_ACCOUNT "devstoreaccount1"
#define CS_KEY "Eby8vdM02xNOcqFlqUwJPLlmEtlCDXJ1OUzFT50uSRZ6IFsuFq2UVErCz4I6tq/K1SZFPTOtr/KBHBeksoGMGw=="
static int csAuthCb(
void *pCtx,
const char *zStorage,
const char *zAccount,
const char *zContainer,
char **pzAuthToken
){
*pzAuthToken = sqlite3_mprintf("%s", CS_KEY);
return (*pzAuthToken) ? SQLITE_OK : SQLITE_NOMEM;
}
static int cloudsql(
const char *zDir,
const char *zCont,
const char *zPath,
const char *zSql
){
int rc = SQLITE_OK;
char *zErr = 0;
sqlite3_bcvfs *pVfs = 0;
sqlite3 *db = 0;
rc = sqlite3_bcvfs_create(zDir, "myvfs", &pVfs, &zErr);
if( rc==SQLITE_OK ){
if( sqlite3_bcvfs_isdaemon(pVfs) ){
printf("VFS is using a daemon\n");
}else{
printf("VFS is in daemonless mode\n");
}
}
if( rc==SQLITE_OK ){
sqlite3_bcvfs_auth_callback(pVfs, 0, csAuthCb);
}
if( rc==SQLITE_OK ){
rc = sqlite3_bcvfs_attach(pVfs, CS_STORAGE, CS_ACCOUNT, zCont, 0,
SQLITE_BCV_ATTACH_IFNOT, &zErr
);
}
if( rc==SQLITE_OK ){
rc = sqlite3_open_v2(zPath, &db, SQLITE_OPEN_READWRITE, "myvfs");
if( rc!=SQLITE_OK ){
zErr = sqlite3_mprintf("%s", sqlite3_errmsg(db));
}
}
if( rc==SQLITE_OK ){
rc = sqlite3_bcvfs_register_vtab(db);
}
if( rc==SQLITE_OK ){
rc = sqlite3_exec(db, zSql, csExecCb, 0, &zErr);
}
sqlite3_close(db);
sqlite3_bcvfs_destroy(pVfs);
if( rc!=SQLITE_OK ){
fprintf(stderr, "Error: (%d) %s\n", rc, zErr);
}
sqlite3_free(zErr);
return rc;
}
int main(int argc, char **argv){
if( argc!=5 ){
fprintf(stderr, "Usage: %s DIRECTORY CONTAINER DBPATH SQL\n", argv[0]);
return -1;
}
return cloudsql(argv[1], argv[2], argv[3], argv[4]);
}