Method insertLanes

common/map_sdk/mapdb/src/sqlite_operation.cpp:1349–1397

}

bool sqliteOperation::insertLanes(hadmap::tx_lane_vec& lanes) {
  char sql[1024];
  sprintf(sql,
          "INSERT INTO %s(road_pkid, section_id, lane_id, name, srs, left_boundary, right_boundary, lane_type, \
           lane_arrow, speed_limit, geom) \
           VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
          LANE_TABLE);

  sqliteStmtPtr stmt(dbPtr, sql);
  if (!stmt.status()) {
    std::cerr << "failed to prepare insert lane." << std::endl;
    return false;
  }

  sqlite3_exec(dbPtr, "begin;", 0, 0, 0);
  bool complete = true;
  sqlite3_blob_data geom;
  for (hadmap::tx_lane_vec::iterator iter = lanes.begin(); iter != lanes.end(); ++iter) {
    sqlite3_bind_int64(stmt, 1, iter->road_pkid);
    sqlite3_bind_int(stmt, 2, iter->section_id);
    sqlite3_bind_int(stmt, 3, iter->lane_id);
    sqlite3_bind_text(stmt, 4, iter->name, -1, SQLITE_TRANSIENT);
    sqlite3_bind_int(stmt, 5, iter->srs);
    sqlite3_bind_int64(stmt, 6, iter->left_boundary);
    sqlite3_bind_int64(stmt, 7, iter->right_boundary);
    sqlite3_bind_int(stmt, 8, iter->lane_type);
    sqlite3_bind_int(stmt, 9, iter->lane_arrow);
    sqlite3_bind_int(stmt, 10, iter->speed_limit);

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

    int r = sqlite3_step(stmt);
    if (SQLITE_DONE != r) {
      std::cerr << "Insert Lane Error, Id " << iter->road_pkid << "-" << iter->section_id << "-" << iter->lane_id
                << ", Code " << r << std::endl;
      std::cerr << sqlite3_errmsg(dbPtr) << std::endl;
      complete = false;
    }
    sqlite3_clear_bindings(stmt);
    sqlite3_reset(stmt);

    geom.release();
  }
  sqlite3_exec(dbPtr, "commit;", 0, 0, 0);
  stmt.finalize();

  return complete;
}

bool sqliteOperation::insertLaneBoundaries(hadmap::tx_laneboundary_vec& boundaries) {
  char sql[1024];