Skip to content

Instantly share code, notes, and snippets.

@loonison123
loonison123 / insertintowithselect.sql
Last active August 29, 2015 14:08
Insert Into with select
insert into [dbo].[Customer] (FirstName, LastName, DateCreated)
select
f_name,
l_name,
getdate()
from [dbo].[Cust]
-- No Where Statement, Careful!
@loonison123
loonison123 / nodejs_emit_events_1.js
Created November 1, 2014 23:10
Node.js emit events by inheriting EventEmitter
// csvHelper.js
var events = require('events');
function CsvHelper () {
this.config = null;
this.data = null;
// Need to instantiate EventEmitter constructor
events.EventEmitter.call(this);
}
@loonison123
loonison123 / rename_Mongo_Database.js
Created November 1, 2014 22:47
Rename database in MongoDB
db.copyDatabase("db_to_rename","db_renamed","localhost")
use db_to_rename
db.dropDatabase();
@loonison123
loonison123 / portable_js.js
Created November 1, 2014 21:48
JavaScript module shared between node or browser
(function(exports){
// Only allow files uploaded below a maximum size
exports.isValidSize = function(sourceSize){
var maxSize = 1024 * 1024 * 10; // 10MB
return sourceSize <= maxSize;
};
})(typeof exports === 'undefined'? this['lib.image']={}: exports);
@loonison123
loonison123 / nodejs_serve_static_files.js
Last active August 29, 2015 14:08
Node.js serve static files
var express = require('express');
var app = express();
// Put static files in a public folder in the same directory as app.js
app.use(express.static(__dirname + '/public'));
app.set('port', 3000);
app.listen(app.get('port'), function () {
});
@loonison123
loonison123 / nodejs_allow_any_domain.js
Created October 31, 2014 02:12
Node.js CORS allow any domain
var express = require('express');
var app = express();
app.use(function (req, res, next) {
res.setHeader('Access-Control-Allow-Origin', req.headers.origin);
});
@loonison123
loonison123 / skydriveCommands_2.cmd
Created September 16, 2014 12:27
Sky drive commands
skydrive /start
@loonison123
loonison123 / skydriveCommands_1.cmd
Created September 16, 2014 12:13
Skydrive (OneDrive) commands
skydrive /shutdown
@loonison123
loonison123 / dupesInJsArrayNoComment.js
Created September 16, 2014 03:06
Find dupes in JS array no comments
var cached = {};
var allTags = ["red", "pants", "jeans", "red", "black", "jeans", "black", "pants", "jeans"];
var duplicatedTags = [];
for (var i=0;i<allTags.length; i++) {
if (cached[allTags[i]] == undefined) {
cached[allTags[i]] = allTags[i];
if (hasDup(allTags, allTags[i], allTags.length)) {
@loonison123
loonison123 / findDupesInJsArray.js
Last active August 29, 2015 14:06
Finding duplicates in JavaScript array of strings
// Some sample data
var image1 = { name: 'google1', ext: 'jpg', url: '/some/url.jpg', tags: ['red', 'pants', 'jeans'] };
var image2 = { name: 'apple5', ext: 'png', url: '/some/url.png', tags: ['red', 'black', 'jeans'] };
var image3 = { name: 'nexus7', ext: 'png', url: '/some/url.png', tags: ['black', 'pants', 'jeans', 'jeans'] };
// Tags for an image can have NO duplicate tags
image1.tags = _.uniq(image1.tags); image2.tags = _.uniq(image2.tags); image3.tags = _.uniq(image3.tags);
var images = [];
images.push(image1); images.push(image2); images.push(image3);