sqlite3でオンメモリDB

sqlite3 でスキーマ関係なく操作したい。オンメモリDBが便利。

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

int main() {
  sqlite3* db = nullptr; 
  int resdb = sqlite3_open(":memory:", &db );
  std::cout << resdb << std::endl;
  sqlite3_stmt* stmt = nullptr;
  sqlite3_prepare_v2( db, "select datetime('now','localtime')", -1, &stmt, 0 );
  sqlite3_step( stmt );
  std::cout << "type  = " << sqlite3_column_type( stmt, 0 ) << std::endl;
  std::cout << "value = " << sqlite3_column_text( stmt, 0 ) << std::endl;
  sqlite3_finalize( stmt );
  sqlite3_close( db );
  return 0;
}