This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Postgres Internals | |
Djangocon US 2024 | |
Elizabeth Christensen | |
## psql basics | |
--whoami | |
\conninfo | |
--user list |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
class SampleFilter(filters.FilterSet): | |
start_date = django_filters.DateFilter(name="date", lookup_type='gte') | |
end_date = django_filters.DateFilter(name="date", lookup_type='lte') | |
# How to filter by a foreign key that uses slug as a lookup | |
foo = django_filters.ModelMultipleChoiceFilter( | |
queryset=MyModel.objects.all(), | |
to_field_name='slug', | |
conjoined=True, | |
) | |
class Meta: |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
from django.db.models import Count, Max | |
from core.models import HelpRequest | |
unique_fields = ['phone', 'title'] | |
actives = HelpRequest.objects.filter(active=True) | |
duplicates = ( | |
actives.values(*unique_fields) | |
.order_by() |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/env python | |
import sys | |
import subprocess | |
diff_requirements = 'git diff ORIG_HEAD HEAD --exit-code -- requirements.txt' | |
exit_code = subprocess.call(diff_requirements.split()) | |
if exit_code == 1: | |
print 'The requirements file has changed! Remember to install new dependencies.' | |
else: |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/python | |
# Quick and dirty demonstration of CVE-2014-0160 by Jared Stafford ([email protected]) | |
# The author disclaims copyright to this source code. | |
import sys | |
import struct | |
import socket | |
import time | |
import select |