| 1220 | } |
| 1221 | |
| 1222 | void account_add(struct db *db, struct account *acct) |
| 1223 | { |
| 1224 | struct db_stmt *stmt; |
| 1225 | |
| 1226 | stmt = db_prepare_v2(db, SQL("INSERT INTO accounts" |
| 1227 | " (" |
| 1228 | " name" |
| 1229 | ", peer_id" |
| 1230 | ", is_wallet" |
| 1231 | ", we_opened" |
| 1232 | ", leased" |
| 1233 | ")" |
| 1234 | " VALUES" |
| 1235 | " (?, ?, ?, ?, ?);")); |
| 1236 | |
| 1237 | db_bind_text(stmt, 0, acct->name); |
| 1238 | if (acct->peer_id) |
| 1239 | db_bind_node_id(stmt, 1, acct->peer_id); |
| 1240 | else |
| 1241 | db_bind_null(stmt, 1); |
| 1242 | db_bind_int(stmt, 2, acct->is_wallet ? 1 : 0); |
| 1243 | db_bind_int(stmt, 3, acct->we_opened ? 1 : 0); |
| 1244 | db_bind_int(stmt, 4, acct->leased ? 1 : 0); |
| 1245 | |
| 1246 | db_exec_prepared_v2(stmt); |
| 1247 | acct->db_id = db_last_insert_id_v2(stmt); |
| 1248 | tal_free(stmt); |
| 1249 | } |
| 1250 | |
| 1251 | void maybe_update_account(struct db *db, |
| 1252 | struct account *acct, |