[その他] チートシート

rem パッケージのインストール
pip install package_name

rem インストール済のパッケージ一覧
pip list

rem インストール済のpackage_nameパッケージについて詳細表示
pip show package_name

rem パッケージpackage_nameをアンインストール
pip uninstall package_name

rem 依存関係のチェック
pip check

rem 今のpythonの構成をエクスポート
pip freeze

rem freezeしたテキストファイルをインポートしてインストール
pip install -r freeze.txt

class BaseClass(object):
    def __init__(self, name):
        self.name = name
class InheritClass(BaseClass):
    def __init__(self):
        super(InheritClass, self).__init__('name')

import enum
class ReturnCode(enum.IntEnum):
    NormalEnd = 0
    WarningEnd = 1
    AbnormalEnd = 2

return int(ReturnCode.NormalEnd)

list = [1, 2, 3]
print(*list) # 1 2 3

print('this is {0}.'.format('test')))

print('-' * 50)

dt_data = '20200102235859'
dt = datetime.datetime.strptime(dt_data, '%Y%m%d%H%M%S')

import datetime
now = datetime.datetime.now()
f = now.strftime('%Y%m%d%H%M%S')
print(f)  # 20230828070052

# 入力
file = 'C:/test.txt'
data = ''
with open(file, 'r', encoding='utf-8') as f:
    data = f.read()

# 出力
data = 'test'
with open(file, 'w', encoding='utf-8') as f:
    f.write(data)

import logging
 
log_level = logging.DEBUG
log_format = '%(asctime)s- %(name)s - %(levelname)s - %(message)s'
log0 = logging.getLogger(__name__)
log0.setLevel(log_level)
sh = logging.StreamHandler()
sh.setLevel(log_level)
sh.setFormatter(logging.Formatter(log_format))
log0.addHandler(sh)
fh = logging.FileHandler(filename='c:/test.log', encoding='utf-8')
fh.setLevel(log_level)
fh.setFormatter(logging.Formatter(log_format))
log0.addHandler(fh)
 
log0.info('infoメッセージ')
log0.error('errorメッセージ')

import argparse
parser = argparse.ArgumentParser(add_help=False)
parser.add_argument('-s', '--longname', dest=parameter1, default='default value of parameter1', help='parameter1の説明です.')
parser.parse_args()

# python -m pip install pycryptodome
import base64
from Crypto.Cipher import AES
from Crypto.Util.Padding import pad
 
password = 'crypt_key_12'.encode('utf-8')
data = 'テスト'.encode('utf-8')
 
cipher = AES.new(password, AES.MODE_CBC)
ct_bytes = cipher.encrypt(pad(data, AES.block_size))
iv = base64.b64encode(cipher.iv).decode('utf-8')
ct = base64.b64encode(ct_bytes).decode('utf-8')
 
print(ct)

# python -m pip install pycryptodome
import base64
from Crypto.Cipher import AES
 
password = 'crypt_key_12'.encode('utf-8')
data = 'xxxx'
 
base64decoded_data = base64.b64decode(data)
iv = base64decoded_data[0:len(password)]
encrypted_data = base64decoded_data[len(password):]
cipher = AES.new(password, AES.MODE_CBC, iv)
decrypted_data = cipher.decrypt(encrypted_data)
 
print(decrypted_data.decode('utf-8'))

# POST
import requests
response = requests.post('http://www.example.com', data={'foo': 'bar'})
print(response.status_code)
print(response.text)

# GET
import requests
response = requests.get('http://www.example.com')
print(response.status_code)
print(response.text)

# 整数かどうか
print(isinstance(var, int))

# 小数かどうか
print(isinstance(i, float))

set MOD_WSGI_APACHE_ROOTDIR=C:\apache

// 全て
$("*");

// 要素
$('tr');
$('div');

// 要素（ある属性を持つ）
$('tr[name]');

// 要素（ある属性のある値を持つ）
$("tr[name1='value1']");
$("tr[name1='value1'][name2='value2']");

// 要素（ある属性のある値を持たない）
$("tr[name1!='value1']");

// 要素（後方一致）
$("tr[name1$='ue1']");

