lars-erik

declare module 'approvals' {

  // Scrubbers.d.ts copy
  export type Scrubber = (t: string) => string;
  type ReplacementFunction = (index: number) => string;
  export class Scrubbers {
    static createReqexScrubber(regex: RegExp, replacement: string | ReplacementFunction): Scrubber;
    static createGuidScrubber(): Scrubber;
    /**
     * This method exists as a convenient way to get an example scrubber for you to use.

lars-erik

param(
    $path
)

$files = Get-ChildItem -Path $path -File

$files | % {
    $fileInfo = $_
    $doc = [xml](Get-Content $fileInfo.FullName)
    $pageNode = $doc.DocumentElement.SelectSingleNode("Pages")

lars-erik

param (
    $Server,
    $Database,
    $Direction = "left to right",
    $IncludeDoctypes = $true,
    [Switch]
    $IncludeElements = $false,
    [Switch]
    $IncludeProperties = $false
)

lars-erik

# run in %programfiles%\Steam\steamapps

$files = Get-ChildItem -Path *.acf

$files | % { 
    $file = $_
    $content = get-content $_ 
    $content | % { 
        if ($_.Contains("AutoUpdateBehavior")) { 
            $_.Replace("0", "2") 

lars-erik

let
    Coalesce = (items as list) =>
        let 
            listOfFirst = List.FirstN(List.Select(items, each _ <> "" and _ <> null), 1),
            first = try List.Single(#"listOfFirst") otherwise null
        in
            first
in
    Coalesce

lars-erik

// umbracoPropertyData
let
    Source = Sql.Database(".\sqlexpress", "[your database]"),
    dbo_umbracoPropertyData = Source{[Schema="dbo",Item="umbracoPropertyData"]}[Data],
    #"Expanded cmsPropertyType" = Table.ExpandRecordColumn(dbo_umbracoPropertyData, "cmsPropertyType", {"Alias", "Name", "umbracoDataType"}, {"cmsPropertyType.Alias", "cmsPropertyType.Name", "cmsPropertyType.umbracoDataType"}),
    #"Expanded cmsPropertyType.umbracoDataType" = Table.ExpandRecordColumn(#"Expanded cmsPropertyType", "cmsPropertyType.umbracoDataType", {"propertyEditorAlias"}, {"cmsPropertyType.umbracoDataType.propertyEditorAlias"}),
    #"Expanded umbracoContentVersion" = Table.ExpandRecordColumn(#"Expanded cmsPropertyType.umbracoDataType", "umbracoContentVersion", {"id", "current", "umbracoContent"}, {"umbracoContentVersion.id", "umbracoContentVersion.current", "umbracoContentVersion.umbracoContent"}),
    #"Expanded umbracoLanguage" = Table.ExpandRecordColumn(#"Expanded umbracoContentVersion", "umbracoLanguage", {"languag

lars-erik

import-module webadministration
$sites = Get-ChildItem -path IIS:\Sites
$mappedSites = $sites | % { 
    $bindings = try { ($_.Bindings.Collection | % {$_.bindingInformation}) } catch { @() }
    if ($bindings -eq $null) { $bindings = @() }
    [PSCustomObject]@{ `
        Name=$_.Name; `
        Id=$_.Id; `
        State=$_.State; `
        Path=$_.PhysicalPath; `

lars-erik

let 
    Table.GenerateByPage = (getNextPage as function) as table =>
        let        
            listOfPages = List.Generate(
                () => getNextPage(null),            // get the first page of data
                (lastPage) => lastPage <> null,     // stop when the function returns null
                (lastPage) => getNextPage(lastPage) // pass the previous page to the next function call
            ),
            // concatenate the pages together
            tableOfPages = Table.FromList(listOfPages, Splitter.SplitByNothing(), {"Column1"}),

lars-erik

using Fluidity;
using XYZ.Core.Entities;
using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Linq.Expressions;
using System.Reflection;
using Umbraco.Core.Models;

lars-erik

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Threading.Tasks;
using System.Xml.Linq;
using Examine;
using Examine.LuceneEngine.Providers;
using Lucene.Net.Analysis;
using Microsoft.WindowsAzure.Storage.Auth;