Mysql + python?

Question

[des1roer]

main.py

import mysql.connector
from mysql.connector import Error
from mysql.connector import MySQLConnection, Error
from mysql_config import connect

def insert_books(books):
    query = "INSERT INTO operator(session_id,operator_login) " \
            "VALUES(%s,%s)"


    try:
        conn = connect
        cursor = conn.cursor()
        cursor.executemany(query, books)

        conn.commit()
    except Error as e:
        print('Error:', e)

    finally:
        cursor.close()
        conn.close()


def main():
    books = [('Harry Potter And The Order Of The Phoenix', '9780439358071'),
             ('Gone with the Wind', '9780446675536'),
             ('Pride and Prejudice (Modern Library Classics)', '9780679783268')]
    insert_books(books)


if __name__ == '__main__':
    main()

mysql_config

import mysql.connector
from mysql.connector import Error

def connect():
    """ Connect to MySQL database """
    try:
        conn = mysql.connector.connect(host='localhost',
                                       database='mydb',
                                       user='root',
                                       password='')
        if conn.is_connected():
            print('connection established.')
        else:
            print('connection failed.')

    except Error as e:
        print(e)

    finally:
        conn.close()

if __name__ == '__main__':
    connect()

получаю

C:\Python27\python.exe F:/python/main.py
Traceback (most recent call last):
File "F:/python/main.py", line 33, in
main()
File "F:/python/main.py", line 29, in main
insert_books(books)
File "F:/python/main.py", line 10, in insert_books
cursor = conn.cursor()
AttributeError: 'function' object has no attribute 'cursor'

Process finished with exit code 1

Answer 1

[Александр]

А значение кто возвращать будет? Дядя вася?

def connect():
    """ Connect to MySQL database """
    try:
        conn = mysql.connector.connect(host='localhost',
                                       database='mydb',
                                       user='root',
                                       password='')
        if conn.is_connected():
            print('connection established.')
        else:
            print('connection failed.')
        return conn
    except Error as e:
        print(e)

    finally:
        conn.close()

Comments

[des1roer]

не часто юзаю питон. что я забыл?

[Александр]

Функция def connect(): , должна в результате успеха или провала возвращать класс conn - коннектора.

[Александр]

а во вторых conn = connect()

[des1roer]

C:\Python27\python.exe F:/python/main.py
Traceback (most recent call last):
connection established.
('Error:', OperationalError(-1, 'MySQL Connection not available.', None))
File "F:/python/main.py", line 32, in
main()
File "F:/python/main.py", line 28, in main
insert_books(books)
File "F:/python/main.py", line 20, in insert_books
cursor.close()
UnboundLocalError: local variable 'cursor' referenced before assignment

[Илья]

А разве конект сразу после получения не закрывается в finally?

[sim3x]

FireGM: закрывается