Method insertObjectGeomRels

common/map_sdk/mapdb/src/sqlite_operation.cpp:1569–1595

}

bool sqliteOperation::insertObjectGeomRels(hadmap::tx_object_geom_rel_vec& geom_rels) {
  const char* sql = SQL_INSERT_OBJECT_GEOM_REL;

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

  sqlite3_exec(dbPtr, "begin;", 0, 0, 0);
  bool complete = true;
  for (hadmap::tx_object_geom_rel_vec::iterator iter = geom_rels.begin(); iter != geom_rels.end(); ++iter) {
    sqlite3_bind_int64(stmt, 1, iter->object_pkid);
    sqlite3_bind_int64(stmt, 2, iter->geom_pkid);
    int r = sqlite3_step(stmt);
    if (SQLITE_DONE != r) {
      std::cerr << "Insert Object Geom Rel Error, Code " << r << std::endl;
      complete = false;
    }
    sqlite3_clear_bindings(stmt);
    sqlite3_reset(stmt);
    iter->pkid = sqlitePackage::getLastInsertedRowid(dbPtr);
  }
  sqlite3_exec(dbPtr, "commit;", 0, 0, 0);

  return complete;
}

bool sqliteOperation::insertObjectRels(hadmap::tx_object_rel_vec& rels) {
  const char* sql = SQL_INSERT_OBJECT_REL;