The going was very good for diesel for a long time - but now the writing is on the wall. This is the full story.