result = cursor.fetchone(variable1, variable2, variable3)
return result

result1 = connector_mysql(subSerialNum, ldev, today_date)
    print(result1)

{'ldev_cap': '0938376656', 'ldev_usedcap': '90937763873'}

used_capacity = result1['ldev_cap']

cursor.execute(sql_query, {'serial': subSerialNum, 'lun': ldev, 'todayD': today_date})
result = cursor.fetchone()
while result:
    ldev_cap = result['ldev_cap']
    ldev_usdcap = result['ldev_usdcap']
    return ldev_cap, ldev_usdcap

ldev_cap = result['ldev_cap']

result1 = connector_mysql(subSerialNum, ldev, today_date)

return ldev_cap, ldev_usdcap

capacity, usd_capacity = connector_mysql(subSerialNum, ldev, today_date)

capacity, usd_capacity = connector_mysql(subSerialNum, ldev, today_date)
print(capacity)
print(usd_capacity)

def connector_mysql(subSerialNum, ldev, today_date):

    import pymysql.cursors

    db_server = 'localhost'
    db_name = 'CBDB'
    db_pass = 'secure_password'
    db_user = 'user1'

    sql_query = (
        "SELECT ldev_cap, ldev_usdcap FROM Ldevs WHERE sub_serial=%(serial)s "
        "and ldev_id=%(lun)s and data_date=%(todayD)s")

    connection = pymysql.connect(host=db_server,
                                 user=db_user,
                                 password=db_pass,
                                 db=db_name,
                                 cursorclass=pymysql.cursors.DictCursor)

    try:
        with connection.cursor() as cursor:
            cursor.execute(sql_query, {'serial': subSerialNum, 'lun': ldev, 'todayD': today_date})
            result = cursor.fetchone()
            #return result          #used for returning dict

            while result:
                ldev_cap = result['ldev_cap']
                ldev_usdcap = result['ldev_usdcap']

                print(result)
                return ldev_cap, ldev_usdcap

    finally:
        connection.close()