pioz

# gem install google-apis-sheets_v4
require 'google/apis/sheets_v4'

scope = Google::Apis::SheetsV4::AUTH_SPREADSHEETS.freeze
spreadsheets_id = '1ga77r2sjPYTSLGh1IXClnGPvdqFAmkRf-Z5akqfpFEo'.freeze

authorizer = Google::Auth::ServiceAccountCredentials.make_creds(
  json_key_io: File.open('./credentials.json'),
  scope: scope
)

pioz

/* Copyright 2021 Glorious, LLC <salman@pcgamingrace.com>
   Copyright 2021 Pioz <epilotto@gmx.com>

This program is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 2 of the License, or
(at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of

pioz

Install qmk

brew install qmk/qmk/qmk

Config qmk environment

qmk config user.keyboard=gmmk/pro/rev1/ansi
qmk config user.keymap=pioz

pioz

SELECT price_cents FROM products ORDER BY price_cents * ('{"EUR": 2.0}'::jsonb->'EUR')::jsonb::numeric;

pioz

git clone https://github.com/google/or-tools.git
cd ./or-tools
cmake -S. -Bbuild -DBUILD_PYTHON=ON -DPython3_ROOT_DIR="/opt/homebrew/Cellar/python@3.9/3.9.10/"
cmake --build build -j8 -v  
pip3 install ./build/python/dist/ortools-9.2.9974-cp39-cp39-macosx_12_0_arm64.whl

pioz

require 'bundler/inline'

gemfile do
  source 'https://rubygems.org'
  gem 'activerecord'
  gem 'pg'
end

require 'active_record'

pioz

SELECT id FROM products WHERE id IN (2,1) ORDER BY array_position(array[2,1], id);

pioz

For hanging pictures I really like to follow the midline style. In practice an imaginary line is drawn on the wall which is at 5/8 the height of the wall itself. Once we have this line in mind the paintings must be hung with 3/8 of their height above the median line.

h = (H*5 + q*3) / 8

where H is the height of the wall and q is the height of the painting itself.

pioz

nano ~/.rbenv/versions/3.2.0/bin/rails

Add these lines before load Gem...:

require 'active_support'
ActiveSupport::Inflector.inflections { |inflect| inflect.acronym 'CT' }

pioz

require 'open-uri'
require 'tty-progressbar'

CONCURRENCY = 8
FIRST_EPISODE_NUMBER = 1
LAST_EPISODE_NUMBER = 628

def get_bounds(episode_number)
  episode_number = 1 if episode_number < 1
  lower_bound = ((episode_number - 1) / 100) * 100 + 1