Sekhar Panja sekharpanja

sekharpanja / remove_duplicates.py

Created February 22, 2024 13:11 — forked from victorono/remove_duplicates.py

Django - remove duplicate objects where there is more than one field to compare

	from django.db.models import Count, Max

	unique_fields = ['field_1', 'field_2']

	duplicates = (
	MyModel.objects.values(*unique_fields)
	.order_by()
	.annotate(max_id=Max('id'), count_id=Count('id'))
	.filter(count_id__gt=1)
	)

sekharpanja / postgres_queries_and_commands.sql

Created February 22, 2023 10:53 — forked from rgreenjr/postgres_queries_and_commands.sql

Useful PostgreSQL Queries and Commands

	-- show running queries (pre 9.2)
	SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(clock_timestamp(), query_start), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

sekharpanja / models.py

Created June 19, 2018 11:13 — forked from jacobian/models.py

An example of using many-to-many "through" to augment m2m relationships. See http://www.quora.com/How-do-you-query-with-a-condition-on-a-ManyToMany-model-in-Django for context.

	from django.db import models

	class Person(models.Model):
	name = models.CharField(max_length=200)
	groups = models.ManyToManyField('Group', through='GroupMember', related_name='people')

	class Meta:
	ordering = ['name']

	def __unicode__(self):