Python Essentials

Libraries

Check Library Version

pip show <library_name>

urllib3

• Disable SSL warnings for insecure connections:

import urllib3
urllib3.disable_warnings(urllib3.exceptions.InsecureRequestWarning)

---

pymysql

• Python client for interacting with MySQL databases.

• The following script dynamically executes SQL queries on a target database using credentials extracted from application settings (It need to be in a directory where the craft_api module is accessible):

#!/usr/bin/env python

import pymysql
import sys
from craft_api import settings

# Test connection to MySQL database
connection = pymysql.connect(
    host=settings.MYSQL_DATABASE_HOST,
    user=settings.MYSQL_DATABASE_USER,
    password=settings.MYSQL_DATABASE_PASSWORD,
    db=settings.MYSQL_DATABASE_DB,
    cursorclass=pymysql.cursors.DictCursor
)

try:
    with connection.cursor() as cursor:
        sql = sys.argv[1]
        cursor.execute(sql)
        result = cursor.fetchall()
        print(result)
finally:
    connection.close()

• Use Cases:

python myscript.py "SHOW TABLES"

python myscript.py "SELECT * FROM user"

python myscript.py "SHOW GRANTS FOR CURRENT_USER()"

python myscript.py "DESCRIBE user"