Fixes #8316: Removing a host can create a huge transaction

Removing a host with some reports (say 200), and each of them with several log lines (10000) generates 2.000.000 DELETE sql statements in the same transaction.
More often than not, ActiveRecord won't be able to make such a big transaction, in fact it will likely eat all memory available (I tried on a machine 16GB RAM machine) and Foreman will stop working in that host. In the best scenario the DB will end up with a non-committed giant transaction.

I suggest deleting hosts and reports manually on host destroy to avoid this.
it was just an example for inner query, of course replace with the relevant code :)
you can just add .delete_all at the end afair.

you can probably refactor https://github.com/theforeman/foreman/blob/develop/app/models/report.rb#L123-L126 to include a single host as well.