t18n

SELECT conrelid::regclass AS table_from
     , conname
     , pg_get_constraintdef(c.oid)
FROM   pg_constraint c
JOIN   pg_namespace n ON n.oid = c.connamespace
WHERE  contype IN ('f', 'p ')
AND    n.nspname = 'public' -- your schema here
ORDER  BY conrelid::regclass::text, contype DESC;

t18n

Usage	Command
Open postgres with postgres user permission	psql -U postgres
Check Postgres version	select version();
Show all users with permissions	\du
List all databases	\l
Create a database	CREATE DATABASE db_name;
Grant all permission of a database to Postgres user	GRANT ALL PRIVILEGES ON DATABASE db_name TO pg_user;
Connect to a database	\c db_name
Connect to a database as specific user	\c db_name pg_user

t18n

// Return multiple className which separate by space
// Usage : Really useful when adding multiple classes to className as modules
export function classes(classArray) {
  return classArray.join(' ');
}

const squareBox = <div className={classes([styles['shape'], styles.square ])}>

t18n

// Install sitemap-generator first

const SitemapGenerator = require('sitemap-generator');

// create generator
var generator = SitemapGenerator('http://localhost:8080/', {
  maxDepth: 10,
  filepath: 'src/sitemap.xml',
  maxEntriesPerFile: 50000,
  stripQuerystring: true

t18n

1. Prerequisite

• Having Django app with basic set up running

2. Install Graphene pip install graphene-django

3. Register graphene-django In Project > Settings.py

• Add graphene-django to INSTALLED_APPS array
• Add Graphene schema under INSTALLED_APPS

t18n

#!/bin/bash

# Update CentOS with any patches
sudo yum update -y --exclude=kernel

# Tools
sudo yum install -y nano unzip screen wget

# Apache 2
sudo yum install -y httpd httpd-devel httpd-tools

t18n

1. Prerequisites

• Install Python 3
• Install Pip
• Install Virtualenv
• Install Postgres
• Install Django

2. Installation

• Create project