Alfredo Torre alfred-dub

alfred-dub / version_natural_sorting_mysql.sql

Last active August 15, 2017 14:16

Natural ordering of migrations' versions using MySQL and Postgre

	SELECT
	SUBSTRING_INDEX(number, '.', 1) AS FIRST_INT,
	SUBSTRING_INDEX(SUBSTRING_INDEX(number, '.', 2), '.', -1) AS SECOND_INT,
	SUBSTRING_INDEX(number, '.', -1) AS THIRD_INT,
	number as VERSION,
	description as TITLE
	FROM _version
	ORDER BY
	LENGTH(SUBSTRING_INDEX(number, '.', 1)) DESC,
	SUBSTRING_INDEX(number, '.', 1) DESC,

alfred-dub / useful_phalcon_snippets.php

Last active April 4, 2017 11:03

Useful Phalcon snippets

	<?php
	// @see http://stackoverflow.com/a/28769763/1977778
	$queryBuilder = $this->getDI()->getModelsManager()
	->createBuilder()
	->columns(['p.id','participants.*'])
	->addFrom('Entity\Projects', 'p')
	->leftJoin('Entity\Participants', 'participants.projectId = p.id', 'participants')
	->groupBy('p.id, participants.id')
	->orderBy('p.id ASC');

alfred-dub / spacemacs-cheatsheet.txt

Created March 21, 2017 14:15 — forked from davoclavo/spacemacs-cheatsheet.md

Spacemacs cheatsheet

	`emacs --daemon` to run in the background.
	`emacsclient.emacs24 <filename/dirname>` to open in terminal

	NOTE: "M-m and SPC can be used interchangeably".

	* Undo - `C-/`
	* Redo - `C-?`
	* Change case: 1. Camel Case : `M-c`
	2. Upper Case : `M-u`
	3. Lower Case : `M-l`