[sqlite3]モード (output mode)その１ ファイルに書き出す

モードは
ascii box column csv html insert json line list markdown qbox quote table tabs tcl

---

---

【スクリプトエディタで開く】| クリップボードへコピー

/usr/bin/sqlite3 "/Library/Application Support/com.apple.TCC/TCC.db"

/usr/bin/sqlite3 "$HOME/Library/Application Support/com.apple.TCC/TCC.db"

mode should be one of: ascii box column csv html insert json line list markdown qbox quote table tabs tcl

##HTMLはテーブル内の要素のみ出力されるので<table></table>で囲む必要あり

/usr/bin/sqlite3 "$HOME/Library/Application Support/com.apple.TCC/TCC.db" "SELECT * FROM access;" -html > $HOME/Desktop/USER_TCC.html

/usr/bin/sqlite3 "$HOME/Library/Application Support/com.apple.TCC/TCC.db" "SELECT * FROM access;" -json > $HOME/Desktop/USER_TCC.json

/usr/bin/sqlite3 "$HOME/Library/Application Support/com.apple.TCC/TCC.db" "SELECT * FROM access;" -csv > $HOME/Desktop/USER_TCC.csv

/usr/bin/sqlite3 "$HOME/Library/Application Support/com.apple.TCC/TCC.db" "SELECT * FROM access;" -tabs > $HOME/Desktop/USER_TCC.tsv

/usr/bin/sqlite3 "$HOME/Library/Application Support/com.apple.TCC/TCC.db" "SELECT * FROM access;" -markdown > $HOME/Desktop/USER_TCC.md

/usr/bin/sqlite3 "/Library/Application Support/com.apple.TCC/TCC.db" "SELECT * FROM access;" -html > $HOME/Desktop/LOCAL_TCC.html

/usr/bin/sqlite3 "/Library/Application Support/com.apple.TCC/TCC.db" "SELECT * FROM access;" -json > $HOME/Desktop/LOCAL_TCC.json

/usr/bin/sqlite3 "/Library/Application Support/com.apple.TCC/TCC.db" "SELECT * FROM access;" -csv > $HOME/Desktop/LOCAL_TCC.csv

/usr/bin/sqlite3 "/Library/Application Support/com.apple.TCC/TCC.db" "SELECT * FROM access;" -tabs > $HOME/Desktop/LOCAL_TCC.tsv

/usr/bin/sqlite3 "/Library/Application Support/com.apple.TCC/TCC.db" "SELECT * FROM access;" -markdown > $HOME/Desktop/LOCAL_TCC.md

---