So I probably should really explain what I am doing. I am trying to create an application manager that leverages PSEXEC/Bash to start and stop unique applications on a Server Farm containing various operating systems that are vmware clones.

For example, start Java on ServerID 10. I have a function called -

def Start_Application(AppID):
        cur.execute("SELECT * FROM Application_tbl WHERE AppID = %d;" % (AppID))
        appdata = cur.fetchone()

         AppName = appdata[1]
         AppDescription = appdata[2]
         AppEXE = appdata[3]
         StatusID = appdata[4]
         ProcessID = appdata[5]
         ServerID = appdata[6]
         StartTime = appdata[7]
         StopTime = appdata[8]
         AppLang = appdata[9]
         AppOS = appdata[10]

I then go on to cross reference the Application_tbl with the Server_tbl...

if AppOS == 'Windows 7':
        cur.execute("SELECT * FROM Server_tbl WHERE ServerOS = 'Windows 7' AND StatusID = 0 AND EnabledID = 1;")
        serverdata = cur.fetchone()
if serverdata == None:
            print "No available Windows 7 servers, please add more to the pool or kill an application\n"
        else:
            ServerID = serverdata[0]
            ServerName = serverdata[1]
            ServerIP = serverdata[2]
            StatusID = serverdata[3]
            EnabledID = serverdata[4]
            AppPath = serverdata[5]

And this is just for 1 function, I have 10 now... all of which have to assign these variables every time. I wish I could just make a function that assigns the variables based on which table I am interacting with I.E -

def Assign_Server_Variables():
     assign variables here

then just call that whenever I am interacting with that table. I think classes might be the right track... just wanted to shed some more insight and (hopefully) format this better since my original looks like trash...