Running SQL file from Python

Question

I have to launch a python sql file. The file is for mysql. I tried it like this:

from subprocess import Popen, PIPE
import sys


class ImportSql:
    def execImport(self, fileSql):
        try:
            with open(fileSql, 'r') as fileInput:
                proc = Popen(["mysql", "DB_NAME", "-u", "USER", "-pPASSWORD"], stdin=PIPE, stdout=PIPE)
                proc.communicate('source ' + fileInput)[0]
        except BaseException as ex:
            print("ERROR:", ex)
            sys.exit()

But I get this error:

ERROR: must be str, not _io.TextIOWrapper

how can I do?

This one looks like what you want. stackoverflow.com/a/4563950/1394353 note what the source is using - the file name, not contents. So dont open the file — JL Peyret
– JL Peyret, Commented May 9, 2017 at 15:07

Daniel Roseman · Accepted Answer · 2017-05-09 08:40:20Z

2

You need to pass the contents of the file, not the file object.

proc.communicate('source ' + fileInput.read())

Also, please don't catch exceptions just to print them and exit. That's what Python does already. Leave out that try/except.

answered May 9, 2017 at 8:40

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

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

Comments

matteo · Accepted Answer · 2017-05-10 10:46:36Z

0

Ok, I moved the mysql instructions inside a bat.

from subprocess import Popen


class ImportSql:
    def execImport(self):
        p = Popen("import.bat")
        p.communicate()

it's ok! thanks!

answered May 10, 2017 at 10:46

matteo

2,4114 gold badges24 silver badges36 bronze badges

Collectives™ on Stack Overflow

Running SQL file from 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