LOADING

分类 python 下的文章

  1. 下载指定版本下文中以3.7.3为例
wget https://www.python.org/ftp/python/3.7.3/Python-3.7.3.tgz
  1. 解压
tar zxvf Python-3.7.3.tgz
  1. 切换目录
cd Python-3.7.3
  1. 编译
./configure --with-ssl
make
sudo make install
–with-ssl必须加上，否则使用pip安装第三方包时，会引发ssl错误。导致无法使用
  1. 安装python依赖
sudo apt-get install python-dev python-setuptools python-pip python-smbus build-essential libncursesw5-dev libgdbm-dev libc6-dev zlib1g-dev libsqlite3-dev tk-dev libssl-dev openssl libffi-dev
  1. 添加软连接 (方便区分不同版本)

添加python3的软链接

sudo ln -s /usr/local/bin/python3.7 /usr/bin/python3.7

添加 pip3 的软链接

sudo ln -s /usr/local/bin/pip3.7 /usr/bin/pip3.7

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

php版本7.1

<?php

$n=1;
$time=time();
while($n<100000000){
    $n=$n+1;
}
echo time()-$time;
3秒

python版本3.7

8.27714991569519秒


python版本2.7
import time
n = 1
time_start = time.time()
while n < 100000000:
    n = n+1
time_end = time.time()
print time_end - time_start
10.3120000362秒

斐波那契 php版本 7.1
<?php
/**
 * Created by PhpStorm.
 * User: dn
 * Date: 2018/10/18
 * Time: 17:17
 */

$startTime = time();
function f($a)
{
    if ($a == 0 || $a == 1) {
        return 1;
    }
    return f($a-1) + f($a-2);
}
for($i = 0; $i < 40; ++$i) {
    echo f($i).' ';
}
$endTime = time();
echo $endTime-$startTime;
101秒

斐波那契 php版本 5.6

177秒

斐波那契 python2.7

182秒
  1. 1
  2. 2