Fianna Fáil leader Micheál Martin has finally won a by-election at the seventh time of asking in a badly needed victory that has relieved pressure on his leadership position.