Description

#7342 introduced a change where nox would check for test_*.py and *_test.py files. Django and IDP-SQL had their tests in test/, so this glob didn't find these files, and these tests haven't been run for a bit.

Outstanding issues with these tests:

dynamic PR status update follows

• Django: Postgres 9.6 EOL

Step #6 - "Migrate database": django.db.utils.ProgrammingError: column c.relispartition does not exist
Step #6 - "Migrate database": LINE 3:             CASE WHEN c.relispartition THEN 'p' WHEN c.relki...
Step #6 - "Migrate database": 

Debugging seems to indicate this happens on old versions of postgres. Django 4.0 no longer supports Postgres 9.6. test-instance-pg is Postgres 9.6, which is EOL as of November 2021.

Suggest creating a newer versioned instance of a postgres testing database (happy to help here where I can).

Update: test-instance-pg has been updated to Postgres 14

• IDP: Linting issues

./middleware.py:31:29: ANN401 Dynamically typed expressions (typing.Any) are disallowed
    def decorated_function(*args: Any, **kwargs: Any) -> Any:
                            ^
./middleware.py:31:42: ANN401 Dynamically typed expressions (typing.Any) are disallowed
    def decorated_function(*args: Any, **kwargs: Any) -> Any:
                                         ^
./middleware.py:31:61: ANN401 Dynamically typed expressions (typing.Any) are disallowed
    def decorated_function(*args: Any, **kwargs: Any) -> Any:
                                                            ^

This is being addressed as of v2.9.0 of flake8-annotations. sco1/flake8-annotations#136

It will require adding --allow-star-arg-any to the flake8 call.

Update: while this flag could be used, I opted to use the TypeVar method in #7789

Checklist

• I have followed Sample Guidelines from AUTHORING_GUIDE.MD
• README is updated to include all relevant information
• Tests pass: nox -s py-3.6 (see Test Environment Setup)
• Lint pass: nox -s lint (see Test Environment Setup)
• These samples need a new API enabled in testing projects to pass (let us know which ones)
• These samples need a new/updated env vars in testing projects set to pass (let us know which ones)
• Please merge this PR for me once it is approved.
• This sample adds a new sample directory, and I updated the CODEOWNERS file with the codeowners for this sample