CODEWITHSUNDEEP
pythonmysqlsqlmariadbpopen
matteo
matteo

Reputation: 2401

Running SQL file from Python

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?

Upvotes: 3

Views: 854

Answers (2)

matteo
matteo

Reputation: 2401

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!

Upvotes: 0

Daniel Roseman
Daniel Roseman

Reputation: 599796

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.

Upvotes: 2

Related Questions