Skip to content

Instantly share code, notes, and snippets.

@chenbojian
chenbojian / http-proxy-connect.js
Last active December 26, 2023 02:57
simple nodejs http proxy implementation
# https://imququ.com/post/web-proxy.html
var http = require('http');
var net = require('net');
var url = require('url');
function connect(cReq, cSock) {
var u = url.parse('http://' + cReq.url);
var pSock = net.connect(u.port, u.hostname, function() {
cSock.write('HTTP/1.1 200 Connection Established\r\n\r\n');
@chenbojian
chenbojian / UserRights.psm1
Created September 1, 2020 08:45
UserRights.psm1
<# -- UserRights.psm1 --
The latest version of this script is available at https://gallery.technet.microsoft.com/Grant-Revoke-Query-user-26e259b0
VERSION DATE AUTHOR
1.0 2015-03-10 Tony Pombo
- Initial Release
1.1 2015-03-11 Tony Pombo
- Added enum Rights, and configured functions to use it
// See https://aka.ms/new-console-template for more information
using System.Text;
using System.Text.RegularExpressions;
var lines = File.ReadAllLines("error.txt");
var regex = new Regex(@"(C:\\workspace.+.cs)\((.+),(.+)\): Error CodeAnalyzer0001", RegexOptions.Compiled);
Console.WriteLine("start");
var fileRowsDict = new Dictionary<string, List<int>>();
@chenbojian
chenbojian / openssl-cert-chain.sh
Last active March 25, 2023 02:31
Certificate Chain
#Generate CA Certificate
#Generate private Key
openssl genrsa -out CA.key 2048
#Generate CA CSR
void Update(DataRow newRow, string connStr, string tableName)
{
using MySqlDataAdapter da = new MySqlDataAdapter(
$"select * from {tableName}",
connStr
);
da.UpdateCommand = new MySqlCommandBuilder(da).GetUpdateCommand();
DataSet ds = new DataSet();
@chenbojian
chenbojian / MFC-CRecordset-example.cpp
Last active September 4, 2022 02:30
MFC CRecordset
void func() {
CDatabase db;
CRecordset rs(&db);
db.OpenEx("Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\\dbo.mdb;");
db.ExecuteSQL("select * from Sporter");
rs.Open(CRecordset::dynaset, "select * from [Sporter]", CRecordset::none);
BOOL a = rs.CanAppend();
function Convert-Gbk-To-Utf8($source, $dest) {
$gbk = [System.Text.Encoding]::GetEncoding("gb2312")
$utf8 = [System.Text.Encoding]::UTF8
$text = [System.IO.File]::ReadAllText($source, $gbk)
[System.IO.File]::WriteAllText($dest, $text, $utf8)
}
function Set-TrustAllCertsPolicy {
Add-Type @"
using System.Net;
using System.Security.Cryptography.X509Certificates;
public class TrustAllCertsPolicy : ICertificatePolicy {
public bool CheckValidationResult(
ServicePoint srvPoint, X509Certificate certificate,
WebRequest request, int certificateProblem) {
return true;
}
$roleAssignments = Get-AzRoleAssignment
$roles = Get-AzRoleDefinition
# https://docs.microsoft.com/en-us/azure/role-based-access-control/resource-provider-operations
$storageActionRegexList = @('^\*$', '^\*/.+$', '^Microsoft\.Storage/.+$')
$storageDataActionRegexList = @('^\*$', '^\*/.+$', '^Microsoft\.Storage/.+$')
$storageManagementAccessRoles = @()
$storageDataAccessRoles = @()