<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[aa1384656303的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/aa1384656303</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; aa1384656303]]></copyright><item><title><![CDATA[自动化框架之logbook]]></title><link>https://blog.youkuaiyun.com/aa1384656303/article/details/102429255</link><guid>https://blog.youkuaiyun.com/aa1384656303/article/details/102429255</guid><author>aa1384656303</author><pubDate>Tue, 03 Sep 2019 16:41:00 +0800</pubDate><description><![CDATA[python:利用logbook模块管理日志

1. 模块安装(采用pip命令安装)
    进入cmd命令,输入pip install logbook安装, 安装成功之后采用pip show logbook查看相关信息
2. logbook简介
    http://logbook.readthedocs.io/en/stable/index.html
3. 用法说明
i...]]></description><category></category></item><item><title><![CDATA[xlrd处理Excel数据(读)]]></title><link>https://blog.youkuaiyun.com/aa1384656303/article/details/102429250</link><guid>https://blog.youkuaiyun.com/aa1384656303/article/details/102429250</guid><author>aa1384656303</author><pubDate>Wed, 10 Jul 2019 15:22:00 +0800</pubDate><description><![CDATA[1. 什么是xlrd?
　　python操作excel主要用到xlrd和xlwt这两个库，即xlrd是读excel，xlwt是写excel的库
2. 使用
　　1. 常用单元格中的数据类型　　　

empty（空的)   string（text） number  date  boolean  error  blank（空白表格）


　　2. 文件打开

#文件名以...]]></description><category></category></item><item><title><![CDATA[pandas处理Excel数据]]></title><link>https://blog.youkuaiyun.com/aa1384656303/article/details/102429254</link><guid>https://blog.youkuaiyun.com/aa1384656303/article/details/102429254</guid><author>aa1384656303</author><pubDate>Wed, 10 Jul 2019 15:09:00 +0800</pubDate><description><![CDATA[1. pandas操作Excel表单
　　存在一个Excel文件包含两个sheet页
　　
　　读取Excel文件的两种方式:　


# 方法一, 默认读取第一个表单
import pandas as pd 
df = pd.read_excel("文件名") # 默认打开第一个Excel表单
data = df.head() # 默认读取前五行
print("获取到...]]></description><category></category></item><item><title><![CDATA[django缓存]]></title><link>https://blog.youkuaiyun.com/aa1384656303/article/details/102429249</link><guid>https://blog.youkuaiyun.com/aa1384656303/article/details/102429249</guid><author>aa1384656303</author><pubDate>Mon, 01 Apr 2019 20:45:00 +0800</pubDate><description><![CDATA[1. django中使用缓存需要在settings中配置(缓存方式):　
缓存的本质就是: 提高网站的并发量三种粒度: 全站缓存   单页面缓存   页面局部缓存
六种缓存方式:
　　django中使用缓存:
　　第一步: 在settings中配置(缓存方式)


CACHES = {
 'default': {
# 缓存后台使用...]]></description><category></category></item><item><title><![CDATA[Redis (待完善)]]></title><link>https://blog.youkuaiyun.com/aa1384656303/article/details/102429252</link><guid>https://blog.youkuaiyun.com/aa1384656303/article/details/102429252</guid><author>aa1384656303</author><pubDate>Mon, 01 Apr 2019 19:29:00 +0800</pubDate><description><![CDATA[字符串操作-mysql,oracle:关系型数据库
-redis,mongodb:非关系型数据库/nosql
    -redis存储在内存中
    -mongodb存储在硬盘上
# redis 是一个key-value存储系统
redis-cli 启动redis
Redis作用
    - 缓存
    - session数据
    -对速度要求比较高的数据的...]]></description><category></category></item><item><title><![CDATA[视图组件和认证组件]]></title><link>https://blog.youkuaiyun.com/aa1384656303/article/details/102429246</link><guid>https://blog.youkuaiyun.com/aa1384656303/article/details/102429246</guid><author>aa1384656303</author><pubDate>Wed, 27 Mar 2019 20:35:00 +0800</pubDate><description><![CDATA[1.使用mixin和generics类编写视图 from rest_framework.mixins import CreateModelMixin, ListModelMixin, DestroyModelMixin, RetrieveModelMixin, \
    UpdateModelMixin
from rest_framework.generics import G...]]></description><category></category></item><item><title><![CDATA[drf序列化组件]]></title><link>https://blog.youkuaiyun.com/aa1384656303/article/details/102429247</link><guid>https://blog.youkuaiyun.com/aa1384656303/article/details/102429247</guid><author>aa1384656303</author><pubDate>Tue, 26 Mar 2019 16:19:00 +0800</pubDate><description><![CDATA[1.rest-framework序列化之Serializer

