Skip to content

Instantly share code, notes, and snippets.

View wupher's full-sized avatar

wupher wupher

View GitHub Profile
docker run -d \
--name=wjdbmgrapp \
-v ~/Workspace/Docker/manager_app/wjdbmgrapp/conf:/etc/mysql/conf.d \
-v ~/Workspace/Docker/manager_app/wjdbmgrapp/data:/var/lib/mysql \
-e MYSQL_ROOT_PASSWORD=123456 \
-e MYSQL_DATABASE=wjdbmgrapp \
-e MYSQL_USER=mgrapp \
-e MYSQL_PASSWORD='mgrapp123!@#' \
daocloud.io/library/mysql:5.7.5
@wupher
wupher / 添加 Topic.sh
Created February 12, 2020 02:23
向 kafka. 中添加 topic
./kafka-topics.sh --create \
--zookeeper 192.168.97.195:2181 \
--replication-factor 1 \
--partitions 1\
--topic mqRequest
@wupher
wupher / 常用 MySQL 脚本
Created December 8, 2019 12:04
数据库建库、新增用户、权限、时区设置脚本
-- 创建数据库
CREATE DATABASE IF NOT EXISTS wjdbmgrapp DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
-- 创建用户密码
CREATE USER 'manager_app'@'localhost' IDENTIFIED BY 'mgrapp123!@#';
-- rights
GRANT ALL PRIVILEGES ON manager_app.* TO 'manager_app'@'localhost';
import matplotlib as mpl
import matplotlib.pyplot as plt
mpl.rcParams['font.family'] = 'Heiti TC'
%matplotlib inline
bins = range(min(data), max(data)+100, 100)
plt.hist(data, bins=bins)
plt.title("数据分布图")
plt.show()
import pymysql
connection = pymysql.connect(host='localhost', port=3306, user='manager_app',
password='mgrapp123!@#', db='wjdbmgrapp',
charset='utf8')
cursor = connection.cursor()
data = []
sql = 'select times from mq2004_record where date="2019-10-15 00:00:00" order by times desc ;'
cursor.execute(sql)
@wupher
wupher / HttpSignUtil.kt
Created May 3, 2018 03:11
ByteArry to HexString
fun ByteArray.toHex(): String {
val result = StringBuffer()
forEach {
val octet = it.toInt()
val firstIndex = (octet and 0xF0).ushr(4)
val secondIndex = octet and 0x0F
result.append(HEX_CHARS[firstIndex])
result.append(HEX_CHARS[secondIndex])
}
return result.toString()
@wupher
wupher / GZIPResponseStream.groovy
Created January 25, 2018 03:39
JavaSpringGzipFilter
package com.ktvme.mgrapp.util.gzip
import javax.servlet.ServletOutputStream
import javax.servlet.WriteListener
import java.util.concurrent.atomic.AtomicBoolean
import java.util.zip.GZIPOutputStream
/**
* @author fanwu 编写于 2018/1/25.
*/
@wupher
wupher / Encryptor.groovy
Created December 1, 2017 06:24
GZip & AES128
package me.fanwu.fx.utils
import groovy.util.logging.Slf4j
import javax.crypto.Cipher
import javax.crypto.spec.SecretKeySpec
import java.security.MessageDigest
import java.security.NoSuchAlgorithmException
import java.util.zip.GZIPInputStream
import java.util.zip.GZIPOutputStream
@wupher
wupher / RequestLogAspect.java
Created October 30, 2017 01:52
基于AOP,按照公司的日志规范修改后的WebAccessLog实现。
package com.ktvme.config.weblog;
import com.ktvme.mqservice.web.utils.Response;
import lombok.extern.slf4j.Slf4j;
import org.aspectj.lang.JoinPoint;
import org.aspectj.lang.annotation.*;
import org.slf4j.MDC;
import org.springframework.stereotype.Component;
import org.springframework.web.context.request.RequestContextHolder;
import org.springframework.web.context.request.ServletRequestAttributes;
@wupher
wupher / setenv.sh
Created March 22, 2017 13:25 — forked from terrancesnyder/setenv.sh
./setenv.sh - example setenv.sh with defaults set for minimal time spent in garbage collection
#! /bin/sh
# ==================================================================
# ______ __ _____
# /_ __/___ ____ ___ _________ _/ /_ /__ /
# / / / __ \/ __ `__ \/ ___/ __ `/ __/ / /
# / / / /_/ / / / / / / /__/ /_/ / /_ / /
#/_/ \____/_/ /_/ /_/\___/\__,_/\__/ /_/
# Multi-instance Apache Tomcat installation with a focus
# on best-practices as defined by Apache, SpringSource, and MuleSoft