?
Solved

Simple Python Syntax Problem

Posted on 2010-08-23
1
Medium Priority
?
1,827 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 2000 total points
ID: 33506125
you should put a
import getopt
at the top somewhere.
0

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Plenty of writing has gone on the web trying to compare Python with other competitive programming languages and vice versa. However, not much has been put into a wholistic perspective. This article should help you decide whether to adopt Python as a…
Flask is a microframework for Python based on Werkzeug and Jinja 2. This requires you to have a good understanding of Python 2.7. Lets install Flask! To install Flask you can use a python repository for libraries tool called pip. Download this f…
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 if, else, and elif statements in Python 2.7. Use "if" statements to test a specified condition.: The structure of an if statement is as follows: (CODE) Use "else" statements to allow the execution of an alternative, if the …

569 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