Django

Source: https://simpleisbetterthancomplex.com/tutorial/2016/07/26/how-to-reset-migrations.html

1. Remove all migrations

find . -path "*/migrations/*.py" -not -name "__init__.py" -delete
find . -path "*/migrations/*.pyc"  -delete

2. Delete and recreate database

3. Make migrations and migrate

./manage.py makemigrations
./manage.py migrate

Source: http://techstream.org/Bits/Remove-App-From-Django-Project

• Remove all imports and usage of the app in the project.
• Remove all models in models.py of the app. Can bring in error if the models are called in other files of the app like admin.py or any other so remove the reference or just delete the files expect init.py and models.py.
• Create a new migration for the app, which removes all models.
• Perform Migration.
• Production : If this is to be done in production, perform tests, push the code to production and perform migration before you proceed to next step.
• Remove the app from INSTALLED_APPS in settings.py.
• Delete the directory.

sudo nginx -s reload

# database optimization
subquery = Subquery(
    Job.objects.published().filter(school=OuterRef('pk'))
        .values('school').annotate(count=Count('pk'))
        .values('count'), output_field=IntegerField()
    )
    qs = qs.annotate(jobs_count=Coalesce(subquery, 0))