从python的“自下而上”从sqlite数据库打印到文本框

Question

下面的代码将循环通过光标并打印到文本框。它将下一行向下推，并在其上方打印下一个线。我不确定如何将其逆转或将其放在下一行，而不是在文本框中。

 def favorite_store(self):
    self.text.delete("1.0", "end")
    cursor = con.execute("""SELECT lastName, firstName
 FROM person JOIN stores ON (favoriteStore = stores.storeID)
 where storeName = 'Total Wine'""")
    for row in cursor:
        self.text.insert(0.0, (row[0], row[1]), )
        self.text.insert(0.0,"n")

这是代码的输出：

Casey Mick
Cohen Jessica
Washington Martha

应打印为：

Washington Martha
Cohen Jessica
Casey Mick

Answer 1

def favorite_store(self):
    self.text.delete("1.0", "end")
    cursor = con.execute("""SELECT lastName, firstName
 FROM person JOIN stores ON (favoriteStore = stores.storeID)
 where storeName = 'Total Wine' ORDER BY lastName DESC, firstName DESC""")
    for row in cursor:
        self.text.insert(0.0, (row[0], row[1]), )
        self.text.insert(0.0,"n")