Skip to content

Instantly share code, notes, and snippets.

View suntong's full-sized avatar

suntong

40 followers · 0 following
View GitHub Profile
@suntong
suntong / test.md
Last active November 8, 2021 15:02

test.mdtest2

@suntong
suntong / PerformanceCounterTest.cs
Created July 31, 2018 18:40
using System;
using System.Diagnostics;
using System.IO;
using System.Linq;
using System.Threading;
namespace PerformanceCounterTest
{
public class Program
@suntong
suntong / etc-locale.nopurge
Created November 7, 2021 02:47
####################################################
# This is the configuration file for localepurge(8).
####################################################
####################################################
# Uncommenting this string enables the use of dpkg's
# --path-exclude feature. In this mode, localepurge
# will configure dpkg to exclude the desired locales
# at unpack time.
#
@suntong
suntong / grml2usb.md
Created October 16, 2021 21:11 
grml2usb --verbose --mbr-menu grml64-full_2021.07.iso /dev/sdb3
2021-10-16 17:06:48,429 Executing grml2usb version 0.18.3
2021-10-16 17:06:48,430 Checking for boot flag
2021-10-16 17:06:48,588 boot flag is enabled on /dev/sdb3
2021-10-16 17:06:48,771 Using ISO grml64-full_2021.07.iso
2021-10-16 17:06:48,772 mount ['-o', 'loop,ro', '-t', 'iso9660'] /mnt/d/Arch/linux/grml64-full_2021.07.iso /tmp/grml2usbnk1kskoc
2021-10-16 17:06:48,797 register_mountpoint(/tmp/grml2usbnk1kskoc)
2021-10-16 17:06:48,798 mount ['-o', 'utf8,iocharset=iso8859-1'] /dev/sdb3 /tmp/grml2usbgmn859jd
2021-10-16 17:06:48,985 register_mountpoint(/tmp/grml2usbgmn859jd)
@suntong
suntong / My own public repos.json
Last active September 19, 2021 20:39
{
"data": {
"search": {
"repositoryCount": 76,
"edges": [
{
"node": {
"name": "adbc",
"url": "https://github.com/suntong/adbc",
"description": "adbc - Ant Design BizCharts",
@suntong
suntong / AdventureWorksLT2017.sql
Created August 12, 2021 02:59
USE [master]
GO
/****** Object: Database [AdventureWorksLT2017] Script Date: 8/11/2021 10:48:24 PM ******/
CREATE DATABASE [AdventureWorksLT2017]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'AdventureWorksLT2012_Data', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\DATA\AdventureWorksLT2012.mdf' , SIZE = 22464KB , MAXSIZE = UNLIMITED, FILEGROWTH = 16384KB )
LOG ON
( NAME = N'AdventureWorksLT2012_Log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\DATA\AdventureWorksLT2012_log.ldf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
GO
@suntong
suntong / Sql.rl
Created August 7, 2021 16:14 — forked from umjasnik/Sql.rl
simple SQL parser using ragel - get all tables that are referenced in a SQL statement
package de.uwefleischer.statemachines;
import java.util.Set;
import java.util.TreeSet;
public class Sql {
private static Set<String> tables;
%%{
@suntong
suntong / sales.sql
Last active August 4, 2021 20:37
CREATE TABLE "Customer" (
"CustomerID" int NOT NULL,
"Name" varchar NOT NULL,
"Address1" varchar NOT NULL,
"Address2" varchar NULL,
"Address3" varchar NULL,
CONSTRAINT "pk_Customer" PRIMARY KEY (
"CustomerID"
)
);
@suntong
suntong / AdventureWorksLT.ddl.sql
Created August 4, 2021 15:58
USE [AdventureWorksLT]
GO
/****** Object: Table [ProductModel] Script Date: 8/3/2021 10:04:22 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [ProductModel](
[ProductModelID] [int] IDENTITY(1,1) NOT NULL,
[Name] [dbo].[Name] NOT NULL,
@suntong
suntong / openwechat-Caller.svg
Last active August 2, 2021 20:50
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.