sqlite_blob.cpp

#include <stdio.h>
#include <stdlib.h>
#include <stdint.h>

#include <sqlite3.h>
#include <string.h>

static int callback ( void* NotUsed, int argc, char** argv, char** azColName )
{
  int i;

  fprintf ( stderr, "callback called\n" );

  for ( i = 0; i < argc; i++ )
  {
    printf ( "%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL" );
  }

  printf ( "\n" );
  return 0;
}

int main ( int argc, char* argv[] )
{
  sqlite3* db;
  char* zErrMsg = 0;
  int rc;
  char* sql;
  sqlite3_stmt* stmt = NULL;

  sqlite3_open ( "test.db", &db );

  #if 0
  //sql = "UPDATE COMPANY set SALARY = 28000 where ID = 1;";
  sql = "create table bList(fileName varchar(16) primary key, binData blob);";
  sqlite3_exec ( db, sql, callback, NULL, &zErrMsg );

  #else
  sql = "insert into bList values ('hex2',?);";
  uint8_t hex[16] = { 10, 11, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15};
  sqlite3_prepare ( db, sql, -1, &stmt, NULL );
  sqlite3_bind_blob ( stmt, 1, hex, 16, NULL );
  sqlite3_step ( stmt );
  sqlite3_finalize ( stmt );
  #endif

  #if 0
  uint8_t buffer[16] = { 0 };
  char* data = NULL;
  sql = "select binData from bList where fileName='hex';";
  sqlite3_prepare ( db, sql, -1, &stmt, NULL );
  sqlite3_step ( stmt );

  data = ( char* ) sqlite3_column_blob ( stmt, 0 );
  int iLen = sqlite3_column_bytes ( stmt, 0 );
  sqlite3_finalize ( stmt );
  memmove ( buffer, data, iLen );

  for ( auto& c : buffer )
    printf ( "%02x ", c );

  #endif


  sqlite3_close ( db );

  return 0;
}