Exporting all triggers when using include-tables

[juppwerner]

Hello,

I am crossposting this issue here, too, because i just realized that the original repository is stale.

I have skip-triggers set to false.
I am also using include-tables to only select some tables to be dumped.

I expect to only get the CREATE TRIGGERs related to the included tables. But all triggers get exported.

I believe a fix could something like this:

public function getDatabaseStructureTriggers()
{
// Listing all triggers from database
if (false === $this->dumpSettings['skip-triggers']) {
foreach ($this->dbHandler->query($this->typeAdapter->show_triggers($this->dbName)) as $row) {
if(in_array($row['Table'], $this->dumpSettings['include-views']))
array_push($this->triggers, $row['Trigger']);
}
}
return;
}
Thank you.

Regards
Joachim

[back-2-95]

Hello,

Could you create a PR ? I'm not super duper SQL expert so PRs run against the tests are very helpful.