Instantly share code, notes, and snippets.

View drop.sql
BEGIN -- Delete all tables in order to re-create.
DECLARE @sql NVARCHAR(MAX);
SET @sql = N'';
SELECT @sql = @sql + N'
ALTER TABLE ' + QUOTENAME(s.name) + N'.'
+ QUOTENAME(t.name) + N' DROP CONSTRAINT '
+ QUOTENAME(c.name) + ';'
FROM sys.objects AS c
INNER JOIN sys.tables AS t
View README.md

Cron Job Wrapper Wish List

I want a script that will give me:

  1. Logging
  2. Log purging!
  3. Email errors!
  4. Prevent duplicate processes! (flock)
  5. Source an environment file!
  6. Anything else?
View Program.cs
using System;
using System.Net.Http;
using System.Net.Http.Headers;
using System.Text;
using System.Threading.Tasks;
namespace ConsoleTestApp1
{
class Program
{
View BuildingDbContextFactory.cs
public class FooDbContextFactory : IDesignTimeDbContextFactory<FooDbContext>
{
public FooDbContext CreateDbContext(string[] args)
{
var optionsBuilder = new DbContextOptionsBuilder<FooDbContext>();
optionsBuilder.UseSqlServer("DeaultConnection");
return new FooDbContext(optionsBuilder.Options);
}
}
View gist:e6ccf70736bc1a8ae9abe5afc212c1de
Vue.directive('on-show-bs-tab', {
bind: function (el, binding) {
// This is BS4 jQuery
// When the tab is activated, load the data!
$(el).on('show.bs.tab', function (e) {
if (typeof binding.value === "function") {
binding.value.call();
}
});
}
View CampaignMonitor.cs
[TestMethod]
public void PrintListIds()
{
PrintListIds("key", "id");
PrintListIds("key", "id");
PrintListIds("key", "id");
}
private static void PrintListIds(string apiKey, string clientId)
{
View InMemorySet.cs
using System;
using System.Collections;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Data.Entity;
using System.Linq;
using System.Linq.Expressions;
namespace FCM.Web.Tests.TestHelpers
{
View SimMetricsMetricUtilities_JaroWinkler_Bug.cs
[Test]
public void GetSimilarity_SpaceInTarget_NotZero()
{
var matcher = new SimMetricsMetricUtilities.JaroWinkler();
var target = " 1 main";
var candidate = "1 main st";
var similarity = matcher.GetSimilarity(candidate, target);
var message = string.Format("Expect similarity {0} to be > .9", similarity);
Assert.IsTrue(similarity > .90, message);
View google-chart.html
var ngGridObj = [ {
"entity" : {
'date' : '2013-09-23 23:23:23',
'amt' : 4.5,
'name' : 'Mike'
}
}, {
"entity" : {
'date' : '2013-09-26 23:23:23',
'amt' : 6.5,
View groupBy.js
/**
* @method
* @public
* @description Take an array of objects and convert to an array of pairs whose
* xCol are grouped and yCol values are aggregated somehow. If
* grouping by day or month, dates must be in ZULU format strings!
* Original implementation returned an object with keys = xCol and
* values = yCol. It worked great but js maps(objects) cannot be
* sorted!
* @param {array}