Know how you feel. Got a flattened rear tyre one week after purchase. Do people purposely drop self-tapping screws on the highways. Fixed it with a roadside fix plug. Been a year since repair and tyre maintains pressure very well. Previous tyre had three roadside plugs fitted during its life. Only had to repair one repair three times, (was still learning how to do it then). Don't like having roadside plug repairs, but all seems ok so far. Success comes from making sure the hole is reamed out well and very clean, use glue lavishly and allow a little curing time before reinflation.
Cheers, Hobs