dodbrian

using System;
using System.IO;
using System.Linq;
using OfficeOpenXml;
using SpreadsheetLight;

namespace XlsxTemplateTest
{
    internal static class Program
    {

dodbrian

public Expression<Func<TEntity, TProperty>> ColumnByName<TEntity, TProperty>(string columnName)
{
    var propInfo = typeof(TEntity).GetProperty(columnName);
    var parameter = Expression.Parameter(typeof(TEntity));
    var memberAccess = Expression.MakeMemberAccess(parameter, propInfo);

    var exp = Expression.Lambda<Func<TEntity, TProperty>>(memberAccess, parameter);

    return exp;
}

dodbrian

Useful Git Commands

undo last rebase

1. Run git reflog and find first line from the top without rebase:
2. Take that line number, for instance: HEAD@{5}
3. Run git reset --hard HEAD@{5} to revert to the original state

undo last commit/merge

git reset --hard HEAD~1

dodbrian

 web:
   image: 'gitlab/gitlab-ce:latest'
   container_name: gitlab
   restart: always
   hostname: 'localhost'
   environment:
     GITLAB_OMNIBUS_CONFIG: |
       external_url 'http://localhost:32700'
       # Add any other gitlab.rb configuration here, each on its own line
   ports:

dodbrian

#!/bin/bash

# NAME: rm-kernels
# PATH: /usr/local/bin
# DESC: Provide zenity item list of kernels to remove

# DATE: Mar 10, 2017. Modified Aug 5, 2017.

# NOTE: Will not delete current kernel.

dodbrian

let arr = [], set = new Set(), n = 1000000;

for (let i = 0; i < n; i++) {
    arr.push(i);
    set.add(i);
}

function checkArr(arr, value) {
    return arr.indexOf(value);
}

dodbrian

Python 3 installation steps

Install pyenv

curl https://pyenv.run | bash

Install dependencies

sudo apt install build-essential zlib1g-dev libffi-dev libssl-dev

Install Python

pyenv install 3.7.3

dodbrian

@echo off

echo Checking for permissions
>nul 2>&1 "%SYSTEMROOT%\system32\cacls.exe" "%SYSTEMROOT%\system32\config\system"

echo Permission check result: %errorlevel%

REM --> If error flag set, we do not have admin.
if '%errorlevel%' NEQ '0' (
echo Requesting administrative privileges...

dodbrian

export class Guid {
    static newGuid() {
        return 'xxxxxxxx-xxxx-4xxx-yxxx-xxxxxxxxxxxx'.replace(/[xy]/g, function (c) {
            var r = Math.random() * 16 | 0, v = c == 'x' ? r : (r & 0x3 | 0x8);
            return v.toString(16);
        });
    }
}

dodbrian

#!/bin/bash

rabbitmqctl stop_app
rabbitmqctl reset
rabbitmqctl start_app