mapkyca

Useful shell commands

Shell

• Find which directories are the disk hogs

  du --max-depth=1 -h | sort -h

mapkyca

-- The table
CREATE TABLE `my_table` (
  field1 varchar(50),

  ....

  createdTime datetime NOT NULL, -- NOT NULL is important to trigger the trigger
  modifiedTime TIMESTAMP -- Timestamps automatically update on insert
);

mapkyca

JQuery Gotchas

Here are some notes when hacking on jquery, compiled over time.

JQuery Dialogs

• If your browser scrolls to the top of the screen when the dialog opens and you're opening it from an onclick event on an Anchor tag, make sure you return false in the click event.

mapkyca

Some example paypal response for reference:

array (
  'test_ipn' => '1',
  'payment_type' => 'instant',
  'payment_date' => '03:46:59 Jul 19, 2012 PDT',
  'payment_status' => 'Completed',
  'address_status' => 'confirmed',
  'payer_status' => 'unverified',
  'first_name' => 'John',

mapkyca

sed -r "s/\x1B\[([0-9]{1,3}((;[0-9]{1,3})*)?)?[m|K]//g"

mapkyca

// Quick regexp to remove non-alpha chars from a string. Very handy
$string = preg_replace("/[^a-zA-Z0-9\s]/", "", $string);

mapkyca

// Quick regexp to remove non-alpha chars from a string. Very handy
$string = preg_replace("/[^a-zA-Z0-9\s]/", "", $string);

mapkyca

/*
 * To correctly set the doc name of a java App in OSX, use....
 */

System.setProperty("com.apple.mrj.application.apple.menu.about.name", "Foo");
    

mapkyca

DATE -> SECONDS
---------------

(CELL - DATE (1970,1,1))*86400


TIME -> SECONDS
---------------

mapkyca

Prep:

- apt-get update && apt-get upgrade && apt-get dist-upgrade
- Check for holds
    dpkg --audit 
    dpkg --get-selections | grep hold
    aptitude & press "g"
- Edit sources.list s/lenny/squeeze
- apt-get update NOTE: Debian docs say don't use aptitude to upgrade.
- apt-get upgrade to to a safe-upgrade