O'Reilly logo

MariaDB Cookbook by Daniel Bartholomew

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required