myesn’s gists

myesn / split_worksheet_as_a_new_xlsx.py

Created March 21, 2025 07:40

将 xlsx 文件中的所有 worksheet 单独保存一份新的 xlsx 文件

	import os.path
	import shutil

	import openpyxl

	original_filepath = 'assets/a.xlsx'
	original_folder = os.path.dirname(original_filepath)
	original_filename = os.path.splitext(os.path.basename(original_filepath))[0]
	original_workbook = openpyxl.load_workbook(original_filepath)

myesn / payment-adapter.js

Last active October 31, 2024 02:46

通过 User-Agent 请求头区分扫码端应用，可实现一码适配多平台支付

	const http = require("http");

	const hostname = "0.0.0.0"; // 允许局域网内访问
	const port = 3000;

	const server = http.createServer((req, res) => {
	let clientDisplayName = undefined;
	const userAgent = req.headers["user-agent"];
	if (userAgent.includes("MicroMessenger")) {
	// wechat

myesn / GitHubStarManager.cs

Last active July 31, 2024 16:07

使用自定义条件批量取消我对仓库的 Star

	#region 必要参数配置

	// https://github.com/settings/tokens
	var accessToken = "ghp_";
	/*
	使用 https://sqlitebrowser.org/ 创建一个 SQLite 数据库文件，并执行以下语句创建表

	CREATE TABLE "Stars" (
	"Id" INTEGER UNIQUE,
	"Owner" TEXT NOT NULL,

myesn / animate-on-hover.html

Last active May 31, 2024 08:51

使用 animate.css 在鼠标悬浮至元素时添加动画

	<!DOCTYPE html>
	<html lang="en">

	<head>
	<meta charset="UTF-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<title>Document</title>
	<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/animate.css/4.1.1/animate.min.css" />
	<style>
	.container {

myesn / BinaryTreeTraversal.cs

Created October 16, 2023 07:34

二叉树遍历（层级、前序、中序、后序）

myesn / SearchIn2DMatrix.cs

Created October 15, 2023 06:32

在矩阵(二维数组)中查找目标值的坐标

	/*
	Q: 给定一个的目标值，在一个横向有序和纵向有序的二维数组（矩阵 matrix）中找到该目标值的坐标


	可以从矩阵的右上角或者左下角开始查找。
	假设从右上角开始查询：
	如果当前元素大于目标值，则可以排除当前元素所在的列，因为这一列都会比目标值大；
	如果当前元素小于目标值，则可以排除当前元素所在的行，因为这一行都会比目标值小。
	通过这种方式，每次都可以排除一整行或者一整列，大大减少了比较的次数，时间复杂度为 O(m+n)
	*/

myesn / BinarySearch.cs

Last active October 15, 2023 06:25

在一维数组中使用二分查找算法得到目标值的索引

	int[] array = { 1,11,21,31,41 };

	foreach(int num in array) {
	Console.WriteLine(BinarySearchMatrix(array, num));
	}

	// 二分查找：在一维数组中找到目标值的索引
	int BinarySearch(int[] array,int target)
	{
	// 初始化指针，定义头指针 left、尾指针 right = 二维数组中一维数组的数量-1=4-1，双闭区间 [0, array.Length - 1]

myesn / node-dns-benchmark.js

Created March 19, 2023 06:07

指定 dns 服务器，测试该 dns 服务器的 A 记录每秒解析速率

	const { Resolver } = require('node:dns').promises;
	const { performance } = require('perf_hooks');

	const domain = 'giao.com';

	const resolver = new Resolver();
	resolver.setServers(['192.168.31.117']);

	async function main() {
	const numIterations = 1;

myesn / logging.middleware.ts

Created December 22, 2022 01:52

NestJS Middleware

	// logging.middleware.ts
	import { Injectable, NestMiddleware } from '@nestjs/common';
	import { NextFunction, Request, Response } from 'express';

	@Injectable()
	export class LoggingMiddleware implements NestMiddleware {
	use(req: Request, res: Response, next: NextFunction) {
	console.log(`start [${req.method}] ${req.url}`);
	const oldSend = res.send;
	res.send = (body: any): any => {

myesn / logto-auth.guard.ts

Created October 20, 2022 08:52

NestJS Logto Auth Guard

	import {
	Injectable,
	CanActivate,
	ExecutionContext,
	HttpStatus,
	BadRequestException,
	UnauthorizedException,
	} from '@nestjs/common';
	import { Request } from 'express';
	import { ConfigService } from '@nestjs/config';