| 58 | } |
| 59 | |
| 60 | void db_set_intvar(struct db *db, const char *varname, s64 val) |
| 61 | { |
| 62 | size_t changes; |
| 63 | struct db_stmt *stmt = db_prepare_v2(db, SQL("UPDATE vars SET intval=? WHERE name=?;")); |
| 64 | db_bind_int(stmt, val); |
| 65 | db_bind_text(stmt, varname); |
| 66 | db_exec_prepared_v2(stmt); |
| 67 | changes = db_count_changes(stmt); |
| 68 | tal_free(stmt); |
| 69 | |
| 70 | if (changes == 0) { |
| 71 | stmt = db_prepare_v2(db, SQL("INSERT INTO vars (name, intval) VALUES (?, ?);")); |
| 72 | db_bind_text(stmt, varname); |
| 73 | db_bind_int(stmt, val); |
| 74 | db_exec_prepared_v2(stmt); |
| 75 | tal_free(stmt); |
| 76 | } |
| 77 | } |
| 78 | |
| 79 | s64 db_get_intvar(struct db *db, const char *varname, s64 defval) |
| 80 | { |