Function migrate_initialize_alias_local

wallet/db.c:989–1012

We required local aliases to be set on established channels, * but we forgot about already-existing ones in the db! */

/* We required local aliases to be set on established channels,
 * but we forgot about already-existing ones in the db! */
void migrate_initialize_alias_local(struct lightningd *ld,
				    struct db *db)
{
	struct db_stmt *stmt;
	u64 *ids = tal_arr(tmpctx, u64, 0);

	stmt = db_prepare_v2(db, SQL("SELECT id FROM channels"
				     " WHERE alias_local IS NULL;"));
	db_query_prepared(stmt);
	while (db_step(stmt))
		tal_arr_expand(&ids, db_col_u64(stmt, "id"));
	tal_free(stmt);

	for (size_t i = 0; i < tal_count(ids); i++) {
		stmt = db_prepare_v2(db, SQL("UPDATE channels"
					     " SET alias_local = ?"
					     " WHERE id = ?;"));
		/* We don't even check for clashes! */
		db_bind_short_channel_id(stmt, random_scid());
		db_bind_u64(stmt, ids[i]);
		db_exec_prepared_v2(stmt);
		tal_free(stmt);
	}
}

/* Insert address type as `ADDR_ALL` for issued addresses */
void insert_addrtype_to_addresses(struct lightningd *ld,