furtive

[Bash] On Slow bash for loop.

2008-02-08T19:49:35-08:00

It didn't make a difference performance wise but I really like the clarity of the cut command, I didn't know it existed. Thanks!

[Bash] Slow bash for loop.

2008-02-07T19:57:46-08:00

Here's a quick and dirty bash script that takes a file and looks for a particular line, then loops through those lines and splits the contents to get the 8th column and create an sql insert statement with it. I'm not looking to make it more generic, but the for loop is unbearably slow. How to improve it?

SCRIPT="gen_${1}.sql"
echo "--gen_${1}.sql" > $SCRIPT
typeset -i counter
counter=0

echo "Get all lines that start with D|4| (this may take a while)"
LINES=$(grep "D|4|" $1)

echo "Generate insert statements to $SCRIPT"
for LINE in $LINES; do
  REFNO=$(echo $LINE | awk '{split($0,a,"|");print a[8]}')
  echo "insert into CHEQUE (datecomptable, noreference) values (to_date('2007/11/30','YYYY/MM/DD'),'${REFNO}');" >> $SCRIPT
        counter=counter+1
done

echo "commit;" >> $SCRIPT
echo "${counter} records created in $SCRIPT"

[JavaScript] On Beautify JS Date to how recently the event occured.

2007-10-01T18:28:28-07:00

Wow guys, I'm impressed! Typefreak's does a great job in being efficient operationally while Andre's appears to do the best job at exploiting the Date object itself. I'm impressed!

[JavaScript] Beautify JS Date to how recently the event occured.

2007-10-01T09:55:17-07:00

This adds a .when() method to Date() object allowing you do things such as "Posted " + someDate.when() + " ago." and get output such as "Posted 10 minutes ago." I've refactored it twice but would like to see it even smaller.

/***
* Beautify date to how recent the event occurred compared to now.
* Some examples:  1 second, 4 hours, 10 days, 1 year.
*	Example:
*   var oneFiftyMin = new Date(new Date().getTime() - 60000 * 150);
*   alert(oneFiftyMin.when()); // will display "2 hours"
*
*  Handy for things like "Item posted " + someDate.when() + " ago."
*/
Date.prototype.when = function() {

	var diff = new Date().getTime() - this.getTime();
	var when; // our return value

	//TODO:  what if the time is in the future? 
	//if (diff < 0) throw new Error ("Date is in future, check timezone?";

	//one or more of these will be non-zero, but we only care about the biggest one (in scale of time)
  var secondsOld = Math.floor(diff / 1000);
  var minutesOld = Math.floor(diff / 60000);
  var hoursOld   = Math.floor(diff / 3600000);
  var daysOld    = Math.floor(diff / 86400000);
	var monthsOld  = Math.floor(diff / 2592000000);
	var yearsOld   = Math.floor(diff / (2592000000 * 12));  //your content is old!

	//determine which value is non-zero and assign appropriate text
  if (yearsOld > 0) {
		when = yearsOld + " year";
  }
  else if (monthsOld > 0) {
		when = monthsOld + " month";
  }
  else if (daysOld > 0) {
		when = daysOld + " day";
  }
  else if (hoursOld > 0) {
		when = hoursOld + " hour";
  }
  else if (minutesOld > 0) {
		when = minutesOld + " minute";
  }
  else {
		when = Math.round(diff /1000) + " second";
	}

	//add plural if necessary
	return (0 == when.indexOf("1 ")) ? when : when + "s";
}