void Gamefield::_destroyElement(ElementPtr const& elem) {
//Remove Element from QuadTree
if(elem->getRegion()) {
if (!elem->getRegion()->remove(elem.get())) {
fprintf(stderr, "Elem is not inside its own Region %d %p\n", elem->getId(), elem.get());
if (!mQuadTree->remove(elem.get()))
fprintf(stderr, "Remove from QuadTree failed for %d %p\n", elem->getId(), elem.get());
}
} else
if(!mQuadTree->remove(elem.get()))
fprintf(stderr, "Remove2 from QuadTree failed for %d %p\n", elem->getId(), elem.get());
elem->setRegion(NULL);
lock_guard<mutex> _lock(mMutexElements);
//Find element
auto it = mElements.begin();
while (it != mElements.end()) {
if ((*it)->getId() == elem->getId())
break;
it++;
}
if (it != mElements.end()) {
//Swap with last element then pop last (no realocation needed)
(*it) = mElements.back();
mElements.pop_back();
}
}
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 Gamefield::destroyElement(ElementPtr const& elem) {
if(elem->isDeleted()) {
fprintf(stderr, "Dubble destory of element!!!!!! %d %p\n", elem->getId(), elem.get());
assert(false);
return;
}
//printf("Maring as Deleted %d %p\n", elem->getId(), elem.get());
elem->markDeleted();
{
lock_guard<mutex> _lock(mMutexDeletedElements);
mDeletedElements.push_back(elem);
}
if (elem->getType() == ET_Ball) {
auto ball = std::dynamic_pointer_cast<Ball>(elem);
ball->getPlayer()->removeBall(ball->getId());
}
if (elem->getType() == ET_Food)
mFoodCounter--;
else if (elem->getType() == ET_Obstracle)
mObstracleCounter--;
else if (elem->getType() == ET_Item)
mItemCounter--;
}
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());
}
