OKAMOTO Taichi curipha

## list_all_modules.ps1
Get-InstalledModule | Get-InstalledModule -AllVersions

## views.sql
select
  s.name as [schema],
  v.name,
  v.type_desc,
  format(dateadd(hour, 9, v.create_date), 'yyyy-MM-dd HH:mm') as created,
  case when v.create_date = v.modify_date
    then null
    else format(dateadd(hour, 9, v.modify_date), 'yyyy-MM-dd HH:mm')
  end as modified,
  m.definition

## tables.sql
select
  t.name,
  i.rows
from sys.tables t
join sys.sysindexes i
  on t.object_id = i.id and i.indid < 2
order by t.name

## disable_web_search.bat
reg add HKCU\Software\Policies\Microsoft\Windows\Explorer /v DisableSearchBoxSuggestions /t REG_DWORD /d 0x00000001 /f

## remove_limit.bat
reg add HKCU\Software\Policies\Microsoft\OneDrive /v DownloadBandwidthLimit /t REG_DWORD /d 0x000fffff /f
reg add HKCU\Software\Policies\Microsoft\OneDrive /v UploadBandwidthLimit /t REG_DWORD /d 0x000fffff /f

## logger.rb
require 'logger'

l = Logger.new($stderr)
l.formatter = lambda {|sev, time, prog, msg|
  line = []
  line << "[#{time.strftime('%H:%M:%S.%02N')}]"
  line << "#{prog}:" unless prog.nil? || prog.empty?
  line << case sev
  when 'DEBUG' then "\033[34m#{msg.strip}\033[0m"
  when 'INFO'  then msg.strip

## run_apt.sh
echo -n 'server1 server2 server3 server4' | \
xargs -ot -d' ' -n1 -I{} ssh -t {} 'sudo apt -y clean && sudo apt -yqq update && sudo apt -y full-upgrade && sudo apt -yqq autoremove && cat /var/run/reboot-required* && sudo shutdown --reboot +1' 2> >(while read line; do echo -e "\e[01;31m${line}\e[0m" >&2; done)

## .bash_profile
history -c
unset HISTFILE

# zsh executor http://blog.kenichimaehashi.com/?article=12851025960
if [ -z "${BASH_EXECUTION_STRING}" ]; then
  ZSH="/bin/zsh"
  [ -x "${ZSH}" ] && SHELL="${ZSH}" exec "${ZSH}" -l
fi

## worker.rb
require 'thread'

WORKERS=3

q = Queue.new
[5,6,7,8,9].each {|r| q.push(r) }

threads = []
WORKERS.times do
  threads << Thread.start do

## export_sqldb.bat
@echo off
setlocal

chcp 65001

set targetdir=%~dp0\csv.sql.%date:~0,4%%date:~5,2%%date:~8,2%
mkdir "%targetdir%"

for /f %%T in (%~dp0\tablesU.txt) do call :sqlexport "%%T"
:: pause
	select
	s.name as [schema],
	v.name,
	v.type_desc,
	format(dateadd(hour, 9, v.create_date), 'yyyy-MM-dd HH:mm') as created,
	case when v.create_date = v.modify_date
	then null
	else format(dateadd(hour, 9, v.modify_date), 'yyyy-MM-dd HH:mm')
	end as modified,
	m.definition
	select
	t.name,
	i.rows
	from sys.tables t
	join sys.sysindexes i
	on t.object_id = i.id and i.indid < 2
	order by t.name
	reg add HKCU\Software\Policies\Microsoft\OneDrive /v DownloadBandwidthLimit /t REG_DWORD /d 0x000fffff /f
	reg add HKCU\Software\Policies\Microsoft\OneDrive /v UploadBandwidthLimit /t REG_DWORD /d 0x000fffff /f
	require 'logger'

	l = Logger.new($stderr)
	l.formatter = lambda {\|sev, time, prog, msg\|
	line = []
	line << "[#{time.strftime('%H:%M:%S.%02N')}]"
	line << "#{prog}:" unless prog.nil? \|\| prog.empty?
	line << case sev
	when 'DEBUG' then "\033[34m#{msg.strip}\033[0m"
	when 'INFO' then msg.strip
	echo -n 'server1 server2 server3 server4' \| \
	xargs -ot -d' ' -n1 -I{} ssh -t {} 'sudo apt -y clean && sudo apt -yqq update && sudo apt -y full-upgrade && sudo apt -yqq autoremove && cat /var/run/reboot-required* && sudo shutdown --reboot +1' 2> >(while read line; do echo -e "\e[01;31m${line}\e[0m" >&2; done)
	history -c
	unset HISTFILE

	# zsh executor http://blog.kenichimaehashi.com/?article=12851025960
	if [ -z "${BASH_EXECUTION_STRING}" ]; then
	ZSH="/bin/zsh"
	[ -x "${ZSH}" ] && SHELL="${ZSH}" exec "${ZSH}" -l
	fi
	require 'thread'

	WORKERS=3

	q = Queue.new
	[5,6,7,8,9].each {\|r\| q.push(r) }

	threads = []
	WORKERS.times do
	threads << Thread.start do
	@echo off
	setlocal

	chcp 65001

	set targetdir=%~dp0\csv.sql.%date:~0,4%%date:~5,2%%date:~8,2%
	mkdir "%targetdir%"

	for /f %%T in (%~dp0\tablesU.txt) do call :sqlexport "%%T"
	:: pause