Vorleak Chy

Wireless Not Working in Ubuntu 11.04

2011-08-28T20:30:00+07:00

My ubuntu 11.04 haven't upgraded long time after first installation, I don't want to click upgrade either. This weekend I accidently clicked "Upgrade" and after my laptop restarted then wireless were gone, I was so sure that there were wireless in the office but the problem was that it didn't detect wireless at all.

I'm using Dell Inspiron N4010 which uses Broadcom Wireless Adapter "BCM4313 802.11b/g/n Wireless LAN Controller", you can also check your network adapter in terminal by typing: sudo lshw -C network.

To fix this terrible problem I need to do in the following:

Open the "Synaptic Package Manager" and search for bcm-kernel-source then uninstall this package
Make sure that the firmware-b43-installer and the b43-fwcutter packages are installed
Type in the terminal:

cat /etc/modprobe.d/* | egrep '8180|acx|at76|ath|b43|bcm|CX|eth|ipw|irmware|isl|lbtf|orinoco|ndiswrapper|NPE|p54|prism|rtl|rt2|rt3|rt6|rt7|witch|wl'

(you may want to copy this) and see if the term blacklist bcm43xx is there
If it is, type cd /etc/modprobe.d/ and then sudo gedit blacklist.conf, put a # in front of the line: blacklist bcm43xx then save the file
reboot

This worked fine for me.

For more information: http://computerandu.wordpress.com/2011/05/04/how-to-solve-no-wireless-networks-in-ubuntu-11-04/

Remove All Ruby Gems

2011-08-27T17:29:00+07:00

In the early morning I try to clean up all of my ruby gems and use rvm gemset to create for multiple projects that make me easily to see which gems are using in which projects and keep it organized.

So to remove all ruby gems I run this code below:

gem list | cut -d" " -f1 | xargs gem uninstall -aIx

For more information: http://geekystuff.net/2009/01/14/remove-all-ruby-gems/

WARNING: Global Access to Rake DSL Methods Is Deprecated in Rails

2011-08-27T00:03:00+07:00

I've run rake task in my rails app and I got an error message:

WARNING: Global access to Rake DSL methods is deprecated.  Please include
    ...  Rake::DSL into classes and modules which use the Rake DSL methods.

Because of the new Rake version (0.9+). The quick fix is to downgrade to Rake 0.8.7, but you can also add this little snippet to your Rakefile above the YourApplicationName::Application.load_tasks

For more information: http://benwoodall.com/2011/06/rails-global-access-to-rake-dsl-methods-is-deprecated/

Show SQL Statement in Rails Console

2011-08-26T23:36:00+07:00

I was working on complex queries using ActiveRecord in rails console, it's so difficult to get it right because I didn't see the SQL statement. Follow the step below I can get it working in my rails app.

Rails 3.0

Rails 2.3

For more detail http://chamnapchhorn.blogspot.com/2009/10/script-console-tricks.html.

Switch My Blog to Octopress

2011-08-26T22:45:00+07:00

As you might know I haven't blogged about a year, I've been thinking how I could getting started blogging again with two reasons that I want to keep up-to-date about what I have learned and share to other geeks. I've been using WordPress for my blog, which is powerful enough, but I don't want to maintain with PHP codes. A few days ago I found and switched to Octopress.

Follow Octopress Documentation is good enough to start swithcing, but if you are using WordPress and want to keep old posts you can read more http://zanshin.net/2011/08/11/switching-to-octopress/.

VirtualBox: No IP Address After Copying VDI

2010-05-18T20:52:00+07:00

After copying the virtual disk (.vdi file) from one machine to another, create a new virtual machine using the copied .vdi as a virtual disk and boot up then suddenly you don’t get an IP from DHCP.

What you can do to solve this problem now just:

Open the file /etc/udev/rules.d/70-persistent-net.rules
Delete all the contents and save it
Reboot the virtual machine

If you still have this problem then try to change eth… to eth0 in the file /etc/network/interfaces

VirtualBox: Change UUID of VDI

2010-05-17T23:11:00+07:00

I use VirtualBox regularly. Recently I copy the image of Virtual Disk (.vdi file) is a convenient way of duplicate the disk, in case I want to avoid reinstalling an operating system from scratch.

By adding the copy in the Virtual Media Manager, I got an error like this screenshot below because of UUID already exists.

In this case, I have to do the following

VBoxManage internalcommands sethduuid disk2.vdi

Since the old UUID is replaced with a new one, I can now add and use the virtual disk.

Polymorphic Associations in Ruby on Rails

2009-10-16T19:12:00+07:00

You might have instances where the associations could be with multiple models. For example, if you have a Picture model that can be associated with either a Student model or an Employee model. In this case, you really want to be able to call @picture.imageable to get the image. This is where polymorphic associations come in.

class Picture < ActiveRecord::Base belongs_to :imageable, :polymorphic => true end class Student < ActiveRecord::Base has_many :pictures, :as => :imageable end class Employee < ActiveRecord::Base has_many :pictures, :as => :imageable end

You can think of a polymorphic belongs_to declaration as setting up an interface that any other model can use. You can also retrieve a collection of pictures: @student.pictures or @employee.pictures from instances of Student or Employee model.

To make this work, you need to declare both a foreign key column and a type column in the model that declares the polymorphic interface:

class CreatePictures < ActiveRecord::Migration def self.up create_table :pictures do |t| t.string :name t.integer :imageable_id t.string :imageable_type t.timestamps end end def self.down drop_table :pictures end end

Finally, you can read more on the documentation written by Rails team.

Using UUID as Primary Key in Ruby on Rails

2009-10-14T19:41:00+07:00

You may be working on multi-master database model which required to use UUID sometime because of using auto incrementing integer primary key just is not good enough.

So, you want to replace the default integer-based primary keys in your model with a UUID.

Now you need to disable the default id column by setting :id => false and create a primary key named uuid instead

You need to create UUID itself for the next step. Because of most databases do not support UUID out of the box so you have to do in rails application.

Install the uuidtools gem

sudo gem install uuidtools

Then go into your rails application and create uuid_helper.rb in your lib directory

In the Product model you need to set the name of the primary key column and include the module UUIDHelper

Now, you have the uuid field is automatically filled with a Universally Unique Identifier whenever you save a new Product object.

Introduction to Refactoring

2009-10-07T21:01:00+07:00

I have presented about “Introduction to Refactoring” with Mr. Dane at BarCamp PP2. What interesting for me was “Coder Camp” which got more helps from Mr. Sokun to make it up without preparation, especially the room was full.

You can get more details from Share Vision Team. Thanks to the team that spent almost two days to help with presentations and introduced many people to know about Share Vision Team at booth.

Introduction to Refactoring

View more presentations from Vorleak Chy

Installing GeoServer on Ubuntu

2009-08-28T21:15:00+07:00

Recently, I install GeoServer 1.7.6 on Ubuntu 9.04. I would like to share some information with everybody what I have configured on my local PC.

As far as I follow the installation instruction of GeoServer documentation for Linux I get the error message “The JAVA_HOME environment variable is not defined This environment variable is needed to run this program” when I try to startup server by typing sudo sh startup.sh. It means that it doesn’t find the default path for JAVA_HOME so you need to setup.

Setting up JAVA_HOME you need to lookup the Java program path in your PC. In my local PC is /usr/lib/jvm/java-6-sun.

Finally you also setup GEOSERVER_HOME is where GeoServer folder stores on your local PC.

Anyway you can copy the codes below into startup.sh, shutdown.sh files in /geoserver/bin folder, put on the top and replace the path.

JAVA_HOME="/usr/lib/jvm/java-6-sun";
GEOSERVER_HOME="/home/administrator/software/geoserver";

Strategy Design Pattern

2008-11-14T21:40:00+07:00

If you have the algorithms with conditional statements in the client code it will be messy. The Strategy pattern moves an algorithm from the client code to a separate class. A program that requires a particular service or function and that has several ways of carrying out that function is a candidate for the Strategy pattern. Programs choose between these algorithms based on computational efficiency or user choice. There can be any number of strategies, more can be added, and any of them can be changed at any time. One of the dominant strategies of object-oriented design is the “open-closed principle”.

There are a number of cases in programs where we would like to do the same thing in several different ways. Here is a list that can be strategy:

Compress files using different algorithms
Save files in different formats
Use different link-breaking strategies to display text data
Capture video data using different compression schemes
Plot the same data in different formats: line, graph, bar chart, or pie chart

Let’s consider a simplified sorting an array using quick sort or bubble sort which a client will choose as an algorithm to sort elements in array. Here is an example below I have to do now in both C# and JavaScript:

C# Codes

There are QucikSort and BubbleSort as concrete classes will implement an interface because they have the same method, the only different is an algorithm.

using System; namespace Patterns.Strategy { public interface ISortStrategy { void Sort(string[] arr); } public class QuickSort : ISortStrategy { public void Sort(string[] arr) { Console.Write(string.Format("QuickSort array contains {0} elements", arr.Length)); } } public class BubleSort : ISortStrategy { public void Sort(string[] arr) { Console.Write(string.Format("BubleSort array contains {0} elements", arr.Length)); } } public class SortableArray { private readonly ISortStrategy sortStrategy; public SortableArray(ISortStrategy sortStrategy) { this.sortStrategy = sortStrategy; } public void SortArray(string[] arr) { sortStrategy.Sort(arr); } } }

Here is a client code will choose which algorithm is needed to sort an array.

using System; namespace Patterns.Strategy { internal class Program { private static void Main(string[] args) { var array = new[] {"a", "b", "c", "d", "e"}; var sortableArray = new SortableArray(new QuickSort()); sortableArray.SortArray(array); Console.Read(); } } }

JavaScript Codes

If you meet this problem and need to solve it please go to your application and do the code refactorings which is now the ReSharper tool add-in to Visual Studio is very powerful to do this and much more. Doesn’t it?

NAnt Task With Red-Gate SQL Compare

2008-11-11T00:10:00+07:00

It can be an easy way to do if you have a database with schema changes. You have to convert a database to scripts so that you can commit to source control by comparing script files. Or you get update from source control as scripts and synchronize to your local database.

Most code development these days involves using a “local development” model. In other words, the code is created on the developers’ local machines, and the shared source control database is the integration point and provides the mechanism for sharing new code. The automated delivery processes then provide the isolated continuous integration process as already specified. Database development is not necessarily handled in the same way, but it can be. The actual model used affects the requirements for handling database integration.

Red-Gate have a very good product called SQL Compare which can compare two database versions and produce a script to convert one version to the other and a SQL Toolkit that allows you to automate the process.

NAnt task help you a lot of saving time instead of doing manual work everyday by creating custom task for your own which I include in here.

Here is an example of the configuration:

This is a build file which will load SyncNAntTask.dll as a custom task and have two databases need to synchronize with script files.

<?xml version="1.0" ?> <project name="SyncDatabase"> <property name="schemaRoot.dir" value="..\database\schema\" /> <property name="dbServer" value="localhost" /> <property name="dbUserId" value="sa" /> <property name="dbPassword" value="123" /> <loadtasks assembly="..\src\SyncNAntTask\bin\Debug\SyncNAntTask.dll"/> <syncDatabase> <databases> <database folder="${schemaRoot.dir}db1" server="${dbServer}" name="db1" userId="${dbUserId}" password="${dbPassword}" /> <database folder="${schemaRoot.dir}db2" server="${dbServer}" name="db2" userId="${dbUserId}" password="${dbPassword}" /> </databases> </syncDatabase> </project>

There are three .cs files for the SyncNAntTask.dll which I have to separate.

It’s quite simple for database element with five attributes.

<!DOCTYPE html> <html> <head> <meta charset='utf-8'> <meta http-equiv="X-UA-Compatible" content="chrome=1"> <script type="text/javascript">var NREUMQ=[];NREUMQ.push(["mark","firstbyte",new Date().getTime()]);</script> <title>404 - GitHub</title> <link rel="search" type="application/opensearchdescription+xml" href="/opensearch.xml" title="GitHub" /> <link rel="fluid-icon" href="https://github.com/fluidicon.png" title="GitHub" /> <meta content="authenticity_token" name="csrf-param" /> <meta name="csrf-token" /> <link href="https://a248.e.akamai.net/assets.github.com/4ab42aa6ea0cfc9a0079aaea26be62ab36a62793/stylesheets/bundle_github.css" media="screen" rel="stylesheet" type="text/css" /> <script type="text/javascript"> if (typeof console == "undefined" || typeof console.log == "undefined") console = { log: function() {} } </script> <script src="https://a248.e.akamai.net/assets.github.com/javascripts/jquery/jquery-1.6.1.min.js" type="text/javascript"></script> <script type="text/javascript" charset="utf-8"> var GitHub = { assetHost: 'https://a248.e.akamai.net/assets.github.com' } var github_user = null </script> <script src="https://a248.e.akamai.net/assets.github.com/c95ebfaaef8d0756f7ecff3aad37542991891eb6/javascripts/bundle_github.js" type="text/javascript"></script> <script type="text/javascript" charset="utf-8"> if (GitHub.spy) { GitHub.spy({repo: ""}); } </script> <script type="text/javascript"> var _gaq = _gaq || []; _gaq.push(['_setAccount', 'UA-3769691-2']); _gaq.push(['_setDomainName', 'none']); _gaq.push(['_trackPageview']); _gaq.push(['_trackPageLoadTime']); (function() { var ga = document.createElement('script'); ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js'; ga.setAttribute('async', 'true'); document.documentElement.firstChild.appendChild(ga); })(); </script> </head> <body class="logged_out env-production"> <div class="" id="main"> <div id="header" class="true"> <a class="logo boring" href="https://github.com"> <img alt="github" class="default" height="45" src="https://a248.e.akamai.net/assets.github.com/images/modules/header/logov6.png" />  <img alt="github" class="hover" height="45" src="https://a248.e.akamai.net/assets.github.com/images/modules/header/logov6-hover.png" />  </a> <div class="topsearch">  <ul class="nav logged_out"> <li class="pricing"><a href="https://github.com/plans">Pricing and Signup</a></li> <li class="explore"><a href="https://github.com/explore">Explore GitHub</a></li> <li class="features"><a href="https://github.com/features">Features</a></li> <li class="blog"><a href="https://github.com/blog">Blog</a></li> <li class="login"><a href="https://github.com/login?return_to=%2Fgist%2F1168596%2FDatabaseInfo.cs">Login</a></li> </ul> </div> </div> <div class="site"> <style type="text/css"> * { margin: 0px; padding: 0px; } #parallax_illustration { display:block; width: 940px; height: 375px; margin: 20px 0 0 20px; position: relative; overflow: hidden; } #parallax_illustration #parallax_error_text { position: absolute; top: 72px; left: 72px; z-index: 10; } #parallax_illustration #parallax_octocat { position: absolute; top: 94px; left: 356px; z-index: 9; } #parallax_illustration #parallax_speeder { position: absolute; top: 150px; left: 432px; z-index: 8; } #parallax_illustration #parallax_octocatshadow { position: absolute; top: 297px; left: 371px; z-index: 7; } #parallax_illustration #parallax_speedershadow { position: absolute; top: 263px; left: 442px; z-index: 6; } #parallax_illustration #parallax_building_1 { position: absolute; top: 73px; left: 467px; z-index: 5; } #parallax_illustration #parallax_building_2 { position: absolute; top: 113px; left: 762px; z-index: 4; } #parallax_illustration #parallax_bg { position: absolute; top: -20px; left: -20px; z-index: 1; } </style> <div id="parallax_illustration"> <img alt="404 | “This is not the web page you are looking for”" height="249" id="parallax_error_text" src="https://a248.e.akamai.net/assets.github.com/images/modules/404/parallax_errortext.png" width="271" /> <img alt="Octobi Wan Catnobi" height="230" id="parallax_octocat" src="https://a248.e.akamai.net/assets.github.com/images/modules/404/parallax_octocat.png" width="188" /> <img alt="land speeder" height="156" id="parallax_speeder" src="https://a248.e.akamai.net/assets.github.com/images/modules/404/parallax_speeder.png" width="440" /> <img alt="Octobi Wan Catnobi's shadow" height="49" id="parallax_octocatshadow" src="https://a248.e.akamai.net/assets.github.com/images/modules/404/parallax_octocatshadow.png" width="166" /> <img alt="land speeder's shadow" height="75" id="parallax_speedershadow" src="https://a248.e.akamai.net/assets.github.com/images/modules/404/parallax_speedershadow.png" width="430" /> <img alt="building" height="123" id="parallax_building_1" src="https://a248.e.akamai.net/assets.github.com/images/modules/404/parallax_building_1.png" width="304" /> <img alt="building" height="50" id="parallax_building_2" src="https://a248.e.akamai.net/assets.github.com/images/modules/404/parallax_building_2.png" width="116" /> <img alt="building" height="415" id="parallax_bg" src="https://a248.e.akamai.net/assets.github.com/images/modules/404/parallax_bg.jpg" width="940" /> </div> <script type="text/javascript"> $(document).ready(function () { $('#parallax_error_text').plaxify({"xRange":20,"yRange":10}) $('#parallax_octocat').plaxify({"xRange":10,"yRange":10}) $('#parallax_octocatshadow').plaxify({"xRange":10,"yRange":10}) $('#parallax_speeder').plaxify({"xRange":10,"yRange":10}) $('#parallax_speedershadow').plaxify({"xRange":10,"yRange":10}) $('#parallax_building_1').plaxify({"xRange":50,"yRange":20,"invert":true}) $('#parallax_building_2').plaxify({"xRange":75,"yRange":30,"invert":true}) $('#parallax_bg').plaxify({"xRange":0,"yRange":40,"invert":true}) }) $.plax.enable() </script> <script type="text/javascript"> if (typeof _gaq !== "undefined") _gaq.push(['_trackPageview', '/404.html?page=' + document.location.pathname + document.location.search + '&from=' + document.referrer]) </script> </div> </div>  <div id="footer" > <div class="upper_footer"> <div class="site" class="clearfix">  <![if !IE]><h4 id="blacktocat">GitHub Links</h4><![endif]> <ul class="footer_nav"> <h4>GitHub</h4> <li><a href="https://github.com/about">About</a></li> <li><a href="https://github.com/blog">Blog</a></li> <li><a href="https://github.com/contact">Contact & Support</a></li> <li><a href="https://github.com/training">Training</a></li> <li><a href="http://status.github.com/">Site Status</a></li> </ul> <ul class="footer_nav"> <h4>Tools</h4> <li><a href="http://mac.github.com/">GitHub for Mac</a></li> <li><a href="http://mobile.github.com/">GitHub:Issues for iPhone</a></li> <li><a href="https://gist.github.com">Gist: Code Snippets</a></li> <li><a href="http://fi.github.com/">Enterprise Install</a></li> <li><a href="http://jobs.github.com/">Job Board</a></li> </ul> <ul class="footer_nav"> <h4>Extras</h4> <li><a href="http://shop.github.com/">GitHub Shop</a></li> <li><a href="http://octodex.github.com/">The Octodex</a></li> </ul> <ul class="footer_nav"> <h4>Documentation</h4> <li><a href="http://help.github.com/">GitHub Help</a></li> <li><a href="http://developer.github.com/">Developer API</a></li> <li><a href="http://github.github.com/github-flavored-markdown/">GitHub Flavored Markdown</a></li> <li><a href="http://pages.github.com/">GitHub Pages</a></li> </ul> </div> </div> <div class="lower_footer"> <div class="site" class="clearfix">  <![if !IE]><div id="legal"><![endif]> <ul> <li><a href="https://github.com/site/terms">Terms of Service</a></li> <li><a href="https://github.com/site/privacy">Privacy</a></li> <li><a href="https://github.com/security">Security</a></li> </ul> <p>© 2011 <span id="_rrt" title="0.16966s from fe5.rs.github.com">GitHub</span> Inc. All rights reserved.</p> </div> <div class="sponsor"> <a href="http://www.rackspace.com" class="logo"> <img alt="Dedicated Server" height="36" src="https://a248.e.akamai.net/assets.github.com/images/modules/footer/rackspace_logo.png?v2" width="38" /> </a> Powered by the <a href="http://www.rackspace.com ">Dedicated Servers</a> and<br/> <a href="http://www.rackspacecloud.com">Cloud Computing</a> of Rackspace Hosting<span>®</span> </div> </div> </div> </div> <div id="keyboard_shortcuts_pane" class="instapaper_ignore readability-extra" style="display:none"> <h2>Keyboard Shortcuts <small><a href="#" class="js-see-all-keyboard-shortcuts">(see all)</a></small></h2> <div class="columns threecols"> <div class="column first"> <h3>Site wide shortcuts</h3> <dl class="keyboard-mappings"> <dt>s</dt> <dd>Focus site search</dd> </dl> <dl class="keyboard-mappings"> <dt>?</dt> <dd>Bring up this help dialog</dd> </dl> </div> <div class="column middle" style='display:none'> <h3>Commit list</h3> <dl class="keyboard-mappings"> <dt>j</dt> <dd>Move selected down</dd> </dl> <dl class="keyboard-mappings"> <dt>k</dt> <dd>Move selected up</dd> </dl> <dl class="keyboard-mappings"> <dt>t</dt> <dd>Open tree</dd> </dl> <dl class="keyboard-mappings"> <dt>p</dt> <dd>Open parent</dd> </dl> <dl class="keyboard-mappings"> <dt>c <em>or</em> o <em>or</em> enter</dt> <dd>Open commit</dd> </dl> <dl class="keyboard-mappings"> <dt>y</dt> <dd>Expand URL to its canonical form</dd> </dl> </div> <div class="column last" style='display:none'> <h3>Pull request list</h3> <dl class="keyboard-mappings"> <dt>j</dt> <dd>Move selected down</dd> </dl> <dl class="keyboard-mappings"> <dt>k</dt> <dd>Move selected up</dd> </dl> <dl class="keyboard-mappings"> <dt>o <em>or</em> enter</dt> <dd>Open issue</dd> </dl> </div> </div> <div style='display:none'> <div class="rule"></div> <h3>Issues</h3> <div class="columns threecols"> <div class="column first"> <dl class="keyboard-mappings"> <dt>j</dt> <dd>Move selected down</dd> </dl> <dl class="keyboard-mappings"> <dt>k</dt> <dd>Move selected up</dd> </dl> <dl class="keyboard-mappings"> <dt>x</dt> <dd>Toggle select target</dd> </dl> <dl class="keyboard-mappings"> <dt>o <em>or</em> enter</dt> <dd>Open issue</dd> </dl> </div> <div class="column middle"> <dl class="keyboard-mappings"> <dt>I</dt> <dd>Mark selected as read</dd> </dl> <dl class="keyboard-mappings"> <dt>U</dt> <dd>Mark selected as unread</dd> </dl> <dl class="keyboard-mappings"> <dt>e</dt> <dd>Close selected</dd> </dl> <dl class="keyboard-mappings"> <dt>y</dt> <dd>Remove selected from view</dd> </dl> </div> <div class="column last"> <dl class="keyboard-mappings"> <dt>c</dt> <dd>Create issue</dd> </dl> <dl class="keyboard-mappings"> <dt>l</dt> <dd>Create label</dd> </dl> <dl class="keyboard-mappings"> <dt>i</dt> <dd>Back to inbox</dd> </dl> <dl class="keyboard-mappings"> <dt>u</dt> <dd>Back to issues</dd> </dl> <dl class="keyboard-mappings"> <dt>/</dt> <dd>Focus issues search</dd> </dl> </div> </div> </div> <div style='display:none'> <div class="rule"></div> <h3>Network Graph</h3> <div class="columns equacols"> <div class="column first"> <dl class="keyboard-mappings"> <dt><span class="badmono">←</span> <em>or</em> h</dt> <dd>Scroll left</dd> </dl> <dl class="keyboard-mappings"> <dt><span class="badmono">→</span> <em>or</em> l</dt> <dd>Scroll right</dd> </dl> <dl class="keyboard-mappings"> <dt><span class="badmono">↑</span> <em>or</em> k</dt> <dd>Scroll up</dd> </dl> <dl class="keyboard-mappings"> <dt><span class="badmono">↓</span> <em>or</em> j</dt> <dd>Scroll down</dd> </dl> <dl class="keyboard-mappings"> <dt>t</dt> <dd>Toggle visibility of head labels</dd> </dl> </div> <div class="column last"> <dl class="keyboard-mappings"> <dt>shift <span class="badmono">←</span> <em>or</em> shift h</dt> <dd>Scroll all the way left</dd> </dl> <dl class="keyboard-mappings"> <dt>shift <span class="badmono">→</span> <em>or</em> shift l</dt> <dd>Scroll all the way right</dd> </dl> <dl class="keyboard-mappings"> <dt>shift <span class="badmono">↑</span> <em>or</em> shift k</dt> <dd>Scroll all the way up</dd> </dl> <dl class="keyboard-mappings"> <dt>shift <span class="badmono">↓</span> <em>or</em> shift j</dt> <dd>Scroll all the way down</dd> </dl> </div> </div> </div> <div style='display:none'> <div class="rule"></div> <div class="columns threecols"> <div class="column first" style='display:none'> <h3>Source Code Browsing</h3> <dl class="keyboard-mappings"> <dt>t</dt> <dd>Activates the file finder</dd> </dl> <dl class="keyboard-mappings"> <dt>l</dt> <dd>Jump to line</dd> </dl> <dl class="keyboard-mappings"> <dt>y</dt> <dd>Expand URL to its canonical form</dd> </dl> </div> </div> </div> </div> <div id="markdown-help" class="instapaper_ignore readability-extra"> <h2>Markdown Cheat Sheet</h2> <div class="cheatsheet-content"> <div class="mod"> <div class="col"> <h3>Format Text</h3> <p>Headers</p> <pre> # This is an <h1> tag ## This is an <h2> tag ###### This is an <h6> tag</pre> <p>Text styles</p> <pre> *This text will be italic* _This will also be italic_ **This text will be bold** __This will also be bold__ *You **can** combine them* </pre> </div> <div class="col"> <h3>Lists</h3> <p>Unordered</p> <pre> * Item 1 * Item 2 * Item 2a * Item 2b</pre> <p>Ordered</p> <pre> 1. Item 1 2. Item 2 3. Item 3 * Item 3a * Item 3b</pre> </div> <div class="col"> <h3>Miscellaneous</h3> <p>Images</p> <pre> ![GitHub Logo](/images/logo.png) Format: ![Alt Text](url) </pre> <p>Links</p> <pre> http://github.com - automatic! [GitHub](http://github.com)</pre> <p>Blockquotes</p> <pre> As Kanye West said: > We're living the future so > the present is our past. </pre> </div> </div> <div class="rule"></div> <h3>Code Examples in Markdown</h3> <div class="col"> <p>Syntax highlighting with <a href="http://github.github.com/github-flavored-markdown/" title="GitHub Flavored Markdown" target="_blank">GFM</a></p> <pre> ```javascript function fancyAlert(arg) { if(arg) { $.facebox({div:'#foo'}) } } ```</pre> </div> <div class="col"> <p>Or, indent your code 4 spaces</p> <pre> Here is a Python code example without syntax highlighting: def foo: if not bar: return true</pre> </div> <div class="col"> <p>Inline code for comments</p> <pre> I think you should use an `<addr>` element here instead.</pre> </div> </div> </div> </div>   <script type="text/javascript">(function(){var d=document;var e=d.createElement("script");e.async=true;e.src="https://d1ros97qkrwjf5.cloudfront.net/16/eum/rum.js ";e.type="text/javascript";var s=d.getElementsByTagName("script")[0];s.parentNode.insertBefore(e,s);})();NREUMQ.push(["nrf2","beacon-1.newrelic.com","2f94e4d8c2",64799,"dw1bEBZcX1RWRhoBD0cWRksWUkQ=",0.0,173,new Date().getTime()])</script> </body> </html>

It’s for syncDatabase task which contains collection of database elements.

<!DOCTYPE html> <html> <head> <meta charset='utf-8'> <meta http-equiv="X-UA-Compatible" content="chrome=1"> <script type="text/javascript">var NREUMQ=[];NREUMQ.push(["mark","firstbyte",new Date().getTime()]);</script> <title>404 - GitHub</title> <link rel="search" type="application/opensearchdescription+xml" href="/opensearch.xml" title="GitHub" /> <link rel="fluid-icon" href="https://github.com/fluidicon.png" title="GitHub" /> <meta content="authenticity_token" name="csrf-param" /> <meta name="csrf-token" /> <link href="https://a248.e.akamai.net/assets.github.com/4ab42aa6ea0cfc9a0079aaea26be62ab36a62793/stylesheets/bundle_github.css" media="screen" rel="stylesheet" type="text/css" /> <script type="text/javascript"> if (typeof console == "undefined" || typeof console.log == "undefined") console = { log: function() {} } </script> <script src="https://a248.e.akamai.net/assets.github.com/javascripts/jquery/jquery-1.6.1.min.js" type="text/javascript"></script> <script type="text/javascript" charset="utf-8"> var GitHub = { assetHost: 'https://a248.e.akamai.net/assets.github.com' } var github_user = null </script> <script src="https://a248.e.akamai.net/assets.github.com/c95ebfaaef8d0756f7ecff3aad37542991891eb6/javascripts/bundle_github.js" type="text/javascript"></script> <script type="text/javascript" charset="utf-8"> if (GitHub.spy) { GitHub.spy({repo: ""}); } </script> <script type="text/javascript"> var _gaq = _gaq || []; _gaq.push(['_setAccount', 'UA-3769691-2']); _gaq.push(['_setDomainName', 'none']); _gaq.push(['_trackPageview']); _gaq.push(['_trackPageLoadTime']); (function() { var ga = document.createElement('script'); ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js'; ga.setAttribute('async', 'true'); document.documentElement.firstChild.appendChild(ga); })(); </script> </head> <body class="logged_out env-production"> <div class="" id="main"> <div id="header" class="true"> <a class="logo boring" href="https://github.com"> <img alt="github" class="default" height="45" src="https://a248.e.akamai.net/assets.github.com/images/modules/header/logov6.png" />  <img alt="github" class="hover" height="45" src="https://a248.e.akamai.net/assets.github.com/images/modules/header/logov6-hover.png" />  </a> <div class="topsearch">  <ul class="nav logged_out"> <li class="pricing"><a href="https://github.com/plans">Pricing and Signup</a></li> <li class="explore"><a href="https://github.com/explore">Explore GitHub</a></li> <li class="features"><a href="https://github.com/features">Features</a></li> <li class="blog"><a href="https://github.com/blog">Blog</a></li> <li class="login"><a href="https://github.com/login?return_to=%2Fgist%2F1168596%2FSynchronizeDatabaseTask.cs">Login</a></li> </ul> </div> </div> <div class="site"> <style type="text/css"> * { margin: 0px; padding: 0px; } #parallax_illustration { display:block; width: 940px; height: 375px; margin: 20px 0 0 20px; position: relative; overflow: hidden; } #parallax_illustration #parallax_error_text { position: absolute; top: 72px; left: 72px; z-index: 10; } #parallax_illustration #parallax_octocat { position: absolute; top: 94px; left: 356px; z-index: 9; } #parallax_illustration #parallax_speeder { position: absolute; top: 150px; left: 432px; z-index: 8; } #parallax_illustration #parallax_octocatshadow { position: absolute; top: 297px; left: 371px; z-index: 7; } #parallax_illustration #parallax_speedershadow { position: absolute; top: 263px; left: 442px; z-index: 6; } #parallax_illustration #parallax_building_1 { position: absolute; top: 73px; left: 467px; z-index: 5; } #parallax_illustration #parallax_building_2 { position: absolute; top: 113px; left: 762px; z-index: 4; } #parallax_illustration #parallax_bg { position: absolute; top: -20px; left: -20px; z-index: 1; } </style> <div id="parallax_illustration"> <img alt="404 | “This is not the web page you are looking for”" height="249" id="parallax_error_text" src="https://a248.e.akamai.net/assets.github.com/images/modules/404/parallax_errortext.png" width="271" /> <img alt="Octobi Wan Catnobi" height="230" id="parallax_octocat" src="https://a248.e.akamai.net/assets.github.com/images/modules/404/parallax_octocat.png" width="188" /> <img alt="land speeder" height="156" id="parallax_speeder" src="https://a248.e.akamai.net/assets.github.com/images/modules/404/parallax_speeder.png" width="440" /> <img alt="Octobi Wan Catnobi's shadow" height="49" id="parallax_octocatshadow" src="https://a248.e.akamai.net/assets.github.com/images/modules/404/parallax_octocatshadow.png" width="166" /> <img alt="land speeder's shadow" height="75" id="parallax_speedershadow" src="https://a248.e.akamai.net/assets.github.com/images/modules/404/parallax_speedershadow.png" width="430" /> <img alt="building" height="123" id="parallax_building_1" src="https://a248.e.akamai.net/assets.github.com/images/modules/404/parallax_building_1.png" width="304" /> <img alt="building" height="50" id="parallax_building_2" src="https://a248.e.akamai.net/assets.github.com/images/modules/404/parallax_building_2.png" width="116" /> <img alt="building" height="415" id="parallax_bg" src="https://a248.e.akamai.net/assets.github.com/images/modules/404/parallax_bg.jpg" width="940" /> </div> <script type="text/javascript"> $(document).ready(function () { $('#parallax_error_text').plaxify({"xRange":20,"yRange":10}) $('#parallax_octocat').plaxify({"xRange":10,"yRange":10}) $('#parallax_octocatshadow').plaxify({"xRange":10,"yRange":10}) $('#parallax_speeder').plaxify({"xRange":10,"yRange":10}) $('#parallax_speedershadow').plaxify({"xRange":10,"yRange":10}) $('#parallax_building_1').plaxify({"xRange":50,"yRange":20,"invert":true}) $('#parallax_building_2').plaxify({"xRange":75,"yRange":30,"invert":true}) $('#parallax_bg').plaxify({"xRange":0,"yRange":40,"invert":true}) }) $.plax.enable() </script> <script type="text/javascript"> if (typeof _gaq !== "undefined") _gaq.push(['_trackPageview', '/404.html?page=' + document.location.pathname + document.location.search + '&from=' + document.referrer]) </script> </div> </div>  <div id="footer" > <div class="upper_footer"> <div class="site" class="clearfix">  <![if !IE]><h4 id="blacktocat">GitHub Links</h4><![endif]> <ul class="footer_nav"> <h4>GitHub</h4> <li><a href="https://github.com/about">About</a></li> <li><a href="https://github.com/blog">Blog</a></li> <li><a href="https://github.com/contact">Contact & Support</a></li> <li><a href="https://github.com/training">Training</a></li> <li><a href="http://status.github.com/">Site Status</a></li> </ul> <ul class="footer_nav"> <h4>Tools</h4> <li><a href="http://mac.github.com/">GitHub for Mac</a></li> <li><a href="http://mobile.github.com/">GitHub:Issues for iPhone</a></li> <li><a href="https://gist.github.com">Gist: Code Snippets</a></li> <li><a href="http://fi.github.com/">Enterprise Install</a></li> <li><a href="http://jobs.github.com/">Job Board</a></li> </ul> <ul class="footer_nav"> <h4>Extras</h4> <li><a href="http://shop.github.com/">GitHub Shop</a></li> <li><a href="http://octodex.github.com/">The Octodex</a></li> </ul> <ul class="footer_nav"> <h4>Documentation</h4> <li><a href="http://help.github.com/">GitHub Help</a></li> <li><a href="http://developer.github.com/">Developer API</a></li> <li><a href="http://github.github.com/github-flavored-markdown/">GitHub Flavored Markdown</a></li> <li><a href="http://pages.github.com/">GitHub Pages</a></li> </ul> </div> </div> <div class="lower_footer"> <div class="site" class="clearfix">  <![if !IE]><div id="legal"><![endif]> <ul> <li><a href="https://github.com/site/terms">Terms of Service</a></li> <li><a href="https://github.com/site/privacy">Privacy</a></li> <li><a href="https://github.com/security">Security</a></li> </ul> <p>© 2011 <span id="_rrt" title="0.01869s from fe8.rs.github.com">GitHub</span> Inc. All rights reserved.</p> </div> <div class="sponsor"> <a href="http://www.rackspace.com" class="logo"> <img alt="Dedicated Server" height="36" src="https://a248.e.akamai.net/assets.github.com/images/modules/footer/rackspace_logo.png?v2" width="38" /> </a> Powered by the <a href="http://www.rackspace.com ">Dedicated Servers</a> and<br/> <a href="http://www.rackspacecloud.com">Cloud Computing</a> of Rackspace Hosting<span>®</span> </div> </div> </div> </div> <div id="keyboard_shortcuts_pane" class="instapaper_ignore readability-extra" style="display:none"> <h2>Keyboard Shortcuts <small><a href="#" class="js-see-all-keyboard-shortcuts">(see all)</a></small></h2> <div class="columns threecols"> <div class="column first"> <h3>Site wide shortcuts</h3> <dl class="keyboard-mappings"> <dt>s</dt> <dd>Focus site search</dd> </dl> <dl class="keyboard-mappings"> <dt>?</dt> <dd>Bring up this help dialog</dd> </dl> </div> <div class="column middle" style='display:none'> <h3>Commit list</h3> <dl class="keyboard-mappings"> <dt>j</dt> <dd>Move selected down</dd> </dl> <dl class="keyboard-mappings"> <dt>k</dt> <dd>Move selected up</dd> </dl> <dl class="keyboard-mappings"> <dt>t</dt> <dd>Open tree</dd> </dl> <dl class="keyboard-mappings"> <dt>p</dt> <dd>Open parent</dd> </dl> <dl class="keyboard-mappings"> <dt>c <em>or</em> o <em>or</em> enter</dt> <dd>Open commit</dd> </dl> <dl class="keyboard-mappings"> <dt>y</dt> <dd>Expand URL to its canonical form</dd> </dl> </div> <div class="column last" style='display:none'> <h3>Pull request list</h3> <dl class="keyboard-mappings"> <dt>j</dt> <dd>Move selected down</dd> </dl> <dl class="keyboard-mappings"> <dt>k</dt> <dd>Move selected up</dd> </dl> <dl class="keyboard-mappings"> <dt>o <em>or</em> enter</dt> <dd>Open issue</dd> </dl> </div> </div> <div style='display:none'> <div class="rule"></div> <h3>Issues</h3> <div class="columns threecols"> <div class="column first"> <dl class="keyboard-mappings"> <dt>j</dt> <dd>Move selected down</dd> </dl> <dl class="keyboard-mappings"> <dt>k</dt> <dd>Move selected up</dd> </dl> <dl class="keyboard-mappings"> <dt>x</dt> <dd>Toggle select target</dd> </dl> <dl class="keyboard-mappings"> <dt>o <em>or</em> enter</dt> <dd>Open issue</dd> </dl> </div> <div class="column middle"> <dl class="keyboard-mappings"> <dt>I</dt> <dd>Mark selected as read</dd> </dl> <dl class="keyboard-mappings"> <dt>U</dt> <dd>Mark selected as unread</dd> </dl> <dl class="keyboard-mappings"> <dt>e</dt> <dd>Close selected</dd> </dl> <dl class="keyboard-mappings"> <dt>y</dt> <dd>Remove selected from view</dd> </dl> </div> <div class="column last"> <dl class="keyboard-mappings"> <dt>c</dt> <dd>Create issue</dd> </dl> <dl class="keyboard-mappings"> <dt>l</dt> <dd>Create label</dd> </dl> <dl class="keyboard-mappings"> <dt>i</dt> <dd>Back to inbox</dd> </dl> <dl class="keyboard-mappings"> <dt>u</dt> <dd>Back to issues</dd> </dl> <dl class="keyboard-mappings"> <dt>/</dt> <dd>Focus issues search</dd> </dl> </div> </div> </div> <div style='display:none'> <div class="rule"></div> <h3>Network Graph</h3> <div class="columns equacols"> <div class="column first"> <dl class="keyboard-mappings"> <dt><span class="badmono">←</span> <em>or</em> h</dt> <dd>Scroll left</dd> </dl> <dl class="keyboard-mappings"> <dt><span class="badmono">→</span> <em>or</em> l</dt> <dd>Scroll right</dd> </dl> <dl class="keyboard-mappings"> <dt><span class="badmono">↑</span> <em>or</em> k</dt> <dd>Scroll up</dd> </dl> <dl class="keyboard-mappings"> <dt><span class="badmono">↓</span> <em>or</em> j</dt> <dd>Scroll down</dd> </dl> <dl class="keyboard-mappings"> <dt>t</dt> <dd>Toggle visibility of head labels</dd> </dl> </div> <div class="column last"> <dl class="keyboard-mappings"> <dt>shift <span class="badmono">←</span> <em>or</em> shift h</dt> <dd>Scroll all the way left</dd> </dl> <dl class="keyboard-mappings"> <dt>shift <span class="badmono">→</span> <em>or</em> shift l</dt> <dd>Scroll all the way right</dd> </dl> <dl class="keyboard-mappings"> <dt>shift <span class="badmono">↑</span> <em>or</em> shift k</dt> <dd>Scroll all the way up</dd> </dl> <dl class="keyboard-mappings"> <dt>shift <span class="badmono">↓</span> <em>or</em> shift j</dt> <dd>Scroll all the way down</dd> </dl> </div> </div> </div> <div style='display:none'> <div class="rule"></div> <div class="columns threecols"> <div class="column first" style='display:none'> <h3>Source Code Browsing</h3> <dl class="keyboard-mappings"> <dt>t</dt> <dd>Activates the file finder</dd> </dl> <dl class="keyboard-mappings"> <dt>l</dt> <dd>Jump to line</dd> </dl> <dl class="keyboard-mappings"> <dt>y</dt> <dd>Expand URL to its canonical form</dd> </dl> </div> </div> </div> </div> <div id="markdown-help" class="instapaper_ignore readability-extra"> <h2>Markdown Cheat Sheet</h2> <div class="cheatsheet-content"> <div class="mod"> <div class="col"> <h3>Format Text</h3> <p>Headers</p> <pre> # This is an <h1> tag ## This is an <h2> tag ###### This is an <h6> tag</pre> <p>Text styles</p> <pre> *This text will be italic* _This will also be italic_ **This text will be bold** __This will also be bold__ *You **can** combine them* </pre> </div> <div class="col"> <h3>Lists</h3> <p>Unordered</p> <pre> * Item 1 * Item 2 * Item 2a * Item 2b</pre> <p>Ordered</p> <pre> 1. Item 1 2. Item 2 3. Item 3 * Item 3a * Item 3b</pre> </div> <div class="col"> <h3>Miscellaneous</h3> <p>Images</p> <pre> ![GitHub Logo](/images/logo.png) Format: ![Alt Text](url) </pre> <p>Links</p> <pre> http://github.com - automatic! [GitHub](http://github.com)</pre> <p>Blockquotes</p> <pre> As Kanye West said: > We're living the future so > the present is our past. </pre> </div> </div> <div class="rule"></div> <h3>Code Examples in Markdown</h3> <div class="col"> <p>Syntax highlighting with <a href="http://github.github.com/github-flavored-markdown/" title="GitHub Flavored Markdown" target="_blank">GFM</a></p> <pre> ```javascript function fancyAlert(arg) { if(arg) { $.facebox({div:'#foo'}) } } ```</pre> </div> <div class="col"> <p>Or, indent your code 4 spaces</p> <pre> Here is a Python code example without syntax highlighting: def foo: if not bar: return true</pre> </div> <div class="col"> <p>Inline code for comments</p> <pre> I think you should use an `<addr>` element here instead.</pre> </div> </div> </div> </div>   <script type="text/javascript">(function(){var d=document;var e=d.createElement("script");e.async=true;e.src="https://d1ros97qkrwjf5.cloudfront.net/16/eum/rum.js ";e.type="text/javascript";var s=d.getElementsByTagName("script")[0];s.parentNode.insertBefore(e,s);})();NREUMQ.push(["nrf2","beacon-1.newrelic.com","2f94e4d8c2",64799,"dw1bEBZcX1RWRhoBD0cWRksWUkQ=",0.0,23,new Date().getTime()])</script> </body> </html>

It is static class to run a task to do synchronizing between script files and database.

<!DOCTYPE html> <html> <head> <meta charset='utf-8'> <meta http-equiv="X-UA-Compatible" content="chrome=1"> <script type="text/javascript">var NREUMQ=[];NREUMQ.push(["mark","firstbyte",new Date().getTime()]);</script> <title>404 - GitHub</title> <link rel="search" type="application/opensearchdescription+xml" href="/opensearch.xml" title="GitHub" /> <link rel="fluid-icon" href="https://github.com/fluidicon.png" title="GitHub" /> <meta content="authenticity_token" name="csrf-param" /> <meta name="csrf-token" /> <link href="https://a248.e.akamai.net/assets.github.com/4ab42aa6ea0cfc9a0079aaea26be62ab36a62793/stylesheets/bundle_github.css" media="screen" rel="stylesheet" type="text/css" /> <script type="text/javascript"> if (typeof console == "undefined" || typeof console.log == "undefined") console = { log: function() {} } </script> <script src="https://a248.e.akamai.net/assets.github.com/javascripts/jquery/jquery-1.6.1.min.js" type="text/javascript"></script> <script type="text/javascript" charset="utf-8"> var GitHub = { assetHost: 'https://a248.e.akamai.net/assets.github.com' } var github_user = null </script> <script src="https://a248.e.akamai.net/assets.github.com/c95ebfaaef8d0756f7ecff3aad37542991891eb6/javascripts/bundle_github.js" type="text/javascript"></script> <script type="text/javascript" charset="utf-8"> if (GitHub.spy) { GitHub.spy({repo: ""}); } </script> <script type="text/javascript"> var _gaq = _gaq || []; _gaq.push(['_setAccount', 'UA-3769691-2']); _gaq.push(['_setDomainName', 'none']); _gaq.push(['_trackPageview']); _gaq.push(['_trackPageLoadTime']); (function() { var ga = document.createElement('script'); ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js'; ga.setAttribute('async', 'true'); document.documentElement.firstChild.appendChild(ga); })(); </script> </head> <body class="logged_out env-production"> <div class="" id="main"> <div id="header" class="true"> <a class="logo boring" href="https://github.com"> <img alt="github" class="default" height="45" src="https://a248.e.akamai.net/assets.github.com/images/modules/header/logov6.png" />  <img alt="github" class="hover" height="45" src="https://a248.e.akamai.net/assets.github.com/images/modules/header/logov6-hover.png" />  </a> <div class="topsearch">  <ul class="nav logged_out"> <li class="pricing"><a href="https://github.com/plans">Pricing and Signup</a></li> <li class="explore"><a href="https://github.com/explore">Explore GitHub</a></li> <li class="features"><a href="https://github.com/features">Features</a></li> <li class="blog"><a href="https://github.com/blog">Blog</a></li> <li class="login"><a href="https://github.com/login?return_to=%2Fgist%2F1168596%2FSynchronizeScripts.cs">Login</a></li> </ul> </div> </div> <div class="site"> <style type="text/css"> * { margin: 0px; padding: 0px; } #parallax_illustration { display:block; width: 940px; height: 375px; margin: 20px 0 0 20px; position: relative; overflow: hidden; } #parallax_illustration #parallax_error_text { position: absolute; top: 72px; left: 72px; z-index: 10; } #parallax_illustration #parallax_octocat { position: absolute; top: 94px; left: 356px; z-index: 9; } #parallax_illustration #parallax_speeder { position: absolute; top: 150px; left: 432px; z-index: 8; } #parallax_illustration #parallax_octocatshadow { position: absolute; top: 297px; left: 371px; z-index: 7; } #parallax_illustration #parallax_speedershadow { position: absolute; top: 263px; left: 442px; z-index: 6; } #parallax_illustration #parallax_building_1 { position: absolute; top: 73px; left: 467px; z-index: 5; } #parallax_illustration #parallax_building_2 { position: absolute; top: 113px; left: 762px; z-index: 4; } #parallax_illustration #parallax_bg { position: absolute; top: -20px; left: -20px; z-index: 1; } </style> <div id="parallax_illustration"> <img alt="404 | “This is not the web page you are looking for”" height="249" id="parallax_error_text" src="https://a248.e.akamai.net/assets.github.com/images/modules/404/parallax_errortext.png" width="271" /> <img alt="Octobi Wan Catnobi" height="230" id="parallax_octocat" src="https://a248.e.akamai.net/assets.github.com/images/modules/404/parallax_octocat.png" width="188" /> <img alt="land speeder" height="156" id="parallax_speeder" src="https://a248.e.akamai.net/assets.github.com/images/modules/404/parallax_speeder.png" width="440" /> <img alt="Octobi Wan Catnobi's shadow" height="49" id="parallax_octocatshadow" src="https://a248.e.akamai.net/assets.github.com/images/modules/404/parallax_octocatshadow.png" width="166" /> <img alt="land speeder's shadow" height="75" id="parallax_speedershadow" src="https://a248.e.akamai.net/assets.github.com/images/modules/404/parallax_speedershadow.png" width="430" /> <img alt="building" height="123" id="parallax_building_1" src="https://a248.e.akamai.net/assets.github.com/images/modules/404/parallax_building_1.png" width="304" /> <img alt="building" height="50" id="parallax_building_2" src="https://a248.e.akamai.net/assets.github.com/images/modules/404/parallax_building_2.png" width="116" /> <img alt="building" height="415" id="parallax_bg" src="https://a248.e.akamai.net/assets.github.com/images/modules/404/parallax_bg.jpg" width="940" /> </div> <script type="text/javascript"> $(document).ready(function () { $('#parallax_error_text').plaxify({"xRange":20,"yRange":10}) $('#parallax_octocat').plaxify({"xRange":10,"yRange":10}) $('#parallax_octocatshadow').plaxify({"xRange":10,"yRange":10}) $('#parallax_speeder').plaxify({"xRange":10,"yRange":10}) $('#parallax_speedershadow').plaxify({"xRange":10,"yRange":10}) $('#parallax_building_1').plaxify({"xRange":50,"yRange":20,"invert":true}) $('#parallax_building_2').plaxify({"xRange":75,"yRange":30,"invert":true}) $('#parallax_bg').plaxify({"xRange":0,"yRange":40,"invert":true}) }) $.plax.enable() </script> <script type="text/javascript"> if (typeof _gaq !== "undefined") _gaq.push(['_trackPageview', '/404.html?page=' + document.location.pathname + document.location.search + '&from=' + document.referrer]) </script> </div> </div>  <div id="footer" > <div class="upper_footer"> <div class="site" class="clearfix">  <![if !IE]><h4 id="blacktocat">GitHub Links</h4><![endif]> <ul class="footer_nav"> <h4>GitHub</h4> <li><a href="https://github.com/about">About</a></li> <li><a href="https://github.com/blog">Blog</a></li> <li><a href="https://github.com/contact">Contact & Support</a></li> <li><a href="https://github.com/training">Training</a></li> <li><a href="http://status.github.com/">Site Status</a></li> </ul> <ul class="footer_nav"> <h4>Tools</h4> <li><a href="http://mac.github.com/">GitHub for Mac</a></li> <li><a href="http://mobile.github.com/">GitHub:Issues for iPhone</a></li> <li><a href="https://gist.github.com">Gist: Code Snippets</a></li> <li><a href="http://fi.github.com/">Enterprise Install</a></li> <li><a href="http://jobs.github.com/">Job Board</a></li> </ul> <ul class="footer_nav"> <h4>Extras</h4> <li><a href="http://shop.github.com/">GitHub Shop</a></li> <li><a href="http://octodex.github.com/">The Octodex</a></li> </ul> <ul class="footer_nav"> <h4>Documentation</h4> <li><a href="http://help.github.com/">GitHub Help</a></li> <li><a href="http://developer.github.com/">Developer API</a></li> <li><a href="http://github.github.com/github-flavored-markdown/">GitHub Flavored Markdown</a></li> <li><a href="http://pages.github.com/">GitHub Pages</a></li> </ul> </div> </div> <div class="lower_footer"> <div class="site" class="clearfix">  <![if !IE]><div id="legal"><![endif]> <ul> <li><a href="https://github.com/site/terms">Terms of Service</a></li> <li><a href="https://github.com/site/privacy">Privacy</a></li> <li><a href="https://github.com/security">Security</a></li> </ul> <p>© 2011 <span id="_rrt" title="0.01709s from fe6.rs.github.com">GitHub</span> Inc. All rights reserved.</p> </div> <div class="sponsor"> <a href="http://www.rackspace.com" class="logo"> <img alt="Dedicated Server" height="36" src="https://a248.e.akamai.net/assets.github.com/images/modules/footer/rackspace_logo.png?v2" width="38" /> </a> Powered by the <a href="http://www.rackspace.com ">Dedicated Servers</a> and<br/> <a href="http://www.rackspacecloud.com">Cloud Computing</a> of Rackspace Hosting<span>®</span> </div> </div> </div> </div> <div id="keyboard_shortcuts_pane" class="instapaper_ignore readability-extra" style="display:none"> <h2>Keyboard Shortcuts <small><a href="#" class="js-see-all-keyboard-shortcuts">(see all)</a></small></h2> <div class="columns threecols"> <div class="column first"> <h3>Site wide shortcuts</h3> <dl class="keyboard-mappings"> <dt>s</dt> <dd>Focus site search</dd> </dl> <dl class="keyboard-mappings"> <dt>?</dt> <dd>Bring up this help dialog</dd> </dl> </div> <div class="column middle" style='display:none'> <h3>Commit list</h3> <dl class="keyboard-mappings"> <dt>j</dt> <dd>Move selected down</dd> </dl> <dl class="keyboard-mappings"> <dt>k</dt> <dd>Move selected up</dd> </dl> <dl class="keyboard-mappings"> <dt>t</dt> <dd>Open tree</dd> </dl> <dl class="keyboard-mappings"> <dt>p</dt> <dd>Open parent</dd> </dl> <dl class="keyboard-mappings"> <dt>c <em>or</em> o <em>or</em> enter</dt> <dd>Open commit</dd> </dl> <dl class="keyboard-mappings"> <dt>y</dt> <dd>Expand URL to its canonical form</dd> </dl> </div> <div class="column last" style='display:none'> <h3>Pull request list</h3> <dl class="keyboard-mappings"> <dt>j</dt> <dd>Move selected down</dd> </dl> <dl class="keyboard-mappings"> <dt>k</dt> <dd>Move selected up</dd> </dl> <dl class="keyboard-mappings"> <dt>o <em>or</em> enter</dt> <dd>Open issue</dd> </dl> </div> </div> <div style='display:none'> <div class="rule"></div> <h3>Issues</h3> <div class="columns threecols"> <div class="column first"> <dl class="keyboard-mappings"> <dt>j</dt> <dd>Move selected down</dd> </dl> <dl class="keyboard-mappings"> <dt>k</dt> <dd>Move selected up</dd> </dl> <dl class="keyboard-mappings"> <dt>x</dt> <dd>Toggle select target</dd> </dl> <dl class="keyboard-mappings"> <dt>o <em>or</em> enter</dt> <dd>Open issue</dd> </dl> </div> <div class="column middle"> <dl class="keyboard-mappings"> <dt>I</dt> <dd>Mark selected as read</dd> </dl> <dl class="keyboard-mappings"> <dt>U</dt> <dd>Mark selected as unread</dd> </dl> <dl class="keyboard-mappings"> <dt>e</dt> <dd>Close selected</dd> </dl> <dl class="keyboard-mappings"> <dt>y</dt> <dd>Remove selected from view</dd> </dl> </div> <div class="column last"> <dl class="keyboard-mappings"> <dt>c</dt> <dd>Create issue</dd> </dl> <dl class="keyboard-mappings"> <dt>l</dt> <dd>Create label</dd> </dl> <dl class="keyboard-mappings"> <dt>i</dt> <dd>Back to inbox</dd> </dl> <dl class="keyboard-mappings"> <dt>u</dt> <dd>Back to issues</dd> </dl> <dl class="keyboard-mappings"> <dt>/</dt> <dd>Focus issues search</dd> </dl> </div> </div> </div> <div style='display:none'> <div class="rule"></div> <h3>Network Graph</h3> <div class="columns equacols"> <div class="column first"> <dl class="keyboard-mappings"> <dt><span class="badmono">←</span> <em>or</em> h</dt> <dd>Scroll left</dd> </dl> <dl class="keyboard-mappings"> <dt><span class="badmono">→</span> <em>or</em> l</dt> <dd>Scroll right</dd> </dl> <dl class="keyboard-mappings"> <dt><span class="badmono">↑</span> <em>or</em> k</dt> <dd>Scroll up</dd> </dl> <dl class="keyboard-mappings"> <dt><span class="badmono">↓</span> <em>or</em> j</dt> <dd>Scroll down</dd> </dl> <dl class="keyboard-mappings"> <dt>t</dt> <dd>Toggle visibility of head labels</dd> </dl> </div> <div class="column last"> <dl class="keyboard-mappings"> <dt>shift <span class="badmono">←</span> <em>or</em> shift h</dt> <dd>Scroll all the way left</dd> </dl> <dl class="keyboard-mappings"> <dt>shift <span class="badmono">→</span> <em>or</em> shift l</dt> <dd>Scroll all the way right</dd> </dl> <dl class="keyboard-mappings"> <dt>shift <span class="badmono">↑</span> <em>or</em> shift k</dt> <dd>Scroll all the way up</dd> </dl> <dl class="keyboard-mappings"> <dt>shift <span class="badmono">↓</span> <em>or</em> shift j</dt> <dd>Scroll all the way down</dd> </dl> </div> </div> </div> <div style='display:none'> <div class="rule"></div> <div class="columns threecols"> <div class="column first" style='display:none'> <h3>Source Code Browsing</h3> <dl class="keyboard-mappings"> <dt>t</dt> <dd>Activates the file finder</dd> </dl> <dl class="keyboard-mappings"> <dt>l</dt> <dd>Jump to line</dd> </dl> <dl class="keyboard-mappings"> <dt>y</dt> <dd>Expand URL to its canonical form</dd> </dl> </div> </div> </div> </div> <div id="markdown-help" class="instapaper_ignore readability-extra"> <h2>Markdown Cheat Sheet</h2> <div class="cheatsheet-content"> <div class="mod"> <div class="col"> <h3>Format Text</h3> <p>Headers</p> <pre> # This is an <h1> tag ## This is an <h2> tag ###### This is an <h6> tag</pre> <p>Text styles</p> <pre> *This text will be italic* _This will also be italic_ **This text will be bold** __This will also be bold__ *You **can** combine them* </pre> </div> <div class="col"> <h3>Lists</h3> <p>Unordered</p> <pre> * Item 1 * Item 2 * Item 2a * Item 2b</pre> <p>Ordered</p> <pre> 1. Item 1 2. Item 2 3. Item 3 * Item 3a * Item 3b</pre> </div> <div class="col"> <h3>Miscellaneous</h3> <p>Images</p> <pre> ![GitHub Logo](/images/logo.png) Format: ![Alt Text](url) </pre> <p>Links</p> <pre> http://github.com - automatic! [GitHub](http://github.com)</pre> <p>Blockquotes</p> <pre> As Kanye West said: > We're living the future so > the present is our past. </pre> </div> </div> <div class="rule"></div> <h3>Code Examples in Markdown</h3> <div class="col"> <p>Syntax highlighting with <a href="http://github.github.com/github-flavored-markdown/" title="GitHub Flavored Markdown" target="_blank">GFM</a></p> <pre> ```javascript function fancyAlert(arg) { if(arg) { $.facebox({div:'#foo'}) } } ```</pre> </div> <div class="col"> <p>Or, indent your code 4 spaces</p> <pre> Here is a Python code example without syntax highlighting: def foo: if not bar: return true</pre> </div> <div class="col"> <p>Inline code for comments</p> <pre> I think you should use an `<addr>` element here instead.</pre> </div> </div> </div> </div>   <script type="text/javascript">(function(){var d=document;var e=d.createElement("script");e.async=true;e.src="https://d1ros97qkrwjf5.cloudfront.net/16/eum/rum.js ";e.type="text/javascript";var s=d.getElementsByTagName("script")[0];s.parentNode.insertBefore(e,s);})();NREUMQ.push(["nrf2","beacon-1.newrelic.com","2f94e4d8c2",64799,"dw1bEBZcX1RWRhoBD0cWRksWUkQ=",0,17,new Date().getTime()])</script> </body> </html>

That’s all for this, do you have another way? please let me know!

Factory Method Pattern in JavaScript

2008-11-10T00:03:00+07:00

Last two months I posted about Factory Method Design Pattern in C#. Now I do the same thing in JavaScript.

This is a simple example of the factory method pattern in JavaScript, The factory method getPhone() will generate Phone object. I just keep as organizing with namespace “Patterns” as in C#.

var Patterns = {}; Patterns.Nokia = function(){ this.getPrice = function(){ return 200; }; }; Patterns.Motorola = function(){ this.getPrice = function(){ return 100; }; }; Patterns.PhoneFactory = { getPhone : function(type){ switch(type){ case "Motorola": return new Patterns.Motorola(); case "Nokia": default: return new Patterns.Nokia(); } } }; var phone = Patterns.PhoneFactory.getPhone("Nokia"); console.log(phone.getPrice());

Art of Test WebAii Tests Web UI

2008-10-09T23:42:00+07:00

My colleague have some problems using Selenium to test the website specifically issues with JavaScript and Ajax. Also we would like to include testing nicely and easily integrated into our build process with continuous integration.

So we did together a bit of searching and found the free .Net automation framework for web testing produced by Art Of Test Inc called WebAii. Just see from the demo it seems to do everything we want.

I would think this is more useful framework rather than the others for now even I’ve just started to use it and there are just a small sample codes of its features. I guess it can be a killer web testing application. I tried it with my colleague and how about you?

Here is an example for you to try it:

Configuration file App.config

<?xml version="1.0" encoding="utf-8" ?> <configuration> <configSections> <section name="WebAii.Settings" type="ArtOfTest.WebAii.Core.SettingsConfigSectionHandler,ArtOfTest.WebAii, Version=1.1.900.0, Culture=neutral, PublicKeyToken=4FD5F65BE123776C"/> </configSections> <WebAii.Settings annotateExecution="false" baseUrl="http://www.google.com/" clientReadyTimeout="50000" defaultBrowser="InternetExplorer" enableScriptLogging="false" enableUILessRequestViewing="false" executionDelay="0" executionTimeout="60000" localWebServer="None" logLocation="C:\WebAiiLog\" queryEventLogErrorsOnExit="false" simulatedMouseMoveSpeed="0.3" webAppPhysicalPath=""/> </configuration>

Abstract class PageBase.cs

using ArtOfTest.WebAii.Core; using NUnit.Framework; namespace WebAiiUITest { public abstract class PageBase { public readonly Manager manager = new Manager(true); protected Browser browser; protected Find find; [SetUp] public void SetUp() { manager.Start(); manager.LaunchNewBrowser(); browser = manager.ActiveBrowser; find = browser.Find; browser.NavigateTo("http://www.google.com/"); } [TearDown] public void TearDown() { browser.Close(); } } }

Testing class KeywordSearch.cs

using ArtOfTest.WebAii.Controls.HtmlControls; using NUnit.Framework; namespace WebAiiUITest { [TestFixture] public class KeywordSearch : PageBase { [Test] public void Should_keyword_search_found() { var searchText = "WowKhmer Tech"; find.ById<htmlinputtext>("q").Value = searchText; find.ById<htmlinputsubmit>("btnG").Click(); Assert.IsNotNull(find.ById<htmlanchor>(searchText)); } } }

This example will run with Internet Explorer browser. You can run with Firefox just change defaultBrowser=”Firefox” in App.config you can either write one line of code but I would like keep it easily in configuration file. It still doesn’t work if it opens with a new tab, from my experience unless you need to have a setting in browser. Click Tools -> Options -> Tabs -> select “a new window” option.

Factory Method Design Pattern

2008-09-28T23:16:00+07:00

The factory method pattern is a design pattern that allows for the creations of objects without specifying the type of object that is to be created in code. A factory class contain a method that allow determination of the created type at run-time. It is used to replace class constructors, abstracting the process of object generation so that the type of the object instantiated can be determined at run-time.

One example of the use of the factory method pattern is when creating a connection to a data source if the type of the data source will be selected by the end-user using a graphical interface. In this case, an abstract class name “DataSource” may be created that defines the base functionality of all data source. Many concreate subclass may be created, perhaps “SqlDataSource”, “XmlDataSource”, “CsvDataSource”, etc, each with specific functionality for a differenct type of data. At run-time, a further class, perhaps named “DataSourceFactory”, generates objects of the correct class based upon a parameter passed to the factory method.

Implementation

The UML class diagram above describes an implementation of the factory method design pattern. In this diagram there are four classes:

FactoryBase: This is an abstract base class for the concrete factory classes that will actually generate new objects. This class could be a simple interface containing the signature for the factory method. However, generally an abstract class will be used so that other standard functionality can included and inherited by subclass. In simple situations the factory method may be implemented in full here. rather than being declared as abstract.
ConcreateFactory: Inheriting from the FactoryBase class, the concreate factory classes inherit the actual factory method. This is overridden with the object generation code unless already implemented in full in the base class.
ProductBase: This abstract class is the base class for the types of object that the factory can create. It is also the return type for the factory method. Again, this can be a simple interface info general functionality is to be inherited by its subclasses.
ConcreateProduct: Multiple subclasses of the Product class are defined, each containing specific functionality. Object of these classes are generated by the factory method.

The basic code of the factory method design pattern implemented using C# is shown in the following:

public abstract class FactoryBase { public abstract Product FactoryMethod(int type); } public class ConcreteFactory : FactoryBase { public override Product FactoryMethod(int type) { switch (type) { case 1: return new ConcreteProduct1(); case 2: return new ConcreteProduct2(); default: throw new ArgumentException("Invalid type.", "type"); } } } public abstract class ProductBase { } public class ConcreteProduct1 : ProductBase { } public class ConcreteProduct2 : ProductBase { }

Example 1

This is a simple example of the factory method design pattern in action, The factory method GetPhone() will generate Phone object

namespace FactoryMethod { public interface IPhone { decimal Price { get; } } public class Nokia : IPhone { public decimal Price { get { return 200; } } } public class Motorola : IPhone { public decimal Price { get { return 100; } } } public class PhoneFactory { public IPhone GetPhone(string type) { switch (type) { case "Nokia": return new Nokia(); case "Motorola": return new Motorola(); default: return null; } } } }

You just call GetPhone() and pass type as a parameter in your client code you will get a new Phone object

using System; using FactoryMethod; namespace FactoryMethod { class Program { static void Main(string[] args) { PhoneFactory phoneFactory = new PhoneFactory(); IPhone phone; phone = phoneFactory.GetPhone("Nokia"); Console.WriteLine("The price for Nokia: {0}", phone.Price); phone = phoneFactory.GetPhone("Motorola"); Console.WriteLine("The price for Motorola: {0}", phone.Price); Console.Read(); } } }

Example 2

This example is similar to the example 1. CreateConnection() will create connection object.

namespace FactoryMethod { public interface IConnectionProvider { string ConnectionString { get; } } public class SqlServerConnection : IConnectionProvider { public string ConnectionString { get { return "Server=(local);initial catalog=AdventureWorks;Integrated Security=SSPI"; } } } public class OracleConnection : IConnectionProvider { public string ConnectionString { get { return "User ID=vorleak;Password=vorleak;Data Source=localhost"; } } } public class MySqlConnection : IConnectionProvider { public string ConnectionString { get { return "Database=AdventureWorks;Data Source=192.168.0.1;User Id=vorleak;Password=vorleak"; } } } public class ConnectionProviderFactory { public IConnectionProvider CreateConnection(string type) { switch (type) { case "SQL Server" : return new SqlServerConnection(); case "Oracle" : return new OracleConnection(); case "MySQL": return new MySqlConnection(); default: return null; } } } }

You don’t need to have condition in the client code just pass parameter type.

using System; using FactoryMethod; namespace FactoryMethod { class Program { static void Main(string[] args) { ConnectionProviderFactory connectionProviderFactory = new ConnectionProviderFactory(); IConnectionProvider connectionProvider; connectionProvider = connectionProviderFactory.CreateConnection("SQL Server"); Console.WriteLine("ConnectionString for SQL Server: {0}", connectionProvider.ConnectionString); connectionProvider = connectionProviderFactory.CreateConnection("Oracle"); Console.WriteLine("ConnectionString for Oracle: {0}", connectionProvider.ConnectionString); connectionProvider = connectionProviderFactory.CreateConnection("MySQL"); Console.WriteLine("ConnectionString for MySQL: {0}", connectionProvider.ConnectionString); Console.Read(); } } }

What Are Design Patterns?

2008-09-23T23:11:00+07:00

Working everyday and sitting at your desk in front of your computer, you stare into space, trying to figure out how to write a new feature for your software. You know intuitively what must be done, what data and what objects come into play, but you have this underlying feeling that there is a more elegant and general way to write a software.

In fact, you probably don’t write any code until you can build a picture in your mind of what the code does and how the pieces of the code interact. The more that you can picture, the more likely you are to feel comfortable that you have developed the best solution to the problem.

There are problems rarely stay solved after you’ve handled them once. Developers typically regard their work as tackling individual problems by writing code and solving those problems. But the truth is that in any professional environment, developers almost always end up spending a lot more time on maintenance and adapting code to new situations than writing entirely new code.

A design pattern is a general repeatable solution to a commonly occurring problem in software design. It makes your solution easily reusable, extendable, and maintainable. When you are working on a programming problem, the tendency is to program to the problem, not in terms of reuse, extensibility, maintainability, or other good design issues. And that’s where most developers should be putting in more work because they end up spending far more time on such issues than solving the original problem in the long run. It can also speed up the development process by providing tested, proven development paradigms.

In generally, there are three types: creational, structural, and behavioral.

Creational Patterns: create objects for you rather than having you instantiate objects directly. This gives your program more flexibility in deciding which objects need to be created for a given case.
Structural Patterns: help you compose groups of object into larger structures, such as complex user interfaces or accounting data.
Behavioral Patterns: help you define the communication between objects in your system and how the flow is controlled in a complex program.

Vertical and Horizontal CSS Bar Graph

2008-09-10T22:38:00+07:00

Currently, you may be running a website for long time which is also more popular and getting more visitors everyday, So it is time to do advertising if you don’t have.

Before that, how do you know your website has more visitors or not? What you need to do is looking to the statistic which is very important for you to sell advertisement.

Even there are more stats plugins available for you such as google stats or the others but you may need to customize for yourself with nice graph and flexible way.

What is a Bar Graph?

A bar graph is a visual display used to compare the amounts or frequency of occurrence of different characteristics of data. This type of display allow us to compare groups of data and to make generalizations about the data quickly.

Vertical CSS Bar Graph

This is a bar graph to display the number of visits per month in year 2007. You may want to make it like this:

You need to have two images:

The column image: For this example the width is always 35px and the height is flexibility which base on formula Value / MaxValue * MaxHeight and rounded to the nearest number. For example data in here is starting from January: 10000 / 100000 * 200 = 20, 17000 / 100000 * 200 = 34, and so on
The background line image

XHTML Codes

<table id="bargraphVertical"> <tbody><tr><th>Visits 2007</th> <td>10000<img src="column.gif" alt="10000" width="35" height="10"></td> <td>17000<img src="column.gif" alt="17000" width="35" height="34"></td> <td>24000<img src="column.gif" alt="24000" width="35" height="48"></td> <td>30000<img src="column.gif" alt="30000" width="35" height="60"></td> <td>35000<img src="column.gif" alt="35000" width="35" height="70"></td> <td>40000<img src="column.gif" alt="40000" width="35" height="80"></td> <td>50000<img src="column.gif" alt="50000" width="35" height="100"></td> <td>60000<img src="column.gif" alt="60000" width="35" height="120"></td> <td>70000<img src="column.gif" alt="70000" width="35" height="140"></td> <td>80000<img src="column.gif" alt="80000" width="35" height="160"></td> <td>90000<img src="column.gif" alt="90000" width="35" height="180"></td> <td>100000<img src="column.gif" alt="100000" width="35" height="200"></td> </tr></tbody> <tfoot><tr><th>Month</th> <th>Jan</th> <th>Feb</th> <th>Mar</th> <th>Apr</th> <th>May</th> <th>Jun</th> <th>Jul</th> <th>Aug</th> <th>Sep</th> <th>Oct</th> <th>Nov</th> <th>Dec</th> </tr></tfoot> </table>

CSS Codes

#bargraphVertical{ font:0.7em Arial; width:475px; border:1px solid #ccc; } #bargraphVertical td{ padding:0; margin:0; vertical-align:bottom; text-align:center; background:#eee url(graphbg.gif) 15px bottom; } #bargraphVertical img{ display:block; border-right:1px solid #fff; } #bargraphVertical th{ font-weight:normal; }

Horizontal CSS Bar Graph

This is a bar graph to display the number of visitors within countries. It is very similar to the Vertical Bar Graph implementation. We use this when the label is longer text such “REPUBLIC OF KOREA” as an example.

You need to have one image:

The row image: For this example the height is always 10px and the width is flexibility which base on formula Value / MaxValue * MaxWidth and rounded to the nearest number. For example data in here is starting from CAMBODIA: 100000 / 100000 * 200 = 20, 90000 / 100000 * 200 = 180, and so on

XHTML Codes

<table id="bargraphHorizontal"><tbody> <tr> <th class="label">Country</th> <th class="val">Visitors</th> </tr> <tr> <td class="label">CAMBODIA</td> <td class="val"><img src="row.gif" width="200" height="10"> 100000</td> </tr> <tr> <td class="label">UNITED STATES</td> <td class="val"><img src="row.gif" width="180" height="10"> 90000</td> </tr> <tr> <td class="label">AUSTRALIA</td> <td class="val"><img src="row.gif" width="160" height="10"> 80000</td> </tr> <tr> <td class="label">Unknown</td> <td class="val"><img src="row.gif" width="140" height="10"> 70000</td> </tr> <tr> <td class="label">FRANCE</td> <td class="val"><img src="row.gif" width="120" height="10"> 60000</td> </tr> <tr> <td class="label">THAILAND</td> <td class="val"><img src="row.gif" width="100" height="10"> 50000</td> </tr> <tr> <td class="label">REPUBLIC OF KOREA</td> <td class="val"><img src="row.gif" width="80" height="10"> 40000</td> </tr> <tr> <td class="label">CANADA</td> <td class="val"><img src="row.gif" width="70" height="10"> 35000</td> </tr> <tr> <td class="label">JAPAN</td> <td class="val"><img src="row.gif" width="60" height="10"> 30000</td> </tr> <tr> <td class="label">SINGAPORE</td> <td class="val"><img src="row.gif" width="48" height="10"> 24000</td> </tr> </tbody></table>

CSS Codes

#bargraphHorizontal{ font:0.7em Arial; border:1px solid #ccc; } #bargraphHorizontal th{ font-weight:normal; } #bargraphHorizontal td{ padding:1px 0; margin:0; } #bargraphHorizontal .label{ text-align:right; } #bargraphHorizontal .val{ text-align:left; } #bargraphHorizontal img{ vertical-align:middle; }

SQL Server 2005 Update Trigger Effect Multiple Rows

2008-08-15T22:25:00+07:00

I have two tables which I would like to keep records were changed in DeliveryTypeChanges if user updates the DeliveryCharge in the DeliveryType table.

First time I try to create a trigger that the SELECT statement without having INNER JOIN Deleted and keep value from Deleted to variable before INSERT, So what I get is only one record updates to the table. First time I try to create a trigger that the SELECT statement without having INNER JOIN Deleted and keep value from Deleted to variable before INSERT, So what I get is only one record updates to the table.

There are two tables:

Create Table DeliveryType ( DeliveryTypeID int not null Constraint pk_DeliveryType_DeliveryTypeID primary key, DeliveryTypeDescription varchar(10) not null, DeliveryCharge smallmoney not null ) Create Table DeliveryTypeChanges ( ChangeID int identity(1,1) not null Constraint pk_DeliveryTypeChanges_ChangeID primary key, ChangeDateTime datetime not null, DeliveryTypeDescription varchar(10) not null, OldDeliveryCharge smallmoney not null, NewDeliveryCharge smallmoney not null )

Here is the trigger to make it works with multiple records:

CREATE TRIGGER trUpdateRecordDeliveryChargeChange On DeliveryType FOR UPDATE AS IF UPDATE (DeliveryCharge) BEGIN INSERT DeliveryTypeChanges(ChangeDateTime, DeliveryTypeDescription, OldDeliveryCharge, NewDeliveryCharge) SELECT GETDATE(), Inserted.DeliveryTypeDescription, Deleted.DeliveryCharge, Inserted.DeliveryCharge FROM Inserted INNER JOIN Deleted ON Inserted.DeliveryTypeID = Deleted.DeliveryTypeID END