Fix bug in test and implement the SniperTableAdapter