已然大四，想当初大一时在某处听大神教诲：
大学四年写足十万行代码，码路遂成；前几天想想是该把欠下的码量补上了，于是花了一个晚上写了个代码量记录器，其实也很简单：用Python写个简陋的展示界面和与数据库交互的按钮，用MySQL保存插入的数据；
-
大概就是这样子：
1.png
2.png
- 码量一行填入要提交的代码量，语言默认是C++，备注自己标注，点击commit按钮则提交， refresh按钮从数据库读取数据并刷新页面；
- 建表语句是：
create table codeRecord
(
code_id int auto_increment,
code_date date not null default now(),
code_line int not null default 0,
code_type varchar(10) not null default 'C++',
code_comment varchar(20) default " ",
primary key(code_id)
)engine=innodb default charset=utf8;
Python版本是2.7 ，UI是用Python自带的tkinter库写的，虽然有点难看，但自己用也还凑合，与MySQL进行交互的库是用mysql-connector-python，这个是第三方的，需要自己下载并安装到环境里，Google一番很容易；
用数据库表记录下插入的记录，方便以后做各种统计和分析
下面直接把代码贴上来吧：
#!/usr/bin/python
# -*- coding:UTF-8 -*-
from Tkinter import *
import tkFont
import mysql.connector as mariadb
codeTool = Tk()
config = {
'host':'127.0.0.1', # 如果是跑在本地
'user':'xxxx', # 数据库用户名
'password':'xxxxx', # 数据库密码
'port':3306,
'database':'xxxxx', # 数据库名
'charset':'utf8'
}
feedbackText = StringVar()
feedbackText.set(' ')
codeLineText = StringVar()
codeTypeText = StringVar()
codeCommentText = StringVar()
codeTodayText = StringVar()
codeTotalText = StringVar()
def func_GUI(codeTool):
codeTool.title("十万行代码")
codeTool.minsize(400, 300)
# 字体
labFont = tkFont.Font(family='Fixdsys', size=25, weight=tkFont.BOLD)
codeLineLab = Label(codeTool, text="码量: ", font=labFont)
codeLineEnt = Entry(codeTool, textvariable=codeLineText)
codeTypeLab = Label(codeTool, text="语言(默认:C++): ")
codeTypeEnt = Entry(codeTool, textvariable=codeTypeText)
codeCommentLab = Label(codeTool, text="备注(默认为空): ")
codeCommentEnt = Entry(codeTool, textvariable=codeCommentText)
codeCommitBtn = Button(codeTool, text='Commit', command=func_codeCommit, width=6)
codeRefreshBtn = Button(codeTool, text='Refresh', command=func_codeRefresh, width=6)
showFont = tkFont.Font(size=40, weight=tkFont.BOLD)
codeTodayLab = Label(codeTool, text="今日代码量: ", font=labFont)
codeTodayNum = Label(codeTool, text=" ", textvariable=codeTodayText, font=showFont)
codeTotalLab = Label(codeTool, text="总代码量: ", font=labFont)
codeTotalNum = Label(codeTool, text=" ", textvariable=codeTotalText, font=showFont)
codeFeedbackLab = Label(codeTool, text='连接错误', textvariable=feedbackText)
codeLineLab.grid(row=0, column=0)
codeLineEnt.grid(row=0, column=1)
codeTypeLab.grid(row=1, column=0)
codeTypeEnt.grid(row=1, column=1)
codeCommentLab.grid(row=2, column=0)
codeCommentEnt.grid(row=2, column=1)
codeCommitBtn.grid(row=3, column=0)
codeRefreshBtn.grid(row=3, column=1)
codeTodayLab.grid(row=4, column=0)
codeTodayNum.grid(row=4, column=1)
codeTotalLab.grid(row=5, column=0)
codeTotalNum.grid(row=5, column=1)
codeFeedbackLab.place(x=10, y=250)
return codeTool
def func_codeRefresh():
try:
conn = mariadb.connect(**config)
except Exception , e:
print e
feedbackText.set('连接失败')
conn.close()
return
cursor = conn.cursor()
sqlToday = "select sum(code_line) as code_line from codeRecord where code_date = curdate();"
sqlTotal = "select sum(code_line) as code_line from codeRecord;"
try:
cursor.execute(sqlToday)
for cl in cursor:
tVal = cl[0] if cl[0] else "0"
codeTodayText.set(tVal)
cursor.execute(sqlTotal)
for cl in cursor:
tVal = cl[0] if cl[0] else "0"
codeTotalText.set(tVal)
except Exception , e:
feedbackText.set('查询错误')
cursor.close()
conn.close()
cursor.close()
conn.close()
def func_codeCommit():
try:
conn = mariadb.connect(**config)
except Exception, e:
print e
feedbackText.set('连接失败')
conn.close()
return
cursor = conn.cursor()
codeNum = codeLineText.get()
codeType = codeTypeText.get()
codeComment = codeCommentText.get()
codeType = "C++" if codeType=="" else codeType
codeComment = "forFun" if codeComment=="" else codeComment
sql = "insert into codeRecord(code_line, code_type, code_comment) values(%s, %s, %s);"
param = (codeNum, codeType, codeComment)
try:
cursor.execute(sql, param)
conn.commit()
except Exception, e:
print e
feedbackText.set('插入失败')
cursor.close()
conn.close()
return
feedbackText.set('插入成功:'+codeNum)
cursor.close()
conn.close()
#更新下数据
func_codeRefresh()
if __name__ == "__main__":
func_GUI(codeTool)
codeTool.mainloop()
- 代码很简单，一看便知；
