Inserting data using HandlerSocket and Ruby

Now that we can read data (as described in the previous recipe), it's time to learn how to insert data using Ruby.

Getting ready

Complete the Reading data using HandlerSocket and Ruby recipe described earlier in this chapter prior to starting this recipe.

How to do it...

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

   irb
   

2. Open a connection to our database in the irb interpreter as follows:

   require 'rubygems'
   require 'handlersocket'
   hsw = HandlerSocket.new(:host => '127.0.0.1',:port => '9999')
   hsw.open_index(1,'test','hs_test','PRIMARY','id,givenname,surname')
   

3. Still in the irb interpreter, insert a couple of new rows using the following statements:

   p hsw.execute_single(1,'+',[7,'Sylvester','McCoy'])
   p hsw.execute_single(1,'+',[8,'Paul','McGann'])
   

4. Then, read the rows we entered using the following statements in the irb interpreter:

   p hsw.execute_single(1,'=',[7])
   p hsw.execute_single(1,'=',[8])
   p hsw.execute_single(1,'...