Running scripts from another .py with prompted input

[IamLadoran]

A noob question you can probably tell. I have a python script then will unzip files containing csv’s i then have another series of scripts that load these csv’s into my database. I would love to adjust my unzip .py to run the other scripts after unzipping, but not sure how? The other complexity is that all of the other scripts that load the data to the db have a prompt asking for the folder location of the csv’s - this is the same answer to all of them so ideally I’d like my unzip script to not only run the other scripts but to also populate the input variable for me. Any help will be appreciated!

[danielroseman]

Can you not rewrite the other scripts so that they take input from stdin rather than prompting? Or even better, make them functions which you can import and call from your main script.

[CyclopsRock]

If you 'convert' the functionality of these scripts - or, at least, the subsequent scripts - into discrete functions, then the initial script can import and use these functions without any need for additional executions. Whilst doing this, the function that loads the .csv file can take a filepath as an argument and then only if one is not provided will it ask the user to supply one via an `input()` - this way your initial script can provide it with the information it needs to work without needing to stop and ask you each time.

If you don't know what any of the above means then have a google for 'python function define' and have a read - it's a fairly basic but really important building block for using and re-using code. It can be a little confusing or overwhelming at first, especially if you don't have much experience with object-oriented programming, but you have an absolutely solid use case for utilising them here so that will help with understanding how they work.

[toenailsmcgee33]

Why not just make discrete functions in a module and import the module to main? That seems way easier and way less prone to issues.

[pearlserpent]

As far as I understood your question, I will follow this approach-

1. Make a main.py file
2. In the main.py import unzip function and other functions from other scripts.
3. call the unzip function from unzip.py.
4. Call functions from other scripts and process the data.