Skip to content

Instantly share code, notes, and snippets.

View JeremyCaney's full-sized avatar

Jeremy Caney JeremyCaney

View GitHub Profile
@JeremyCaney
JeremyCaney / OrganizationNameControllerFactory.cs
Last active February 19, 2019 03:10
Reference version of a ControllerFactory used to configure OnTopic.
/*==============================================================================================================================
| Author Ignia, LLC
| Client OrganizationName
| Project Website
\=============================================================================================================================*/
using System;
using System.Web.Mvc;
using System.Web.Routing;
using Ignia.Topics;
using Ignia.Topics.Mapping;
@JeremyCaney
JeremyCaney / OrganizationNameActivator.cs
Last active December 16, 2019 00:35
Reference version of an `IControllerActivator` used to configure OnTopic in ASP.NET Core.
/*==============================================================================================================================
| Author Ignia, LLC
| Client OrganizationName
| Project Website
\=============================================================================================================================*/
using System;
using Ignia.Topics;
using Ignia.Topics.AspNetCore.Mvc;
using Ignia.Topics.AspNetCore.Mvc.Components;
using Ignia.Topics.AspNetCore.Mvc.Controllers;
@JeremyCaney
JeremyCaney / LightroomQuery.sql
Last active September 13, 2019 20:44
Adobe Lightroom Classic: List folders with image count, optionally filtered by rating
select pathFromRoot,
count(*)
from AgLibraryFile files
join Adobe_images images
on files.id_local = images.rootFile
join AgLibraryFolder folders
on files.folder = folders.id_local
where rating >= 0
group by pathFromRoot