2016May Python学习笔记（MySQL&flask）_flask连接mysql数据库可视化workbench-CSDN博客

本文链接：https://blog.csdn.net/coraline_m/article/details/51543298

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
SQLiteManager for mac download
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>

其他

Python smtplib发送邮件

工具

工作画图
- 官网XMind
- omnigraffle
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.
- DOWNLOAD ANACONDA NOW!