如何参数化python排序

Question

我用python编写了以下代码用于排序

cursor.execute('SELECT Column1, Column2, Column3 from Table1');
Details = cursor.fetchall()

def mixed_order(Details):
    return (Details.Column1,
            Details.Column2,
            Details.Column3
            )

Sorted_Details = sorted(Details,key=mixed_order)

我想参数化混合顺序函数

Criteria1 ="Details.Column2"
Criteria2 ="Details.Column1"
Criteria3 ="Details.Column3"

并定义以下内容

def mixed_order(Details):
    return (Criteria1,
            Criteria2,
            Criteria3 
            )

但是，python没有整理我的细节。我定义条件并为其指定列的方式有问题

Answer 1

我想你想要这样的东西：

def mixed_order(Details):
    return (getattr(Details, Criteria1),
            getattr(Details, Criteria2),
            getattr(Details, Criteria3)
            )