By Ryan Aunur Rassyid
Simply create RESTful API with Google Script and store it to Google SpreadSheet like a Pro.
// Ropp's main config | |
// https://nilesoft.org/docs/functions/id | |
// Cheatsheet: | |
// Types: file|dir|drive|usb|dvd|fixed|vhd|removable|remote|back|desktop|namespace|computer|recyclebin|taskbar | |
// remove... mod etc | |
// multiple remove (find="view|sort|paste") | |
// all not equal to remove(where=this.name!="shit") | |
// type is file only remove (type="file" find="run as admin") | |
// modify( find = value [property = value [...] ]) | |
// |
-- | |
-- description: What spooled files does the current user own? | |
-- | |
select job_name, spooled_file_name, file_number, user_data, | |
create_timestamp | |
from qsys2.output_queue_entries_basic | |
where user_name = user; | |
stop; | |
-- | |
-- description: Query the contents of RUNSQLSTM spooled files for the current user |
-- Author: Scott Forstie | |
-- Email: forstie@us.ibm.com | |
create or replace variable coolstuff.decdate dec(6,0); | |
set coolstuff.decdate = '190718'; | |
-- July 18, 2019 (yes, really!) | |
values timestamp_format(varchar(coolstuff.decdate), 'YYMMDD'); | |
-- Wow | |
-- Yowza |
@echo off | |
set /a counter=0 | |
for %%f in (*.jpg) do ( | |
C:\libwebp\bin\cwebp.exe -q 80 %%f -o %%~nf.webp | |
set /A counter=counter+1 | |
) | |
echo ************************************ |
vec3 gammaCorrect(vec3 color, float gamma){ | |
return pow(color, vec3(1.0/gamma)); | |
} | |
vec3 levelRange(vec3 color, float minInput, float maxInput){ | |
return min(max(color - vec3(minInput), vec3(0.0)) / (vec3(maxInput) - vec3(minInput)), vec3(1.0)); | |
} | |
vec3 finalLevels(vec3 color, float minInput, float gamma, float maxInput){ | |
return gammaCorrect(levelRange(color, minInput, maxInput), gamma); |
-- This fails to return data....why? | |
SELECT cusip, issueDate, bidToCoverRatio | |
FROM JSON_TABLE( | |
SYSTOOLS.HTTPGETCLOB('https://www.treasurydirect.gov/TA_WS/securities/announced?format=json&type=FRN&pagesize=5', null), | |
'$.root[*]' | |
COLUMNS(cusip VARCHAR(10) PATH '$.cusip', | |
issueDate Timestamp PATH '$.issueDate', | |
bidToCoverRatio double PATH '$.bidToCoverRatio') | |
) AS X; | |
stop; |
-- ================================================================= | |
-- Author: Scott Forstie | |
-- Email : forstie@us.ibm.com | |
-- Date : January 10, 2020 | |
-- ================================================================= | |
-- | |
-- Setup: | |
-- 1) create and populate the spreadsheet generator table | |
-- 2) change the procedure source code: |
-- | |
-- Now that ACS is shipped on the IBM i via PTFs, we no longer need to manually move the | |
-- acsbundle.jar onto the IBM i. Just apply the latest ACS PTFs and reference the jar | |
-- at: /QIBM/proddata/Access/ACS/Base/acsbundle.jar | |
-- | |
-- Initial PTFs of ACS | |
-- V7R4M0 SI71900 | |
-- V7R3M0 SI71934 | |
-- |
The latest beta (3.5) includes separate color settings for light & dark mode. Toggling dark mode automatically switches colors.
Vist iTerm2 homepage or use brew install iterm2-beta
to download the beta. Thanks @stefanwascoding.
switch_automatic.py
to ~/Library/ApplicationSupport/iTerm2/Scripts/AutoLaunch
with: