I know I've had experiences in life where I look back and say 'what was I thinking?!?'
As difficult as it is, nicely done on recognizing the situation, holding yourself accountable and chalking it up as a lesson learned. No doubt about it, this experience will help you somewhere down the line...
I'm really impressed with your articulate re-cap of the story.