python如何循环sql语句_python sql查询中的while循环

嗨，我在php中尝试了这个查询，它运行得很好，我必须在python中也这样做$select=mysql_query("SELECT DISTINCT A.entity_id AS entity_id ,A.email AS email,A.catquizid AS style_quiz_score ,A.catquizquesans AS style_quiz_answer,A.created_at AS date_joined,A.is_active AS is_active ,B.attribute_id AS attribute_id,B.value AS info FROM `customer_entity` AS A inner join `customer_entity_varchar` AS B on A.entity_id=B.entity_id WHERE B.`attribute_id` IN (1,2) limit 10",$conn);

$arr=array();

while($result= mysql_fetch_assoc($select))

{

if(!isset($arr[$result['entity_id']]['lastname'])){

$arr[$result['entity_id']]['firstname'] = $result['info'];

}

$arr[$result['entity_id']]['lastname'] = $result['info'];

$arr[$result['entity_id']]["email"]=$result['email'];

$arr[$result['entity_id']]["style_quiz_score"]=$result['style_quiz_score'];

$arr[$result['entity_id']]["style_quiz_answer"]=$result['style_quiz_answer'];

$arr[$result['entity_id']]["date_joined"]=$result['date_joined'];

$arr[$result['entity_id']]["is_active"]=$result['is_active'];

$arr[$result['entity_id']]["username"]=normalize_str($result['email']);

}

在python中我尝试过def customer_migrate(request):

cursor = connections['migration'].cursor()

cursor.execute("SELECT DISTINCT A.entity_id AS entity_id ,A.email AS email,A.catquizid AS style_quiz_score ,A.catquizquesans AS style_quiz_answer,A.created_at AS date_joined,A.is_active AS is_active ,B.attribute_id AS attribute_id,B.value AS info FROM customer_entity AS A inner join customer_entity_varchar AS B on A.entity_id=B.entity_id WHERE B.attribute_id limit 4 ")

row = cursor.fetchall()

如何在python查询中使用while循环