Add exported/virtual resource spec tests and example manifests

Resources can be defined in the spec tests prior to catalog compilation
and will then be available to the catalog for importing.

A scratch database is created for each compile, and connections and
configuration settings are reset after each compile to allow for a clean
division between runs.