Flexi MySQL

Flexi MySQL is a Python module designed to streamline the process of interacting with MySQL databases. This module offers a variety of functions that significantly reduce the need for manually typing queries, executing them, and handling the results or committing data to the database. Additionally, for scenarios requiring raw SQL queries, the module provides support for creating such queries using MySQL

Examples

Fetching results from the database

import flexi_mysql
myobj = flexi_mysql.connect(host="localhost", user = "root",database="test", password="")
print(myobj.fetch_result(tables = ["t1"], where="id = 2"))

Close connection

import flexi_mysql 
myobj = flexi_mysql.connect(host="localhost", user = "root",database="test", password="")
myobj.close_connection()

Update value in a table

import flexi_mysql
myobj =  flexi_mysql.connect(host="localhost", user="root", database="test")
myobj.update_value(table_name="t1", columns = ["name"], value="Eternity", where = "id = 4")

Fetching results from database using with statement

import flexi_mysql
with flexi_mysql.connect(host="localhost", user="root", database="test") as myobj:
    print(myobj.fetch_result(tables = ["t1"], where="id = 2"))

Documentation