Updating and deleting data using HandlerSocket and Ruby

Updating and deleting data is similar to but not quite the same as inserting data. In this recipe, we will use Ruby and HandlerSocket to update and delete data.

Getting ready

Complete the Inserting data using HandlerSocket and Ruby recipe prior to starting this recipe.

How to do it...

1. Launch the interactive Ruby interpreter in a terminal window as follows:

   irb
   

2. Run the following commands in the irb interpreter to open a HandlerSocket connection to our test database and the hs_test table:

   require 'rubygems'
   require 'handlersocket'
   hsu = HandlerSocket.new(:host => '127.0.0.1',:port => '9999')
   hsu.open_index(2,'test','hs_test','PRIMARY','givenname')
   

3. Then, update a row in the interpreter using the following statement:

   p hsu.execute_single(2,'=',[3],1,0,'U',['Jon'])
   

4. Read out the value of the column we just updated in irb to confirm that the data was updated using the following statement:

   p hsu.execute_single(2,'=',[3])
   

5. Open a connection...