廖雪峰实战_1day

使用conda创建虚拟环境

查看当前虚拟环境

conda info --envs

创建python=3.7 的虚拟环境

conda create -n venv python=3.7

激活venv虚拟环境

conda activate venv # source activate venv

退出venv虚拟环境

conda deactivate # source deactivate

查看当前虚拟环境安装包

conda list

安装必要包aiohttp,jinja2

pip install aiohttp jinja2	

安装mysql5.7

# 安装mysql server
sudo apt-get install mysql-server
# 安装mysql客户端
sudo apt install mysql-client
# 安装依赖
sudo apt install libmysqlclient-dev
# 检查状态
sudo netstat -tap | grep mysql #command netstat not found
# 安装net-tools
sudo apt-get install net-tools
# 安装图形化工具workbench
sudo apt-get install mysql-workbench

解决本地账户不能登陆mysql问题（root可登陆）

$ sudo su
# mysql
mysql>
mysql> select user, plugin from mysql.user;
+------------------+-----------------------+
| user             | plugin                |
+------------------+-----------------------+
| root             | auth_socket           |
| mysql.session    | mysql_native_password |
| mysql.sys        | mysql_native_password |
| debian-sys-maint | mysql_native_password |
+------------------+-----------------------+
4 rows in set (0.00 sec)
mysql> update mysql.user set authentication_string=PASSWORD('password'), plugin='mysql_native_password' where user='root';
mysql> flush privileges;
mysql> exit
Bye
$ sudo /etc/init.d/mysql restart
$ mysql -uroot -p

配置mysql远程登陆

# 注销bind-address = 127.0.0.1
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
# 保存并退出 进入mysql服务，进行授权命令
mysql -uroot -p
mysql> grant all on *.* to root@'%' identified by 'password' with grant option;
mysql> flush privileges;
mysql> exit
#重新启动mysql服务
sudo /etc/init.d/mysql restart

防火墙开启3306端口

# 开启或者关闭防火墙
sudo ufw enable/disable
# 添加允许规则
sudo ufw allow 3306/tcp
#查看已添加规则
sudo ufw status

Status: active

To                         Action      From
--                         ------      ----
3306/tcp                   ALLOW       Anywhere                  
3306/tcp (v6)              ALLOW       Anywhere (v6)   

安装Mysql的python异步驱动程序aiomysql

pip install aiomysql

创建本地目录

awesome-python3-webapp/  <-- 根目录
|
+- backup/               <-- 备份目录
|
+- conf/                 <-- 配置文件
|
+- dist/                 <-- 打包目录
|
+- www/                  <-- Web目录，存放.py文件
|  |
|  +- static/            <-- 存放静态文件
|  |
|  +- templates/         <-- 存放模板文件
|
+- ios/                  <-- 存放iOS App工程
|
+- LICENSE               <-- 代码LICENSE # 不知道怎么引入

同步到github

本地建git仓库

#进入awesome-python3-webapp，进行git
cd awesome-python3-webapp
git init
# 添加readme.txt &LICENSE.txt
touch readme.txt
touch LICENSE.txt
# 添加并提交
git add readme.txt
git add LICENSE.txt
git commit -m "add two  txt files"

Github新建仓库

# 命令行将本地仓库推倒远程仓库
git remote add origin https://github.com/Toseefaraway/pythonweb.git
git push -u origin master

创建分支

# 创建分支first_try
git branch first_try
# 切换到分支first_try
git checkout first_try
# 查看当前分支
git branch
# 删除分支
# git branch -d first_try
# 合并分支
# git merge first_try
# 推送分支
git push origin first_try

创建标签

# 查看当前分支
git branch
# 创建标签
git tag v1.0 # git tag -a v1.0 -m “first version ”
# 删除标签
git tag -d v1.0
# 推送标签到github
git push origin v1.1
# 删除github端标签
git push origin :refs/tags/v1.1