chiark
/
gitweb
/
~yarrgweb
/
ypp-sc-tools.db-test.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
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();
}
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 (;;) {
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);
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);
}
}
fputs("\n",stderr);
}