wchiquito’s gists

wchiquito / gist:880dea085a30b92d525fa98bb44a35aa

Created April 25, 2017 12:12

	-- Source: https://mysqlstepbystep.com/2017/04/24/handy-stored-procedure-for-regular-dba-tasks/

	DROP PROCEDURE IF EXISTS `reorganize_tables`;

	DELIMITER //

	CREATE PROCEDURE `reorganize_tables` (`db_name` VARCHAR(64))
	BEGIN
	DECLARE `v_finished` BOOL DEFAULT FALSE;
	DECLARE `tbl_name` VARCHAR(64) DEFAULT '';

wchiquito / gist:7021866

Last active December 25, 2015 18:39

Split a string using common_schema and insert the tokens in a table.

	/* Need to install common_schema - code.google.com/p/common-schema/ */

	/* Procedure structure for procedure `explode1` */

	/!50003 DROP PROCEDURE IF EXISTS `explode1` /;

	DELIMITER $$

	/*!50003 CREATE PROCEDURE `explode1`(str varchar(65500), delim VARCHAR(255))
	BEGIN

wchiquito / gist:6105659

Created July 29, 2013 16:39

	/* CODE FOR DEMONSTRATION PURPOSES */
	function getAvailableTags() {
	var ss = SpreadsheetApp.openById([SS-ID]);
	var s = ss.getSheetByName([S-NAME]);
	var data = s.getDataRange().getValues();
	var headers = 1; // number of header rows to skip at top
	var tagColumn = 2; // column # (0-based) containing tag

	var availableTags = [], availableTag;
	for (var row = headers, len = data.length; row < len; row++) {

wchiquito / gist:5965451

Last active December 19, 2015 13:58

[Google Apps Script] Issue 2969: On Submit trigger is not working when form response is edited - https://code.google.com/p/google-apps-script-issues/issues/detail?id=2969

	/*
	In the Form, create new trigger:
	Run: onFormSubmit
	Events: From form
	On form submit

	Runs for new / edit responses
	*/

	/* CODE FOR DEMONSTRATION PURPOSES */

wchiquito / gist:5932870

Last active April 27, 2023 03:50

[Google Apps Script] Move files

	/* CODE FOR DEMONSTRATION PURPOSES */

	function getFileById_(idFile) {
	return DocsList.getFileById(idFile);
	}

	function getFolderById_(idFolder) {
	return DocsList.getFolderById(idFolder);
	}

wchiquito / gist:1163036

Created August 22, 2011 17:57

v.1/Ejercicio 4/Reunión #4/Grupo de Estudio JavaScript

	var _STRING = "string", _ARRAY = "array", _HELLO = "Hola", _SPACE = " ";

	function toType(obj) {
	//return ({}).toString.call(obj).match(/\s([a-z\|A-Z]+)/)[1].toLowerCase();

	//Expresión regular mejorada
	//return ({}).toString.call(obj).match(/\s([a-zA-Z]+)/)[1].toLowerCase();

	// Usando el "slice"
	return ({}).toString.call(obj).slice(8,-1).toLowerCase();

wchiquito / arrayConcatenator

Created August 13, 2011 23:27

v.2/Ejercicio 1/Reunión #3/Grupo de Estudio JavaScript

	/*
	.isArray
	Implemented in: JavaScript 1.8.5
	ECMAScript Edition: ECMAScript 5th Edition
	MDN Docs http://goo.gl/AjneU
	*/
	/* From MDN Docs http://goo.gl/AjneU */
	if(!Array.isArray) {
	Array.isArray = function (arg) {
	return Object.prototype.toString.call(arg) == '[object Array]';

wchiquito / arrayConcatenator

Created August 13, 2011 23:27

v.1/Ejercicio 1/Reunión #3/Grupo de Estudio JavaScript

	/*
	.isArray
	Implemented in: JavaScript 1.8.5
	ECMAScript Edition: ECMAScript 5th Edition
	MDN Docs http://goo.gl/AjneU
	*/
	/* From MDN Docs http://goo.gl/AjneU */
	if(!Array.isArray) {
	Array.isArray = function (arg) {
	return Object.prototype.toString.call(arg) == '[object Array]';