python
在踩坑中前进
我是人间惆怅客
展开
-
python操作clickhouse
第一种方式import requestsSSL_VERIFY = Falsehost = 'http://127.0.0.1:8123'db = '数据库名称'table = '表名'#插入query_dict = { 'query': "insert into 数据库名称.表名(api,param,create_time,time) values('python-api','参数',now(),11)"}#查询query_dict = { 'query':原创 2021-12-31 17:21:48 · 2586 阅读 · 0 评论 -
python上传文件
# -*- coding: UTF-8 -*-from flask import Flask,request,Responseapp = Flask(__name__) @app.route('/upload', methods=['GET', 'POST'])def upload_file(): f = request.files['file'] f.save('/temp/{}'.format(f.filename)) return 'success'if __.原创 2021-12-31 14:25:36 · 663 阅读 · 0 评论 -
python下载文件
from flask import Flask,request,Responseapp = Flask(__name__)@app.route('/', methods=["GET"])def download(): file = request.args.get("file", 0) f = open(file,'r') data = f.read() f.close() return Response(data, content_type='appl.原创 2021-12-30 20:39:06 · 348 阅读 · 0 评论 -
pyhton请求接口
安装pip install requests请求import requests#GETres = requests.get("http://10.0.20.22:9999/actuator/health")print(res.text)#POSTurl = "api地址"jsonParam = { "pageIndex":1, "pageSize":10}headers={ "Authorization":"MDNlNTQwMjNhOGFmNzdj原创 2021-12-30 14:11:36 · 1006 阅读 · 0 评论 -
python操作elasticsearch
安装pip install elasticsearch pip install elasticsearch[async] #支持异步插入from elasticsearch import Elasticsearchfrom elasticsearch import AsyncElasticsearchesClient = Elasticsearch(hosts="127.0.0.1",port=9200)esClient.index(index="indexName",doc原创 2021-12-30 11:32:12 · 1418 阅读 · 0 评论 -
python操作mongodb
安装pip install pymongo插入#!/usr/bin/python3 import pymongomyclient = pymongo.MongoClient('mongodb://账号:密码@ip:27017/')mydb = myclient["dbname"]coll = mydb["collectName"]record={ 'name':'hello', 'age':22}id=coll.insert_one(record)prin原创 2021-12-30 10:42:32 · 384 阅读 · 0 评论 -
python操作mysql
安装pip install pymysql插入import pymysqlconn = pymysql.connect(host='10.0.20.9',user="root",passwd="GCFSlfyZIvxxs",db="go2global")cursor=conn.cursor()cursor.execute('insert into Person (Name,Age) values (\"{}\",{})'.format('你是谁',33))cursor.close()原创 2021-12-29 20:20:52 · 518 阅读 · 0 评论 -
python读取文件中的数据
方式1f = open('文件路径','r', encoding="utf-8")data = f.read()f.close()方式2data = os.system('type {}'.format('文件路径'))原创 2021-12-29 19:17:27 · 438 阅读 · 0 评论 -
python flask提供API
安装flaskpipe install flask编码# -*- coding: UTF-8 -*-from flask import Flask,requestapp = Flask(__name__)@app.route('/get', methods=["GET"])def get(): name= request.args.get("name", 0) return nameif __name__ == '__main__': app原创 2021-12-29 19:14:54 · 206 阅读 · 0 评论 -
python操作redis
import redisredisClient=redis.StrictRedis(host='127.0.0.1',port=6379,db=0)redisClient.set('hello','world 20211224')redisClient.expire('hello',1000*60)v = redisClient.get('hello')print(v)原创 2021-12-24 19:22:38 · 731 阅读 · 0 评论