Ondrej Kvasnovsky ondrej-kvasnovsky

43 followers · 6 following

View GitHub Profile

Recently created

Least recently created

Recently updated

Least recently updated

ondrej-kvasnovsky / search.sh

Created November 21, 2018 16:52

Search all files in give directory

	#! /bin/sh -
	# that also works in any sh, so you don't even need to have or use bash

	file_pattern="/Users/ondrej/Downloads/emails/*.dms"
	# all uppercase variables should be reserved for environment variables

	IFS='' # disable splitting

	for f in $file_pattern # here we're not quoting the variable so
	# we're invoking the split+glob operator.

ondrej-kvasnovsky / gist:b70e94fc8282235013ed9dbb99e129aa

Created November 15, 2018 20:37

S3 bucket structure to HTML

	const fs = require('mz/fs');

	const read = async() => {
	const root = '/Users/testing-s3-2/'
	let html = `<html><table style="width:100%" border="1">`
	const folders = await fs.readdir(root);
	for (const folder of folders) {
	if (!fs.lstatSync(folder).isDirectory()) continue;
	if (folder.startsWith('.') \|\| folder.startsWith('node_modules')) continue;
	html += '<tr>'

ondrej-kvasnovsky / reinstall-postgres.sh

Created November 8, 2018 20:28

Remove Postgres and start it in docker

	brew doctor
	brew update
	brew services list
	brew services stop postgres
	brew uninstall postgres
	rm -rf /usr/local/var/postgres
	rm -rf /usr/local/opt/postgresql
	rm -rf .psql_history .psqlrc .psql.local .pgpass .psqlrc.local

	# then use docker to start local postgres to avoid all these issues with running postgres on your local

ondrej-kvasnovsky / debugging.sql

Last active November 1, 2018 18:49

Find out biggest databases and tables in Postgres

	-- find biggest database
	SELECT *, pg_size_pretty(total_bytes) AS total
	, pg_size_pretty(index_bytes) AS INDEX
	, pg_size_pretty(toast_bytes) AS toast
	, pg_size_pretty(table_bytes) AS TABLE
	FROM (
	SELECT *, total_bytes-index_bytes-COALESCE(toast_bytes,0) AS table_bytes FROM (
	SELECT c.oid,nspname AS table_schema, relname AS TABLE_NAME
	, c.reltuples AS row_estimate
	, pg_total_relation_size(c.oid) AS total_bytes

ondrej-kvasnovsky / index.js

Created April 17, 2018 20:27

	const data1 = {
	attributes: {
	domain: 'from.attributes.com'
	}
	}

	const data2 = {
	attributes: {
	unknownAttributes: {
	domain: 'from.unknownAttributes.com'

ondrej-kvasnovsky / index.js

Created April 17, 2018 18:27

snowflake udf to extract domain from json or url

	const data1 = {
	attributes: {
	domain: 'from.attributes.com'
	}
	}

	const data2 = {
	attributes: {
	unknownAttributes: {
	domain: 'from.unknownAttributes.com'

ondrej-kvasnovsky / index.js

Created April 17, 2018 17:20

extract domain from json and url

	const data1 = {
	attributes: {
	domain: 'from.attributes.com'
	}
	}

	const data2 = {
	attributes: {
	unknownAttributes: {
	domain: 'from.unknownAttributes.com'

ondrej-kvasnovsky / setup.sh

Created April 7, 2018 18:29

	# List existing mongo process
	pgrep mongo
	# Kill existing process if has.
	pkill mongo
	# Clear old folder if has.
	rm -rf rs0 && rm -rf rs1 && rm -rf rs2
	# Create log folder.
	mkdir -p ./var/log/mongodb
	# Create replica set 0
	. rs.sh 0

ondrej-kvasnovsky / rs.sh

Created April 7, 2018 18:29

	#!/bin/bash
	RS_INDEX=$1
	RS_NAME="rs"$1
	mkdir $RS_NAME
	PORT=$((27017+$RS_INDEX))
	cat <<EOF > $RS_NAME.conf
	systemLog:
	destination: file
	path: "var/log/mongodb/mongod.log"
	logAppend: true

ondrej-kvasnovsky / test.js

Created March 19, 2018 23:16

Mock AWS S3 in JavaScript using Mocha and Sinon

	const SomeService = require('some/service')
	const AWS = require('aws-sdk')

	describe('someService', async function() {
	let someService

	beforeEach(async function() {
	someService = new SomeService()
	})