Narendra Nath Joshi narendranathjoshi

## count_rows_in_all_tables.sql
SELECT schemaname,relname,n_live_tup
FROM pg_stat_user_tables
ORDER BY n_live_tup DESC;

## quicksort.py
qsort = lambda l : [x for x in l[1:] if x < l[0]] + [l[0]] + [x for x in l[1:] if x >= l[0]]

#usage
qsort([7,5,2,8])

## weighted_choice.py
def weighted_choice(choices):
    total = sum(w for c, w in choices)
    r = random.uniform(0, total)
    upto = 0
    for c, w in choices:
        if upto + w >= r:
            return c
        upto += w
    assert False, "Shouldn't get here"

## iterctr.py
def iterctr(items, n):
    ctr = 0
    for item in items:
        ctr += 1
        if ctr % n == 0:
            print(ctr)

        yield item
	SELECT schemaname,relname,n_live_tup
	FROM pg_stat_user_tables
	ORDER BY n_live_tup DESC;
	qsort = lambda l : [x for x in l[1:] if x < l[0]] + [l[0]] + [x for x in l[1:] if x >= l[0]]

	#usage
	qsort([7,5,2,8])
	def weighted_choice(choices):
	total = sum(w for c, w in choices)
	r = random.uniform(0, total)
	upto = 0
	for c, w in choices:
	if upto + w >= r:
	return c
	upto += w
	assert False, "Shouldn't get here"
	def iterctr(items, n):
	ctr = 0
	for item in items:
	ctr += 1
	if ctr % n == 0:
	print(ctr)

	yield item