navobj_db.cpp File Reference

Implement navobj_db.h – MySQL based storage for routes, tracks, etc. More...

#include <cmath>
#include <iomanip>
#include <memory>
#include <string>
#include <vector>
#include <wx/dir.h>
#include <wx/filename.h>
#include "model/base_platform.h"
#include "model/comm_appmsg_bus.h"
#include "model/navobj_db.h"
#include "model/navutil_base.h"
#include "model/notification.h"
#include "model/notification_manager.h"
#include "model/routeman.h"

Go to the source code of this file.

Functions
bool	CreateTables (sqlite3 *db)
bool	TrackExists (sqlite3 *db, const std::string &track_guid)
bool	TrackHtmlLinkExists (sqlite3 *db, const std::string &link_guid)
bool	DeleteAllCommentsForTrack (sqlite3 *db, const std::string &track_guid)
bool	InsertTrackPoint (sqlite3 *db, const std::string &track_guid, double lat, double lon, const std::string &timestamp, int i_point)
bool	InsertTrackHTML (sqlite3 *db, const std::string &track_guid, const std::string &link_guid, const std::string &descrText, const std::string &link, const std::string &ltype)
bool	DeleteAllCommentsForRoute (sqlite3 *db, const std::string &route_guid)
bool	RouteHtmlLinkExists (sqlite3 *db, const std::string &link_guid)
bool	RoutePointHtmlLinkExists (sqlite3 *db, const std::string &link_guid)
bool	RouteExistsDB (sqlite3 *db, const std::string &route_guid)
bool	InsertRouteHTML (sqlite3 *db, const std::string &route_guid, const std::string &link_guid, const std::string &descrText, const std::string &link, const std::string &ltype)
bool	RoutePointExists (sqlite3 *db, const std::string &routepoint_guid)
bool	InsertRoutePointHTML (sqlite3 *db, const std::string &point_guid, const std::string &link_guid, const std::string &descrText, const std::string &link, const std::string &ltype)
bool	DeleteAllCommentsForRoutePoint (sqlite3 *db, const std::string &routepoint_guid)
bool	InsertRoutePointDB (sqlite3 *db, RoutePoint *point)
bool	InsertRoutePointLink (sqlite3 *db, Route *route, RoutePoint *point, int point_order)
void	DeleteOrphanedRoutepoint (sqlite3 *db)
void	errorLogCallback (void *pArg, int iErrCode, const char *zMsg)

Detailed Description

Implement navobj_db.h – MySQL based storage for routes, tracks, etc.

Definition in file navobj_db.cpp.

Function Documentation

CreateTables()

bool CreateTables

(

sqlite3 *

db

)

Definition at line 61 of file navobj_db.cpp.

DeleteAllCommentsForRoute()

bool DeleteAllCommentsForRoute	(	sqlite3 *	db,
		const std::string &	route_guid
	)

Definition at line 293 of file navobj_db.cpp.

DeleteAllCommentsForRoutePoint()

bool DeleteAllCommentsForRoutePoint	(	sqlite3 *	db,
		const std::string &	routepoint_guid
	)

Definition at line 443 of file navobj_db.cpp.

DeleteAllCommentsForTrack()

bool DeleteAllCommentsForTrack	(	sqlite3 *	db,
		const std::string &	track_guid
	)

Definition at line 219 of file navobj_db.cpp.

DeleteOrphanedRoutepoint()

void DeleteOrphanedRoutepoint

(

sqlite3 *

db

)

Definition at line 513 of file navobj_db.cpp.

errorLogCallback()

void errorLogCallback	(	void *	pArg,
		int	iErrCode,
		const char *	zMsg
	)

Definition at line 525 of file navobj_db.cpp.

InsertRouteHTML()

bool InsertRouteHTML	(	sqlite3 *	db,
		const std::string &	route_guid,
		const std::string &	link_guid,
		const std::string &	descrText,
		const std::string &	link,
		const std::string &	ltype
	)

Definition at line 370 of file navobj_db.cpp.

InsertRoutePointDB()

bool InsertRoutePointDB	(	sqlite3 *	db,
		RoutePoint *	point
	)

Definition at line 464 of file navobj_db.cpp.

InsertRoutePointHTML()

bool InsertRoutePointHTML	(	sqlite3 *	db,
		const std::string &	point_guid,
		const std::string &	link_guid,
		const std::string &	descrText,
		const std::string &	link,
		const std::string &	ltype
	)

Definition at line 416 of file navobj_db.cpp.

InsertRoutePointLink()

bool InsertRoutePointLink	(	sqlite3 *	db,
		Route *	route,
		RoutePoint *	point,
		int	point_order
	)

Definition at line 486 of file navobj_db.cpp.

InsertTrackHTML()

bool InsertTrackHTML	(	sqlite3 *	db,
		const std::string &	track_guid,
		const std::string &	link_guid,
		const std::string &	descrText,
		const std::string &	link,
		const std::string &	ltype
	)

Definition at line 264 of file navobj_db.cpp.

InsertTrackPoint()

bool InsertTrackPoint	(	sqlite3 *	db,
		const std::string &	track_guid,
		double	lat,
		double	lon,
		const std::string &	timestamp,
		int	i_point
	)

Definition at line 238 of file navobj_db.cpp.

RouteExistsDB()

bool RouteExistsDB	(	sqlite3 *	db,
		const std::string &	route_guid
	)

Definition at line 351 of file navobj_db.cpp.

RouteHtmlLinkExists()

bool RouteHtmlLinkExists	(	sqlite3 *	db,
		const std::string &	link_guid
	)

Definition at line 312 of file navobj_db.cpp.

RoutePointExists()

bool RoutePointExists	(	sqlite3 *	db,
		const std::string &	routepoint_guid
	)

Definition at line 397 of file navobj_db.cpp.

RoutePointHtmlLinkExists()

bool RoutePointHtmlLinkExists	(	sqlite3 *	db,
		const std::string &	link_guid
	)

Definition at line 331 of file navobj_db.cpp.

TrackExists()

bool TrackExists	(	sqlite3 *	db,
		const std::string &	track_guid
	)

Definition at line 179 of file navobj_db.cpp.

TrackHtmlLinkExists()

bool TrackHtmlLinkExists	(	sqlite3 *	db,
		const std::string &	link_guid
	)

Definition at line 199 of file navobj_db.cpp.