Okan Menevşeoğlu okanmenevseoglu

🏠

Working from home

ufuk / posgresql-lightspeed-alter-table.sql

Last active November 5, 2018 07:59

Increase performance of alter tables or any other expensive operations by increasing WORK_MEM parameter for current session in PostgreSQL

ufuk / TurkishNumberUtils.java

Last active November 13, 2020 07:55

Util for converting whole numbers to Turkish words

	public final class TurkishNumberUtils {

	private static final String SPACE = " ";

	private static final String EMPTY = "";

	private static final String[] PERIOD_NAMES = {EMPTY, "bin", "milyon", "milyar", "trilyon", "katrilyon", "kentilyon"};

	private static final String[] UNITS_TEXTS = {EMPTY, "bir", "iki", "üç", "dört", "beş", "altı", "yedi", "sekiz", "dokuz"};

ufuk / postgresql-cryptography-functions.sql

Last active January 29, 2018 11:29

Enable cryptography functions (pgcrypto extension) in PostgreSQL.

	CREATE EXTENSION pgcrypto;

	-- Examples
	SELECT ENCODE(DIGEST('password', 'md5'), 'hex');
	SELECT ENCODE(DIGEST('password', 'sha1'), 'hex');
	SELECT ENCODE(DIGEST('password', 'sha224'), 'hex');
	SELECT ENCODE(DIGEST('password', 'sha256'), 'hex');
	SELECT ENCODE(DIGEST('password', 'sha384'), 'hex');
	SELECT ENCODE(DIGEST('password', 'sha512'), 'base64');

ufuk / postgresql-export-import-schema.sh

Last active June 11, 2018 12:50

Exporting and then importing full schema for PostgreSQL.

	# export
	PGPASSWORD="<PASSWORD>" pg_dump -U <USERNAME> -h <HOST> -d <DB_NAME> -n <SCHEMA_NAME> > export.sql

	# import
	PGPASSWORD="<PASSWORD>" psql -U <USERNAME> -h <HOST> -d <DB_NAME> -n <SCHEMA_NAME> -f export.sql

ufuk / JpaEntityQueryBuilder.java

Last active January 27, 2025 03:21

Easy to use query builder for JPA Criteria API

	import org.apache.commons.collections4.CollectionUtils;
	import org.apache.commons.collections4.IteratorUtils;
	import org.apache.commons.lang3.StringUtils;
	import org.hibernate.query.criteria.internal.path.PluralAttributePath;
	import org.springframework.data.domain.Page;
	import org.springframework.data.domain.PageRequest;
	import org.springframework.data.repository.support.PageableExecutionUtils;

	import javax.persistence.EntityManager;
	import javax.persistence.TypedQuery;

ufuk / find-out-stale-branches.sh

Last active October 31, 2017 08:35

Lists git branches ordered by last change time to find out which ones are stale branches.

	#!/bin/bash

	# DESCRIPTION
	# -----------
	#
	# Produces CSV output like this:
	#
	# LAST CHANGE TIME, TIME ELAPSED, AUTHOR, BRANCH
	# 2017-01-16 14:56:26 +0000, 3 months ago, [email protected], origin/bug-fix-1
	# 2017-01-23 18:27:53 +0300, 2 months ago, [email protected], origin/new-feature-1

ufuk / BaseMockitoTest.java

Last active April 9, 2019 20:30

Performs "verify no more interactions" check automatically for all mock objects (works with Mockito version 2). For detailed description: https://ufukuzun.wordpress.com/2019/04/09/ne-olup-bittiginden-habersiz-testlere-derman-mockscollector/ (Turkish)

	import org.apache.commons.lang3.ArrayUtils;
	import org.junit.After;
	import org.junit.runner.RunWith;
	import org.mockito.InOrder;
	import org.mockito.runners.MockitoJUnitRunner;

	import static org.mockito.Mockito.inOrder;
	import static org.mockito.Mockito.verifyNoMoreInteractions;

	@RunWith(MockitoJUnitRunner.class)

kevin-smets / iterm2-solarized.md

Last active April 4, 2025 20:57

iTerm2 + Oh My Zsh + Solarized color scheme + Source Code Pro Powerline + Font Awesome + [Powerlevel10k] - (macOS)

Default