4 * See docs for table definitions.
24 typedef struct _poi_db poi_db;
31 /** Data to describe a POI. */
32 typedef struct _poi_info poi_info;
45 /** Data used during action: add or edit category/poi **/
46 typedef struct _delete_poi delete_poi;
53 typedef struct _poi_category poi_category;
54 struct _poi_category {
63 sqlite3_stmt *select_poi;
64 sqlite3_stmt *select_nearest_poi;
65 sqlite3_stmt *select_poi_search;
66 sqlite3_stmt *select_poi_search_cat;
67 sqlite3_stmt *insert_poi;
68 sqlite3_stmt *update_poi;
69 sqlite3_stmt *delete_poi;
70 sqlite3_stmt *delete_poi_by_catid;
71 sqlite3_stmt *nextlabel_poi;
72 sqlite3_stmt *select_cat;
73 sqlite3_stmt *insert_cat;
74 sqlite3_stmt *update_cat;
75 sqlite3_stmt *delete_cat;
76 sqlite3_stmt *toggle_cat;
77 sqlite3_stmt *selall_cat;
78 sqlite3_stmt *select_quick_cat;
80 struct sql_poi_stmt poisql;
84 gboolean poi_init(sqlite3 **db);
85 void poi_deinit(sqlite3 *db);
87 gboolean poi_db_create(sqlite3 *db);
88 gboolean poi_db_prepare(sqlite3 *db);
90 poi_info *poi_new(void);
91 void poi_free(poi_info *p);
93 gboolean poi_get_list_near(guint unitx, guint unity, GtkListStore **store, guint *num_cats);
94 gboolean poi_update(guint poi_id, guint cat_id, gchar *poi_label, gchar *poi_desc);
95 gboolean poi_add(gdouble lat, gdouble lon, guint cat_id, gchar *poi_label, gchar *poi_desc);
96 gboolean poi_delete(guint id);
98 gboolean poi_search(poi_search_type pst, gdouble lat, gdouble lon, gchar *text, guint cat, GtkListStore **store);
100 poi_category *poi_category_new(void);
101 void poi_category_free(poi_category *c);
102 gboolean poi_category_get(guint cat_id, poi_category **c);
103 gboolean poi_category_delete(guint id);
104 gboolean poi_category_update(guint cat_id, poi_category *c);
105 poi_info *poi_find_nearest(gdouble lat, gdouble lon);
106 gboolean poi_category_toggle(guint cat_id, gboolean cat_enabled);
107 GtkListStore *poi_category_generate_store(void);