Skip to content

Instantly share code, notes, and snippets.

View Sheikh2Imran's full-sized avatar
🎯
Focusing

Md Imran Sheikh Sheikh2Imran

🎯
Focusing
9 followers · 0 following
View GitHub Profile
@Sheikh2Imran
Sheikh2Imran / models.py
Last active December 15, 2019 14:41
How to use BrinIndex in Django model
from django.db import models
from django.contrib.postgres.indexes import BrinIndex
class Account(models.Model):
id = models.AutoField()
username = models.CharField(max_lenght=100)
password = models.CharField(max_lenght=200)
class Meta:
@Sheikh2Imran
Sheikh2Imran / formatted_date.py
Last active December 15, 2019 14:40
Convert date object into a desired format (Ex- 16-12-2019)
import time
from django.utils import timezone
now_time = timezone.now().timetuple()
formatted_time = time.strftime("%d-%m-%Y %H:%M:%S", now_time)
print(formatted_time) # it will print '15-12-2019 10:49:54'
@Sheikh2Imran
Sheikh2Imran / xml_to_json.py
Last active December 15, 2019 14:33
Convert xml object to json
from xml.etree.ElementTree import fromstring
from xmljson import parker
xml_data =
<?xml version="1.0"?>
<COMMAND>
<ID>2341</ID>
<NAME>"testname"</NAME>
<EMAIL>"testemail@gmail.com"</EMAIL>
@Sheikh2Imran
Sheikh2Imran / json_to_xml.py
Last active December 15, 2019 14:32
Convert json object to xml object
data = {
"id": "124324",
"name": "testname",
"email": "testname@gmail.com",
"password": "test1234"
}
def get_json_to_xml_data(data):
return f'''
<?xml version="1.0"?>
@Sheikh2Imran
Sheikh2Imran / decorators.py
Last active December 21, 2021 14:28
Custom method decorator in Django
def authentication_decorator(function):
def wrap(request, *args, **kwargs):
user_token = request.META.get('HTTP_AUTHORIZATION')
user_response, status_code = backend_obj.get_user(user_token)
if status_code == 200:
kwargs = user_response
return function(request, *args, **kwargs)
return wrap
@Sheikh2Imran
Sheikh2Imran / create_or_get.py
Last active December 15, 2019 14:38
create_or_get ORM in Django
# should not use
try:
Account.objects.get(username='testuser', password='test1234')
except ObjectDoesNotExist:
Account.objects.create(username='testuser', password='test1234')
# should use
try:
Account.objects.get_or_create(username='testuser', password='test1234')
except Exception as e:
@Sheikh2Imran
Sheikh2Imran / create_user_and_database.txt
Last active December 15, 2019 14:36
How to setup postgres database in Django
-> sudo su - postgres # To perform administrative tasks
-> password # Enter user password
-> psql # Log into a Postgres session
-> CREATE DATABASE db_name;
-> CREATE USER db_user WITH PASSWORD 'your_password';
-> ALTER ROLE db_user SET client_encoding TO 'utf8';
-> ALTER ROLE db_user SET default_transaction_isolation TO 'read committed';
-> ALTER ROLE db_user SET timezone TO 'UTC';
@Sheikh2Imran
Sheikh2Imran / clean_database_scripts.py
Last active December 15, 2019 14:37
Clean all postgres database model By running script
from django.db import connections, OperationalError
# Drop all tables from a given database
"""
python manage.py runscript clean_database_tables
"""
def run():
@Sheikh2Imran
Sheikh2Imran / settings.py
Last active December 20, 2019 11:31
How to setup template path in Django settings.py
BASE_DIR = os.path.dirname(os.path.dirname(os.path.abspath(__file__)))
TEMPLATES = [
{
'BACKEND': 'django.template.backends.django.DjangoTemplates',
'DIRS': [os.path.join(BASE_DIR, 'templates')],
'APP_DIRS': True,
'OPTIONS': {
'context_processors': [
'django.template.context_processors.debug',
@Sheikh2Imran
Sheikh2Imran / javascript_counter.html
Created December 20, 2019 05:09
How to make a counter in JavaScript
<!DOCTYPE HTML>
<html>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1">
<style>
p {
text-align: center;
font-size: 60px;
margin-top: 0px;
}