Skip to content

Instantly share code, notes, and snippets.

View gengxiankun's full-sized avatar
💭
I may be slow to respond.

gengxiankun

💭
I may be slow to respond.
View GitHub Profile
/**
* 信息脱敏逻辑类
* @author xiankun.geng
*/
@Service
public class DesensitizedService {
/**
* 信息脱敏
* @param result 出参
<type>(<scope>): <subject>
#type:
# 1. feat: 新功能 (feature)
# 2. fix: 修复bug
# 3. docs: 文档 (documentation)
# 4. style: 格式 (不影响代码运行的变动)
# 5. refactor: 重构 (即不是新增功能,也不是修改bug的代码变动)
# 6. test: 增加测试
# 7. chore: 构建过程或者辅助工具的变动
@gengxiankun
gengxiankun / tcpdump-sql.sh
Last active January 2, 2019 06:25
使用tcpdump抓取sql
#!/bin/bash
#this script used montor mysql network traffic.echo sql
tcpdump -i ${1:eth0} -s 0 -l -w - dst port ${2:3306} | strings | perl -e '
while(<>) { chomp; next if /^[^ ]+[ ]*$/;
if(/^(SELECT|UPDATE|DELETE|INSERT|SET|COMMIT|ROLLBACK|CREATE|DROP|ALTER|CALL)/i)
{
if (defined $q) { print "$q\n"; }
$q=$_;
} else {
$_ =~ s/^[ \t]+//; $q.=" $_";
@gengxiankun
gengxiankun / sqlbackup.sh
Created June 14, 2017 15:41
Automatically back up SQL scripts
#!/usr/bin/env bash
# @auther <james@lightbeijing.com>
set -x
shopt -s extglob
BACKUP_HOST=''
BACKUP_USER=''
BACKUP_PASSWORD=''
BACKUP_PORT=3306
MAIL_ADDR=('james@lightbeijing.com')