1) It is always a good idea to turn off the sink and relieve the pressure in the line before doing anything else.
2) I can see how this could happen to anyone... one little detail overlooked and BAM, water everywhere
3) Never test Murphy's Law, you will always lose.
4) If you want a small trickle from the python, it is best to adjust the pressure at the sink, not the python valve. Keeping too much pressure in the line can cause plastic pieces to crack, or the entire thing to pop off the faucet.
5) I've come to expect this sort of thing to happen any time I get near the tank plumbing. My advice, buy yourself some chamois