Carl O'Brien, who once harangued city SNP staff with bigoted abuse, was locked up after admitting the domestic assault.