vebodev

Install Warp Terminal on Arch Linux

sudo sh -c "echo -e '\n[warpdotdev]\nServer = https://releases.warp.dev/linux/pacman/\$repo/\$arch' >> /etc/pacman.conf"
sudo pacman-key -r "[email protected]"
sudo pacman-key --lsign-key "[email protected]"

vebodev

删除某个时间点前的indics

# 列出当前所有indics
curl -k  "https://localhost:9200/_cat/indices"

curl -k -X POST "http://localhost:9200/graylog_148/_delete_by_query?pretty" -H 'Content-Type: application/json' -d'
{

vebodev

# match text in all tables' comments
SELECT TABLE_NAME, COLUMN_NAME, COLUMN_COMMENT
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'iCRM2_CustomerDB_Saas_xzdyf'
AND COLUMN_COMMENT LIKE '%复购%';

vebodev

/* 查询 TiKV 节点状态 */
select * from INFORMATION_SCHEMA.TIKV_STORE_STATUS;

vebodev

# list all running tasks from tidb
select * from information_schema.cluster_processlist where INFO is not null order by Time DESC

vebodev

#[derive(Debug, StructOpt)]
#[structopt(name = "wechat-user-refresh", about = "批量刷新微信用户 unionid")]
struct Opt {
    #[structopt(short="t", long="token", help="微会员企业Token, 不是微信token")]
    token: String,
    #[structopt(short="c", long="concurrency", default_value="16", help="并发数")]
    concurrency: usize,
    #[structopt(name="FILE", parse(from_os_str), help="包含 card_num,openid 格式的 csv文件")]
    file: PathBuf,
}

vebodev

# This is the UnixODBC driver config
[mysql]
Driver          = /usr/local/lib/libmyodbc8a.so
UsageCount      = 1

vebodev

[test]
Driver      = mysql
Description = Connector/ODBC 8.0 UNICODE Driver DSN
SERVER      = tidb-dev
PORT        = 4000
USER        = 
Password    = 
Database    = patrolman
OPTION      = 3
SOCKET      =