Method insertRoads

common/map_sdk/mapdb/src/sqlite_operation.cpp:1273–1347

}

bool sqliteOperation::insertRoads(hadmap::tx_road_vec& roads) {
  char sql[1024];
  sprintf(
      sql,
      "INSERT INTO '%s' (pkid, task_pkid, id, name, srs, junction_pkid, ground, section_num, road_type, direction, \
           toll, func_class, urban, paved, transition_type, lane_mark, material, geom) \
           VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
      ROAD_TABLE);

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

  int index_base = 1;
  bool complete = true;
  sqlite3_blob_data curvature, slope, heading, super_elevation, geom;
  for (hadmap::tx_road_vec::iterator iter = roads.begin(); iter != roads.end(); ++iter) {
    sqlite3_bind_int64(stmt, index_base, iter->pkid);
    sqlite3_bind_int64(stmt, index_base + 1, iter->task_pkid);
    sqlite3_bind_text(stmt, index_base + 2, iter->id, -1, SQLITE_TRANSIENT);
    sqlite3_bind_text(stmt, index_base + 3, iter->name, -1, SQLITE_TRANSIENT);
    sqlite3_bind_int(stmt, index_base + 4, iter->srs);
    sqlite3_bind_int64(stmt, index_base + 5, iter->junction_pkid);
    sqlite3_bind_double(stmt, index_base + 6, iter->ground);
    sqlite3_bind_int(stmt, index_base + 7, iter->section_num);
    sqlite3_bind_int(stmt, index_base + 8, iter->road_type);
    sqlite3_bind_int(stmt, index_base + 9, iter->direction);
    sqlite3_bind_int(stmt, index_base + 10, iter->toll);
    sqlite3_bind_int(stmt, index_base + 11, iter->func_class);
    sqlite3_bind_int(stmt, index_base + 12, iter->urban);
    sqlite3_bind_int(stmt, index_base + 13, iter->paved);
    sqlite3_bind_int(stmt, index_base + 14, iter->transition_type);
    sqlite3_bind_int(stmt, index_base + 15, iter->lane_mark);
    sqlite3_bind_int(stmt, index_base + 16, iter->material);

    /*
    createBlob( iter->curvature, iter->srs, curvature );
    sqlite3_bind_blob(stmt, index_base+17, curvature.data, curvature.size, SQLITE_TRANSIENT);

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

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

    createBlob( iter->super_elevation, iter->srs, super_elevation );
    sqlite3_bind_blob(stmt, index_base+20, super_elevation.data, super_elevation.size, SQLITE_TRANSIENT);
    */

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

    int r = sqlite3_step(stmt);
    if (SQLITE_DONE != r) {
      std::cerr << "Insert Road Error, Id " << iter->id << ", Code " << r << std::endl;