Tomasz Mazur defkode

## excelColumnNameToInteger.js
// Converts Excel Column name to zero-based index
// A => 0, B => 1, Z => 25  AA => 26).

function excelColumnNameToInteger(columnName) {
  if !(/^[A-z]+$/.test(columnName)) {
    let result = 0;
    for (let i = 0; i < columnName.length; i++) {
      result += (columnName.charCodeAt(i) - 64) * Math.pow(26, columnName.length - i - 1);
    }
    return result - 1 // shift the result by 1 to get zero-based numbering;

## with_retries.rb
# USAGE: retry 3 times on specified errors and wait 5s between retries
# when maximum retries is run then raise exception

# with_retries(on: [Errno::EHOSTUNREACH], tries: 3, interval: 5) do
#   Net::HTTP.get('example.com', '/index.html')
# end

module WithRetries
  def with_retries(on: [StandardError], tries: 3, interval: 0.5)
    interval = 0 if Rails.env.test? # speed up tests

## betterstack-logs-rails-lograge.sql
-- SQL: https://clickhouse.com/docs/en/sql-reference
-- top db
SELECT endpoint, AVG(db) AS average_db, MIN(db) AS min_db, MAX(db) AS max_db, COUNT(*) AS count FROM (
  SELECT
      CONCAT(
        JSON_VALUE(json, '$.message.controller'),
        '#',
        JSON_VALUE(json, '$.message.action')
      ) AS endpoint,
      simpleJSONExtractFloat(message, 'db') / 1000 as db

## copy-image-from-clipboard.js
// app.js

import React from 'react';

class App extends React.Component {
  componentDidMount() {

    const retrieveImageFromClipboardAsBlob = (pasteEvent, callback) => {
      if(pasteEvent.clipboardData === false){
            if(typeof(callback) === "function"){

## heroku-review-apps-create.yml
# please set up following github secrets in your repo:
# HEROKU_PIPELINE_NAME (https://devcenter.heroku.com/articles/pipelines#creating-pipelines)
# HEROKU_USER (your heroku username/email)
# HEROKU_API_KEY (use: 'heroku authorizations:create' for creating separate api_key for this purpose)

name: Heroku Review App Create

on:
  pull_request:
    types: opened

## weasyprint-v54-alpine.dockerfile
FROM alpine:latest

RUN apk add \
   py3-pip \
   py3-pillow \
   py3-cffi \
   py3-brotli \
   gcc \
   musl-dev \
   python3-dev \

## weasyprint-v51-debian:buster.dockerfile
FROM debian:buster

RUN apt-get update -qq && apt-get install -qqy \
    build-essential \
    python3-pip \
    python3-cffi \
    libpango-1.0-0 \
    libpangocairo-1.0-0 \
    libgdk-pixbuf2.0-0

## flatten_json.coffee
window.flattenJSON = (obj) ->
  flattened = {}

  join = (path, key) ->
    (if path is "" then "" else path + "_") + key

  flattenArray = (arr, path) ->
    flattenElement(arr, path, i) for i in [0...arr.length]

  flattenObject = (obj, path) ->

## machine_readable_code_validation.rb
# TPD<<T220001293<<<<<<<<<<<<<<<
# 6408125<2010315D<<<<<<<<<<<<<4
# MUSTERMAN<<ERIKA<<<<<<<<<<<<<<

class PersonalId

  attr_reader :code, :data
  # 9 alphanumeric
  def initialize(machinecode = "TPD<<2406055684D<<<<<<<<<<<<<<6810203<0705109D<<<<<<<<<<<<<6MUSTERMAN<<ERIKA<<<<<<<<<<<<<<")
    @code = machinecode

## adsense_helper.rb
module AdsenseHelper

  # Author: Tomasz Mazur (defkode@gmail.com)
  # http://www.mydigitallife.info/2009/01/17/google-adsense-legacy-old-generation-code-reference-generate-and-get/
  # :slot
  # :theme
  #   :background
  #   :border
  #   :link
  #   :text
	// Converts Excel Column name to zero-based index
	// A => 0, B => 1, Z => 25 AA => 26).

	function excelColumnNameToInteger(columnName) {
	if !(/^[A-z]+$/.test(columnName)) {
	let result = 0;
	for (let i = 0; i < columnName.length; i++) {
	result += (columnName.charCodeAt(i) - 64) * Math.pow(26, columnName.length - i - 1);
	}
	return result - 1 // shift the result by 1 to get zero-based numbering;
	# USAGE: retry 3 times on specified errors and wait 5s between retries
	# when maximum retries is run then raise exception

	# with_retries(on: [Errno::EHOSTUNREACH], tries: 3, interval: 5) do
	# Net::HTTP.get('example.com', '/index.html')
	# end

	module WithRetries
	def with_retries(on: [StandardError], tries: 3, interval: 0.5)
	interval = 0 if Rails.env.test? # speed up tests
	-- SQL: https://clickhouse.com/docs/en/sql-reference
	-- top db
	SELECT endpoint, AVG(db) AS average_db, MIN(db) AS min_db, MAX(db) AS max_db, COUNT(*) AS count FROM (
	SELECT
	CONCAT(
	JSON_VALUE(json, '$.message.controller'),
	'#',
	JSON_VALUE(json, '$.message.action')
	) AS endpoint,
	simpleJSONExtractFloat(message, 'db') / 1000 as db
	// app.js

	import React from 'react';

	class App extends React.Component {
	componentDidMount() {

	const retrieveImageFromClipboardAsBlob = (pasteEvent, callback) => {
	if(pasteEvent.clipboardData === false){
	if(typeof(callback) === "function"){
	# please set up following github secrets in your repo:
	# HEROKU_PIPELINE_NAME (https://devcenter.heroku.com/articles/pipelines#creating-pipelines)
	# HEROKU_USER (your heroku username/email)
	# HEROKU_API_KEY (use: 'heroku authorizations:create' for creating separate api_key for this purpose)

	name: Heroku Review App Create

	on:
	pull_request:
	types: opened
	FROM alpine:latest

	RUN apk add \
	py3-pip \
	py3-pillow \
	py3-cffi \
	py3-brotli \
	gcc \
	musl-dev \
	python3-dev \
	FROM debian:buster

	RUN apt-get update -qq && apt-get install -qqy \
	build-essential \
	python3-pip \
	python3-cffi \
	libpango-1.0-0 \
	libpangocairo-1.0-0 \
	libgdk-pixbuf2.0-0
	window.flattenJSON = (obj) ->
	flattened = {}

	join = (path, key) ->
	(if path is "" then "" else path + "_") + key

	flattenArray = (arr, path) ->
	flattenElement(arr, path, i) for i in [0...arr.length]

	flattenObject = (obj, path) ->
	# TPD<<T220001293<<<<<<<<<<<<<<<
	# 6408125<2010315D<<<<<<<<<<<<<4
	# MUSTERMAN<<ERIKA<<<<<<<<<<<<<<

	class PersonalId

	attr_reader :code, :data
	# 9 alphanumeric
	def initialize(machinecode = "TPD<<2406055684D<<<<<<<<<<<<<<6810203<0705109D<<<<<<<<<<<<<6MUSTERMAN<<ERIKA<<<<<<<<<<<<<<")
	@code = machinecode
	module AdsenseHelper

	# Author: Tomasz Mazur (defkode@gmail.com)
	# http://www.mydigitallife.info/2009/01/17/google-adsense-legacy-old-generation-code-reference-generate-and-get/
	# :slot
	# :theme
	# :background
	# :border
	# :link
	# :text