Admun's Tech Journey

MySQL skips foreign key check

Wed, 1 May 2013 23:52:00 +0000

I keep forgeting this when need to flush the table in MySQL



SET foreign_key_checks = 0;

svn + meld...

Fri, 8 Feb 2013 20:09:03 +0000

The easiest way to setup code diff on command-line I can found.

I modify it a bit so it works on MacOS X.

First, you need to install meld from homebrew.

Then create a shell script "svn-diff-meld" in ~/bin:



#!/bin/sh

# SVN Diff Wrapper for Meld

# KOG 2008-02



# This line is only need if you use it on MacOS, assuming meld installed by homebrew 

export PYTHONPATH=/usr/local/lib/python2.7/site-packages



left="$6"

right="$7"



meld "$left" "$right"

add alais to do svn diff w/ meld:



alias svn-diff='svn diff --diff-cmd=/Users/me/bin/svn-diff-meld'

Getting IP address from string

Mon, 21 May 2012 22:32:19 +0000

I was in need for some shell magic to get the current NTP server IP address. After some Googling, found this:



ntpstat | grep -o '[0-9]\{1,3\}\.[0-9]\{1,3\}\.[0-9]\{1,3\}\.[0-9]\{1,3\}'

Pair up array key and value into string

Wed, 10 Aug 2011 16:40:37 +0000

Saw a snippet in PHP doc, and applies it to display model validation error in cakePHP:



    $this->Somemodel->create();

    if (!$this->Somemodel->save($data)) {

      $errors = array_map(create_function('$key, $value', 'return $key.":".$value;'), array_keys($this->Somemodel->validationErrors), array_values($this->Somemodel->validationErrors));

      echo ' - FAILED (rule: ' . implode(',', $errors) . ')';

    }

Cake Control, we have no model!

Wed, 10 Aug 2011 16:35:39 +0000

It's sort of obvious; To create a controller that has no model, simply:



        var $uses = array();

Finding out page load on IE6

Mon, 11 Jul 2011 12:22:28 +0000

Yeah, we shouldn't need this piece of code anymore... but the world is not ideal.



var isIE6 = /msie|MSIE 6/.test(navigator.userAgent);

With this, then I can conditional deal with IE6 throughout my javascript.

Reading Current URL from jQuery

Tue, 28 Jun 2011 15:29:10 +0000

I'm working on a piece of jQuery code that need to read a parameter from the current URL to perform work. First step is to read the URL. Here's how to do it:



url_path = window.location.pathname;

Dump all tables in MySL

Thu, 12 May 2011 13:20:48 +0000

Another trick I saw a while back using mysqldump. This come in handy when you want to drop everything in a database:



mysqldump -u[uesr] -p[passwd] --add-drop-table --no-data [database] | grep DROP | mysql -u[user] -p[passwd] [database]

Counting Days and Hours in PHP

Fri, 18 Mar 2011 17:26:41 +0000

Just come up with some code to calculate how many days + hours since a particular date/time.



            $time = time() - strtotime($created_at); // $created_at is a string of time i.e. Fri Mar 18 17:24:35 PDT 2011

            $days = floor($time/24/60/60);

            if ($days > 0) {

                $days_out = "$days day";

                $days_out .= $days > 1 ? 's' : '' .", ";

            }

            $hours = floor(($time % (24*60*60))/60/60);

            $hours_out = "{$hours} hour";

            $hours_out .= $hours > 1 ? 's' : '' . " ago";

            echo "{$days_out}{$hours_out}";

A simple web crawler in PHP

Tue, 21 Sep 2010 19:26:03 +0000

I was talking to a colleague about how to write a web crawler, and spend an hour to split out this simple piece of code as a proof of concept.




// a simple web crawler example

// v1.1

//



$toplink = "http://edmondhui.homeip.net/blog";

$depth = 2;



walkIt($toplink,1);



function walkIt($link, $level) {

	global $depth;

	if ($level <= $depth) {

		$content = file($link);

		if ($content != false) {

			$content = html_entity_decode(implode($content));

			//

			// IF NEED, PAGE CONTENTS PROCESS AND SAVE TO DB HERE

			//

			preg_match_all("/href=\".*?\"/i", $content, $matches);

			$matches = array_unique($matches[0]);

			foreach ($matches as $idx => $url) {

				$url = substr($url, 6, -1);

				if (strstr($url, "http://") != false) {

					for ($i = 0; $i < $level; $i++) { echo '  '; }

					echo "$url\n";

					walkIt($url, $level+1);

				}

			}

		} else {

			echo "failed to crawle - $link\n";

		}

	}

}

?>

Next exercise, write this in python!