Skip to content

Instantly share code, notes, and snippets.

View mikaelnet's full-sized avatar

Mikael Högberg mikaelnet

View GitHub Profile
@mikaelnet
mikaelnet / controller.js
Last active August 29, 2015 14:14
Node client for Raspberry PI Deployer
var argv = require('argv');
var https = require('https');
var xml2js = require('xml2js');
var inspect = require('eyes').inspector({maxLength: false});
var gpio = require('gpio');
var xmlParser = new xml2js.Parser();
var teamCityHost = 'your team city host';
@mikaelnet
mikaelnet / EnumerableExtensions
Created April 17, 2015 07:52
Extension methods for enumerables
public static class EnumerableExtensions
{
public static IEnumerable<T> ToEnumerable<T>(this T item, bool nullAsEmpty = true)
{
if (EqualityComparer<T>.Default.Equals(item, default(T)) && nullAsEmpty)
yield break;
yield return item;
}
public static bool None<TSource>(this IEnumerable<TSource> source, Func<TSource, bool> predicate)
@mikaelnet
mikaelnet / IPAddressExtensions
Created April 17, 2015 08:22
Extension methods for handling IPv4 addresses
public static class IPAddressExtensions
{
/// <summary>
/// Tests if a given IPv4 address is within any of the private
/// IP address ranges, 10.0.0.0/8, 172.16.0.0/12 or 192.168.0.0/16
/// </summary>
/// <param name="address"></param>
/// <returns>True if the address is private, otherwise false.
/// Note: IPv6 address always returns false</returns>
/// <exception cref="NotSupportedException">For unknown address families (other than IPv4 and IPv6)</exception>
@mikaelnet
mikaelnet / LevenshteinDistanceComputer
Created April 17, 2015 08:28
Computes Levenshtein Distance of two strings
public static class LevenshteinDistanceComputer
{
public static int LevenshteinDistance(this string s, string t)
{
return Compute(s, t);
}
public static int Compute(string s, string t)
{
if (string.IsNullOrEmpty(s))
@mikaelnet
mikaelnet / Upload-MediaItems.ps1
Created November 19, 2015 07:31
Sitecore Powershell Image upload
function Update-MediaItem {
[CmdletBinding()]
param(
[Parameter(Position=0, Mandatory=$true, ValueFromPipeline=$true)]
[ValidateNotNullOrEmpty()]
[string]$filePath,
[Parameter(Position=1, Mandatory=$true)]
[ValidateNotNullOrEmpty()]
[string]$mediaPath)
@mikaelnet
mikaelnet / table-sizes.sql
Created April 4, 2016 09:41
List the size of all tables in database on SQL Server
select 'Database Name: ', db_name()
set nocount on
if exists(select name from tempdb..sysobjects where name='##tmp') drop table ##tmp
create table ##tmp(nam varchar(50), rows int, res varchar(15),data varchar(15),ind_sze varchar(15),unsed varchar(15))
go
declare @tblname varchar(50)
declare tblname CURSOR for select name from sysobjects where xtype='U'
open tblname
Fetch next from tblname into @tblname
WHILE @@FETCH_STATUS = 0
@mikaelnet
mikaelnet / find-text-in-database.sql
Created April 5, 2016 07:01
Find a piece of text in any column in any table in a SQL Server database
DECLARE @SearchStr nvarchar (100)
SET @SearchStr = 'string to find'
CREATE TABLE #Results ( ColumnName nvarchar( 370), ColumnValue nvarchar(3630 ))
SET NOCOUNT ON
DECLARE @TableName nvarchar (256), @ColumnName nvarchar( 128), @SearchStr2 nvarchar(110 )
SET @TableName = ''
SET @SearchStr2 = QUOTENAME( '%' + @SearchStr + '%','''' )
@mikaelnet
mikaelnet / TouchItem.cs
Created April 15, 2019 14:23
Sitecore Touch-Item Powershell Cmdlet
using System.Management.Automation;
using Sitecore.Data.Items;
[OutputType(typeof(Item)), Cmdlet("Touch", "Item")]
public class TouchItem : Cmdlet
{
[Parameter(ValueFromPipeline = true, ValueFromPipelineByPropertyName = true)]
public Item Item { get; set; }
protected override void ProcessRecord()
@mikaelnet
mikaelnet / Broken links Report.ps1
Created August 21, 2019 12:31
Updated Sitecore SPE Broken links Report
@mikaelnet
mikaelnet / FilteredSitecoreItemCrawler.cs
Last active May 10, 2020 07:54
Sitecore Filtered Item Crawler
using System;
using System.Collections.Generic;
using System.Linq;
using Sitecore;
using Sitecore.Collections;
using Sitecore.ContentSearch;
using Sitecore.Data;
using Sitecore.Data.Items;
using Sitecore.Diagnostics;