fizzvr

SELECT orders.customerid, 
       orders.transactiondate, 
       orders.transactionamount, 
       cohorts.cohortdate 
FROM   orders 
       JOIN (SELECT customerid, 
                    Min(transactiondate) AS cohortDate 
             FROM   orders 
             GROUP  BY customerid) AS cohorts 
         ON orders.customerid = cohorts.customerid; 

fizzvr

#############################################
# Push de la rama actual
git push origin $rama_actual

#############################################
# Volver a un commit anterior, descartando los cambios
git reset --HARD $SHA1

#############################################
# Ver y descargar Ramas remotas

fizzvr

Moving from jQuery

Events

// jQuery
$(document).ready(function() {
  // code
})

fizzvr

// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console

fizzvr

// Load the TCP Library
net = require('net');

// Keep track of the chat clients
var clients = [];

// Start a TCP Server
net.createServer(function (socket) {

  // Identify this client

fizzvr

DocPad: Sitemap Genereation

Generates a sitemap.txt file your website. To use add the contents of the docpad.coffee file of this gist into your docpad configuration file.

Note: There is now the Sitemap Plugin which generates a proper sitemap.xml file for you automatically instead of the basic sitemap.txt file this gist creates.

fizzvr

# Define our Configuration
docpadConfig =

	# Define our own Collections
	collections:

		# Posts
		# Anything outputted to the posts directory can be considered a post
		# Sort the posts by newest first
		# And set their layout to `post` automatically if it isn't already set

fizzvr

DocPad: Absolute URL Helper

Uses a docpad configuration file to specify template data that we can use in our document to generate absolute urls.

fizzvr

DocPad: Localising Dates

1. Install Moment via npm install --save moment

2. Add it and a template helper to your docpad configuration file

3. Use the template helper in your app

Discussion about localisation within DocPad.

fizzvr

# Define our Configuration
docpadConfig =

	# Define our own Collections
	collections:

		# Posts
		# Anything outputted to the posts directory can be considered a post
		# Sort the posts by newest first
		# And set their layout to `post` automatically if it isn't already set