Windows 10: Python Error in Main Script

Hi, Can anybody help me i am getting Python Error in main Script,

:)

 

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