def loginto():
aa= MySQLdb.connect(host='127.0.0.1',port= 3306,user="******",passwd="010905885",db="kitpage")
mm = aa.cursor()
username = e1.get()
password = e2.get()
mm.execute('SELECT * FROM singup WHERE username = %s AND passwords = %s', (username, password))
for i in username:
print i
if mm.fetchall():
tkMessageBox.showinfo("Welcome to %s" %username, "Let GO")
R.destroy()
master = Tk()
tframe = Frame(master)
tframe.pack()
table = TableCanvas(tframe)
table.createTableFrame()
model = TableModel()adf
table = TableCanvas(tframe, model=model)
master.mainloop()
else:
tkMessageBox.showinfo("Sorry" , "Wrong Password")
def show_transaction_table(frame, frame1):
model = TableModel()
transactionItems = transactions_database.getData()
data = {}
data1 = {}
totalSale = 0.0
for i in range(len(transactionItems)):
totalSale += float(transactionItems[i][1])
for i in range(len(transactionItems)):
data['row' + str(i + 1)] = {
'Name': transactionItems[i][0],
'S.Price': transactionItems[i][1],
'Date': transactionItems[i][2]
}
data1['row1'] = {'Total ($)': totalSale}
table1 = TableCanvas(frame1, data=data1, takefocus=0)
table = TableCanvas(frame, data=data, takefocus=0)
table.show()
table1.show()
def redraw_tables(self):
# Create a new frame for the TableCanvas.
tframe = ttk.Frame(self)
tframe.grid(row=1, columnspan=4, padx=10, pady=10)
self.table = TableCanvas(
tframe,
data={
1: {
"name": "",
"amount": "",
"barcode": "",
"price_piece": ""
}
},
width=1300,
height=600,
cellwidth=325,
rowheight=40,
rowheaderwidth=60, # To hide; set value to 0.
read_only=True,
rowselectedcolor=None, # Get rid of the row selection.
selectedcolor=None, # Get rid of the cell selection.
thefont=('Arial', 14),
)
self.table.show()
def __init__(self, root, model, controller):
self.model = model
self.root = root
self.controller = controller
self.popup = Popup(model)
# Table setup
self.frame_table = tk.Frame(root)
self.table = TableCanvas(self.frame_table)
self.table.show()
self.frame_table.pack(side=tk.LEFT, fill=tk.BOTH, expand=True)
# Buttons setup
self.frame_buttons = tk.Frame(root)
# Event handlers
self.btn_open = tk.Button(self.frame_buttons, text="Open", command=self.controller.openFile)
self.btn_search = tk.Button(self.frame_buttons, text="Search", command=self.controller.findValue)
self.btn_statistics = tk.Button(self.frame_buttons, text="Statistics", command=self.controller.getMinMax)
self.btn_plot = tk.Button(self.frame_buttons, text="Show plot", command=self.controller.openPlot)
# Grid setup
self.btn_open.grid(row=0, column=0, sticky="ew", padx=5, pady=5)
self.btn_search.grid(row=1, column=0, sticky="ew", padx=5, pady=5)
self.btn_statistics.grid(row=2, column=0, sticky="ew", padx=5, pady=5)
self.btn_plot.grid(row=3, column=0, sticky="ew", padx=5, pady=5)
self.frame_buttons.pack(side=tk.LEFT, fill=tk.BOTH)
#Window setup
self.root.rowconfigure(0, minsize=800, weight=1)
self.root.columnconfigure(1, minsize=800, weight=1)
self.root.title("Log viewer")
def read_csv(self):
#reads csv and displays table using tkintertable
self.tframe = Frame(self.window)
self.tframe.place(x=1200, y=350, width=600)
self.table = TableCanvas(self.tframe)
self.table.importCSV(self.csv_path)
self.table.show()
def demo2(root):
frame = Frame(root)
frame.pack()
model = TableModel()
model.importDict(data)
table = TableCanvas(frame, model=model)
table.createTableFrame()
def update_table(self):
try:
temp_dict = {}
for meas in self.meas_array:
with self.session.initiate():
measurement_stat = self.session.channels[
self.config_channels].fetch_measurement_stats(
niscope.enums.ScalarMeasurement[meas], 5.0)
for stat in measurement_stat:
inner_temp_dict = {}
inner_temp_dict["Measurement"] = meas
inner_temp_dict["Channel"] = stat.channel
inner_temp_dict["Result"] = stat.result
inner_temp_dict["Mean"] = stat.mean
inner_temp_dict["StDev"] = stat.stdev
inner_temp_dict["Min"] = stat.min_val
inner_temp_dict["Max"] = stat.max_val
inner_temp_dict["Num in Stats"] = stat.num_in_stats
key = meas + "_" + stat.channel
temp_dict[key] = inner_temp_dict
self.table = TableCanvas(self.table_frame,
data=temp_dict,
read_only=True)
self.table.show()
except Exception as e:
self._set_message(str(e))
def CreateTable(Main, Data):
tframe = tk.Frame(Main,
bg ="blue",
highlightcolor = "blue")
tframe.place(x = 50, y =275,
height = 275, width =1100)
rec, col = Data.shape
aux = dict()
data = dict()
for i in range(rec):
for j in range(col):
aux [Data.columns[j]] = Data.values[i,j]
data['rec'+str(i+1)] = aux.copy()
model = TableModel()
table = TableCanvas(tframe, cellbackgr='white',
thefont=('Arial',12, ), cellwidth = 100 ,
rowheight=25, rowheaderwidth=30,
rowselectedcolor='yellow', editable=False,
model = model)
table.createTableFrame()
model = table.model
model.importDict(data)
table.show()
return table, model
def redraw_tables(self):
try:
# The data from th API.
request = requests.get("http://127.0.0.1:8000/products/",
auth=("gabriel", "1"))
# Transform the API's data to the TableCanvas' form.
# Use the unique index for the rows in the TableCanvas.
data = {}
for i in request.json():
data[request.json().index(i)] = i
# Create a new frame for the TableCanvas.
tframe = ttk.Frame(self)
tframe.grid(row=1, columnspan=4, padx=10, pady=10)
self.table = TableCanvas(
tframe,
data=data,
read_only=True,
width=1300,
height=600,
cellwidth=325,
rowheight=40,
rowheaderwidth=60, # To hide; set value to 0.
rowselectedcolor=None, # Get rid of the row selection.
selectedcolor=None, # Get rid of the cell selection.
thefont=('Arial', 15),
)
self.table.show()
except:
messagebox.showerror("API Error", "The api isn't running.")
def conv_to_csv(self):
self.f = Frame(root, height=300, width=300)
self.f.pack(fill=BOTH, expand=1)
self.table = TableCanvas(self.f, read_only=True)
self.table.importCSV('empsal.csv')
self.table.show()
def MenuAssignments():
AssignmentsWindow = tk.Toplevel(window)
AssignmentsWindow.title("Replenisher Assignments")
AssignmentsWindow.geometry('800x500')
UserList = [
"User Selection",
"User1",
"User2",
"User3"
]
UserVariable = StringVar(AssignmentsWindow)
UserVariable.set(UserList[0]) # default value
UserOptionMenu = tk.OptionMenu(AssignmentsWindow, UserVariable, *UserList)
UserOptionMenu.pack()
TaskList = [
"Task Selection",
"Task1",
"Task2",
"Task3"
]
TaskVariable = StringVar(AssignmentsWindow)
TaskVariable.set(TaskList[0]) # default value
TaskOptionMenu = tk.OptionMenu(AssignmentsWindow, TaskVariable, *TaskList)
TaskOptionMenu.pack()
def AddUserTask():
tkMessageBox.showinfo('Add User and Task', "Added User: "******"; " + "Added Task: " + TaskVariable.get() )
AddUserTaskBT = tk.Button(AssignmentsWindow, text="Add User and Task", command=AddUserTask)
AddUserTaskBT.pack()
#Add a table
'''
RowNum = 2
ColNum = 2
for i in range(RowNum):
for j in range(ColNum):
b = tk.Entry(AssignmentsWindow, text="")
b.grid(row=i, column=j)
b.pack()
'''
#To use tkintertable
tframe = tk.Frame(AssignmentsWindow)
tframe.pack()
model = TableModel()
table = TableCanvas(tframe, model=model)
table.createTableFrame()
model = table.model
data = {'rec1': {'User': '******', 'Task': 'Task1', 'Status': 'Open', 'Rank': 1, 'Priority': 'High', 'Start Time': '05-19-2018 10:30', 'Finish Time': ''},
'rec2': {'User': '******', 'Task': 'Task2', 'Status': 'Open', 'Rank': 2, 'Priority': 'Low', 'Start Time': '05-19-2018 11:30', 'Finish Time': '05-19-2018 22:30'},
'rec3': {'User': '******', 'Task': 'Task3', 'Status': 'Open', 'Rank': 3, 'Priority': 'Low', 'Start Time': '05-19-2018 12:30', 'Finish Time': '05-19-2018 22:45'}
}
model.importDict(data) #Import from a dictionary to populate model
table.redrawTable()
AssignmentsWindow.mainloop()
def display_leaderboard(self):
self.cursor.execute(
'SELECT player.username, MAX(data.kills) AS kills, data.date FROM data INNER JOIN player ON data.playerID = player.playerID GROUP BY username limit 0, 10 '
)
result = self.cursor.fetchall()
data = Convert(result)
kills_dict = dict()
for key in data:
data_value = list(data[key].values())
kills_dict[key] = data_value[1]
kills_dict = mergeSortDict(kills_dict, ascending=False)
final_dict = dict()
for key in kills_dict:
final_dict[key] = data[key]
tframe = Frame(self.my_w)
tframe.pack()
model = TableModel()
table = TableCanvas(tframe,
model=model,
data=final_dict,
editable=False,
width=800,
height=300)
table.show()
self.my_w.mainloop()
def __init__(self,root):
self.f=Frame(root,height=200,width=100)
self.f.pack(fill=BOTH,expand=1)
self.table=TableCanvas(self.f,read_only=True)
self.table.importCSV('/media/amit/Work/GitHub/Machine Learning with Python/DataSets/empsal.csv')
print(self.table.model.columnNames)
self.table.show()
def initFrame(self):
# *****界面区*****
# 布局参数
params = ['row','column','rowspan','columnspan']
gridMap = {'label':(0,0),
'entry':(0,1),
'search_button':(0,2),
'table':(1,1,None,3),
'next_page':(2,1),
'modify':(2,2),
'corfirm':(2,3)}
cnfs = {}
for k,vals in gridMap.items():
dic = {}
for i,v in enumerate(vals):
dic[params[i]] = v
cnfs[k] = dic
ttk.Label(self, text='搜索', style="BW.TLabel").grid(cnfs['label'])
self.keyword = tk.StringVar() # 搜索框
tk.Entry(self, borderwidth=3, width=40, textvariable=self.keyword, selectbackground='gray').grid(cnfs['entry'])
ttk.Button(self, text='搜索', command="", width=9).grid(cnfs['search_button'])
frame = tk.Frame(self)
frame.grid(cnfs['table'])
model = TableModel()
self.table = TableCanvas(frame,model)
self.table.show()
ttk.Button(self, text='下一页', command="", width=9).grid(cnfs['next_page'])
ttk.Button(self, text='设为组合', command=self.set_combo, width=9).grid(cnfs['next_page'],sticky=tk.E)
ttk.Button(self, text='修改', command=self.modify, width=9).grid(cnfs['modify'])
ttk.Button(self, text='选择', command=self.choic, width=9).grid(cnfs['corfirm'])
def DataGrid(xValues, yValues):
## setup window
dataGrid = Tk()
dataGrid.wm_title("Data")
## setup frame
frame = Frame(dataGrid)
frame.pack()
label = Label(dataGrid,
text=("Showing %.0f data points" % len(xValues)),
font=("Verdana", 12))
label.pack(pady=5, padx=10)
dataDict = {}
## iterate through time
for i in range(0, len(xValues)):
xVal = ("%.2f" % float(xValues[i]))
yVal = ("%.2f" % float(yValues[i]))
dataDict[xVal] = {"Time (s)": xVal, "Height (m)": yVal}
model = TableModel()
model.importDict(dataDict)
model.moveColumn(model.getColumnIndex('Time (s)'), 0)
table = TableCanvas(frame, model=model, editable=False)
table.createTableFrame()
## order by time
table.sortTable(columnName='Time (s)')
dataGrid.mainloop()
def __init__(self,tktk = None,
br_image = None,
pathico = None,
br_image_path = None):
Frame.__init__(self, tktk)
self.tktk = tktk
self.br_image_path = br_image_path
self.br_image = br_image
self.pathico = pathico
self.filewin = Toplevel(self.tktk)
gui (tktk=self.filewin,
pathico=self.pathico,
width=1280,
height=1024,
widthx=300,
widthy=0,
resizable=[True,True]).setcfbs()
# set data
data = createData()
menu (tktk=self.filewin).createmenu()
#create label
self.framelb = Frame(self.filewin,bg = "slate gray")
self.framelb.pack(side = TOP)
#creare frame for infomation
self.frameinfor = Frame(self.filewin,bg = "slate gray")
self.frameinfor.pack(side = TOP)
#create title
self.framett = Frame(self.filewin,bg = "slate gray")
self.framett.pack(side = TOP)
# creare frame for table
self.tframe = Frame(self.filewin)
self.tframe.pack(fill = X,side = TOP)
model = TableModel()
table = TableCanvas(self.tframe, model=model,data=data,height=650)
table.show()
#update quotation
self.frameupdate = Frame(self.filewin,bg = "slate gray")
self.frameupdate.pack(side = TOP)
# import and export excel
self.frameimeex = Frame(self.filewin,bg = "slate gray")
self.frameimeex.pack(side = TOP)
self.createguiin()
def __init__(self, root):
self.f = Frame(root, height=200, width=300)
self.f.pack(fill=BOTH,expand=1)
self.table = TableCanvas(self.f, read_only=True)
self.table.importCSV('exp_sal.csv')
print (self.table.model.columnNames)
self.table.show()
def table_gui(data):
tframe = Frame(master)
tframe.pack()
table = TableCanvas(tframe)
table.show()
#if __name__ == '__main__': main()
def demo3(root):
frame = Frame(root)
frame.pack()
model = TableModel()
model.importDict(data)
table = TableCanvas(frame, model=model)
table.createTableFrame()
table.model.data['rec2']['col2'] = 50
table.redrawTable()
def ClearTable():
DataTracking.Question = []
DataTracking.Answers = []
DataTracking.Correct = []
Data = {}
model = TableModel()
table = TableCanvas(tframe, data=Data)
table.show()
def __init__(self, master=None):
Frame.__init__(self, master)
self.pack()
self.configure(width=1250, height=500)
self.frCal = Frame(self)
self.frCal.place(relx=0, rely=0)
self.frCal.configure(bd=1, relief=RAISED)
self.calWidget = tkcalendar.Calendar(self.frCal,
showweeknumbers=False,
locale="ru_RU",
maxdate=self.today)
self.calWidget.pack()
self.calWidget.bind('<<CalendarSelected>>', self.getDate)
self.dayDataFrame = Frame(self)
self.dayDataFrame.grid_propagate(0)
self.dayDataFrame.place(relx=0, rely=1, anchor=SW)
self.dayDataFrame.configure(width=1250,
height=300,
bd=1,
relief=RAISED)
self.tableModel = TableModel()
self.table = TableCanvas(self.dayDataFrame,
cellwidth=300,
model=self.tableModel,
rowheight=25)
self.table.show()
self.drawFrame = Frame(self)
self.drawFrame.grid_propagate(0)
self.drawFrame.place(relx=1, rely=0, anchor=NE)
self.drawFrame.configure(width=966, height=200, bd=1, relief=RAISED)
self.createCanvas()
self.dateList = []
self.hourUsed = [0 for i in range(24)]
self.strInfo = StringVar()
self.labelInfo = Label(self,
textvariable=self.strInfo,
width=30,
height=1,
bg='white',
bd=1,
relief=RAISED,
font='Arial 10')
self.strInfo.set('Test')
self.labelInfo.place(x=0, y=175)
self.createFileList()
self.createTable()
self.readReportFile(self.today)
def __init__(self, parent=None):
self.parent = parent
Frame.__init__(self)
self.main = self.master
self.main.geometry('800x500+0+0')
self.main.title('Sequences of Shifts')
f = Frame(self.main)
f.pack(fill=BOTH,expand=1)
self.table = TableCanvas(f, data=data, cellwidth=150, cellbackgr='#E3F6CE',read_only=True,rowselectedcolor='yellow',rowheaderwidth=100,showkeynamesinheader=True)
self.table.show()
return
def LoadWebPage():
HtmlFile = filedialog.askopenfilename()
File = open(HtmlFile, encoding='utf-8')
soup = BeautifulSoup(File.read(), features="html.parser")
Data = GetQuestions.GetAnswers(soup)
model = TableModel()
table = TableCanvas(tframe, data=Data)
table.thefont = ('Arial', 10)
table.show()
def demo5(root):
frame = Frame(root)
frame.pack()
table = TableCanvas(frame,
rowheaderwidth=0,
cellwidth=150,
rowheight=20,
editable=False,
rowselectedcolor='red',
reverseorder=1)
table.createTableFrame()
def conv_to_csv(self):
try:
# Now display the CSV in 'tkintertable' widget
self.f = Frame(root, height=200, width=300)
self.f.pack(fill=BOTH, expand=1)
self.table = TableCanvas(self.f, read_only=True)
self.table.importCSV('exp_sal.csv')
self.table.show()
except FileNotFoundError as e:
msg.showerror('Error in opening file', e.msg)
def display_excel(self):
try:
stock_price_df=pd.read_excel('E:\project5\stock_price.xls', sheet_name='Stock')
stock_price_df.to_csv('E:\project5\stock_price.csv', index=False)
# Now display the csv in 'tkintertable' widget
self.f= Frame(root,height=200 , width=300)
self.f.pack(fill=BOTH, expand=1)
self.table= TableCanvas(self.f , read_only=True)
self.table.importCSV('E:\project5\stock_price.csv')
#print(self.table.mode1.columnNames)# to print column names in IDLE shell
except FileNotFoundError as e:
print(e)
def __init__(self, parent=None):
self.parent = parent
Frame.__init__(self)
self.main = self.master
self.main.geometry('800x500+200+100')
self.main.title(weather)
f = Frame(self.main)
f.pack(fill=BOTH, expand=1)
table = TableCanvas(f, data=data2)
# table.redrawTable()
# table.model.data[0]['col1'] = 'XX'
# print(table.model.columnNames)
table.show()
return
def demo4(root):
frame = Frame(root)
frame.pack()
model = TableModel()
model.importDict(data)
table = TableCanvas(frame,
model=model,
rowheaderwidth=0,
cellwidth=150,
rowheight=20,
editable=False,
rowselectedcolor='red',
reverseorder=1)
table.createTableFrame()
def drawEnemyFleetTable(self):
self.model = TableModel()
self.table = TableCanvas(self.EnemyFleet,
model=self.model,
cellwidth=50,
cellbackgr='white',
thefont=self.tkFont,
rowheight=16,
editable=True,
rowselectedcolor='white',
reverseorder=1)
self.table.createTableFrame()
self.table.model.columnNames = ['A', 'B', 'C', 'D', 'E']
self.table.redrawTable
self.iniEnemyFleet()
def __init__(self, parent=None):
self.parent = parent
Frame.__init__(self)
self.main = self.master
self.main.geometry('800x500+200+100')
self.main.title('Test')
f = Frame(self.main)
f.pack(fill=BOTH, expand=1)
table = TableCanvas(f, data=data)
# table.importCSV('test.csv')
print(table.model.columnNames)
# table.model.data[1]['a'] = 'XX'
# table.model.setValueAt('YY',0,2)
table.show()
return
