Random User Selection from Local Database using PyMySQL

This function connects to a local database using PyMySQL and randomly selects a user's information from it.

Technology Stack : PyMySQL, Database Query

Code Type : Database Query

Code Difficulty : Intermediate

                
                    
import pymysql
import random

def fetch_random_user_info():
    connection = pymysql.connect(host='localhost',
                                 user='user',
                                 password='password',
                                 database='testdb',
                                 charset='utf8mb4',
                                 cursorclass=pymysql.cursors.DictCursor)

    try:
        with connection.cursor() as cursor:
            sql = "SELECT * FROM users ORDER BY RAND() LIMIT 1"
            cursor.execute(sql)
            result = cursor.fetchone()
    finally:
        connection.close()

    return result