rest-framework序列化之Serializer步骤
    1. 创建一个类,继承Serializer
    2. 在类中写要序列化的字段
'''
class BookSerializer(serializers.Serializer):
    # 序列化表中的某几个字段 固定写法
    ni...]]></description><category></category></item><item><title><![CDATA[幂等性与微服务]]></title><link>https://blog.youkuaiyun.com/aa1384656303/article/details/102429244</link><guid>https://blog.youkuaiyun.com/aa1384656303/article/details/102429244</guid><author>aa1384656303</author><pubDate>Mon, 25 Mar 2019 17:33:00 +0800</pubDate><description><![CDATA[幂等性

幂等性的使用场景?
    业务开发中，经常会遇到重复提交的情况，无论是由于网络问题无法收到请求结果而重新发起请求，或是前端的操作抖动而造成重复提交情况.
    exp: 1. 用户在app上连续点击多次提交订单,后台应只生成一个订单
         2. 向支付宝发起支付请求，由于网络问题或系统BUG重发，支付宝应该只扣一次钱。 
            很显...]]></description><category></category></item><item><title><![CDATA[restful规范及drf]]></title><link>https://blog.youkuaiyun.com/aa1384656303/article/details/102429093</link><guid>https://blog.youkuaiyun.com/aa1384656303/article/details/102429093</guid><author>aa1384656303</author><pubDate>Mon, 25 Mar 2019 15:54:00 +0800</pubDate><description><![CDATA[1. restful

1.restful: 是一种规范, 面向资源架构
    10条规范:
        -1 API与用户的通信协议，总是使用HTTPs协议
        -2域名 
            https://api.example.com ：尽量将API部署在专用域名（会存在跨域问题）
            https://example.org...]]></description><category></category></item><item><title><![CDATA[ajax&分页器]]></title><link>https://blog.youkuaiyun.com/aa1384656303/article/details/102429094</link><guid>https://blog.youkuaiyun.com/aa1384656303/article/details/102429094</guid><author>aa1384656303</author><pubDate>Mon, 11 Mar 2019 20:49:00 +0800</pubDate><description><![CDATA[ajax请求数据

# 前台
$.ajax({
    url:'/ajax/',  # 请求路径
    type: 'post', # 请求方式
    
    data:{ # get 和 post 都以data字典方式携带数据
        usr: $('.usr').val, # 获取from表单输入框内容
        pwd: $('.pwd')....]]></description><category></category></item><item><title><![CDATA[聚合查询]]></title><link>https://blog.youkuaiyun.com/aa1384656303/article/details/102429245</link><guid>https://blog.youkuaiyun.com/aa1384656303/article/details/102429245</guid><author>aa1384656303</author><pubDate>Thu, 07 Mar 2019 23:36:00 +0800</pubDate><description><![CDATA[一 分组查询概念
    Book: id name price publish_date publish
    1. 聚合函数可以单独使用: 将整张表作为一个大的分组,查询字段只能是聚合结果
        select max(price), group_concat(name) from book where id &lt; 10;
    2. 聚合函数在分组下使用...]]></description><category></category></item><item><title><![CDATA[django orm 多表查询]]></title><link>https://blog.youkuaiyun.com/aa1384656303/article/details/102429242</link><guid>https://blog.youkuaiyun.com/aa1384656303/article/details/102429242</guid><author>aa1384656303</author><pubDate>Thu, 07 Mar 2019 19:36:00 +0800</pubDate><description><![CDATA[Django多表ORM设计规则

1. 关联表之间建议建立外键,但是可以取消关联关系(db_constraint=False)
2. 关联表之间的晚间字段建议采用对应类名的全小写
3. 采用关联表的主键或对象均能进行操作
'''
    书籍: Book: id name price publish_date publish author(多对多关联字段)
    出版社...]]></description><category></category></item><item><title><![CDATA[django orm 单表增删改查]]></title><link>https://blog.youkuaiyun.com/aa1384656303/article/details/102429241</link><guid>https://blog.youkuaiyun.com/aa1384656303/article/details/102429241</guid><author>aa1384656303</author><pubDate>Thu, 07 Mar 2019 19:03:00 +0800</pubDate><description><![CDATA[一 简单增删改查

1.增
    User.objects.create(name='Alan', age=10, birthday='2018-08-08')
    
    user = User(name='Alan', age=10, birthday='2018-08-08')
    user.save()
2.查询
    # 操作的结果拥有是一个lis...]]></description><category></category></item><item><title><![CDATA[DTL(Django templeate language)]]></title><link>https://blog.youkuaiyun.com/aa1384656303/article/details/102429239</link><guid>https://blog.youkuaiyun.com/aa1384656303/article/details/102429239</guid><author>aa1384656303</author><pubDate>Fri, 01 Mar 2019 15:13:00 +0800</pubDate><description><![CDATA[一 变量