// 要素（部分一致）
$("tr[name1*='ue']");

// 要素（単語の完全一致）
$("tr[class~='test_class']");

// ID指定
$('#IdName');

// クラス指定
$('.ClassName');

// 複数指定(AND)
$('.ClassName1.ClassName2');

// 複数指定(OR)
$('.ClassName1, .ClassName2');

// SELECT要素で選択されたオプションだけ
$('#select_element option:selected').val();

// SELECT要素で選択されたオプションの属性を取得
$('#select_element option:selected').attr('attirbute1');

// イベント登録
$('.class_name').on('click', function(param1, param2){
  // do something.
});

// イベント削除
$('.class_name').off('click');

// イベントを呼ぶ
$('.class_name').trigger('click', [param1, param2], function(param1, param2){
  // 処理
});

// 表示
$('.class').show();

// 非表示
$('.class').hide();

// 表示されているか
$('.class').is(':visible');

// 表示されていないか
$('.class').is(':hidden');

// DOM追加
$('ul').append('<li>追加されました</li>');
$('<li>追加されました</li>').appendTo('ul');

// 属性追加/変更
$('<div>').attr('id', 'div_id');

// 削除
$('<div>').removeAttr('id');

# 単一ディレクトリのパーミッションを設定する
chmod a+w /home/user/test
 
# 下位ディレクトリも再帰的に設定する
chmod -R a+w /home/user/test

free
free -h

curl -s -H "User-Agent: test/1.0" -w 'url: %{url}, time_total: %{time_total}, http_code: %{http_code}\n' -o /dev/null https://www.google.co.jp > ~/test.log

date "+%Y-%m-%d %H:%M:%S"

*.info;mail.none;authpriv.none;cron.none;local0.none;local1.none    /var/log/messages
 
local0.err;local1.err                                   /var/log/error_log
local1.*                                                /var/log/local1_log

sudo systemctl restart rsyslog sudo systemctl status rsyslog

if $msg contains 'AH01630: client denied by server configuration' then ~
local0.err;local1.err                                   /var/log/error_log

/var/log/test_log
{
  missingok
  nocompress
  create
  daily
  ifempty
  dateext
  maxage 14
  postrotate
    /bin/kill -HUP `cat /var/run/syslogd.pid 2> /dev/null` 2> /dev/null || true
  endscript
}

sudo logrotate -fd /etc/logrotate.d/test_log

swapoff /swapfile
rm -f /swapfile
fallocate -l 1G /swapfile
chmod a+rw /swapfile
mkswap /swapfile
swapon /swapfile

sudo systemctl list-units

#!/bin/bash
 
echo "----------" >> /usr/local/loop_access.log
date "+%Y-%m-%d %H:%M:%S" >> /usr/local/loop_access.log
for i in {1..10}
do
  curl -s -H "User-Agent: xxxx/1.0" -o /dev/null -w 'url: %{url}, http_code: %{http_code}, exitcode: %{exitcode}\n' https://xxxx >> /usr/local/loop_access.log
done

echo Y | del folder\*

cd /d %~dp0

echo F | xcopy /Y C:\src_dir1\src_dir2\source.txt C:\dest_dir1\dest_dir2\dest.txt

chcp [num]

set LANG=ja_JP.UTF-8

@echo off
for %%i in (*.txt) do (
  echo ファイル名：%%i
  mysql.exe -hlocalhost -uuser_name -ppassword -P3306 database_name < %%i
)

$i=1; cat -Encoding UTF8 .\many_line_file.txt -ReadCount 1000 | % { $_ > many_line_file_$i.txt;$i++ }

for /F %a in ('dir /AD /B /W C:\test\*') do rmdir /S /Q C:\test\%a

fsutil volume diskfree C:

t user {アカウント名} /domain

rem ポート使用PIDを探す
netstat -ano
 
rem PIDからプログラムを探す
tasklist /svc /fi "PID eq 20840"

rem 毎日0:00に実行
schtasks /Create /RU .\Administrator /RP password /SC DAILY /TN "タスク名" /TR "D:\bin\task.bat" /ST 00:00 /F /RL HIGHEST

