added failed insert test
implemented update
implemented query