[Bot]

hello, j’ai un soucis avec du Python : j’ai défini 2 fonctions et quand j’exécute la deuxième j’ai une erreur

——————–
Dwenura

Sujet

[Bot]

    
    py
import mysql.connector
from mysql.connector import Error

def mysqlConnect(host='', db='', user='', passwd=''):
    try:
        connection = mysql.connector.connect(host=host,
                                             database=db,
                                             user=user,
                                             password=passwd)

        if connection.is_connected():
            print('Connected to MySQL Server')
            cursor = connection.cursor()
            # print(cursor)
    except Error as e:
        print('Error while connecting to MySQL', e)
    finally:
        if connection.is_connected():
            cursor.close()
            connection.close()

    return cursor

def showData():
    with mysqlConnect() as cursor:
        cursor.execute('select * from ')
        result = cursor.fetchall()

        for res in result:
            return res[0]
    

    
    py
from functions import showData

showData()
    

——————–
Dwenura

[Bot]

Le cursor est local au if nan ?

Défini cursor = null au début de ta fonction ?

Ouais 100% je pense l’object est delete quand tu sors du try catch

——————–
Mirinda Inner Eye

[Bot]

wow, toi qui demande un truc ici

depuis quand tu fais du Python

——————–
DK

[Bot]

Askip le serv est fait pour Issou

Moi quand je demande un truc c’est généralement trop spécifique du coup j’ai jamais de réponses

——————–
Mirinda Inner Eye

[Bot]

yep

solved

    
    py
import mysql.connector
from mysql.connector import Error

def mysqlConnect(host='localhost', db='outilio', user='root', passwd=''):
    connection = mysql.connector.connect(host=host,
                                         database=db,
                                         user=user,
                                         password=passwd)

    return connection

def showData():
    try:
        connection = mysqlConnect()

        if connection.is_connected():
            print('Connected to MySQL Server')
            cursor = connection.cursor()
            cursor.execute('select * from bankaccounts')
            result = cursor.fetchall()

            for res in result:
                print(res)
    except Error as e:
        print('Error while connecting to MySQL', e)
    finally:
        if connection.is_connected():
            print('MySQL connection is closed')
            cursor.close()
            connection.close()
    

——————–
Dwenura

[Auteur]

Réponses