void OsmApiDbSqlChangesetFileWriter::_createNewElement(ConstElementPtr element)
{
const QString elementTypeStr = element->getElementType().toString().toLower();
ElementPtr changeElement = _getChangeElement(element);
//we only grab and assign a new id if we have a new element with a negative id, since we'll be
//writing this directly to the database and negative ids aren't allowed
LOG_TRACE("ID before: " << changeElement->getElementId());
long id;
if (changeElement->getId() < 0)
{
id = _db.getNextId(element->getElementType().getEnum());
}
else
{
id = changeElement->getId();
}
LOG_TRACE("ID after: " << ElementId(changeElement->getElementType(), id));
changeElement->setId(id);
changeElement->setVersion(1);
changeElement->setVisible(true);
changeElement->setChangeset(_changesetId);
LOG_TRACE("Creating: " << changeElement->getElementId());
QString note = "";
LOG_VART(changeElement->getId());
LOG_VART(note);
LOG_VART(changeElement->getVersion());
QString commentStr = "/* create " + elementTypeStr + " " + QString::number(changeElement->getId());
commentStr += "*/\n";
_outputSql.write((commentStr).toUtf8());
const QString values = _getInsertValuesStr(changeElement);
_outputSql.write(
("INSERT INTO " + elementTypeStr + "s (" + elementTypeStr + "_id, " + values).toUtf8());
_outputSql.write(("INSERT INTO current_" + elementTypeStr + "s (id, " + values).toUtf8());
_createTags(changeElement);
switch (changeElement->getElementType().getEnum())
{
case ElementType::Way:
_createWayNodes(boost::dynamic_pointer_cast<const Way>(changeElement));
break;
case ElementType::Relation:
_createRelationMembers(boost::dynamic_pointer_cast<const Relation>(changeElement));
break;
default:
//node
break;
}
}
void OsmApiDbSqlChangesetFileWriter::_updateExistingElement(ConstElementPtr element)
{
const QString elementTypeStr = element->getElementType().toString().toLower();
ElementPtr changeElement = _getChangeElement(element);
//if another parsed change previously modified the element with this id, we want to get the
//modified version
const long currentVersion = changeElement->getVersion();
const long newVersion = currentVersion + 1;
changeElement->setVersion(newVersion);
changeElement->setChangeset(_changesetId);
changeElement->setVisible(true);
LOG_TRACE("Updating: " << changeElement->getElementId());
QString note = "";
LOG_VART(changeElement->getId());
LOG_VART(note);
LOG_VART(changeElement->getVersion());
QString commentStr = "/* modify " + elementTypeStr + " " + QString::number(changeElement->getId());
commentStr += "*/\n";
_outputSql.write((commentStr).toUtf8());
//<element-name> table contains all version of all elements of that type in a history, so insert
//into that table.
_outputSql.write(
("INSERT INTO " + elementTypeStr + "s (" + elementTypeStr + "_id, " +
_getInsertValuesStr(changeElement)).toUtf8());
//current_<element-name> contains the single latest version of the element, so update that record
_outputSql.write(
("UPDATE current_" + elementTypeStr + "s SET " + _getUpdateValuesStr(changeElement)).toUtf8());
_deleteCurrentTags(changeElement->getElementId());
_createTags(changeElement);
switch (changeElement->getElementType().getEnum())
{
case ElementType::Way:
_deleteAll(ApiDb::getCurrentWayNodesTableName(), "way_id", changeElement->getId());
_deleteAll(ApiDb::getWayNodesTableName(), "way_id", changeElement->getId());
_createWayNodes(boost::dynamic_pointer_cast<const Way>(changeElement));
break;
case ElementType::Relation:
_deleteAll(ApiDb::getCurrentRelationMembersTableName(), "relation_id", changeElement->getId());
_deleteAll(ApiDb::getRelationMembersTableName(), "relation_id", changeElement->getId());
_createRelationMembers(boost::dynamic_pointer_cast<const Relation>(changeElement));
break;
default:
//node
break;
}
}
void OsmApiDbSqlChangesetFileWriter::_deleteExistingElement(ConstElementPtr element)
{
const QString elementIdStr = QString::number(element->getId());
const QString elementTypeStr = element->getElementType().toString().toLower();
ElementPtr changeElement = _getChangeElement(element);
const long currentVersion = changeElement->getVersion();
const long newVersion = currentVersion + 1;
changeElement->setVersion(newVersion);
changeElement->setVisible(false);
changeElement->setChangeset(_changesetId);
LOG_TRACE("Deleting: " << changeElement->getElementId());
QString note = "";
LOG_VART(changeElement->getId());
LOG_VART(note);
LOG_VART(changeElement->getVersion());
QString commentStr = "/* delete " + elementTypeStr + " " + QString::number(changeElement->getId());
commentStr += "*/\n";
_outputSql.write((commentStr).toUtf8());
//OSM API DB keeps history for all elements, so the existing element in the master table is not
//modified and a new record is added with the updated version and visible set to false
_outputSql.write(("INSERT INTO " + elementTypeStr + "s (" + elementTypeStr + "_id, " +
_getInsertValuesStr(changeElement)).toUtf8());
_deleteCurrentTags(changeElement->getElementId());
switch (changeElement->getElementType().getEnum())
{
case ElementType::Node:
_outputSql.write(
("DELETE FROM " + ApiDb::getCurrentWayNodesTableName() +
" WHERE node_id=" + elementIdStr + ";\n").toUtf8());
_outputSql.write(
("DELETE FROM " + ApiDb::getCurrentRelationMembersTableName() +
" WHERE member_type = 'Node' AND member_id = " +
elementIdStr + ";\n").toUtf8());
break;
case ElementType::Way:
//all of its entries in current way nodes are removed
_outputSql.write(
("DELETE FROM " + ApiDb::getCurrentWayNodesTableName() +
" WHERE way_id=" + elementIdStr + ";\n").toUtf8());
_outputSql.write(
("DELETE FROM " + ApiDb::getCurrentRelationMembersTableName() +
" WHERE member_type = 'Way' AND member_id = " +
elementIdStr + ";\n").toUtf8());
break;
case ElementType::Relation:
_outputSql.write(
("DELETE FROM " + ApiDb::getCurrentRelationMembersTableName() +
" WHERE relation_id=" + elementIdStr + ";\n").toUtf8());
_outputSql.write(
("DELETE FROM " + ApiDb::getCurrentRelationMembersTableName() +
" WHERE member_type = 'Relation' AND member_id = " +
elementIdStr + ";\n").toUtf8());
break;
default:
throw HootException("Unknown element type");
}
//in the current table, the element isn't deleted but set to be invisible
const QString values =
QString("changeset_id=%1, visible=%2, version=%3 WHERE id=%4;\n")
.arg(changeElement->getChangeset())
.arg(_getVisibleStr(changeElement->getVisible()))
.arg(changeElement->getVersion())
.arg(changeElement->getId());
_outputSql.write(("UPDATE current_" + elementTypeStr + "s SET " + values).toUtf8());
}
