my sister did a similar thing last year - OD'd but not with the intent of suicide.
her pdoc and therapist didn't terminate her

.
it is difficult facing people who care about us when we know we have let ourselves down. but hopefully your T will work with you to towards gaining "life affirming skills" (like ktgirl said, which is great) and not make you feel even more bad.
i told pdoc last week that i have been wanting to self harm, but haven't yet, as i am scared i won't have control over it this time and will do serious damage. he offered to see me more often (i already see him once a week), and also asked that i send him a message to let him know how i'm travelling in 5 days (that would be today. hmm). he also said i could take some meds he's given me before to help take the edge off the urge.
it did help, because now i have 3 things i can do before i need to self harm.