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

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