'''
def dtl(request):
    num = 3.14
    ss = 'abc123嘿嘿'
    # return render(request, 'django_dtl.html', {'number': num, 'ss': ss})
    result = True
    list = [1, 2, 3, 4, 5]
  ...]]></description><category></category></item><item><title><![CDATA[数据库优化]]></title><link>https://blog.youkuaiyun.com/aa1384656303/article/details/102429240</link><guid>https://blog.youkuaiyun.com/aa1384656303/article/details/102429240</guid><author>aa1384656303</author><pubDate>Thu, 28 Feb 2019 20:32:00 +0800</pubDate><description><![CDATA['''
django开发中对数据库有什么优化?
    1.设计表时候,尽量少用或不用外键,因为外键约束会影响插入和删除性能
    2.使用缓存,减少对数据库的访问
    3.在orm框架下设置表时,能用varchar确定字段长度就不用text
    4.给搜索频率高的字段,在定义阶段设置索引
    5.Django orm框架下的Querysets本来就具有缓存...]]></description><category></category></item><item><title><![CDATA[HTTP详解]]></title><link>https://blog.youkuaiyun.com/aa1384656303/article/details/102429238</link><guid>https://blog.youkuaiyun.com/aa1384656303/article/details/102429238</guid><author>aa1384656303</author><pubDate>Thu, 28 Feb 2019 19:47:00 +0800</pubDate><description><![CDATA[一 什么是HTTP协议? HTTP请求有哪几种?"""
HTTP是超文本传输协议(hypertext transfer protocol)
是TCP/IP协议的一个应用层协议,用于定义web与web服务器之间的数据交换过程
客户端链接上服务端后,如想进行数据交换需要遵循一定的通讯格式
HTTP就是用户定义服务端与web端服务器的通讯格式
HTTP的请求: OPTIONS /...]]></description><category></category></item><item><title><![CDATA[Django 4]]></title><link>https://blog.youkuaiyun.com/aa1384656303/article/details/102429236</link><guid>https://blog.youkuaiyun.com/aa1384656303/article/details/102429236</guid><author>aa1384656303</author><pubDate>Thu, 28 Feb 2019 18:49:00 +0800</pubDate><description><![CDATA[一 虚拟环境

'''
解决版本共存

1. 用pycharm选择virtualenv创建一个纯净环境
2. 将环境copy到需要指定长期使用的文件夹下
3. 再次创建项目时，将该环境添加到pycharm环境选择中
4. 为该环境添加需要处理的版本共存包
'''

二 路由配置主页与404

'''
路由层：
from django.urls import ...]]></description><category></category></item><item><title><![CDATA[django常用命令集合 待完善]]></title><link>https://blog.youkuaiyun.com/aa1384656303/article/details/102429237</link><guid>https://blog.youkuaiyun.com/aa1384656303/article/details/102429237</guid><author>aa1384656303</author><pubDate>Wed, 27 Feb 2019 20:22:00 +0800</pubDate><description><![CDATA['''
下载Django:
    -- pip3 install django
    -- pip install django==1.11.9 -i http://pypi.hustunique.org/simple指定版本号，指定国内镜像
    -- pychram安装
    -- 用pycharm的Terminal的命令行安装, 类似于cmd命令行
    ...]]></description><category></category></item><item><title><![CDATA[路由]]></title><link>https://blog.youkuaiyun.com/aa1384656303/article/details/102429235</link><guid>https://blog.youkuaiyun.com/aa1384656303/article/details/102429235</guid><author>aa1384656303</author><pubDate>Wed, 27 Feb 2019 20:08:00 +0800</pubDate><description><![CDATA[一 路由基础

'''
正则路径 试图函数地址 默认关键字参数 路由别名

r'^index$' 只能匹配index，不能匹配index/
r'^index/$' 只能匹配index/，能匹配index(先拿index匹配，如果失败，会添加/再次匹配)
url(r'^index/$', views.index)
url(r'^testkw/$', views.testk...]]></description><category></category></item><item><title><![CDATA[django learing day01]]></title><link>https://blog.youkuaiyun.com/aa1384656303/article/details/102429233</link><guid>https://blog.youkuaiyun.com/aa1384656303/article/details/102429233</guid><author>aa1384656303</author><pubDate>Tue, 26 Feb 2019 19:47:00 +0800</pubDate><description><![CDATA[一 Django项目创建与介绍

安装： pip3 install django== 1.11.x (x代表版本号)
查看版本号: django-admin --version
新建项目: 1.前往目标目录
            2.django-admin startproject 项目名称
proj_name：项目目录，包含项目最基本的一些配置
    -- __in...]]></description><category></category></item></channel></rss>