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, Mar 22 '14 at 07:30
Ah I thought of that initially, but then I thought mentioning mysql would be more specific — wjimenez5271, Mar 22 '14 at 07:35
[Effective dupe](http://stackoverflow.com/questions/372885/how-do-i-connect-to-a-mysql-database-in-python). I'm pretty sure you just want to connect and run queries. — U2EF1, Mar 22 '14 at 07:42
@U2EF1, no this is not a duplicate. He wants his users to be able to run queries *interactively*. — Paul Draper, Mar 22 '14 at 07: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, Mar 22 '14 at 07:51
Is the idea just to launch the mysql client and then hand over control, or do you want python to interact with mysql? — Peter Gibson, Mar 22 '14 at 07:52
@PaulDraper Thanks for pointing out how the question comes across — wjimenez5271, Jul 25 '14 at 21:45

score 1 · Accepted Answer · answered Mar 22 '14 at 08:00

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".

1 Answers1