Skip to content

Instantly share code, notes, and snippets.

View lachok's full-sized avatar

Lachezar (Lacho) Kozhuharov lachok

  • Zuhlke Engineering
  • London
View GitHub Profile
@lachok
lachok / CloneAndStartBugTracker.sh
Last active August 29, 2015 14:16
Getting started with vNext in OS X
git clone git@github.com:aspnet/BugTracker.git
cd BugTracker/src/BugTracker
kpm restore
k kestrel
-- DELETE OLD CONSTRAINTS
DECLARE @sql NVARCHAR(MAX) = N'';
SELECT @sql += N'
ALTER TABLE ' + QUOTENAME(OBJECT_SCHEMA_NAME(parent_object_id))
+ '.' + QUOTENAME(OBJECT_NAME(parent_object_id)) +
' DROP CONSTRAINT ' + QUOTENAME(name) + ';'
FROM sys.key_constraints
WHERE type IN ('UQ', 'PK') AND OBJECT_SCHEMA_NAME(parent_object_id) = 'dbo' AND OBJECT_NAME(parent_object_id) = 'RO_tblRole2User';
--PRINT @sql;
@lachok
lachok / pdfpen - ocr.scpt
Created May 3, 2014 21:17
AppleScript folder action and script application to OCR pdf files with PDFpen
--
-- OCR selected documents to a folder
--
on run
try
set input_items to choose file of type "com.adobe.pdf" with prompt "Choose input files:" with multiple selections allowed
set output_folder to choose folder with prompt "Choose output folder:"
tell application "Finder" to set output_folder_path to output_folder as text