import sqlite3
import datetime
from tkinter import *
link = sqlite3.connect('mydb.db')
cursor = link.cursor()
cursor.execute('''CREATE TABLE IF NOT EXISTS albums (
                 id INT,
                 title VARCHAR(25),
                 artist VARCHAR(25),
                 release_date VARCHAR(25),
                 publisher VARCHAR(25),
                 media_type VARCHAR(25),
                 PRIMARY KEY (id)
              ) ''')
link.commit()
root = Tk()
root.title('Добавление данных в таблицу')
root.geometry('351x151+300+300')

Add_name = Label(root, text='Добавить имя')
Add_name.grid(row=0, column=0)
Name = Entry()
Name.grid(row=1, column=0)
Add_Art = Label(root, text='Добавить артиста')
Add_Art.grid(row=2, column=0)
Art  = Entry()
Art.grid(row=3, column=0)

pubOpt = ['Xplore', 'Spinnin', 'RusRec', 'Records']
pub = StringVar()
pub.set(pubOpt[0])
medOpt = ['MP3', 'WAV','WMA','OGG']
var1 = StringVar()
var1.set(medOpt[0])
media_type = OptionMenu(root, var1, 'MP3', 'WAV','WMA','OGG').grid(row=1, column=1)
publisher = OptionMenu(root, pub,*pubOpt).grid(row=1, column=2)


def insertData():
    cursor.execute('''SELECT MAX(id) FROM albums''')
    last_id = cursor.fetchone()[0]
    now = datetime.datetime.now().strftime('%d-%m-%Y')
    x = last_id, Name.get(), Art.get(), now, pub.get(), var1.get()
    sql = 'INSERT INTO albums VALUES (?, ?, ?, ?, ?, ?)'
    cursor.execute(sql, x)
    link.commit()
    print('Данные успешно добавлены!')

def state():
    print(Name.get(),Art.get(),var1.get(),pub.get())


Button(root, command=insertData, text='Добавить в бд').grid(row=3, column=2)

root.mainloop()