# -*- coding: utf-8 -*-

import sqlite3
import Tkinter
import Image
import ImageTk

def insimg():
#    c.delete(slide)
    cu.execute('select imgdb from dbimg where id = 1')
    for row in cu:
        fileimg1 = row[0]
    img = ImageTk.PhotoImage(data = fileimg1)
    c.create_image(0, 0, image=img, anchor="nw")
    
        
cc = sqlite3.connect(database="files.s3db")
cu = cc.cursor()
    
tup = Tkinter.Tk()
F = Tkinter.Frame(tup)
F.pack()
numfiles = Tkinter.StringVar()

# Номер изображения
s1 = Tkinter.Spinbox(F, from_=0, to=72, textvariable=numfiles, command = insimg)
s1.grid(row=0, column=0)

# Выводим изображение
c = Tkinter.Canvas(F, width=32, height=32)
c.grid(row=1, column=0)
# ---------------------
cu.execute('select imgdb from dbimg where id = 0')
for row in cu:
    fileimg = row[0]
# ---------------------

#src_img = Image.open(r'C:\BASE\baseico\ico_00.bmp')

img = ImageTk.PhotoImage(data = fileimg)
slide = c.create_image(0, 0, image=img, anchor="nw")


#Закрываем GUI                               
btclose = Tkinter.Button(F, text = u'Закрыть', command = lambda: tup.destroy())
btclose.grid(row=2, column=0)

tup.mainloop()
cc.close()