python - Dynamically Process Stored Procedure Results With Django

Question

I am attempting to get the results of a stored procedure and populate a model dynamically, or at a minimum, generate a model based off of the result.

My intent is to create a reusable function where it should be ambiguous to the data. I will not know the fields being returned, and wish to take what's returned from the stored procedure, get the field names and put the data in an object with said field names.

How can I dynamically discover the columns in a result set returned from a stored procedure and then create an object to match?

Answer 1

I was able to figure this out. I got a list of the column names from the returned data, created an object by name and set properties/attributes of the object by string.

def callProc(sqlString, clsName):
    cursor = connection.cursor()  
    dataResults = []
      
    try:
        cursor.execute(sqlString)        

        #get data results
        results = cursor.fetchall()

        #Get column names
        columns = [column[0] for column in cursor.description]                   
        #populate class
        for row in results:
            p = getattr(sys.modules[__name__], clsName)
            i=0
            for x in columns:
                #set property value of matching column name
                setattr(p, x, row[i])
                #get property value
                #x = getattr(p, x)
                i=i+1
            dataResults.append(p)
    except Exception as ex:
        print(ex)
    finally:
        cursor.close()

    return dataResults