Skip to content

Instantly share code, notes, and snippets.

@Eotel
Eotel / script.md
Created October 14, 2025 11:43
静止画を一定時間再生した後,定期的に動画を差し込む

動画を白背景で 2250×4000 に拡張

$ ffmpeg -i ccbt_logo_h264.mp4 -vf 'scale=2250:4000:force_original_aspect_ratio=decrease,pad=2250:4000:(ow-iw)/2:(oh-ih)/2:color=white,setsar=1,format=yuv420p' -r 30 -c:v libx264 -profile:v high -level 5.1 -movflags +faststart -c:a aac -ar 48000 -ac 2 -b:a 192k vid_2250x4000.mp4

静止画を同仕様のクリップ化(300秒)

無音

@Eotel
Eotel / excel_image_extractor.py
Created August 26, 2025 01:17
Excel image extractor (xlsx/xls via conversion)
#!/usr/bin/env python3
"""
Excel embedded image extractor
Extracts all images embedded in an .xlsx/.xlsm workbook and saves them
into a folder structure: {file_name}/{sheet_name}/{image}
Key points:
- No external dependencies. Parses the .xlsx (ZIP) and OOXML parts directly.
- Maps images to sheets via drawing relationships.
@Eotel
Eotel / ghq-get-repos.ps1
Created February 19, 2025 01:29
指定した GitHub アカウントのリポジトリ一覧を並列でクローンする
Param(
[Parameter(Mandatory = $true)]
[string]$GitHubAccount
)
# GitHub アカウントを環境変数 ORG に設定
$env:ORG = $GitHubAccount
# gh CLI でリポジトリ一覧を取得し、JSON を PowerShell オブジェクトに変換
$repoList = gh repo list $GitHubAccount --limit 1000 --json name | ConvertFrom-Json
@Eotel
Eotel / pythonrc
Created March 28, 2024 07:14
pythonrc for libedit
def is_vanilla() -> bool:
import sys
return not hasattr(__builtins__, "__IPYTHON__") and "bpython" not in sys.argv[0]
def setup_history():
import os
import atexit
import readline
@Eotel
Eotel / README.md
Created July 25, 2023 08:04 — forked from triangletodd/README.md
k3s in LXC on Proxmox

On the host

Ensure these modules are loaded

cat /proc/sys/net/bridge/bridge-nf-call-iptables

Disable swap

sysctl vm.swappiness=0
swapoff -a
@Eotel
Eotel / JsonSummarizer.ts
Created December 9, 2022 07:28
JSONの配列を集計する
export default class JsonSummarizer {
public static summarize(input: { [key: string]: string | number }[]) {
// 結果を格納する辞書
const result: { [key: string]: Map<string, number> } = {};
// 入力を処理する
for (const obj of input) {
// オブジェクト内の各キーを処理する
for (const key in obj) {
// 結果辞書にキーが存在しない場合は新しい Map を作成する
@Eotel
Eotel / get_gh_subfolders.zsh
Last active August 17, 2022 05:42
GitHubのリポジトリのサブフォルダをsvnでダウンロードするzsh関数
if [[ $(command -v svn) ]]; then
function get_subfolders() {
svn export $( echo $1 | sed -E 's/^(https:\/\/github.com\/[^/]+\/[^/]+\/)([^/]+\/[^/]+)(\/.+)$/\1trunk\3/' )
}
fi