Book Image

MariaDB Cookbook

By : Daniel Bartholomew
Book Image

MariaDB Cookbook

By: Daniel Bartholomew

Overview of this book

Table of Contents (20 chapters)
MariaDB Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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...