2016May Python学习笔记
MySQL安装及设置
- MAC下安装与配置MySQL
[其中包含MySQL Workbench可视化工具的介绍及安装] - 清除mysql管理员root密码
- 更改root密码时,MySQL user DB does not have password columns
MySQL命令
- mac进入mysql命令:
mysql -u root -p - 查看所有数据库:show databses; (会显示所有的数据库)
- 进入某个数据库: use mytest; (会提示database changed)
- 查看所有表格: show tables;(会显示mytest中的所有表格)
参考资料:
- 在mac系统下使用mysql数据库命令
MySQLdb
MySQLdb
Python 连接 MySQL 的模块。 MySQL versions 3.23-5.1; and Python versions 2.3-2.5 are supported.百度百科
可以参见例子:
#coding=utf-8
import MySQLdb
import hashlib
class UserInfoDao():
def __init__(self):
self.conn1 = MySQLdb.connect('localhost', 'root', 'root', 'MYTEST')
self.cur1 = self.conn1.cursor()
def get_admin(self):
self.cur1.execute('select Users.Username,Users.Password from Users,Grants \
where Users.UserID = Grants.UserID and Grants.Right = 1')
result1 = self.cur1.fetchall()
return result1
def get_user(self):
self.cur1.execute('select Username,Password from Users')
result1 = self.cur1.fetchall()
return result1
def get_right(self,Username):
sqlstr = 'select Grants.Right from Users,Grants where Users.UserID = Grants.UserID and '\
+'Users.Username = "'+ Username + '"'
self.cur1.execute(sqlstr)
result1 = self.cur1.fetchall()
return result1
def first_insert(self):
users = [['monkey','admin','1'],['test1','123456','2'],['test2','123456','3'],['test3','123456','4']]
for x in users:
hash_md5 = hashlib.md5(x[1])
x[1] = hash_md5.hexdigest()
for x in users:
sqlstr = 'insert into Users values ("' + x[0]+'","'+x[1]+'","'+x[2]+'")'
#print sqlstr
self.cur1.execute(sqlstr)
self.conn1.commit()
def __del__(self):
self.cur1.close()
self.conn1.close()
if __name__ == '__main__':
F = UserInfoDao()
F.first_insert()
Flask学习
使用flask模块
PS:关于flask-login
- Before 0.3.0
use current_user.is_authenticated() - Since 0.3.0
use current_user.is_authenticated
- Before 0.3.0
html中render_template传参
<!DOCTYPE html>
<br lang="en">
<head>
<meta charset="UTF-8">
<title>用户界面</title>
</head>
<a href="index">Home</a>
<body align="center">
{% for message in message_list %}
{% if message %}
<br><br><br>
<font size="8" color="black">{{message}}</font>
{% endif %}
{% endfor %}
</body>
</html>
其他
工具
工作画图
conda
Anaconda is the leading open data science platform powered by Python. The open source version of Anaconda is a high performance distribution of Python and R and includes over 100 of the most popular Python, R and Scala packages for data science. Additionally, you’ll have access to over 720 packages that can easily be installed with conda, our renowned package, dependency and environment manager, that is included in Anaconda. Anaconda is BSD licensed which gives you permission to use Anaconda commercially and for redistribution.