Method insertLaneBoundaries

common/map_sdk/mapdb/src/sqlite_operation.cpp:1399–1435

}

bool sqliteOperation::insertLaneBoundaries(hadmap::tx_laneboundary_vec& boundaries) {
  char sql[1024];
  sprintf(sql, "INSERT INTO '%s' (pkid, srs, lane_mark, geom) VALUES (?, ?, ?, ?)", LANE_BOUNDARY_TABLE);

  sqliteStmtPtr stmt(dbPtr, sql);
  if (!stmt.status()) {
    std::cerr << "failed to prepare insert boundary." << std::endl;
    return false;
  }
  sqlite3_exec(dbPtr, "begin;", 0, 0, 0);
  bool complete = true;
  int index_base = 1;
  sqlite3_blob_data geom;
  for (hadmap::tx_laneboundary_vec::iterator iter = boundaries.begin(); iter != boundaries.end(); ++iter) {
    sqlite3_bind_int(stmt, index_base, iter->pkid);
    sqlite3_bind_int(stmt, index_base + 1, iter->srs);
    sqlite3_bind_int(stmt, index_base + 2, iter->lane_mark);

    createBlob(iter->geom, iter->srs, geom);
    sqlite3_bind_blob(stmt, index_base + 3, geom.data, geom.size, SQLITE_TRANSIENT);

    int r = sqlite3_step(stmt);
    if (SQLITE_DONE != r) {
      std::cerr << "Insert Boundary Error, Code " << r << std::endl;
      complete = false;
    }

    sqlite3_clear_bindings(stmt);
    sqlite3_reset(stmt);

    // iter->pkid = sqlitePackage::getLastInsertedRowid( dbPtr );

    geom.release();
  }
  sqlite3_exec(dbPtr, "commit;", 0, 0, 0);
  return complete;
}

bool sqliteOperation::insertLaneLinks(hadmap::tx_lanelink_vec& lanelinks) {
  char sql[1024];