Solved

Simple Python Syntax Problem

Posted on 2010-08-23
1
1,322 Views
Last Modified: 2012-05-10
Hi the following code gives me the error below.  I have never messed with python so any input would be appreciated.

Thanks!

includes# ./lllog.py
Traceback (most recent call last):
  File "./lllog.py", line 45, in <module>
    main(sys.argv[1:])
  File "./lllog.py", line 18, in main
    except getopt.GetoptError:
NameError: global name 'getopt' is not defined

#!/usr/bin/python

# import MySQL module

import MySQLdb

# import sys module for argument processing etc

import sys



def main(argv):



    fileName = "unknown"

    hfJobId = 444

    message = "hylafax update"

    type = "FAX"

    sendto = 555

    action = "update"



    try:

        opts, args = getopt.getopt(argv, "ha:", ["help"])

    except getopt.GetoptError:

        usage()

        sys.exit(2)



    for opt, arg in opts:

       if opt in ("-h", "--help"):

         usage()

         sys.exit()

       elif opt == '-a':

         action = arg



    print "action arg is", action



  # connect

    db = MySQLdb.connect(host="172.16.1.90", user="hylafax", passwd="pass",

    db="pass")



  # create a cursor

    cursor = db.cursor()

  # execute SQL statement

    cursor.execute("""INSERT INTO lablynk_send_log (fileName, hfJobId, message, type, sendto) VALUES ("test",

    "test","test", "FAX", "test")""")



  # get ID of last inserted record

    print "ID of inserted record is ", int(cursor.insert_id())



if __name__ == "__main__":

    main(sys.argv[1:])



def usage():

    print "build usage messages"

Open in new window

0
Comment
Question by:sean-keys
1 Comment
 
LVL 13

Accepted Solution

by:
Superdave earned 500 total points
ID: 33506125
you should put a
import getopt
at the top somewhere.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

"The time has come," the Walrus said, "To talk of many things: Of sets--and lists--and dictionaries-- Of variable kinks-- And why you see it changing not-- And why so strange are strings." This part describes how variables and references (see …
Variable is a place holder or reserved memory locations to store any value. Which means whenever we create a variable, indirectly we are reserving some space in the memory. The interpreter assigns or allocates some space in the memory based on the d…
Learn the basics of lists in Python. Lists, as their name suggests, are a means for ordering and storing values. : Lists are declared using brackets; for example: t = [1, 2, 3]: Lists may contain a mix of data types; for example: t = ['string', 1, T…
Learn the basics of while and for loops in Python.  while loops are used for testing while, or until, a condition is met: The structure of a while loop is as follows:     while <condition>:         do something         repeate: The break statement m…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now