Skip to content

Instantly share code, notes, and snippets.

View naughtyGitCat's full-sized avatar
💭
😑

ngcat naughtyGitCat

💭
😑
  • Genshin
View GitHub Profile
@secsilm
secsilm / merge_mijia.py
Last active April 9, 2024 09:16
合并米家摄像头监控视频,生成以天为单位的视频文件。
import argparse
import subprocess
from pathlib import Path
from loguru import logger
parser = argparse.ArgumentParser(description='合并米家摄像头视频,以天为单位。')
parser.add_argument('indir', help='原米家摄像头视频目录。')
parser.add_argument('--outdir', default='./', help='合并后视频存放目录,目录不存在会被创建。默认当前目录。')
args = parser.parse_args()
@gianpaj
gianpaj / consoletable.js
Last active July 7, 2020 18:55
console.table for mongo shell - v1.0.2
// console.table for mongo shell - v1.0.2
// https://gist.github.com/gianpaj/63e04baed150f30b8976c16b16a0010c
// originally from 447dc8b on 18 Apr 2015
// https://github.com/chinchang/konsole.table/blob/447dc8be4bcb463865f0527ed6aef4da864d6558/index.js
var SEPARATOR = '│';
/**
* Repeat provided string a given no. of times.
@loilo
loilo / split-pull-requests.md
Last active April 3, 2024 07:24
Split a large pull request into two
@AlbertoMonteiro
AlbertoMonteiro / ObjectSpread.cs
Created February 14, 2018 23:24
Spread object in C#
using System;
using System.Collections.Concurrent;
using System.Collections.Generic;
using System.Linq;
using System.Reflection;
using System.Reflection.Emit;
namespace Playground
{
public class Program
@marwei
marwei / how_to_reset_kafka_consumer_group_offset.md
Created November 9, 2017 23:39
How to Reset Kafka Consumer Group Offset

Kafka 0.11.0.0 (Confluent 3.3.0) added support to manipulate offsets for a consumer group via cli kafka-consumer-groups command.

  1. List the topics to which the group is subscribed
kafka-consumer-groups --bootstrap-server <kafkahost:port> --group <group_id> --describe

Note the values under "CURRENT-OFFSET" and "LOG-END-OFFSET". "CURRENT-OFFSET" is the offset where this consumer group is currently at in each of the partitions.

  1. Reset the consumer offset for a topic (preview)
@lefred
lefred / addition_to_sys.sql
Last active May 24, 2023 12:28
MySQL Group Replication extra functions and views to sys schema
USE sys;
DELIMITER $$
CREATE FUNCTION IFZERO(a INT, b INT)
RETURNS INT
DETERMINISTIC
RETURN IF(a = 0, b, a)$$
CREATE FUNCTION LOCATE2(needle TEXT(10000), haystack TEXT(10000), offset INT)
@jonlabelle
jonlabelle / async_await_best_practices_cheatsheet.md
Last active May 12, 2024 03:58
C# Asynchronous Programming Guideline Cheat Sheet

Async Await Best Practices Cheat Sheet

Summary of Asynchronous Programming Guidelines

Name Description Exceptions
Avoid async void Prefer async Task methods over async void methods Event handlers
Async all the way Don't mix blocking and async code Console main method
Configure context Use ConfigureAwait(false) when you can Methods that require con­text
@pjdietz
pjdietz / rfc3339.js
Last active May 27, 2024 12:25
Format a local date as an RFC 3339 date with timezone
function rfc3339(d) {
function pad(n) {
return n < 10 ? "0" + n : n;
}
function timezoneOffset(offset) {
var sign;
if (offset === 0) {
return "Z";
@mooware
mooware / colorstreamhandler.py
Last active July 20, 2023 16:16
Colored log output for Python logging framework. Works on Windows, Linux, and probably Mac as well.
# colored stream handler for python logging framework (use the ColorStreamHandler class).
#
# based on:
# http://stackoverflow.com/questions/384076/how-can-i-color-python-logging-output/1336640#1336640
# how to use:
# i used a dict-based logging configuration, not sure what else would work.
#
# import logging, logging.config, colorstreamhandler
#
@TylerBrock
TylerBrock / orphanage.js
Created May 10, 2012 01:33
MongoDB Sharded Cluster Orphaned (Duplicate) Document Finder/Remover
/*
*
* orphanage.js -- Utility to find and remove orphaned documents
* 10gen 2012 -- Tyler Brock
*
* Script Orphan Finder Procedure:
* - Set up a connection to each shard
* - Turn of the balancer
* - For each chunk of data
* - Query each shard that is not in config