taojy123 taojy123

🏷️ jianshu.tslow.cn

taojy123 / ffmpeg_crop.py

Created February 1, 2022 04:55

使用 ffmpeg 裁剪视频

taojy123 / Dockerfile

Last active December 8, 2020 02:57

jpype + sm2

	FROM python:3.7

	#RUN apt-get update && apt-get -y install vim && rm -rf /var/lib/apt/lists/*

	WORKDIR /workspace
	ENV PYTHONPATH /workspace

	RUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime && echo Asia/Shanghai > /etc/timezone

	#COPY requirements.txt /workspace/requirements.txt

taojy123 / lr.py

Created September 27, 2020 06:01

LR on sklearn

	from sklearn.linear_model import LogisticRegression
	from sklearn.model_selection import train_test_split
	from sklearn.metrics import classification_report

	X = []
	y = []
	lines = open('data.csv').readlines()
	for line in lines[1:]:
	line = line.strip()
	if not line:

taojy123 / yield_from.py

Created July 24, 2020 14:21

taojy123 / orm.py

Created May 21, 2020 02:53

pymysql + sqlalchemy

	import sqlalchemy
	from sqlalchemy import Column, Integer, String
	from sqlalchemy.ext.declarative import declarative_base
	import pymysql
	pymysql.install_as_MySQLdb()

	#object(oop) ---> mysql(SQL)
	#1). 创建数据库引擎(连接数据库的过程)
	#echo=True显示翻译好的SQL语句。
	from sqlalchemy.orm import Session, sessionmaker

taojy123 / sm4.py

Last active May 6, 2020 02:29

Python SM4

	#!/usr/bin/env python
	# -- coding: utf-8 --

	from sys import version_info

	from base64 import b64encode, b64decode
	from binascii import hexlify, unhexlify


	__all__ = ['encrypt_ecb', 'decrypt_ecb',

taojy123 / button.html

Last active June 17, 2020 10:12

css 画 button

taojy123 / sdd_weekly.sqlx

Last active April 7, 2020 01:14

sdd_weekly.sqlx



	-- ! =============== 通用方法 ==================
	func daily(table_name):
	-- 每日统计加上周统计日字段
	(
	SELECT
	*,
	CASE WHEN date_format(date(`日期`),'%w') < 5
	THEN subdate(date(`日期`), date_format(date(`日期`),'%w') -4 )

taojy123 / cassandra_paging.py

Created February 24, 2020 05:25

Python Cassandra Paging

	from cassandra.cluster import Cluster
	from cassandra.query import SimpleStatement


	cluster = Cluster(['taojy123.com'])
	session = cluster.connect('taiqiyun')

	query = "SELECT * FROM best"

	statement = SimpleStatement(query, fetch_size=2)

taojy123 / groxy.go

Last active December 10, 2020 03:02

tcp 端口转发并拦截流量推到 kafka 中