| 1723 | } |
| 1724 | |
| 1725 | bool sqliteOperation::updateLane(const hadmap::tx_lane_t& lane) { |
| 1726 | char sql[512]; |
| 1727 | |
| 1728 | sprintf(sql, |
| 1729 | "UPDATE " LANE_TABLE |
| 1730 | " SET name = ?, srs = ?, left_boundary = ?, " |
| 1731 | "right_boundary = ?, lane_type = ?, lane_arrow = ?, speed_limit = ?, geom = ? " |
| 1732 | "WHERE road_pkid = %llu AND section_id = %u AND lane_id = %d", |
| 1733 | lane.road_pkid, lane.section_id, lane.lane_id); |
| 1734 | |
| 1735 | sqliteStmtPtr stmt(dbPtr, sql); |
| 1736 | |
| 1737 | sqlite3_bind_text(stmt, 1, lane.name, -1, SQLITE_TRANSIENT); |
| 1738 | sqlite3_bind_int(stmt, 2, lane.srs); |
| 1739 | sqlite3_bind_int64(stmt, 3, lane.left_boundary); |
| 1740 | sqlite3_bind_int64(stmt, 4, lane.right_boundary); |
| 1741 | sqlite3_bind_int(stmt, 5, lane.lane_type); |
| 1742 | sqlite3_bind_int(stmt, 6, lane.lane_arrow); |
| 1743 | sqlite3_bind_int(stmt, 7, lane.speed_limit); |
| 1744 | |
| 1745 | sqlite3_blob_data blob; |
| 1746 | createBlob(lane.geom, lane.srs, blob); |
| 1747 | sqlite3_bind_blob(stmt, 8, blob.data, blob.size, SQLITE_TRANSIENT); |
| 1748 | |
| 1749 | int r = sqlite3_step(stmt); |
| 1750 | if (SQLITE_DONE != r) std::cerr << "Update Lane Error, Code " << r << std::endl; |
| 1751 | sqlite3_reset(stmt); |
| 1752 | |
| 1753 | return r == SQLITE_DONE; |
| 1754 | } |
| 1755 | |
| 1756 | bool sqliteOperation::updateLaneBoundary(const hadmap::tx_laneboundary_t& boundary) { |
| 1757 | char sql[512]; |
no test coverage detected