Skip to content

Instantly share code, notes, and snippets.

@sskset
sskset / TestController.aspx
Created April 27, 2019 11:02
TestController
global with sharing class TestController {
@RemoteAction
global static List<WorkOrder> getWorkOrders(){
return [SELECT Id,WorkOrderNumber FROM WorkOrder];
}
}
@sskset
sskset / package.js
Created April 27, 2019 11:05
salesforce package build commands
"scripts": {
"ng": "ng",
"start": "ng serve",
"build": "ng build",
"test": "ng test",
"lint": "ng lint",
"e2e": "ng e2e",
"dev": "ng build && gulp rm && gulp build-dev-package && gulp deploy && ng serve",
"prod": "ng build --prod && gulp rm && gulp build-package && gulp deploy"
},
@sskset
sskset / app.py
Created June 5, 2019 07:31
app.py
from flask import Flask
app=Flask(__name__)
@app.route("/")
def home():
return "Hello, World!"
@sskset
sskset / linked-server.sql
Created June 21, 2019 01:47
create a linked server in sql server
-- Create linked server
DECLARE @database VARCHAR(200) = DB_NAME();
EXECUTE sp_addlinkedserver @server = 'Logging',
@srvproduct = ' ',
@provider = 'SQLNCLI',
@datasrc = @@SERVERNAME,
@catalog = @database
@sskset
sskset / sp_log.sql
Created June 21, 2019 01:51
create a stored procedure in sql server
CREATE PROCEDURE sp_log(@errNumber int,
@errSeverity int,
@errState int,
@errProcedure nvarchar(128),
@errLine int,
@errMessage VARCHAR(4000)) AS
BEGIN
INSERT INTO ErrorLog SELECT @errNumber,@errSeverity,@errState,@errProcedure,@errLine,@errMessage,getdate();
END;
@sskset
sskset / switchs.sql
Created June 21, 2019 01:55
enable sql server rpc and disable distributed transaction
-- Enable RPC calls
EXEC sp_serveroption Logging, 'RPC OUT', 'TRUE'
-- disable distributed transaction
EXEC sp_serveroption Logging, 'remote proc transaction promotion', 'FALSE'
USE [Unicorn Paddock]
GO
/****** Object: StoredProcedure [dbo].[sp_test] Script Date: 21/06/2019 11:57:08 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_test]
AS
@sskset
sskset / muttrc
Created July 8, 2019 05:19 — forked from yangxuan8282/muttrc
Hotmail template config for mutt, just insert your mail account and password to "imap_user" and "imap_pass", if 2-factor is enable, generate an app password.
set ssl_starttls=yes
set ssl_force_tls=yes
set imap_user = '[email protected]'
set imap_pass = 'password_here'
set from= $imap_user
set use_from=yes
set realname='Your_Name'
set folder = imaps://imap-mail.outlook.com:993
set spoolfile = "+INBOX"
@sskset
sskset / cr.cs
Last active August 8, 2019 03:55
fibo
using System;
using System.Collections.Generic;
namespace ConsoleApp4
{
internal class Program
{
private static void Main(string[] args)
{
Console.WriteLine(F(21));
@sskset
sskset / startup.cs
Created September 3, 2019 12:59
FluentValidation in Startup.cs
// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
services
.AddMvc()
.SetCompatibilityVersion(CompatibilityVersion.Version_2_2)
.AddFluentValidation(fv => fv.RegisterValidatorsFromAssemblyContaining<Startup>());
}