Method Execute

libraries/lib-sqlite-helpers/sqlite/Connection.cpp:160–198

}

Error Connection::Execute(std::string_view sql) noexcept
{
   if (mInDestructor || mConnection == nullptr)
      return Error(SQLITE_MISUSE);

   auto tx = BeginTransaction("Connection_Execute");

   auto first = sql.data();
   auto last = first + sql.size();

   while (first != last)
   {
      const char* next = nullptr;
      sqlite3_stmt* statement = nullptr;

      int result = sqlite3_prepare_v2 (
         mConnection, first, last - first, &statement, &next);

      if (result != SQLITE_OK)
         return Error(result);

      first = next;

      if (statement == nullptr)
         continue;

      auto finalizer = finally([statement] { sqlite3_finalize(statement); });

      result = sqlite3_step(statement);

      if (result != SQLITE_OK && result != SQLITE_DONE && result != SQLITE_ROW)
         return Error(result);

      while (result == SQLITE_ROW)
         result = sqlite3_step(statement);
   }

   return tx.Commit();
}

Transaction Connection::BeginTransaction(std::string name)
{