graywolfcorp

CREATE proc [dbo].[sp_MSforeachtable]
	@command1 nvarchar(2000), @replacechar nchar(1) = N'?', @command2 nvarchar(2000) = null,
  @command3 nvarchar(2000) = null, @whereand nvarchar(2000) = null,
	@precommand nvarchar(2000) = null, @postcommand nvarchar(2000) = null
AS
	declare @mscat nvarchar(12)
	select @mscat = ltrim(str(convert(int, 0x0002)))
	if (@precommand is not null)
		exec(@precommand)
   exec(N'declare hCForEachTable cursor global for select ''['' + REPLACE(schema_name(syso.schema_id), N'']'', N'']]'') + '']'' + ''.'' + ''['' + REPLACE(object_name(o.id), N'']'', N'']]'') + '']'' from dbo.sysobjects o join sys.all_objects syso on o.id = syso.object_id '

graywolfcorp

CREATE proc [dbo].[sp_MSforeach_worker]
	@command1 nvarchar(2000), @replacechar nchar(1) = N'?', @command2 nvarchar(2000) = null, @command3 nvarchar(2000) = null, @worker_type int =1
as

	create table #qtemp (	/* Temp command storage */
		qnum				int				NOT NULL,
		qchar				nvarchar(2000)	COLLATE database_default NULL
	)

	set nocount on

graywolfcorp

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <system.webServer>
    <rewrite>
      <rules>
        <rule name="spa" stopProcessing="true">
          <match url="^(?!.*(.js|.css|.png|.jpg|.ico|.svg)).*$" />
          <conditions logicalGrouping="MatchAll">
          </conditions>
          <action type="Rewrite" url="/"  appendQueryString="true" />

graywolfcorp

#include <FileConstants.au3>
#include <MsgBoxConstants.au3>
#include <StringConstants.au3>

HotKeySet("{F1}", "openTabs")
HotKeySet("{F7}", "copyELD")
HotKeySet("{F6}", "terminate")

Func copyELD()
	$window_title = WinGetTitle("[active]")

graywolfcorp

Original idea can be found at  https://stackoverflow.com/questions/70732135/how-to-embed-github-gist-in-blazor-wasm

Modified for Blazor server and MudBlazor 

Usage:

<GithubGistSnippet Title="Test" UserId="graywolfcorp" FileName="08cafafda5d51ccdac25a8b45afd3d77"></GithubGistSnippet>


GitHubGistSnippet.razor.cs

graywolfcorp

  steps:
      - name: checkout Blazor web - primary solution - need to place one folder down so relative refs in sln file work
        uses: actions/checkout@v4
        with:
          path: './app'
          
      - name: check out httprequest - external project library
        uses: actions/checkout@v4
        with:
          token: ${{ secrets.TOKEN }}

graywolfcorp

# Docs for the Azure Web Apps Deploy action: https://github.com/Azure/webapps-deploy
# More GitHub Actions for Azure: https://github.com/Azure/actions

name: gwcblazor - dev

on:
  push:
    branches:
      - dev
  workflow_dispatch:

graywolfcorp

Log.Logger = new LoggerConfiguration()
    .Enrich.FromLogContext()
    .MinimumLevel.Override("System.Net.Http.HttpClient", LogEventLevel.Warning)
    .MinimumLevel.Override("Microsoft", LogEventLevel.Warning)
    .MinimumLevel.Override("Microsoft.Hosting.Lifetime", LogEventLevel.Warning)
    .WriteTo.Logger(x => x
        .Filter.ByExcluding("StartsWith(@m, 'The next 5 occurrences')")
        .Filter.ByExcluding("StartsWith(@m, 'Executing ''Functions')")
        .Filter.ByExcluding("StartsWith(@m, 'Executed ''Functions')")
        .Filter.ByExcluding("StartsWith(@m, 'null')") //suppress null messages from webjobs internal actions at INFO level https://github.com/Azure/azure-webjobs-sdk/issues/1968