Kiran Gangadharan kirang89

##Postgres commands cheatsheet

#####Setup data directory for database

initdb -D /usr/local/pgsql/data

#####Reload Postgres config from command line:

select pg_reload_conf();

General

Standards/Conventions: Make sure that code follows the appropriate standards/conventions (ex: PEP8 for Python).
Appropriate names: Make sure that variables, arguments, functions, modules and packages are named appropriately.
Valid arguments: Make sure that all method arguments are valid ones.
Single responsibility: Make sure that every function/method used has a single responsibility.
Disposable Resources: Make sure that temporary resources are terminated after their use (ex: opening a file to read content).
Security: Make sure no critical data or sensitive information is exposed in any way to the public. This involves both client-side as well as the server-side code (ex: storing a raw password to db)

.......

git checkout fix
git reset HEAD^
git checkout -b fix-1
git add -p
git commit
git stash
git checkout -b fix-1
git stash pop
git commit -a

	import sqlalchemy
	from sqlalchemy.ext.declarative import declarative_base
	from sqlalchemy import Column, Integer, String, ForeignKey
	from sqlalchemy.orm import sessionmaker, relationship


	engine = sqlalchemy.create_engine('sqlite:///:memory:')
	Base = declarative_base()

	import sqlalchemy
	from sqlalchemy.ext.declarative import declarative_base
	from sqlalchemy import Column, Integer, String
	from sqlalchemy.orm import sessionmaker, relationship, backref
	import uuid
	import json


	engine = sqlalchemy.create_engine('sqlite:///:memory:', echo=True)
	Base = declarative_base()

	#!/usr/bin/env python
	# -- coding: utf-8 --

	############################################################
	# #
	# Simple script to connect to a remote mysql database #
	# #
	# #
	# Install MySQLdb package by running: #
	# #

	#!/usr/bin/env python
	# -- coding: utf-8 --

	################################################
	# #
	# Script to download entire animorphs series #
	# #
	# Usage: python animorphs-downloader.py --help #
	# #
	#################################################