rem 毎週日曜日に実行
schtasks /Create /RU .\Administrator /RP password /SC WEEKLY /D SUN /TN "タスク名" /TR "D:\bin\task.bat" /ST 01:15 /F /RL HIGHEST

rem 毎日9:00～22:00の間、1時間おきに実行
schtasks /Create /RU .\Administrator /RP password /SC DAILY /TN "タスク名" /TR "D:\bin\task.bat" /ST 09:00 /RI 60 /ET 21:59 /F /RL HIGHEST

schtasks /delete /tn "タスク名"

rem サービスの確認
sc query

rem 該当サービスの削除
sc delete service_name

robocopy C:\xxx E:\xxx /MIR /E /V /XJ

C:\Users\{ユーザー名}\AppData\Roaming\Microsoft\Internet Explorer\Quick Launch\User Pinned\TaskBar

<service>
  <id>solr</id>
  <name>Apache Solr</name>
  <description>Solr is the popular, blazing-fast, open source enterprise search platform built on Apache Lucene.</description>
  <env name="SOLR_HOME_DIR" value="C:\application\solr"/>
  <executable>%SOLR_HOME_DIR%\bin\solr.cmd</executable>
  <arguments>start -f</arguments>
  <stopexecutable>%SOLR_HOME_DIR%\bin\solr.cmd</stopexecutable>
  <stoparguments>stop -all</stoparguments>
  <logmode>rotate</logmode>
</service>

java xxx -Xms512m -Xmx512m

set _JAVA_OPTIONS=-Xms512M -Xmx512M
java xxx

/*
各種環境変数をセットして実行
set _JAVA_OPTIONS=-Xms12M -Xmx12M
set _JAVA_OPTS=-Xms24M -Xmx24M
set JAVA_OPTIONS=-Xms36M -Xmx36M
set JAVA_OPTS=-Xms48M -Xmx48M
javac JavaMemory.java && java -Xms128M -Xmx128M JavaMemory
*/
import java.text.NumberFormat;
 
public class JavaMemory {
  public static void main(String[] args) {
    Runtime r = Runtime.getRuntime();
    System.out.println("version     : " + System.getProperty("java.version"));
    System.out.println("maxMemory   : " + NumberFormat.getNumberInstance().format(r.maxMemory()));
    System.out.println("totalMemory : " + NumberFormat.getNumberInstance().format(r.totalMemory()));
    System.out.println("freeMemory  : " + NumberFormat.getNumberInstance().format(r.freeMemory()));
  }
}

SELECT DISTINCT owner FROM all_objects ORDER BY owner

DROP USER {USERNAME} cascade;
CREATE USER {USERNAME} IDENTIFIED BY {PASSWORD} DEFAULT tablespace USERS TEMPORARY tablespace TEMP;
SELECT * FROM all_users;

GRANT CONNECT TO {USERNAME};  -- 接続
GRANT resource TO {USERNAME};
GRANT unlimited tablespace TO {USERNAME}; -- 表領域の変更
GRANT CREATE TABLE TO {USERNAME};
GRANT DROP any TABLE TO {USERNAME};
GRANT CREATE VIEW TO {USERNAME};
GRANT DROP any VIEW TO {USERNAME};
GRANT SELECT any TABLE TO {USERNAME};
GRANT INSERT any TABLE TO {USERNAME};
GRANT UPDATE any TABLE TO {USERNAME};
GRANT DELETE any TABLE TO {USERNAME};
GRANT CREATE PROCEDURE TO {USERNAME};
GRANT DROP any PROCEDURE TO {USERNAME};
GRANT ALTER any PROCEDURE TO {USERNAME};
GRANT EXECUTE any PROCEDURE TO {USERNAME};
GRANT CREATE any directory TO {USERNAME};

DROP directory SAVE_DIR;
CREATE OR REPLACE directory SAVE_DIR AS 'C:\temp';
GRANT READ ON directory SAVE_DIR TO {USERNAME};
GRANT WRITE ON directory SAVE_DIR TO {USERNAME};
SELECT * FROM all_directories;

SELECT * FROM user_tables;

