Windows 10: python script does not run from commandline

hello,


I'm having problems suddenly running .py scripts from the command line. CMD


Before, *.py was associated with python.exe The association was created during python installation, associating python scripts .py with the proper executable.

With the proper association of the .py file to python.exe , the location of the python.exe in the %PATH% variable - and the python extension in the %PATHEXT% , just typing '.\myscript.py' would launch the script in using the correct python.exe using the CMD line


However, for some reason this suddenly changed last week. Now, typing '.\myscript.py' does nothing - simply shows me the next prompt in the CMD window.

typing 'python myscript.py' still works, but since there are a load of batch files lingering around running the .py scripts without the explicit 'python' prefix - I have no idea what changed and i'd like to find out what's going on and fix this.


I browsed various forums - mentioning assoc and ftype, but these do not seem to do the trick

in fact, on my tablet, typing .\myscript.py perfectly executes, and assoc/ftype seem to have nothing set for python scripts in the CMD window


On the pc in question:

assoc .py returns 'Python.File' , ftype Python.File shows the path/python.exe to my python executable - yet when typing myscript.py in the CMD line, it does nothing.


I also tried associating the .py extension using the 'Run with' again, was still showing 'python' but this too changed nothing.

I also checked the registry, to see what windows might be doing with .py extension, but although there are some references to the .py extension, some of which referring to the python.exe I like to use, it's hard to see what's going on there not sure which registry items are or used for what or even if they are used in win10.


I 'repaired' my python install - then completely reinstalled python adding registry entries but nothing changed.


when typing '.\myscript.py' on the command line - nothing happens, just the next prompt.


when double clicking the python script - it does seem to be associated with the proper python version, it does start using the right python.exe


My questions

- if possible, how do I see using the cmd line what is windows is actually doing trying to do when I type 'myscript.py' can I start CMD using some debug/verbose options?

- How/where in windows do i control how a .py script runs in the commandline? - apart from the 'run with' is there any way to tell windows how to run my python script, when I type myscript.py on the command line?

- are there additional options for the powershell to deal with this?

- is there a way, again from windows, to add details to the 'run with' , rather then just starting the .py using a python from the list, to tell it to use certain arguments?

- When using 'run with' , and seeing a python logo - is there a way to tell the exact path/execution line associated with that logo?

if not, i really think it should be possible to see this when that list pops up using some advanced settings or something


any help and insights would be much appreciated.

cheers

GJ

:)

 

Simple Python Scripts

Hey exodusprime1337,
Just got in from shoveling snow *Frown

I'm all for suggesting Linux to people, but...
I've also learned to keep my variables to a minimum.
What I'm saying is, when learning something new,
Python in this case, you don't want to add Linux and the
shell into the mix as debugging is harder with 2 unknowns.

Stick with your tried and true environment when experimenting
w/ Python and when you have time to focus on Linux only
start messing w/ shell scripting, perl and tcl/tk.
Then you'll realize that you can do everything on Linux.

For now just remove my she-bang line Code: #!/usr/bin/python[/quote] as it's only function is to tell the Linux kernel what interpreter to use.

I'll have another script for you tonight *Smile

 

Simple Python Scripts

Some Python Database Scripts

Here are some Python Sqlite Database Scripts.

You need the sqlite3 module installed,
(but it's normally part of the initial Python install package)

This first script creates the DATABASE and TABLE:

Code: #!/usr/bin/python import sqlite3 try: #Here is where we create the database var_connection = sqlite3.connect("linux_database.db") #Now we create the cursor for access var_cursor = var_connection.cursor() #Now we create a database table var_cursor.execute('''CREATE TABLE linux_table(distro VARCHAR(15), version VARCHAR(5), type VARCHAR(10))''') var_connection.commit() var_connection.close() print "" print "linux_database DATABASE has been created" print "distro_table TABLE has been created" print "" except (ImportError, RuntimeError, TypeError, NameError): print "" print "Error, exception thrown" print ""[/quote] Image of this script running on my system:






This next script inserts pre-defined data into the newly created table.
The pre-defined data is contained within multiple TUPLES and the
tuples are contained within a LIST.

Code: #!/usr/bin/python import sqlite3 try: #Here is where we connect to the database var_connection = sqlite3.connect("linux_database.db") #Now we create the cursor for access var_cursor = var_connection.cursor() var_data = [ ('Gentoo', '2010', 'rolling'), ('Arch', '2010', 'rolling'), ('Slackware', '13.0', 'fixed'), ('Fedora', '12.0', 'fixed'), ('Debian', '5.0', 'fixed'), ('Ubuntu', '9.10', 'fixed'), ('openSUSE', '11.3', 'fixed'), ('Mandriva', '2010', 'fixed'), ('Mint', '8.0', 'fixed'), ('PCLinuxOS', '2010', 'rolling'), ] var_cursor.executemany('''INSERT INTO linux_table(distro, version,type) VALUES(?, ?, ?)''', var_data) var_connection.commit() var_connection.close() print "" print "Data has been input successfully" print "" except (ImportError, RuntimeError, TypeError, NameError): print "" print "Error inputing data" print ""[/quote] Again, here is the script running on my system:






This final script sends a query to the database and displays the result.

Code: #!/usr/bin/python import sqlite3 try: #Here is where we create the database var_connection = sqlite3.connect("linux_database.db") #Now we create the cursor for access var_cursor = var_connection.cursor() var_cursor.execute('''SELECT distro, version, type FROM linux_table ORDER BY distro''') print "" column_width = 15 for column_description in var_cursor.description: print column_description[0].ljust(column_width) , print "" print "-" * 45 var_index = range(len(var_cursor.description)) #Loop through the cursor dataset to extract data for row in var_cursor: for index in var_index: var_value = str(row[index]) print var_value.ljust(column_width) , print "" var_connection.commit() var_connection.close() print "" except (ImportError, RuntimeError, TypeError, NameError): print "" print "Error, selecting data to be displayed" print ""[/quote]
Here is the script output:






Some basic database functions in Python.
It's a simple into which you can build on.
Have Fun with it!! *Wink

 

Simple Python Scripts

Before we post any more scripts, I'd like to take
a step back and go over the basic help function
within the Python interactive console.
(mine is on linux, not sure if the Windows version is exactly the same) *Confused

Here I start the Python console, it tells me what
version I'm using and gives me a >>> prompt





Now I use the HELP function to view all the installed modules/libraries
Code: help("modules")[/quote]







Now to see what functions are contained within a particular module,
we simply use help again. I'll be looking at the webbrowser module
which can be seen in the list.
Code: help("webbrowser")[/quote]







By looking into the module, I see that I want to use the open_new(url) function,
so my command(s) will look someting like this.
I have to import the module to use the functions.

Code: >>> import webbrowser >>> webbrowser.open_new("TechPowerUp")[/quote] As you can see from the image, my default browser opened to
the specified url from within Python.





Help can navigate through any module, exposing the various
functions which I hope will make your python coding easy and fun *Big Grin

Now lets do some scripting. *Wink