Updating and deleting data using HandlerSocket and Python

Updating and deleting data is similar to but not quite the same as inserting data.

Getting ready

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

How to do it...

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

   python
   

2. Run the following commands in the Python interpreter:

   from pyhs.sockets import WriteSocket
   hsu = WriteSocket([('inet', '127.0.0.1', 9999)])
   u_id = hsu.get_index_id('test', 'hs_test', ['givenname'])
   hsu.find_modify(u_id, '=', ['3'],'U',['Jon'],10,0)
   

3. Then, run the following commands in the Python interpreter to open new read and write connections to our test table:

   from pyhs.sockets import ReadSocket
   hsr = ReadSocket([('inet', '127.0.0.1', 9998)])
   r_id = hsr.get_index_id('test', 'hs_test', ['id', 'givenname', 'surname'])
   
   from pyhs.sockets import WriteSocket
   hsd = WriteSocket([('inet', '127.0.0.1', 9999)])
   d_id = hsd.get_index_id('test', 'hs_test', ...