SELECT TABLE_NAME, num_rows FROM user_tables ORDER BY TABLE_NAME;

cd C:\app\username\virtual\product\12.2.0\dbhome_1\bin
sqlplus.exe {USERNAME}/{PASSWORD}@{DBNAME} @C:\sample.sql

cd C:\app\username\virtual\product\12.2.0\dbhome_1\bin
expdp.exe system/{PASSWORD}@{DBNAME} content=ALL tables=tablename directory=SAVE_DIR dumpfile=tablename.dmp logfile=tablename.log

cd C:\app\username\virtual\product\12.2.0\dbhome_1\bin
impdp.exe {USERNAME}/{PASSWORD}@{DBNAME} content=ALL table_exists_action=REPLACE REMAP_SCHEMA=(SYSTEM:{USERNAME}) dumpfile=accounts.dmp directory=SAVE_DIR tables=accounts

CREATE TABLE new_tablename AS SELECT * FROM old_tablename;

SELECT SQL_ID,FIRST_LOAD_TIME,SQL_TEXT
FROM V$SQL
WHERE FIRST_LOAD_TIME BETWEEN TO_CHAR(SYSDATE - (5 / 24 / 60), 'YYYY-MM-DD/HH24:MI:SS') AND TO_CHAR(SYSDATE, 'YYYY-MM-DD/HH24:MI:SS')
ORDER BY FIRST_LOAD_TIME DESC;

SELECT CASE WHEN 'xxxx' <> '' THEN 1 ELSE 0 END FROM dual;
-- 0を返す

SELECT CASE WHEN nvl(column_a, '') || 'x' <> nvl(colum_b, '') || 'x' THEN 1 ELSE 0 END FROM dual;

# mkdir ./work
# cd ./work
# cat > Dockerfile <<EOF
FROM centos:7
RUN yum install -y httpd
CMD ["/usr/sbin/httpd", "-DFOREGROUND"]
EOF
# docker build -t my-app:latest .
# docker images

docker pull centos:centos8

docker run --detach --name image_name --privileged -p 80:80 -p 443:443 -v C:/htdocs:/home/opuser/htdocs image_name /sbin/init

docker exec -it image_name bin/bash

docker cp ImageMagick-7.0.11-6.x86_64.rpm image_name:/home/ImageMagick-7.0.11-6.x86_64.rpm

docker export image_name > image_name.tar

docker import image_name.tar

docker ps -a

docker commit -m exited xxxx

docker run -u root --rm -it xxxx /bin/bash

sudo docker exec -u root -it xxxx /bin/bash

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE language SYSTEM "language.dtd">
<language name="Novel Files" section="Configuration" extensions="*.txt" mimetype="" version="1.1" kateversion="2.0" author="Kenichi Matsuda (kenichi.matsuda.g@gmail.com)" license="LGPL">
 
	<highlighting>
		<contexts>
			<context name="novel" attribute="Normal Text" lineEndContext="#stay">
				<RegExpr attribute="Chapter" context="#stay" String="^\[[^\[\]]+\]$"/>
				<RegExpr attribute="Section" context="#stay" String="^[\$\@].+$"/>
				<RegExpr attribute="Warning" context="#stay" String="^\%.+$"/>
				<RegExpr attribute="Comment" context="#stay" String="^#.+$"/>
				<RegExpr attribute="Selif" context="#stay" String="^.+[：:]"/>
				<RegExpr attribute="Url" context="#stay" String="(http|https|ftp)\:[a-zA-Z0-9-_\.\/%]+"/>
				<RegExpr attribute="Quote" context="#stay" String="^\>.+$" />
			</context>
		</contexts>
 
		<itemDatas>
			<itemData name="Normal Text" defStyleNum="dsDataType" />
			<itemData name="Chapter" defStyleNum="dsKeyword" />
			<itemData name="Section" defStyleNum="dsKeyword" />
			<itemData name="Warning" defStyleNum="dsKeyword" />
			<itemData name="Comment" defStyleNum="dsComment" />
			<itemData name="Selif" defStyleNum="dsKeyword" />
			<itemData name="Url" defStyleNum="dsKeyword" />
			<itemData name="Quote" defStyleNum="dsKeyword" />
		</itemDatas>
 
	</highlighting>
 
