have the base adapter define `load_schema`

This moves the load schema logic down to the base adapter.  It is
handy to centralize db interaction in the adapters, and this interaction
is common to all adapters.

This will allow us to better test the test helpers using an adapter
spy.