tcmorris

SELECT cv.id
INTO #toDelete
FROM umbracoDocumentVersion dv
INNER JOIN umbracoContentVersion cv ON dv.id = cv.id
WHERE cv.[current] != 1 AND dv.published != 1 AND cv.VersionDate < '2021-01-01'

DELETE FROM umbracoPropertyData WHERE versionId IN (select id from #toDelete)
DELETE FROM umbracoDocumentVersion WHERE id IN (select id from #toDelete)
DELETE FROM umbracoContentVersionCultureVariation WHERE versionId IN (select id from #toDelete)
DELETE FROM umbracoContentVersion WHERE id IN (select id from #toDelete)

tcmorris

name: Build node.js

on: [push]

env:
  NODE_VERSION: '10.x'               

jobs:
  build-assets:
    runs-on: ubuntu-latest

tcmorris

name: Build and deploy to Azure

on: [push]

env:
  PROJECT_DIR: yourapp/path
  AZURE_WEBAPP_NAME: yourapp-name  
  DOTNET_VERSION: '2.2.402'

jobs:

tcmorris

public class CustomMigrationEventHandler : ApplicationEventHandler
{
    protected override void ApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext)
    {
        // check target version
        var rawTargetVersion = ConfigurationManager.AppSettings["app:MigrationVersion"] ?? "1.0.0";
        var targetVersion = SemVersion.Parse(rawTargetVersion);
        if (targetVersion != null)
        {
            HandleMigrations(targetVersion);

tcmorris

{% include events.html previous=true year="2017" %}

tcmorris

/// <summary>
/// MediaEventHandler
/// Will hook into the MediaService saving event and apply some custom logic to ensure we have a valid media file.
/// </summary>
public class MediaEventHandler : ApplicationEventHandler
{
    protected override void ApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext)
    {
        MediaService.Saving += MediaService_Saving;
    }

tcmorris

public static class RegexPatterns
{
    public const string Postcode = "^(GIR 0AA|gir 0aa|[A-PR-UWYZa-pr-uwyz]([0-9]{1,2}|([A-HK-Ya-hk-y][0-9]|[A-HK-Ya-hk-y][0-9]([0-9]|[ABEHMNPRV-Yabehmnprv-y]))|[0-9][A-HJKPS-UWa-hjkps-uw]) {0,1}[0-9][ABD-HJLNP-UW-Zabd-hjlnp-uw-z]{2})$";

    public const string EmailAddress = "^[a-zA-Z0-9._%+-]+@(?:[a-zA-Z0-9-]+\\.)+[a-zA-Z0-9-]{2,63}$";
}

tcmorris

<?xml version="1.0" encoding="utf-8" ?>
<Project xmlns="http://schemas.microsoft.com/developer/msbuild/2003">

	<UsingTask TaskName="TransformXml" AssemblyFile=".\Deploy\Microsoft.Web.Publishing.Tasks.dll" />

	<ItemGroup>
		<ConfigFiles Include=".\*.$(Environment).config;.\config\*.$(Environment).config">
			<OriginalPath>%(ConfigFiles.RootDir)%(ConfigFiles.Directory)$([System.String]::Copy('%(ConfigFiles.Filename)').Replace('.$(Environment)',''))%(ConfigFiles.Extension)</OriginalPath>
		</ConfigFiles>
		<ConfigFiles Include=".\*.$(COMPUTERNAME).config;.\config\*.$(COMPUTERNAME).config">

tcmorris

<!-- Restrict access to Umbraco -->
<rule name="Restrict access" stopProcessing="true">
    <match url="umbraco(?!/Surface/)" />
    <conditions logicalGrouping="MatchAny" trackAllCaptures="false">
        <add input="{HTTP_HOST}" matchType="Pattern" pattern="admin.example.com"
           ignoreCase="true" negate="true" />
    </conditions>
    <action type="Redirect" url="/not-found" appendQueryString="false" />
</rule>

tcmorris

<!--
Avoid search engines (Google, Yahoo, etc) indexing website's content
This method is preferred to using robots.txt, which may still cause your site to
show in search engine result pages even if you have set to disallow.

http://yoast.com/prevent-site-being-indexed/
http://code.google.com/web/controlcrawlindex/docs/robots_meta_tag.html
http://www.youtube.com/watch?v=KBdEwpRQRD0
-->