コード例 #1
0
 def dataUpdate(self):      
     item = self.box.selection()
     data = []
     for i in self.entryArr:
         data.append(i.get())
     DataFunc.update(self.schemaVar.get(),self.tableVar.get(),self.box.item(item,"values"),*data)
     self.query.destroy()
コード例 #2
0
 def change(self, val):
     tableLbl = Label(self.frame1, text="    Table:")
     tableLbl.grid(row=1, column=2, sticky=W)
     self.button1.grid(row=1,column=4,sticky=W)
     self.button2.grid(row=1,column=5,sticky=W)
     self.button3.grid(row=1,column=6,sticky=W)
     schema = DataFunc.getSchemas()
     self.new = []
     for s in schema:
         temp = (s[0],DataFunc.getTables(s[0]))
         self.new.append(temp)
     for s in self.new:
         if self.schemaVar.get() == s[0]:
             self.schemaCurr = s[1:]
             self.schemaCurr = self.schemaCurr[0]
     self.tableMenu = OptionMenu(self.frame1, self.tableVar,*self.schemaCurr, command=self.change2)
     self.tableMenu.grid(row=1, column=3, sticky=W)
コード例 #3
0
 def change2(self, val):
     self.box.delete(*self.box.get_children())
     self.opVar.set("Show")
     self.columns = []
     
     for table in self.schemaCurr:
         if self.tableVar.get() == table:
             for col in DataFunc.getMetaData(self.new[0],table):
                 self.columns.append(col[0])
     self.box['columns'] = tuple(self.columns)
     for i in self.columns:
         self.box.column(i, minwidth=0, stretch=False)
         self.box.heading(i, text=i)
     data = DataFunc.getData(self.schemaVar.get(),self.tableVar.get())
     n = 0
     for d in data:
         self.box.insert("", "end", n, text=n, values=d)
         n += 1
コード例 #4
0
    def gui(self):
        window = Tk()
        window.title("Gujek Database Application")
        window.configure()
        window.resizable(width=FALSE, height=FALSE)
        window.geometry("{}x{}".format(1000, 400))

        
        
        gojek = PhotoImage(master=window,file="gojek.gif")
        self.photo = Label(window, image=gojek)
        self.photo.grid(row=0, sticky=W)

        self.frame1 = Frame(window)
        self.frame1.grid(row=1, sticky=W)

        enter = Label(self.frame1, text=" ")
        enter.grid(row=0)

        schemaLbl = Label(self.frame1, text="Schema:")
        schemaLbl.grid(row=1, column=0, sticky=W)
        
        self.schemaVar = StringVar()
        sch = []
        temp = DataFunc.getSchemas()
        for i in temp:
            sch.append(i[0])
        self.schemaVar.set(temp[0][0])
        schemaMenu = OptionMenu(self.frame1, self.schemaVar, *sch, command=self.change)
        schemaMenu.grid(row=1, column=1, sticky=W)

        enter2 = Label(window, text = " ")
        enter2.grid(row=2)

        self.tableVar = StringVar()

        self.opVar = StringVar()
        self.button1 = ttk.Button(self.frame1, text='Insert', command=self.insertData)

        self.button2 = ttk.Button(self.frame1, text='Update', command=self.updateData)
        
        self.button3 = ttk.Button(self.frame1, text='Delete',command=self.deleteData)
        


        frame2 = Frame(window)
        frame2.grid(row=3)

        scrolly = Scrollbar(frame2, orient="vertical")
        scrolly.pack(side=RIGHT, fill=Y)
        scrollx = Scrollbar(frame2, orient="horizontal")
        scrollx.pack(fill=X)

        self.box = ttk.Treeview(frame2, columns=("col1", "col2", 'col3'), selectmode="extended", displaycolumns=None) # this is how you set columns
        self.box.pack(side=LEFT, fill=Y)
        self.box.column('#0', stretch=NO, minwidth=0, width=0)

        scrolly.config(command=self.box.yview)
        scrollx.config(command=self.box.xview)
        self.box.config(xscrollcommand=scrollx.set, yscrollcommand=scrolly.set)
        window.mainloop()
コード例 #5
0
 def connect(self):
     DataFunc.connect(self.dbVar.get(),self.uVar.get(),self.passVar.get())
     self.login.destroy()
     self.gui()
コード例 #6
0
 def dataInsert(self):
     data = []
     for i in self.entryArr:
         data.append(i.get())
     DataFunc.insert(self.schemaVar.get(),self.tableVar.get(),*data)
     self.query.destroy()
コード例 #7
0
 def deleteData(self):
     item = self.box.selection()
     current = self.box.item(item, "values")[0]
     DataFunc.delete(self.schemaVar.get(),self.tableVar.get(),current)