Reading data using HandlerSocket and Python

Now that we have installed pyhs, we can start using it to read data from our database.

Getting ready

Install the HandlerSocket PERL client libraries as described in the Installing the HandlerSocket PERL client libraries recipe earlier in this chapter. Launch the mysql command-line client and run the SQL commands from the Getting ready section of the Reading data using HandlerSocket and PERL recipe, described earlier in this chapter, to give us some sample data to read (and if we've already gone through the PERL or Ruby recipes, running the SQL commands again will reset the sample data to its default state).

How to do it...

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

   python
   

2. Run the following commands in the interpreter:

   from pyhs import Manager 
   hs = Manager() 
   data = hs.get('test', 'hs_test', ['id', 'givenname', 'surname'], '5') 
   print dict(data)
   

3. Then, run the following commands in the interpreter:

   from pyhs.sockets import...