分类： 便签

windows 下可以先装Git
/winsoft/
Git， https://www.git-scm.com/download/win 官方下载首页


#清理 node_modules
find . -type d -name node_modules > node_modules.dir
cat node_modules.dir | while read line; do echo $line && rm -rf $line; done


独立打包当前文件夹
for dir in */; do tar -cf "${dir%/}.tar" "$dir"; done

WITH RECURSIVE index_loop AS (
    SELECT 1 AS idx  -- 起始索引（可改为0）
    UNION ALL
    SELECT idx + 1   -- 索引自增
    FROM index_loop
    WHERE idx < 100   -- 循环次数（此处为10次）
)
SELECT idx ,
FROM_UNIXTIME(
    FLOOR(
      UNIX_TIMESTAMP('2023-01-01 00:00:00') + 
      RAND() * (
        UNIX_TIMESTAMP('2023-12-31 23:59:59') - 
        UNIX_TIMESTAMP('2023-01-01 00:00:00')
      )
    )
  ) AS random_datetime,
CONCAT(
    ELT(FLOOR(1 + RAND() * 34), '京','津','冀','晋','蒙','辽','吉','黑','沪','苏','浙','皖','闽','赣','鲁','豫','鄂','湘','粤','桂','琼','渝','川','贵','云','藏','陕','甘','青','宁','新','港','澳','台'),
    ELT(FLOOR(1 + RAND() * 24), 'A','B','C','D','E','F','G','H','J','K','L','M','N','P','Q','R','S','T','U','V','W','X','Y','Z'),
    
    CONCAT(
        ELT(FLOOR(1 + RAND() * 34), '0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F','G','H','J','K','L','M','N','P','Q','R','S','T','U','V','W','X','Y','Z'),
        ELT(FLOOR(1 + RAND() * 34), '0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F','G','H','J','K','L','M','N','P','Q','R','S','T','U','V','W','X','Y','Z'),
        ELT(FLOOR(1 + RAND() * 34), '0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F','G','H','J','K','L','M','N','P','Q','R','S','T','U','V','W','X','Y','Z'),
        ELT(FLOOR(1 + RAND() * 34), '0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F','G','H','J','K','L','M','N','P','Q','R','S','T','U','V','W','X','Y','Z'),
        ELT(FLOOR(1 + RAND() * 34), '0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F','G','H','J','K','L','M','N','P','Q','R','S','T','U','V','W','X','Y','Z')
    )
) AS license_plate
FROM index_loop;

https://stackedit.cn/share.html?id=8q5lswj9r3tfxn2pby0uc92

深入浅出Docker
https://ebook.qicoder.com/docker-deep-dive/

https://ebook.qicoder.com/docker-in-practice/

EasyNVR配置海康大华等安防摄像头通道地址的方法

注：在RTSP协议上，由于各个厂家都有不同的处理方法，比如：海康、大华、雄迈、宇视、天地伟业等厂家的RTSP地址规则有所区别。

大华产品
rtsp://username:password@ip:port/cam/realmonitor?channel=1&subtype=0

username: 用户名
password: 密码
ip: 为设备IP
port: 端口号默认为554，默认554时可不填写
channel: 通道号，起始为1。例如通道2，则为channel=2
subtype: 码流类型，主码流（subtype=0），辅码流（subtype=1）

海康-预览取流-旧版规则（2012年之前的设备只持旧版规则）
rtsp://:@://ch//av_stream

username: 用户名
password: 密码
ipaddress: 设备IP
port: 端口号默认为554，默认可不填写
videotype：视频编码格式，如：h264、mpeg4
ch: 通道号，起始为1。例如通道1，则为ch1
streamtype: 码流类型，主码流（main），辅码流（sub）

海康-预览取流-新版规则
rtsp://:@:/Streaming/Channels/(?parm1=value1&parm2=value2)

username: 用户名
password: 密码
ipaddress: 设备IP
port: 端口号默认为554，默认可不填写
id：通道号+0+码流类型 码流类型：1-主码流、2-子码流、3-第三码流；如 1202 表示第12通道子码流
parms 其他入参 如 transportmode=unicast (默认单播）transportmode=multicast (多播)

海康-回放取流
rtsp://:@:/Streaming/tracks/(?parm1=value1&parm2=value2)

username: 用户名
password: 密码
ipaddress: 设备IP
port: 端口号默认为554，默认可不填写
id：通道号+0+码流类型 码流类型：1-主码流、2-子码流、3-第三码流；如 1202 表示第12通道子码流
parms 其他入参 如 starttime=20131013t093812z&endtime=20131013t104816z ；具体格式是YYYYMMDD”T”HHmmSS.fraction”Z”，Y是年，M是月，D是日，T是时间分格符，H是小时，M是分，S是秒，Z是可选的、表示Zulu(GMT) 时间

1. 到当前目录Python
@echo off
@REM @chcp 65001
@REM @title %~n0
@REM @cd /d %~dp0
@set PYTHON_HOME=%~dp0
@set PATH=%PATH%;%PYTHON_HOME%;%PYTHON_HOME%Scripts

REM @echo.
REM @echo CUDA_HOME
@echo %PYTHON_HOME%
@echo PYTHON_HOME setup done

REM @echo.
REM @echo Load-ENV-CUDA
REM @call ./nvidia/cuda_11.6_setup.cmd
REM @call ../nvidia/cuda_12.8_setup.cmd

@cmd /k

REM No module named 'aliyunsdkcore'
REM pip install aliyun-python-sdk-core

2. gey-py.py

3. reinstall-wheel.cmd
@cd /d %~dp0 && clear
REM
python -m pip uninstall -y pip wheel setuptools
REM
python get-pip.py
REM
python -m pip install -y pip wheel setuptools
REM 导出依赖列表
pip freeze > requirements_freeze_wheel.txt
REM 下载依赖的 wheel 包到本地（如 wheelhouse 文件夹）
pip wheel -r requirements_freeze_wheel.txt -w wheelhouse/
REM 后续可通过 wheel 包安装依赖（避免重复下载）：
pip uninstall -r requirements_freeze_wheel.txt -y
REM
pip install --no-index --find-links=wheelhouse/ -r requirements_freeze_wheel.txt