Now that we can read data (as described in the previous recipe), it's time to learn how to insert data using Ruby.
Complete the Reading data using HandlerSocket and Ruby recipe described earlier in this chapter prior to starting this recipe.
Launch the interactive Ruby interpreter in a terminal window as follows:
irb
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')
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'])
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,'...