LOADING

标签 python 下的文章

import copy
from prettyprinter import cpprint as p

        campaign_bigo_no = campaign_bigo = {
            'cpm': 0,
        }
        #  默认是传引用
        campaign_bigo['cpm'] = 1
        p(campaign_bigo_no)
        p(campaign_bigo)
        #  传值
        campaign_bigo_no = copy.deepcopy(campaign_bigo)
        campaign_bigo['cpm'] = 1
        p(campaign_bigo_no)
        p(campaign_bigo)

优先安装 uwsgi 用于接受nginx转发来的请求

pip3 install uwsgi

在项目目录下新建 uwsgi.ini

[uwsgi]
socket=127.0.0.1:9090 #接受nginx转发来的请求
chdir=/Applications/MAMP/htdocs/python_all_rivers #项目目录
module=reptlie.wsgi:application #wsgi文件目录
max-requests=5000 #最大请求数
daemonize=/var/log/yourproject.log #log文件地址 启动失败等日志都在里面

启动 uwsgi 切换到uwsgi.ini文件目录 载入配置方式启动

uwsgi --ini uwsgi.ini

查看是否启动

ps aux|grep uwsgi

root      295550  2.2  0.9  50184 38108 ?        S    14:48   0:00 uwsgi --ini reptlie/uwsgi.ini
root      295554  0.0  0.0   9032   728 pts/0    S+   14:48   0:00 grep --color=auto uwsgi

如需关闭 kill掉当前uwsgi pid

nginx配置


server {
            listen       80;
            server_name  python.allreviers.com;#你自己的域名

            location / {
                uwsgi_pass  127.0.0.1:9090;              #必须和uwsgi中的设置一致
                include  uwsgi_params;
                index  index.html index.htm;
                client_max_body_size 35m;
            }
        }

重启nginx即可
注:每次修改python文件后都需要kill掉 uwsgi 重新载入配置启动

import pymysql

# mysql链接初始化
# cursorclass 设置这个就可以key-value像php一样显示数据
def mysql_model():
    mysql_content = pymysql.connect(host="你的host", user="用户名",
                                    password="密码",
                                    database="数据库", charset="utf8", port=3306,
                                    cursorclass=pymysql.cursors.DictCursor)
    return mysql_content

首先需要引入依赖

import pymysql

# mysql链接初始化
# cursorclass
def mysql_model():
    mysql_content = pymysql.connect(host="你的host", user="用户名",
                                    password="密码",
                                    database="数据库", charset="utf8", port=3306,
                                    cursorclass=pymysql.cursors.DictCursor)
    return mysql_content


#但是一定要注意这种拼接方法只能拼接变量为字符串的,如果是不同类型的请往下看
def delAppMysqlStr():
    yesterday = "2020-01-08"
    del_app_sql = "delete from table where day = '" + yesterday + "'"
    mysql_content = mysql_model()
    # 创建一个游标
    cursor = mysql_content.cursor()
    cursor.execute(del_app_sql)
    mysql_content.commit()
    cursor.close()
    mysql_content.close()
    return 1
#如果是不同类型请使用参数绑定形式进行赋值
#切记占位符%s一定要和values数量匹配
def addAppMysqlStr():
    yesterday = "2020-01-08"
    add_sql = "insert into table (`day`,`union_id`,`appid`,`show_count`,`click_count`,`click_reg`,`cpm`,`money`,`third_app_id`,`platform`,`created_at`) value (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)"
    param = (yesterday, 1, 2, 3, 3.223, 2323,
             6.66, 11, 2, 123, "萨达所大")
    cursor.execute(add_sql, param)
    mysql_content.commit()
    cursor.close()
    mysql_content.close()
    return 1