Rosdyana Kusuma rosdyana

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)

	#!/bin/bash
	#set -x

	# Shows you the largest objects in your repo's pack file.
	# Written for osx.
	#
	# @see http://stubbisms.wordpress.com/2009/07/10/git-script-to-show-largest-pack-objects-and-trim-your-waist-line/
	# @author Antony Stubbs

	# set the internal field spereator to line break, so that we can iterate easily over the verify-pack output

	def repeatedString(s, n):
	number = s.count('a')
	if number == 0:
	return 0
	if number == 1 and len(s) == 1:
	return n
	repeats = n//len(s)
	remainder = math.floor(n%len(s))
	return number*repeats+s[:remainder].count('a')

	from django.db.models import Count, Max, Q
	from django.db.models.functions import Length
	from ma_audience.models import Audience

	unique_fields = ['email']

	duplicates = (
	Audience.objects.filter(Q(organization_id=81), ~Q(email=''), Q(email__isnull=False)).values(*unique_fields)
	.order_by()
	.annotate(max_id=Max('id'), count_id=Count('id'))

	from omnidata.models import *
	from ma_audience.models import *
	from django.db.models import *
	from omnidata.models import Product as d_Product, Organization as d_Organization, Conversion, PageView
	import collections
	from datetime import timedelta


	org = Organization.objects.get(id=1) # Ruby
	d_org = d_Organization.objects.get(id=1)

	# from remote to local
	```
	scp [email protected]:/remote/file.txt /local/directory
	```

	# from local to remote
	```
	scp file.txt [email protected]:/remote/directory
	```

	import pandas as pd
	import sys

	CHUNK_SIZE = int(sys.argv[2])
	rows = pd.read_csv(sys.argv[1], chunksize=CHUNK_SIZE)
	for i, chuck in enumerate(rows):
	# i is for chunk number of each iteration
	chuck.to_csv('out{}.csv'.format(i))