Method insertTasks

common/map_sdk/mapdb/src/sqlite_operation.cpp:1242–1271

}

bool sqliteOperation::insertTasks(hadmap::tx_task_vec& tasks) {
  const char* sql = "INSERT INTO " TASK_TABLE
                    " (name, srs, x, y,z,longitude_ref,latitude_ref, heading, pitch, roll)"
                    " VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
  sqliteStmtPtr stmt(dbPtr, sql);
  bool complete = true;
  for (size_t i = 0; i < tasks.size(); i++) {
    const hadmap::tx_task_t& task = tasks[i];
    sqlite3_bind_text(stmt, 1, task.name, -1, SQLITE_TRANSIENT);
    sqlite3_bind_int(stmt, 2, task.srs);
    sqlite3_bind_double(stmt, 3, task.x);
    sqlite3_bind_double(stmt, 4, task.y);
    sqlite3_bind_double(stmt, 5, task.z);
    sqlite3_bind_double(stmt, 6, task.longitude_ref);
    sqlite3_bind_double(stmt, 7, task.latitude_ref);
    sqlite3_bind_double(stmt, 8, task.heading);
    sqlite3_bind_double(stmt, 9, task.pitch);
    sqlite3_bind_double(stmt, 10, task.roll);
    int r = sqlite3_step(stmt);
    if (SQLITE_DONE != r) {
      std::cerr << "Insert Task Error, Code " << r << std::endl;
      complete = false;
    }
    sqlite3_clear_bindings(stmt);
    sqlite3_reset(stmt);

    tasks[i].pkid = sqlitePackage::getLastInsertedRowid(dbPtr);
  }
  return complete;
}

bool sqliteOperation::insertRoads(hadmap::tx_road_vec& roads) {
  char sql[1024];