dustincurrie

#!/bin/bash
# Delete all containers
docker rm $(docker ps -a -q)
# Delete all images
docker rmi $(docker images -q)

dustincurrie

SELECT TABLE_NAME, table_rows, data_length, index_length, 
round(((data_length + index_length) / 1024 / 1024),2) "Size in MB"
FROM information_schema.TABLES WHERE table_schema = "dbname";

dustincurrie

#!/bin/bash

# ################################################################################ Jenkins

# README:
#
# This script will install Jenkins (a continious integration server) on port 8081
#
HELP="

dustincurrie

drush sm | grep Enabled | gawk '{if (match($0,/\((.*)\)/,f)) print f[1]}' | sort

dustincurrie

#!/bin/bash


# Runs a command on all instances attached to a load balancer
# Elastic Load Balancer Tools from http://aws.amazon.com/developertools/2536

ELB=prod-axs-aeg
COMMAND='service varnish restart'
INSTANCES=$(elb-describe-instance-health $ELB | awk -F " " '{print $2}')

dustincurrie

<?php

$block = module_invoke('module_name', 'block', 'view', 'block_delta');

dustincurrie

<?php

function mymodule_block($op = 'list', $delta = 0, $edit = array()) {
  switch($op) {
    case 'list':
      $blocks['mymodule_quicktabs'] =  array('info' => t('[mymodule] Quicktabs'));
      return $blocks;
      break;
    case 'view':
      switch ($delta) {

dustincurrie

SELECT s.schema_name, CONCAT(IFNULL(ROUND(SUM(t.data_length)/1024/1024,2),0.00),"Mb") as Data_size,
CONCAT(IFNULL(ROUND(SUM(t.index_length)/1024/1024,2),0.00),"Mb") as Index_size,COUNT(table_name) total_tables 
FROM INFORMATION_SCHEMA.SCHEMATA s 
LEFT JOIN INFORMATION_SCHEMA.TABLES t ON s.schema_name = t.table_schema 
WHERE s.schema_name not in("mysql","information_schema","test") GROUP BY s.schema_name order by Data_size DESC;

dustincurrie

CREATE DATABASE databasename;
CREATE USER 'username'@'localhost' IDENTIFIED BY 'password'; 
GRANT ALL PRIVILEGES ON databasename.* TO 'username'@'localhost';
FLUSH PRIVILEGES;

dustincurrie

<?php

$array = preg_split('/\n/', trim(variable_get('string_variable', '')));
//add remove entries in the array
variable_set('string_variable', implode("\n", $array));