Skip to content

Instantly share code, notes, and snippets.

View oscarandreu's full-sized avatar
💭
At work

Óscar Andreu oscarandreu

💭
At work
View GitHub Profile
@oscarandreu
oscarandreu / Wordpress_plugins_article_1.php
Last active December 13, 2015 22:38
Blogger_Articles_Snippets
<?php
/*
Plugin Name: Plugin práctica 1
Plugin URI: http://www.whatsgoingon.es/
Version: 0.1
Author: scar Andreu Martínez
Description: Plugin como práctica docente.
License: GPL2
*/
/* Copyright 2012 Óscar Andreu (email : oscarandreu at gmail dot com)
<?php
/*
Plugin Name: Plugin práctica 2
Plugin URI: http://www.whatsgoingon.es/
Version: 0.1
Author: Óscar Andreu Martínez
Description: Plugin como práctica docente.
License: GPL2
*/
/* Copyright 2012 Óscar Andreu (email : oscarandreu at gmail dot com)
<?xml version="1.0" encoding="UTF-8"?>
<CodeSnippets xmlns="http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet">
<CodeSnippet Format="1.0.0">
<Header>
<Title>Class regions</Title>
<Author>Óscar Andreu</Author>
<Description>Build the structure of a new class.</Description>
<Shortcut>Class_Regions</Shortcut>
</Header>
<Snippet>
@oscarandreu
oscarandreu / javascript clean object.txt
Last active December 9, 2015 15:50
javascript clean object properties
/**
* Clear all the elements of an array/object without changing the reference, this must be used in objects binded
* instead of:
* obj = {}
* This assignments change the reference of the object (pointer) because they create a new object, with this method this can be avoided.
*/
$this.clearObject = function(obj){
var keys = Object.keys(obj);
for (var i = 0; i < keys.length; i++) {
delete obj[keys[i]];
CREATE TABLE #LINKED
(
SRV_NAME nvarchar(100)
,SRV_PROVIDERNAME nvarchar(100)
,SRV_PRODUCT nvarchar(100)
,SRV_DATASOURCE nvarchar(100)
,SRV_PROVIDERSTRING nvarchar(100)
,SRV_LOCATION nvarchar(100)
,SRV_CAT nvarchar(100)
CREATE TABLE #LINKED
(
SRV_NAME nvarchar(100)
,SRV_PROVIDERNAME nvarchar(100)
,SRV_PRODUCT nvarchar(100)
,SRV_DATASOURCE nvarchar(100)
,SRV_PROVIDERSTRING nvarchar(100)
,SRV_LOCATION nvarchar(100)
,SRV_CAT nvarchar(100)
CREATE TABLE #LINKED
(
SRV_NAME nvarchar(100)
,SRV_PROVIDERNAME nvarchar(100)
,SRV_PRODUCT nvarchar(100)
,SRV_DATASOURCE nvarchar(100)
,SRV_PROVIDERSTRING nvarchar(100)
,SRV_LOCATION nvarchar(100)
,SRV_CAT nvarchar(100)
)
CREATE TABLE #LINKED
(
SRV_NAME nvarchar(100)
,SRV_PROVIDERNAME nvarchar(100)
,SRV_PRODUCT nvarchar(100)
,SRV_DATASOURCE nvarchar(100)
,SRV_PROVIDERSTRING nvarchar(100)
,SRV_LOCATION nvarchar(100)
,SRV_CAT nvarchar(100)
)
@oscarandreu
oscarandreu / PowerShell clean directory when exceeds a given size
Created December 21, 2015 10:57
PowerShell clean directory when exceeds a given size
$folder = (dir 'C:\Resources\Directory' | ? {$_.PSIsContainer -eq $True})
$objFSO = New-Object -com Scripting.FileSystemObject
foreach ($folder in $folders){
if($folder.Name -match 'ImageResizerOutputCache'){
$dir = 'C:\Resources\Directory\'+ $folder.Name + '\*'
$size = $objFSO.GetFolder($folder.FullName).Size
$size /= 1024#1073741824#1048576#1024
if($size -gt 6000){
@oscarandreu
oscarandreu / edgesqlExample.js
Created February 1, 2016 10:32
edge sql example with connection string
var edge = require('edge');
var params = {
connectionString: "Data Source=xxx-yyy-zzz\instance;Initial Catalog=fooCatalog;Integrated Security=True",
source: "SELECT * FROM foobar"
};
var testQuery = edge.func("sql", params);
testQuery(null, function (error, result) {