ibrahim edib kokdemir edib

More than 25 years in IT sector. Self educated.

edib / operating_system_count.ps1

Created October 11, 2016 08:22

	[array]$osNameObject = $null
	$vmHosts = Get-VMHost
	$i = 0

	foreach ($h in $vmHosts) {

	Write-Progress -Activity "Going through each host in $vCenter..." -Status "Current Host: $h" -PercentComplete ($i/$vmHosts.Count*100)
	$osName = ($h \| Get-VM \| Get-View).Summary.Config.GuestFullName
	[array]$guestOSList += $osName
	Write-Verbose "Found OS: $osName"

edib / marbleinaBag.py

Created November 19, 2016 12:48

marble in a bag probability

edib / upgrade_pg.sh

Last active January 9, 2026 22:56 — forked from ibussieres/upgrade_pg.sh

Upgrade PostgreSQL 9.3 to 9.6 on Ubuntu 16.04

	sudo apt-get install postgresql-9.6 postgresql-server-dev-9.6 postgresql-contrib-9.6 -y

	sudo su - postgres -c "psql template1 -p 5433 -c 'CREATE EXTENSION IF NOT EXISTS hstore;'"
	sudo su - postgres -c "psql template1 -p 5433 -c 'CREATE EXTENSION IF NOT EXISTS \"uuid-ossp\";'"
	sudo systemctl stop postgresql
	sudo su - postgres -c '/usr/lib/postgresql/9.6/bin/pg_upgrade -b /usr/lib/postgresql/9.3/bin -B /usr/lib/postgresql/9.6/bin \
	-d /var/lib/postgresql/9.3/main/ -D /var/lib/postgresql/9.6/main/ \
	-O "-c config_file=/etc/postgresql/9.6/main/postgresql.conf" -o "-c config_file=/etc/postgresql/9.3/main/postgresql.conf" --link'

	sudo apt-get remove postgresql-9.3 -y

edib / fib.sql

Created December 15, 2016 21:52

another fibonacci sql function

	CREATE OR REPLACE FUNCTION fib(n integer)
	RETURNS INTEGER
	AS $$
	DECLARE
	counter integer := 0;
	a integer := 0;
	b integer := 1;
	BEGIN
	IF (n < 1) THEN
	RETURN 0;

edib / conn.py

Created December 19, 2016 06:58

simple import

	def conn():
	return "host='ahost' dbname='adatabase' user='auser' port=5432 password='apassword'"

edib / query.py

Created December 19, 2016 07:29

	import psycopg2
	import sys
	import pprint
	# file import
	import myconnect as m

	def main():
	conn_string = m.conn()
	# print the connection string we will use to connect
	print "Connecting to database\n ->%s" % (conn_string)

edib / bulk_insert_for_pg_table_partitioning.sql

Created December 22, 2016 19:11

insert function for postgresql partition tutorial in https://www.if-not-true-then-false.com/2009/howto-create-postgresql-table-partitioning-part-1/

	CREATE OR REPLACE FUNCTION insert_date(INTEGER,INTEGER,DATE) RETURNS VOID AS $$
	DECLARE
	mystart alias for $1;
	myend alias for $2;
	mydate alias for $3;
	BEGIN
	FOR i IN mystart..myend LOOP
	INSERT INTO impressions_by_day values(i,mydate,round(random()*10000));
	END LOOP;
	END;

edib / fnsomefunc.sql

Created December 28, 2016 08:24

simplest plpgsql function example

	CREATE OR REPLACE FUNCTION fnsomefunc()
	RETURNS void AS
	$$
	BEGIN
	FOR i IN 1 .. 100 LOOP
	RAISE NOTICE 'I am counting %',i;
	END LOOP;
	END;
	$$
	LANGUAGE 'plpgsql' IMMUTABLE;

edib / pg-upgrade.sh

Last active February 4, 2022 20:54

Upgrade postgres 9.5 to 11 with pg_upgrade

	# See https://wiki.postgresql.org/wiki/Using_pg_upgrade_on_Ubuntu/Debian for more information and warning!

	# Check first
	/usr/lib/postgresql/11/bin/pg_upgrade \
	-b /usr/lib/postgresql/9.6/bin \
	-B /usr/lib/postgresql/11/bin \
	-d /var/lib/postgresql/9.6/main \
	-D /var/lib/postgresql/11/main \
	-o ' -c config_file=/etc/postgresql/9.6/main/postgresql.conf' \
	-O ' -c config_file=/etc/postgresql/11/main/postgresql.conf' \

edib / graph1.py

Created March 20, 2017 13:23

draw graph with numpy and matplotlib

	from matplotlib import pyplot as plt
	from matplotlib import style

	import numpy as np

	# print(style.available)
	#['seaborn-colorblind', 'seaborn-poster', 'grayscale', 'ggplot', 'seaborn-darkgrid', 'seaborn', 'seaborn-ticks', 'seaborn-white', 'seaborn-notebook', 'seaborn-whitegrid', 'seaborn-dark-palette', 'bmh', 'dark_background', 'seaborn-dark', 'seaborn-pastel', 'seaborn-muted', 'seaborn-paper', 'seaborn-talk', 'classic', 'seaborn-deep', 'seaborn-bright', 'fivethirtyeight']

	style.use('ggplot')
	x,y = np.loadtxt('data.csv',unpack=True,delimiter=',')