</language>

httpd.exe -S

sudo apachectl configtest

# エラーログ
#ErrorLog "logs/error_log"
ErrorLog syslog:local1

# アクセスログ
<IfModule log_config_module>
CustomLog "|/usr/bin/logger -p local0.info -t httpd_access" combined
</IfModule>

sudo systemctl restart httpd sudo systemctl status httpd

# 以下をコメントイン
Include conf/extra/httpd-vhosts.conf

<VirtualHost *:80>
    ServerName  site_a.domain.com
    DocumentRoot "C:/htdocs/application1"
</VirtualHost>
<VirtualHost *:80>
    ServerName  site_b.domain.com
    DocumentRoot "C:/htdocs/application2"
</VirtualHost>

<VirtualHost _default_:443>
    DocumentRoot "/var/www/site"
    # 許可するIPアドレスを変数で指定する
    Define IP_OK_1 192.168.1.1
    <Location "/">
        Require all denied
        Require ip 127.0.0.1
        Require ip ::1
        # リクエストのあったIPアドレスが許可されているものならOKとする
        Require expr req('X-Forwarded-For') -strmatch "${IP_OK_1}"
    </Location>
    # ヘルスチェック用のhtmlはユーザエージェントで判断してアクセス許可をする
    <Location "/index.html">
        Require all denied
        Require expr %{HTTP_USER_AGENT} -strmatch 'ELB-HealthChecker/2.0'
    </Location>
</VirtualHost>

# WebDAVモジュールの有効化
LoadModule dav_module modules/mod_dav.so
LoadModule dav_fs_module modules/mod_dav_fs.so
LoadModule dav_lock_module modules/mod_dav_lock.so

# WebDAV用設定ファイル読み込み
Include conf/extra/httpd-dav.conf

# WebDAV用ディレクトリ設定
<Directory "C:/htdocs/test/webdavtest">
    Options All -Indexes +SymLinksIfOwnerMatch -FollowSymLinks
    AllowOverride All
</Directory>

# DavLockDBファイルのパスを設定
DavLockDB "C:/htdocs/test/webdavtest/DavLock"

# エイリアスの設定
Alias /uploads "C:/htdocs/test/webdavtest/uploads"

# WebDAVディレクトリの設定
<Directory "C:/htdocs/test/webdavtest/uploads">
    Dav On
    Options None
    AuthType Basic
    AuthName "webdavuser"
    AuthUserFile C:\htdocs\test\webdavtest\basicauth.txt
    Require valid-user
</Directory>

C:\> cd C:\apache\bin
C:\apache\bin> htpasswd.exe -c C:\htdocs\test\webdavtest\basicauth.txt webdavuser
New password: **************
Re-type new password: **************
Adding password for user webdavuser

yum install gcc gcc-c++ make

cd /usr/local/src/
wget 'https://drive.google.com/uc?export=download&id=0B4y35FiV1wh7cENtOXlicTFaRUE' -O mecab-0.996.tar.gz
tar zxvf mecab-0.996.tar.gz
cd mecab-0.996
./configure --with-charset=utf8 --enable-utf8-only
make
make install
mecab --version

cd /usr/local/src/
wget 'https://drive.google.com/uc?export=download&id=0B4y35FiV1wh7MWVlSDBCSXZMTXM' -O mecab-ipadic-2.7.0-20070801.tar.gz
tar zxvf mecab-ipadic-2.7.0-20070801.tar.gz
cd mecab-ipadic-2.7.0-20070801
./configure --with-charset=utf8
make
make install
 
chmod a+r /usr/local/lib/mecab/dic/ipadic/dicrc

# 出力フォーマットyomiと入出力ファイルを指定して実行
mecab in.txt -o out.txt -Oyomi

# 対象文字列は標準入力から読み込み、自分で指定した出力フォーマット（読みだけ）で出力
echo テスト | mecab --node-format=%f[8] --unk-format=%M --eos-format=\n

import os
import subprocess
 
