gullevek

#!/usr/bin/env bash

if [ -z "${1}" ]; then
    echo "Please give an application as full path to file";
    exit;
fi;

if [ "${1}" = "/" ]; then
    echo "Not a valid path";
    exit;

gullevek

CREATE OR REPLACE VIEW identity_column_status AS
WITH table_data AS (
	SELECT
		t.table_catalog, t.table_schema, t.table_name,
		t.table_schema || '.' || t.table_name AS schema_table_name
	FROM
		information_schema.tables AS t
	WHERE
		t.table_type = 'BASE TABLE'
		AND t.table_schema NOT IN ('information_schema', 'pg_catalog')

gullevek

-- Upgrade serial to identity type
--
-- Original: https://www.enterprisedb.com/blog/postgresql-10-identity-columns-explained#section-6
--
-- @param reclass tbl The table where the column is located, prefix with 'schema.' if different schema
-- @param name col The column to be changed
-- @param varchar identity_type [default=a] Allowed a, d, assigned, default
-- @param varchar col_type [default=''] Allowed smallint, int, bigint, int2, int4, int8
-- @returns varchar status tring
-- @raises EXCEPTON on column not found, no linked sequence, more than one linked sequence found, invalid col type

gullevek

<?php

// Create transparent gif in certain sizes and print out base64

$gd_version = gd_info()["GD Version"];
// check: bundled -> use a transparency, if not and 2.3.3 or higher, use alternate
$use_imagecolorallocatealpha = true;
if (strstr($gd_version, "bundled") !== false) {
	$use_imagecolorallocatealpha = false;
}

gullevek

/**
 * Convert a string with B/K/M/etc into a byte number
 * @param  {String|Number} bytes Any string with B/K/M/etc
 * @return {String|Number}       A byte number, or original string as is
 */
function stringByteFormat(bytes)
{
	// if anything not string return
	if (!(typeof bytes === 'string' || bytes instanceof String)) {
		return bytes;

gullevek

#!/bin/bash

folder=${1};
diff=1;
sleeptime=5;

if [ ! -d "${folder}" ]; then
    echo "Folder: ${folder} not found";
    exit;
fi;

gullevek

find ./ -type f -print0 | xargs -0 stat -f '%Sm %z' -t "%Y" | awk 'function human(x) {s=" B  KB MB GB TB EB PB YB ZB"; while (x>=1024 && length(s)>1){x/=1024; s=substr(s,4)} s=substr(s,1,4); xf=(s==" B  ")?"%d   ":"%.2f"; return sprintf( xf"%s", x, s);}{sum[$1]+= $2;}END{for (date in sum){printf ("%s %s\n", date, human(sum[date]));}}' | sort

gullevek

#!/usr/bin/env python3

"""
formatting with double width characters

"""

import unicodedata

def shorten_string_cjk(intput_string, width, placeholder='..'):

gullevek

CREATE OR REPLACE FUNCTION copy_progress(from_date DATE, to_date DATE, p_precision INT DEFAULT 1) RETURNS "varchar"
AS $$
    DECLARE
        status VARCHAR; -- return status
        my_rec RECORD; -- transfer record
        -- progress info
        pos INT := 1; -- current position
        row_count INT := 0; -- overall row count (max)
        percent NUMERIC; -- output percent
        old_percent NUMERIC := 0.0; -- previous percent

gullevek

set nocompatible
set hidden " background buffers
set history=1000
set wildmenu " tab complete like bash
" set ignorecase " ignore case for search
" set smartcase " but if capital letter, make case sensitive again
set scrolloff=3 " keep 3 lines before/after
set bs=2 " backspace command, alt: indent,eol,start
set noexpandtab
set tabstop=4