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 / maxemail_client.py

Last active September 18, 2020 09:52

Maxemail API Python client

	import codecs
	from contextlib import closing
	import csv
	from datetime import datetime
	import json
	from typing import Dict, List

	import requests
	from requests.auth import HTTPBasicAuth

sekharpanja / models.py

Last active April 23, 2020 11:19

Model changes to incorporate export pipeline models into existing company lists.

	from uuid import uuid4

	from django.conf import settings
	from django.db import models

	from datahub.core.models import BaseModel
	from datahub.core.utils import StrEnum


	class AbstractCompanyListBase(BaseModel):

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):