converted_lines = []
with open(os.path.join(os.path.dirname(__file__), 'in.txt'), 'r', encoding='utf-8') as f:
    while True:
        line = f.readline()
        if line == '':
            break

        command = r'mecab --node-format=%f[8] --unk-format=%M --eos-format=\n'.format(line)

        cp = subprocess.run(command, shell=True, input=line, text=True, capture_output=True, encoding='utf8')
        if cp.stdout is not None:
            converted_lines.append('{}\t{}\n'.format(line, cp.stdout.strip()))

with open(os.path.join(os.path.dirname(__file__), 'out.txt'), 'w', encoding='utf-8') as f:
    f.writelines(converted_lines)

yum install -y https://download.imagemagick.org/ImageMagick/download/linux/CentOS/x86_64/ImageMagick-libs-7.1.0-2.x86_64.rpm
yum install -y https://download.imagemagick.org/ImageMagick/download/linux/CentOS/x86_64/ImageMagick-7.1.0-2.x86_64.rpm
yum install -y https://download.imagemagick.org/ImageMagick/download/linux/CentOS/x86_64/ImageMagick-devel-7.1.0-2.x86_64.rpm
magick --version

# LibreOffice本体のインストール
yum install libreoffice-langpack-ja libreoffice-draw libreoffice-base libreoffice-impress libreoffice-math libreoffice-writer libreoffice-help-ja libreofficekit
soffice.bin --version

# LibreOfficeが使用する日本語フォントのインストール
wget https://moji.or.jp/wp-content/ipafont/IPAexfont/IPAexfont00401.zip
unzip IPAexfont00401.zip
mkdir /usr/share/fonts/japanese
mkdir /usr/share/fonts/japanese/TrueType
mv IPAexfont00401/*.ttf /usr/share/fonts/japanese/TrueType/
 
wget https://moji.or.jp/wp-content/ipafont/IPAfont/IPAfont00303.zip
unzip IPAfont00303.zip
mv IPAfont00303/*.ttf /usr/share/fonts/japanese/TrueType/
fc-cache -fv
fc-list

"C:\Program Files\LibreOffice\program\soffice.exe" --headless --nologo --nofirststartwizard --convert-to "pdf:calc_pdf_Export:{\"EncryptFile\":{\"type\":\"boolean\",\"value\":\"true\"},\"RestrictPermissions\":{\"type\":\"boolean\",\"value\":\"true\"},\"PermissionPassword\":{\"type\":\"string\",\"value\":\"pass\"},\"Changes\":{\"type\":\"long\",\"value\":\"0\"}}" test.xlsx --outdir .\

ffmpeg -i “C:\test\test_video.mp4” -c:v copy -c:a copy -segment_format mpegts -hls_time 9.0 -break_non_keyframes 0 -hls_list_size 0 -hls_segment_filename “C:\test\hls\test_video-%05d.ts” “C:\test\hls\test_video.m3u8”

 rand -out test_video.key 16

C:/> openssl rand -hex 16
b3fe659027bc3b007b883974c2d0ed19

http://localhost/test/test_video.key
C:\test\test_video.key
b3fe659027bc3b007b883974c2d0ed19

ffmpeg -i C:\test\test_video.mp4” -c:v copy -c:a copy -segment_format mpegts -hls_time 9.0 -break_non_keyframes 0 -hls_list_size 0 -hls_key_info_file “C:\test\test_video.keyinfo” -hls_segment_filename “C:\test\hls\test_video-%05d.ts” “C:\test\hls\test_video.m3u8”

<html>
	<head>
		<meta charset="UTF-8" />
		<script src="hls.js"></script>
	</head>
	<body>
		<video id="test_video" controls preload="metadata" width="640" height="480" />
		<script>
			function setVideo(path)
			{
				var video = document.getElementById('test_video');
				if(video.canPlayType('application/vnd.apple.mpegurl'))
				{
					video.src = path;
					return;
				}
				if(Hls.isSupported())
				{
					var hls = new Hls();
					hls.loadSource(path);
					hls.attachMedia(video);
				}
				return;
			}
			setVideo('/test/hls/test_video.m3u8');
		</script>
	</body>
</html>