So I want to import a function which is within a class in mysqlConnector.py to another python file excelread.py I get a Name Error : 'dataBase' not defined which I guess is because I did not import the function right Can Someone review the code and tell me why, thanks !
Below is the code to the file in which I want to import (excelread.py)
#importing python package to read excel file (.xlsx and .xlsm ) & write onto (.xlsx)
import pylightxl as xl      
#importing mysql Package
import mysql.connector
from mysqlConnector import SQLConnector
newConnector = SQLConnector
newConnector.connector()
#TITLE
print("Hello, welcome to XL Read") 
                       
#Reading file & storing data to a var
xcelFile = xl.readxl(fn='C:/Users/Mojo/Desktop/py_excel/excel/test.xlsx')
#interation
for row in xcelFile.ws(ws='Sheet1').rows:
    if(row != ['Name', 'ID', 'Dpt']):
        name,id,dept = row
        #using db cursor and storing it to a variable 'mycursor'
        mycursor = dataBase.cursor()
        mycursor.execute(f"INSERT INTO data_id (NAME, ID) VALUES ('{name}',{id});")
        #executing db commands via the velow funcion
        dataBase.commit() 
Here is the file which contains the code to a function inside a class (mysqlConnector.py)
import mysql.connector
class SQLConnector:
    def connector():
        #Database connector
        dataBase = mysql.connector.connect(
        host="localhost",
        database="excelread_py",
        user="pma",
        password="123456"
        )
        return dataBase
 
    