Function wallet_state_change_get

wallet/wallet.c:1836–1869

}

static struct channel_state_change **wallet_state_change_get(const tal_t *ctx,
							     struct wallet *w,
							     u64 channel_id)
{
	struct db_stmt *stmt;
	struct channel_state_change **res = tal_arr(ctx,
						    struct channel_state_change *, 0);
	stmt = db_prepare_v2(
	    w->db, SQL("SELECT"
		       " timestamp,"
		       " old_state,"
		       " new_state,"
		       " cause,"
		       " message "
		       "FROM channel_state_changes "
		       "WHERE channel_id = ? "
		       "ORDER BY timestamp ASC;"));
	db_bind_int(stmt, channel_id);
	db_query_prepared(stmt);

	while (db_step(stmt)) {
		struct channel_state_change *c;

		c = new_channel_state_change(res,
					     db_col_timeabs(stmt, "timestamp"),
					     db_col_int(stmt, "old_state"),
					     db_col_int(stmt, "new_state"),
					     state_change_in_db(db_col_int(stmt, "cause")),
					     take(db_col_strdup(NULL, stmt, "message")));
		tal_arr_expand(&res, c);
	}
	tal_free(stmt);
	return res;
}

/**
 * wallet_stmt2channel - Helper to populate a wallet_channel from a `db_stmt`