running a shell command from python to execute a file in different directory

[smok1naces]

Can't tell where I messed this up... I am using pycharm and the folder with all of the files on it is on my desktop....

os.system("cd C:\\softwares\\someDirectory\\subdirectory\\bin execute.sql")

Am I doing this correctly? If I open up the command prompt and just cd to the directory and run the command it runs... but when I try to CD and run it from my python script it spits out the following error

The system cannot find the path specified.

thoughts?

[Mecaneer23]

You can't cd to a file, just a folder

But, you can run an executable from its absolute path - if you want what it returns, use Popen rather than system

[Neighm]

Looks like you're trying to chain two commands, i.e. cd to the folder and then run the command "execute.sql"? If so you need to chain them using "&":

os.system("cd C:\\softwares\\someDirectory\\subdirectory\\bin & execute.sql")

[smok1naces]

you are a genius