connection commit function Python

Question

I was reading up on the documentation and saw that you only have to commit in once in a transaction?

Does the following count as one transaction or does each function count as a transaction?

def main():
    conn=pyodbc.connect(sqlconnectionstring) # Assume this connects to the database
    cursor = conn.cursor()

    function1()
    function2()

    conn.commit()

def function1():
    # does inserting here

def function2():
    # does inserting here and calls function 3
    function3()

def function 3():
    # does more inserting here
main()

Is that conn.commit() enough to commit all insertions in all the functions or would I have to pass the "conn" variable as an argument and commit inside each function?

Thanks!

Exprator · Accepted Answer · 2017-05-04 06:43:51Z

1

yes thats enough to commit all the transactions as the ones like insert and delete will all be performed inside the functions, until one fail then you will find the old row.

but that one commit will change the database status to the recent one

answered May 4, 2017 at 6:43

Exprator

27.8k6 gold badges54 silver badges64 bronze badges

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

Collectives™ on Stack Overflow

connection commit function Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related