fhdez

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

• -E: will describe the underlaying queries of the \ commands (cool for learning!)
• -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

fhdez

[user]
	name = Pavan Kumar Sunkara
	email = pavan.sss1991@gmail.com
	username = pksunkara
[core]
	editor = vim
	whitespace = fix,-indent-with-non-tab,trailing-space,cr-at-eol
	excludesfile = ~/.gitignore
[sendemail]
	smtpencryption = tls

fhdez

# -*- coding: utf-8 -*-
from __future__ import unicode_literals

import itertools
import unicodecsv as csv

from optparse import make_option

from django.core.exceptions import ObjectDoesNotExist
from django.core.management.base import BaseCommand

fhdez

SELECT 
	nuevomodelo_aprendizajeesperadonme."id" AS "aprendizaje_id",
  nuevomodelo_aprendizajeesperadonme.nombre AS "aprendizaje_nombre",
	nuevomodelo_objetivonme."id" AS "objetivo_id",
	nuevomodelo_objetivonme.nombre AS "objetivo_nombre",	
	nuevomodelo_temanme."id" AS "tema_id",
	nuevomodelo_temanme.nombre AS "tema_nombre",
	nuevomodelo_asignaturanme."id" AS "asignatura_id",
	nuevomodelo_asignaturanme.nombre AS "asignatura_nombre",
  acuerdo_grado."id" AS "grado_id",