How to wrap mysql in a python script

Question

I want to write a wrapper script around the mysql cli client. So I can construct the mysql cli flags to be used based on some logic.

my question is:

How would I execute the mysql client so that the user can interact with it. (stdout,stdin forwarded etc)?

Perhaps a better title for your question is "How to wrap a process in a python script" — Paul Draper
– Paul Draper, Commented Mar 22, 2014 at 7:30
Ah I thought of that initially, but then I thought mentioning mysql would be more specific — wjimenez5271
– wjimenez5271, Commented Mar 22, 2014 at 7:35
Effective dupe. I'm pretty sure you just want to connect and run queries. — U2EF1
– U2EF1, Commented Mar 22, 2014 at 7:42
@U2EF1, no this is not a duplicate. He wants his users to be able to run queries interactively. — Paul Draper
– Paul Draper, Commented Mar 22, 2014 at 7:49
@wjimenez5271, I think what you will wind up with is a lot of people saying "uh duh, MySQLDB, or PyMySQL", with realizing your real problems is "forwarding" stin/stdout. — Paul Draper
– Paul Draper, Commented Mar 22, 2014 at 7:51

Peter Gibson · Accepted Answer · 2014-03-22 08:00:35Z

1

Just build your list of arguments and use the subprocess module to launch MySQL

import subprocess

args = ['-u', 'wjimenez5271', '-p']
subprocess.call('mysql', args)
print('done')

This will launch mysql -u wjimenez5271 -p, handing over control until the process terminates, then python will resume and print "done".

answered Mar 22, 2014 at 8:00

Peter Gibson

19.6k7 gold badges63 silver badges65 bronze badges

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

1 Answer 1