|
| 1 | +import sqlite3 |
| 2 | +import tkinter |
| 3 | + |
| 4 | +conn = sqlite3.connect("music.sqlite") |
| 5 | + |
| 6 | +mainWindow = tkinter.Tk() |
| 7 | +mainWindow.title('Music DB Browser') |
| 8 | +mainWindow.geometry('1024x768') |
| 9 | + |
| 10 | +mainWindow.columnconfigure(0, weight=2) |
| 11 | +mainWindow.columnconfigure(1, weight=2) |
| 12 | +mainWindow.columnconfigure(2, weight=2) |
| 13 | +mainWindow.columnconfigure(3, weight=1) # spacer column on right |
| 14 | + |
| 15 | +mainWindow.rowconfigure(0, weight=1) |
| 16 | +mainWindow.rowconfigure(1, weight=5) |
| 17 | +mainWindow.rowconfigure(2, weight=5) |
| 18 | +mainWindow.rowconfigure(3, weight=1) |
| 19 | + |
| 20 | +# ===== labels ===== |
| 21 | +tkinter.Label(mainWindow, text="Artists").grid(row=0, column=0) |
| 22 | +tkinter.Label(mainWindow, text="Albums").grid(row=0, column=1) |
| 23 | +tkinter.Label(mainWindow, text="Songs").grid(row=0, column=2) |
| 24 | + |
| 25 | +# ===== Artists Listbox ===== |
| 26 | +artistList = tkinter.Listbox(mainWindow) |
| 27 | +artistList.grid(row=1, column=0, sticky='nsew', rowspan=2, padx=(30, 0)) |
| 28 | +artistList.config(border=2, relief='sunken') |
| 29 | + |
| 30 | +artistScroll = tkinter.Scrollbar(mainWindow, orient=tkinter.VERTICAL, command=artistList.yview) |
| 31 | +artistScroll.grid(row=1, column=0, sticky='nse', rowspan=2) |
| 32 | +artistList['yscrollcommand'] = artistScroll.set |
| 33 | + |
| 34 | +# ===== Albums Listbox ===== |
| 35 | +albumLV = tkinter.Variable(mainWindow) |
| 36 | +albumLV.set(("Choose an artist",)) |
| 37 | +albumList = tkinter.Listbox(mainWindow, listvariable=albumLV) |
| 38 | +albumList.grid(row=1, column=1, sticky='nsew', padx=(30, 0)) |
| 39 | +albumList.config(border=2, relief='sunken') |
| 40 | + |
| 41 | +albumScroll = tkinter.Scrollbar(mainWindow, orient=tkinter.VERTICAL, command=albumList.yview) |
| 42 | +albumScroll.grid(row=1, column=1, sticky='nse', rowspan=1) |
| 43 | +albumList['yscrollcommand'] = albumScroll.set |
| 44 | + |
| 45 | +# ===== Songs Listbox ===== |
| 46 | +songLV = tkinter.Variable(mainWindow) |
| 47 | +songLV.set(("Choose an album",)) |
| 48 | +songList = tkinter.Listbox(mainWindow, listvariable=songLV) |
| 49 | +songList.grid(row=1, column=2, sticky='nsew', padx=(30, 0)) |
| 50 | +songList.config(border=2, relief='sunken') |
| 51 | + |
| 52 | +# ===== Main loop ===== |
| 53 | +testList = range(0, 100) |
| 54 | +albumLV.set(tuple(testList)) |
| 55 | + |
| 56 | +mainWindow.mainloop() |
| 57 | +print("closing database connection") |
| 58 | +conn.close() |
0 commit comments