| 55 | } |
| 56 | |
| 57 | void db_set_intvar(struct db *db, char *varname, s64 val) |
| 58 | { |
| 59 | size_t changes; |
| 60 | struct db_stmt *stmt = db_prepare_v2(db, SQL("UPDATE vars SET intval=? WHERE name=?;")); |
| 61 | db_bind_int(stmt, 0, val); |
| 62 | db_bind_text(stmt, 1, varname); |
| 63 | if (!db_exec_prepared_v2(stmt)) |
| 64 | db_fatal("Error executing update: %s", stmt->error); |
| 65 | changes = db_count_changes(stmt); |
| 66 | tal_free(stmt); |
| 67 | |
| 68 | if (changes == 0) { |
| 69 | stmt = db_prepare_v2(db, SQL("INSERT INTO vars (name, intval) VALUES (?, ?);")); |
| 70 | db_bind_text(stmt, 0, varname); |
| 71 | db_bind_int(stmt, 1, val); |
| 72 | if (!db_exec_prepared_v2(stmt)) |
| 73 | db_fatal("Error executing insert: %s", stmt->error); |
| 74 | tal_free(stmt); |
| 75 | } |
| 76 | } |
| 77 | |
| 78 | s64 db_get_intvar(struct db *db, char *varname, s64 defval) |
| 79 | { |