Differences

This shows you the differences between two versions of the page.

--- code:bash [2014/08/28 14:44]
::ffff:89.204.138.159
+++ code:bash [2026/02/05 15:21] (current)
84.138.194.42
@@ Line 1: / Line 1: @@
 ====== bash ======
 ===== bashrc =====
@@ Line 32: / Line 31: @@
 ===== snippets =====
-<code>
+  # macros
-[ $1 ] || { echo -ne "\033[0m>>> usage: $0 <target>\n" >&2; exit 1; }
+    [ $1 ] || { echo -ne "\033[0m>>> usage: $0 <target>\n" >&2; exit 1; }
-</code>
+  ### pipes
+  ## sqlite to html
+    sqlite3 ex1 'select * from tbl1' | awk '{printf "<tr><td>%s<td>%s\n",$1,$2 }'
+  ### tools
+  ## remove html
+    lynx -dump
 ===== ip and gateway =====
@@ Line 66: / Line 72: @@
 </code>
+==== youtube-dl ====
+* https://github.com/rg3/youtube-dl.git
+<file bash yt.sh>
+#!/bin/sh
+COOKIE_FILE=/var/tmp/youtube-dl-cookies.txt
+for i in $*; do
+  mplayer -cookies -cookies-file ${COOKIE_FILE} $(youtube-dl -g --cookies ${COOKIE_FILE} $i)
+done
+</file>
+==== mysql ====
+  ex='mysql -u root -pxxx mydb -e '
+  min() { echo $(( $1 < $2 ? $1 : $2 )); }
+  i=470;m=479; while [[ "$i" -le "$m" ]]; do
+    a=$i;b=$(min $((i+2)) $m);i=$((i+3));
+    $ex "insert into postlabel (fsid,lsid) values ($a, $b)"; done;
+echo "test?"