FakeApp is really a FrontController

Also use a more conventional style to wire middleware [#72663842]

Signed-off-by: Abhijit Hiremagalur <abhi@pivotallabs.com>
Test authz branches at ModelController only

- Continue to test that auth is wired into all controllers
- Add an admin-only shared example
- [#72663842]

Signed-off-by: Abhijit Hiremagalur <abhi@pivotallabs.com>
Avoid recreating tables too often

- By using an in memory sqlite db where the type of db does not matter
- By creating test tables once for the suite
- Unfixed gotcha: query_spec relies on auto-incrementing ids always starting with 1
- [#72814950]

Signed-off-by: Abhijit Hiremagalur <abhi@pivotallabs.com>