QString OsmApiDbSqlChangesetFileWriter::_getUpdateValuesNodeStr(ConstNodePtr node) const
{
return
QString("latitude=%2, longitude=%3, changeset_id=%4, visible=%5, \"timestamp\"=%8, tile=%6, version=%7 WHERE id=%1;\n")
.arg(node->getId())
.arg((qlonglong)OsmApiDb::toOsmApiDbCoord(node->getY()))
.arg((qlonglong)OsmApiDb::toOsmApiDbCoord(node->getX()))
.arg(node->getChangeset())
.arg(_getVisibleStr(node->getVisible()))
.arg(ApiDb::tileForPoint(node->getY(), node->getX()))
.arg(node->getVersion())
.arg(OsmApiDb::TIMESTAMP_FUNCTION);
}
QString OsmApiDbSqlChangesetFileWriter::_getInsertValuesNodeStr(ConstNodePtr node) const
{
return
QString("latitude, longitude, changeset_id, visible, \"timestamp\", "
"tile, version) VALUES (%1, %2, %3, %4, %5, %8, %6, %7);\n")
.arg(node->getId())
.arg((qlonglong)OsmApiDb::toOsmApiDbCoord(node->getY()))
.arg((qlonglong)OsmApiDb::toOsmApiDbCoord(node->getX()))
.arg(node->getChangeset())
.arg(_getVisibleStr(node->getVisible()))
.arg(ApiDb::tileForPoint(node->getY(), node->getX()))
.arg(node->getVersion())
.arg(OsmApiDb::TIMESTAMP_FUNCTION);
}