Re: [sqlite] Memory DB: Load from file

[Dennis Cote]

Dave Gierok wrote:
Thank you for the help Andrew and D. Richard Hipp. But how would I do
this (page 24 & 25 of the slides) using the C/C++ interface?
{
sqlite3* pFileDB;
sqlite3* pMemoryDB;

sqlite3_open(fileName, &pFileDB);
sqlite3_open(":memory:", &pMemoryDB);

//****************************************
//WHAT DO I DO NOW?
//****************************************
}

Dave,


You simply execute the SQL commands against your memory database like this:


{
  sqlite3* pMemoryDB;

  sqlite3_open(":memory:", &pMemoryDB);

  //****************************************
  //WHAT DO I DO NOW?
  //****************************************


   char* sql = "ATTACH DATABASE backup.db AS backup;"
               "BEGIN;"
               "DELETE FROM backup.attachment;"
               "INSERT INTO backup.attachment SELECT * FROM main.attachment;"
               "COMMIT;"
               "DETACH DATABASE backup;";

   sqlite3_exec(pMemoryDB, sql, NULL, NULL, NULL):
   
  //****************************************
  //continue working with memory database
  //****************************************
   
}

HTH
Dennis Cote