import pymysql.cursors // essa linha fica indicando erro
class Database:
database_cred = {
"host": "HOST",
"user": "USER",
"password": "PASSWORD",
"database": "DATABASE",
"cursorclass": pymysql.cursors.DictCursor
}
def __init__(self, database_cred: dict = None):
if database_cred:
self.conn = pymysql.connect(**database_cred)
else:
self.conn = pymysql.connect(**self.database_cred)
# end if
def run_qry(self, sql: str):
with self.conn.cursor() as cursor:
cursor.execute(sql)
self.conn.commit()
result = cursor.fetchall()
# end with
return result
# end class