WIP routesearch; searcher

[ypp-sc-tools.main.git] / yarrg / rssql.c

diff --git a/yarrg/rssql.c b/yarrg/rssql.c
index 463ef8b560c76dff97b047b22db55f5e4b7d73ca..898ac3b268350b4824021ba987002622600c88e3 100644 (file)
--- a/yarrg/rssql.c
+++ b/yarrg/rssql.c
@@ -4,6 +4,8 @@
 sqlite3 *db;
 sqlite3_stmt *ss_ipair;
 
+int islandtablesz;
+
 DEBUG_DEFINE_DEBUGF(sql);
 
 static int busy_handler(void *u, int previous) {
@@ -12,7 +14,7 @@ static int busy_handler(void *u, int previous) {
   return 1;
 }
 
-void setup(void) {
+void setup_sql(void) {
   sqlite3_stmt *sst;
   
   SQL_MUST( sqlite3_open("OCEAN-Midnight.db", &db) );
@@ -22,7 +24,8 @@ void setup(void) {
   assert( !SQL_STEP(sst) );
   sqlite3_finalize(sst);
 
-  setup_value();
+  islandtablesz= 1 + sql_single_int("SELECT max(islandid) FROM islands");
+  debugf("SQL islandtablesz=%d\n",islandtablesz);
 }
 
 int sql_single_int(const char *stmt) {