mysql-utils

A simple MySQL library including a set of utility APIs for Python database programming. It encapsulates MySQL commands into Pythonic functions to make MYSQL operation easier and code more simplified.

Installation

pip install mysql-utils

or

python setup.py install

Usage

APIs provided by mysql-utils include:

• execute_mysql_cmd
• delete_table_row
• get_table_column_value
• get_multi_columns_given_multi_keys
• get_table_row
• set_table_column_value
• set_table_multi_column_values
• set_table_column_value_given_multi_keys
• set_table_multi_column_values_given_multi_keys
• insert_table_row_from_dict
• insert_or_update_table_row
• insert_or_update_row_given_multi_keys

One example of updating and querying table column is as below

In [5]: import mysql_utils

In [6]: msu = mysql_utils.MySQLUtils(database="mcd")

In [7]: msu.get_table_row("mrs", "url", "https://gitlabe2.net.com/component/merge_requests/1321")["author"]
Out[7]: u'pqian'

In [8]: msu.insert_or_update_table_row("mrs", {"url":"https://gitlabe2.net.com/component/merge_requests/1321", "author":"shelwin"},
   ...:  "url")

In [9]: msu.get_table_row("mrs", "url", "https://gitlabe2.net.com/component/merge_requests/1321")["author"]
Out[9]: u'shelwin'

LISENSE

MIT