eeskildsen

# Creates a WordPress site with SQLite as the database. Should be cross platform.

param(
    [Parameter(Mandatory)]
    [string]
    $SiteName
)

# Create a directory
Write-Host "Creating directory $SiteName."

eeskildsen

# Posh-ACME is for getting Let's Encrypt certificates

# Install for all users (requires elevation)
Install-Module -Name Posh-ACME -Scope AllUsers

# Get a wildcard cert
$domain = Read-Host 'Domain'
$certNames = "*.$domain", $domain
$email = "admin@$domain"
$pArgs = @{} # TODO

eeskildsen

Setting Up ANTLR

1. Download and set up ANTLR4
2. Download PlSqlLexer.g4 and PlSqlParser.g4 from https://github.com/antlr/grammars-v4/tree/master/sql/plsql

Building the Grammar

1. Build the lexer (https://stackoverflow.com/a/55379369/1958726):

   antlr4 PlSqlLexer.g4 -Dlanguage=CSharp
   

eeskildsen

using PuppeteerSharp;
using System.Linq;
using System.Threading.Tasks;

namespace PuppeteerBoilerplate
{
    class Program
    {
        static async Task Main(string[] args)
        {

eeskildsen

<input type="tel" name="phone" id="phone" class="form-control" required="" data-parsley-phone="">

<script>
  var parsleyPhoneValidatorSettings = {
    ignoreCharacters: /[()+\- ]/g,
    usPhoneNumber: /^1?\d{10}$/
  };
  
  window.Parsley.addValidator('phone', {
    validateString: function(value) {

eeskildsen

-- https://stackoverflow.com/a/27361062/1958726
-- Change: Select distinct table, column names only
-- Change: Discard value
-- Change: Sort in ascending order

USE DATABASE_NAME
DECLARE @SearchStr nvarchar(100) = 'SEARCH_TEXT'
DECLARE @Results TABLE (ColumnName nvarchar(370))

SET NOCOUNT ON

eeskildsen

public static Folder FindFolderByDisplayName(ExchangeService service, string name)
{
    var folderView = new FolderView(100);

    folderView.PropertySet = new PropertySet(BasePropertySet.IdOnly);
    folderView.PropertySet.Add(FolderSchema.DisplayName);
    folderView.Traversal = FolderTraversal.Deep;

    FindFoldersResults findFolderResults = service.FindFolders(WellKnownFolderName.Root, folderView);

eeskildsen

using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;

public static class SqlBulkCopyExtensions
{
    public static SqlBulkCopy WithColumnMappings(this SqlBulkCopy sqlBulkCopy, DataColumnCollection columns) => WithColumnMappings(sqlBulkCopy, columns.Cast<DataColumn>());

    public static SqlBulkCopy WithColumnMappings(this SqlBulkCopy sqlBulkCopy, IEnumerable<DataColumn> columns)