How put db connection in seperate file and use in another file in python

Question

Hi i have problem regarding db connection. i want to put db connection in seprate file and can use in multiple files.

i have tried this

connection.py

import pymysql
import mysql.connector

class Connection:

    def __init__(self):
        conn = mysql.connector.connect(host="localhost", user="root", password="", db="")
        cur = conn.cursor()
        return cur, conn

main.py

import connection

cur, conn = connection.Connection()

Error

cur, conn = connection.Connection()
TypeError: __init__() should return None, not 'tuple'

The error message is explicit: the special __init__ method is expected to return None (or not use return at all which is equivalent) — Serge Ballesta
– Serge Ballesta, Commented Mar 4, 2021 at 10:31
I'd suggest you use a config file instead, but otherwise just use a simple function like deceze suggested and you're fine. — DerMaddi
– DerMaddi, Commented Mar 4, 2021 at 10:35

Jaybe Park · Accepted Answer · 2021-03-04 10:37:02Z

7

connection.py

import pymysql
import mysql.connector

def get_connection():
    conn = mysql.connector.connect(host="localhost", user="root", password="", db="")
    cur = conn.cursor()
    return cur, conn

main.py

import connection

cur, conn = connection.get_connection()

answered Mar 4, 2021 at 10:37

Jaybe Park

1921 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

herhor67 Over a year ago

Great, and then, how to close the connection in a function in the connection.py?

Jaybe Park Over a year ago

@herhor67 You can close the connection by conn.close() However, it is not appropriate because if you close the connection in get_connection function, you can't use it.

herhor67 Over a year ago

That was my point. It would be great to have an init and deinit functions, but when done in this way, you need to pass the conn variable to the deinit... God I hate Python.

Jaybe Park Over a year ago

@herhor67 I got it. You can make it to class and override __init__ and __del__ function. I might think pymysql already got this.

Collectives™ on Stack Overflow

How put db connection in seperate file and use in another file in python

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related