Run sql query which is saved in text file using python

Question

I have query in .txt file and i am trying to run that query using python. it is working fine if my query written in single line. but my query had multiple lines in text file. it is giving syntax error as it is reading only first line.

i have tried below code

cursor = cnxn.cursor()
with open('C:\Python_Script_Test\INSERTS.txt','r') as inserts:
    for statement in inserts:
        cursor.execute(statement)

i have big query with multiple lines in it. can you please suggest the best code to read all the lines to run query.

Did you try this solution ? It might help you.

Etienne Landuré
– Etienne Landuré

2019-04-23 13:01:11 +00:00
Commented Apr 23, 2019 at 13:01 — Etienne Landuré
– Etienne Landuré, Commented Apr 23, 2019 at 13:01

Rakesh · Accepted Answer · 2019-04-23 12:51:36Z

2

Try using .read()

Ex:

cursor = cnxn.cursor()
with open('C:\Python_Script_Test\INSERTS.txt','r') as inserts:
    query = inserts.read()
cursor.execute(query)

answered Apr 23, 2019 at 12:51

Rakesh

82.9k17 gold badges85 silver badges122 bronze badges

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

Comments

Jarek · Accepted Answer · 2019-05-08 12:34:53Z

0

.read() works for single line query. For multiline query Python creates list of lines. You can collate lines together using .append(), but you will need to add CRLF markers at the end of each line that are readable by SQL server ...

answered May 8, 2019 at 12:34

Jarek

1

Collectives™ on Stack Overflow

Run sql query which is saved in text file using python

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related