Das deutsche Python-Forum

Code: Alles auswählen

import sys    

class QueryPool:
    """
    If u want to add an new query, just write the name to the caseDict{}
    and add an function with self.getArgs(AmountofArgs)at the start
    and add an return on the end.
    """
    
    ArgList = []
    callByPython = False
    
    def __init__(self, callByPython= False):
        """
        Look if sys.argv[1] exists, then call the function
        """
        self.callByPython = callByPython
        
        if not self.callByPython:
            #sys.argv[1] is the first written argument:
            caseDict = { 'test' : self.test }
            #Call the Method
            try:
                query = caseDict[sys.argv[1]]()
                print "[query]" +query + "[/query]"
            except:
                print "error no such query exists"

    def getArgs(self, needAmount):
        """
        args which wont give will set to None
        """
        
        #called by command line with args
        if not self.callByPython:
            for i in range(len(sys.argv)):
                if i >1:
                    self.ArgList.append(sys.argv[i])

        #SEt the missing args with empty string
        while len(self.ArgList)<needAmount:
            self.ArgList.append("")



#-----------------------just queries down to this-----------------------
  
    def test(self):
        """    
        Arg sequence: rows; table;
        """
        
        #get the Args, argument is the maximum amount of used args
        self.getArgs(2)
        
        query = "select "+ self.ArgList[0] + " from " + self.ArgList[1]
        
        return query




#called if there are arguments entered by command line
if len(sys.argv)>1:
    QueryPool = QueryPool()








#-----------------------end of query class-----------------------

"""
sample how to call it from pyhton


QueryPool = QueryPool(True)

# Set the args in the right sequence, missing args would filled with an empty string
QueryPool.ArgList = ["arg01", "arg02"]

query = QueryPool.test()

print query

"""



"""
sample how to call it from command line
 
command:   test2.py query arg1 arg2
output:    [query]select arg1 from arg2 ...[/query]

You have only to split the string to get the query
"""

Code: Alles auswählen

import sys

class QueryPool:
    def __init__(self, arguments=None):
        if arguments is None:
            arguments = list()
        self.arguments = arguments
        # Evt. irgend etwas mit den Argumenten anstellen.
    
    # ...


def main():
    if len(sys.argv) > 1:
        pool = QueryPool(sys.argv[1:])
        pool.test()
        # ...

if __name__ == '__main__':
    main()

Code: Alles auswählen

import sys    

class QueryPool:
   
    def qu1(self, argList):
        """
        argList = [arg1, arg2]
        """
        try:

            query =  "SELECT " + str(argList[0]) + " from " + str(argList[1]) 

        except:
            print "error with args, check if all needed are given" 
            return ""
        return query





#if called by commandline
if __name__ == '__main__':
    QueryPool = QueryPool()
    
    #The available queries
    caseDict = { 'qu1' : QueryPool.qu1 }
   
    try:
        #call the queries with the commandline args
        query = caseDict[sys.argv[1]](sys.argv[2:])
		if query != "":
			print "[query]" + query + "[/query]"
    except:
        print "error no such query exists"

Code: Alles auswählen

    global logger

    try:

        opts, args = getopt.getopt(argv, "ht:b:d:", 
            ["help", "timeout=", "basedir=", "dirdate="])

    except getopt.error, msg:
        if logger:
            logger.error(msg)
        sys.exit(2)

    for opt, arg in opts:

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

            usage (USAGE)
            
        elif opt in ("-t", "--timeout"):
        
            timeout = int (arg)

        elif opt in ("-d", "--dirdate"):
        
            dirdate = arg
        
        elif opt in ("-b", "--basedir"):
        
            basedir = arg


    if not args:
        if logger:        
            logger.error ("no files to wait for given goodbye")
            ret_value = -1
            return ret_value
    files = args    
    err, found = waitfor (files, timeout, basedir, dirdate)