WIP routesearch; before better SQL stmts

[ypp-sc-tools.db-test.git] / yarrg / rssetup.c

diff --git a/yarrg/rssetup.c b/yarrg/rssetup.c
index e169dd5d323cfe8a9113313bc5b45af3aa3502ff..dadeca6bda4509eff3a17008be0cfefafb9d237d 100644 (file)
--- a/yarrg/rssetup.c
+++ b/yarrg/rssetup.c
@@ -23,6 +23,15 @@ void setup(void) {
   setup_value();
 }
 
+int sql_single_int(const char *stmt) {
+  sqlite3_stmt *sst;
+  SQL_MUST( sqlite3_prepare(db, stmt, -1,&sst,0) );
+  assert( SQL_STEP(sst) );
+  int rv= sqlite3_column_int(sst,0);
+  sqlite3_finalize(sst);
+  return rv;
+}
+
 int sql_step_wrap(sqlite3_stmt *ssh, const char *ssh_string,
                  const char *file, int line) {
   for (;;) {
@@ -39,7 +48,8 @@ int sql_step_wrap(sqlite3_stmt *ssh, const char *ssh_string,
        fprintf(stderr,"SQL %s R",ssh_string);
        for (i=0; i<sqlite3_column_count(ssh); i++) {
          fputc('\t',stderr);
-         fputs((char*)sqlite3_column_text(ssh,i),stderr);
+         const char *txt= (const char*)sqlite3_column_text(ssh,i);
+         fputs(txt ? txt : "<null>", stderr);
        }
        fputs("\n",stderr);
       }