chiark
/
gitweb
/
~yarrgweb
/
ypp-sc-tools.db-live.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Use GLPK's simplex solver instead
[ypp-sc-tools.db-live.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;
sqlite3 *db;
sqlite3_stmt *ss_ipair;
+int islandtablesz;
+
DEBUG_DEFINE_DEBUGF(sql);
static int busy_handler(void *u, int previous) {
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;
}
return 1;
}
-void setup(void) {
+void setup
_sql
(void) {
sqlite3_stmt *sst;
SQL_MUST( sqlite3_open("OCEAN-Midnight.db", &db) );
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);
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) {
}
int sql_single_int(const char *stmt) {