global name is not defined

[barronmo]

I'm getting an error msg I don't understand, "global name EMR_globals
is not defined", and could use some help.

I've separated the application I'm building into several modules. One
of the modules holds variables I need to pass from one module to
another and is called 'EMR_globals'. Several other modules hold
functions or user menus and then 'EMR_main' controls the initial user
interaction. I'm using MySQL to hold the data.

The initial connection to the database is done by 'EMR_main'.
Functions then define and close a cursor for various queries. The
connection variable, 'conn', is defined 'conn = "" ' in EMR_globals
and then used in EMR_main. Unfortunately when a module.function
attempts to use it I get the error msg.

Here is the source of the error, module 'name_lookup':

def name_find(namef rag):

cursor = EMR_globals.con n.cursor(MySQLd b.cursors.DictC ursor)
cursor.execute( "SELECT patient_ID, firstname, lastname FROM
demographics WHERE lastname LIKE '%s%%'" % (namefrag))

results = cursor.fetchall ()

for index, row in enumerate(resul ts):
print "%d %s %s %s" % (index, row["patient_ID "],
row["firstname"], row["lastname"])

indx = int(raw_input(" Select the record you want: "))
results_list = list(results)
a = str(results_lis t[indx]['patient_ID'])
print 'You have chosen patient ID # ' + a

cursor.execute( "SELECT * FROM demographics WHERE patient_ID = %s"
% (a,))
selected_pt = cursor.fetchall ()
# if this query returns more than one record the following code will
fail I think
print menus.menu_demo graphics(select ed_pt['firstname'],
selected_pt['lastname'],
selected_pt['address'],
selected_pt['city'],
selected_pt['state'],
selected_pt['zipcode'],
selected_pt['phonenumber'])
print menus.menu_pt_r ecord

cursor.close()
Thanks for any help. Mike

[Gabriel Genellina]

En Tue, 06 Nov 2007 18:57:12 -0300, barronmo <ba******@gmail .comescribió:

I'm getting an error msg I don't understand, "global name EMR_globals
is not defined", and could use some help.

I've separated the application I'm building into several modules. One
of the modules holds variables I need to pass from one module to
another and is called 'EMR_globals'. Several other modules hold
functions or user menus and then 'EMR_main' controls the initial user
interaction. I'm using MySQL to hold the data.

Global variables usually are not a good design decision, but that's not
your current problem.

The initial connection to the database is done by 'EMR_main'.
Functions then define and close a cursor for various queries. The
connection variable, 'conn', is defined 'conn = "" ' in EMR_globals
and then used in EMR_main. Unfortunately when a module.function
attempts to use it I get the error msg.

In Python, "global" means "global to the module". If conn is defined in
EMR_globals, when you want to use it elsewhere, you can:

a)
from EMR_globals import conn
....
cursor = conn.cursor(... )

b)
import EMR_globals
....
cursor = EMR_globals.con n.cursor(...)

Usually those import statements are placed at the top of the module.

cursor.execute( "SELECT * FROM demographics WHERE patient_ID = %s"
% (a,))
selected_pt = cursor.fetchall ()
# if this query returns more than one record the following code will
fail I think
print menus.menu_demo graphics(select ed_pt['firstname'],
selected_pt['lastname'], ...

I think it will fail even with one record, because fetchall() returns a
list of rows. Try using fetchone(). Anyway, if patient_ID is the primary
key, you should always get a single row.

--
Gabriel Genellina

[Looney, James B]

Looks like you forgot to import EMR_globals, EMR_main, etc.

-----Original Message-----
From: py************* *************** *************@p ython.org
[mailto:py****** *************** *************** *****@python.or g
] On Behalf Of barronmo
Sent: Tuesday, November 06, 2007 2:57 PM
To: py*********@pyt hon.org
Subject: global name is not defined

I'm getting an error msg I don't understand, "global name EMR_globals
is not defined", and could use some help.

I've separated the application I'm building into several modules. One
of the modules holds variables I need to pass from one module to
another and is called 'EMR_globals'. Several other modules hold
functions or user menus and then 'EMR_main' controls the initial user
interaction. I'm using MySQL to hold the data.

The initial connection to the database is done by 'EMR_main'.
Functions then define and close a cursor for various queries. The
connection variable, 'conn', is defined 'conn = "" ' in EMR_globals
and then used in EMR_main. Unfortunately when a module.function
attempts to use it I get the error msg.

Here is the source of the error, module 'name_lookup':

def name_find(namef rag):

cursor = EMR_globals.con n.cursor(MySQLd b.cursors.DictC ursor)
cursor.execute( "SELECT patient_ID, firstname, lastname FROM
demographics WHERE lastname LIKE '%s%%'" % (namefrag))

results = cursor.fetchall ()

for index, row in enumerate(resul ts):
print "%d %s %s %s" % (index, row["patient_ID "],
row["firstname"], row["lastname"])

indx = int(raw_input(" Select the record you want: "))
results_list = list(results)
a = str(results_lis t[indx]['patient_ID'])
print 'You have chosen patient ID # ' + a

cursor.execute( "SELECT * FROM demographics WHERE patient_ID = %s"
% (a,))
selected_pt = cursor.fetchall ()
# if this query returns more than one record the following code will
fail I think
print menus.menu_demo graphics(select ed_pt['firstname'],
selected_pt['lastname'],
selected_pt['address'],
selected_pt['city'],
selected_pt['state'],
selected_pt['zipcode'],
selected_pt['phonenumber'])
print menus.menu_pt_r ecord

cursor.close()
Thanks for any help. Mike

--
http://mail.python.org/mailman/listinfo/python-list

[barronmo]

Thanks, seems to be fixed with importing MySQLdb, menus, EMR_main, etc
in the Name_find module. Is there a better way to do things? I
thought I was avoiding using global variables by putting the shared
ones in their own module.

Thanks for the help.

Mike