Improve test battery stability

Add skip_all function to test header.
Skip many Rosie tests if sqlalchemy not installed.
Avoid Jinja2 version instability.
Skip remote tests if test job host not defined.