Use a function from one script in another

Question

I have a function that connects to a database thats predefined. The code looks like: file1.py

def conn_db():
    try:
        cursor = pymysql.cursors.DictCursor
        conn = pymysql.connect(host=settings.host,
                                user=settings.user,
                                password=settings.password,
                                db=settings.database,
                                port=settings.port,
                                cursorclass=cursor)
        dbcursor = conn.cursor()
    except pymysql.err.OperationalError as e:
        print("Unable to make a connection to the mysql database. \n Error was:{}".format(e))

    return conn, dbcursor

How can I use this function conn_db from file1.py in file2.py. And then call file2.py from executing python's intrepreter via python ?

Having a hard time even identifying something so basic, after several attempts.

Thank you.

In file2.py: from file1 import * and then call your function — mnistic
– mnistic, Commented May 5, 2018 at 16:50
You seem to be looking for the import statement. E.g. from file1 import conn_db — khelwood
– khelwood, Commented May 5, 2018 at 16:50
John, please google your questions before asking them here. A simple "call function from another file python" in google search would've yielded you the answer. This question might get downvoted and closed soon. More info: stackoverflow.com/questions/20309456/… — Rahul Bharadwaj
– Rahul Bharadwaj, Commented May 5, 2018 at 16:54

khelwood · Accepted Answer · 2018-05-05 16:52:24Z

1

You can use import file1 and then use file1.conn_db() to use the function.

edited May 5, 2018 at 16:52

khelwood

59.7k14 gold badges91 silver badges116 bronze badges

answered May 5, 2018 at 16:51

tristan

1281 silver badge9 bronze badges

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

Collectives™ on Stack Overflow

Use a function from one script in another

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related