import tkinter as tk
from tkinter import ttk
import sqlite3
import pprint

def show():
    con = sqlite3.connect('kml.db')
    cur = con.cursor()
    cur.execute("SELECT * from `track`")

    tempList = cur.fetchall()
    print("\n", flush=True)
    pp = pprint.PrettyPrinter(indent=4)
    pp.pprint(tempList)
    print("\n", flush=True)
    
    for count, value in enumerate(tempList):
    	print(count, value, flush=True)
    	tree.insert('', tk.END, values=value)

tracks      = tk.Tk() 

columns     = ('ID', 'Name', 'Date')
tree        = ttk.Treeview(tracks, columns=columns, show='headings')
tree.heading('ID',   text='ID')
tree.heading('Name', text='Track Name')
tree.heading('Date', text='Track Date')

tree                                                                        .grid(row=2, columnspan=3)
label       = tk.Label  (tracks, text="Tracks",      font=("Arial",20))     .grid(row=0, columnspan=3)
showScores  = tk.Button (tracks, text="Show tracks", width=15, command=show).grid(row=1, column=0)
closeButton = tk.Button (tracks, text="Close",       width=15, command=exit).grid(row=1, column=1)

tracks.mainloop()