Skip to content

Instantly share code, notes, and snippets.

@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 / 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 / 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 / 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 / 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];
}
}
[email protected]
SF_PASSWORD={password}C4WjlOBJ5RcWhE0SJGsCCaB4 #password + $security_token
DIST_PATH=dist/salesforce-angular-app
LOGIN_URL=https://test.salesforce.com
PAGE_NAME=test
RESOURCE_NAME=test
CONTROLLER=
EXTENSIONS=
API_VERSION=45.0
BASE_HREF=/
@sskset
sskset / gulpfile.js
Last active April 27, 2019 10:30
gulpfile.js
var forceDeploy = require("gulp-jsforce-deploy");
var gulp = require("gulp");
var del = require("del");
var zip = require("gulp-zip");
var rename = require("gulp-rename");
var replace = require("gulp-replace");
var file = require("gulp-file");
var dotenv = require("dotenv");
var debug = require("gulp-debug");
dotenv.config();
@sskset
sskset / package.js
Last active April 27, 2019 11:13
salesforce-packages
"dotenv": "^7.0.0",
"gulp": "^3.9.1",
"gulp-debug": "^4.0.0",
"gulp-file": "^0.4.0",
"gulp-jsforce-deploy": "^1.1.2",
"gulp-rename": "^1.4.0",
"gulp-replace": "^1.0.0",
"gulp-zip": "^4.2.0",
docker run -d -p 15672:15672 rabbitmq:3-management
user id: guest
password: guest
docker run --name eventstore-node -it -p 2113:2113 -p 1113:1113 eventstore/eventstore