随笔分类 -  Python

上一页 1 2
python日期处理
摘要：##当天日期today = datetime.date.today()print(today)##获取当前月的第一天first = today.replace(day=1)print(first)##减一天，得到上个月的最后一天last_month = first - datetime.timede 阅读全文
posted @ 2022-06-16 16:24 slnngk 阅读(61) 评论(0) 推荐(0)
安装python 3.5/3.8
摘要：环境: OS:Centos 7 1.安装python3.5可能使用的依赖yum install openssl-devel bzip2-devel expat-devel gdbm-devel readline-devel sqlite-devel gcc 2.到python官网找到下载路径, 用w 阅读全文
posted @ 2022-06-06 17:35 slnngk 阅读(1012) 评论(0) 推荐(0)
python飞书发送消息
摘要：环境: Python:3.6.5 pip install requests pip install json #!/usr/bin/env python #coding=utf-8 import json import requests # 你复制的webhook地址 url = "https:// 阅读全文
posted @ 2022-04-08 13:56 slnngk 阅读(139) 评论(0) 推荐(0)
python写数据到elasticsearch
摘要：环境： elasticsearch:6.8.5 开发工具:PyCharm 1.windows机器安装与服务器器相同版本的es pip3 install elasticsearch==6.8.0 2.创建index #!/usr/bin/env python #coding=utf-8 from el 阅读全文
posted @ 2022-03-23 15:32 slnngk 阅读(332) 评论(0) 推荐(0)
输入年份计算生肖年份
摘要：#-*-coding:utf-8 -*- tiangan = {4: "甲", 5: "乙", 6:"丙",7:"丁",8:"戊",9:"己",0:"庚",1:"辛",2:"壬",3:"奎"} dizhi = {4: "子", 5: "丑", 6:"寅",7:"卯",8:"辰",9:"巳& 阅读全文
posted @ 2021-10-22 11:09 slnngk 阅读(144) 评论(0) 推荐(0)
python调用存储过程
摘要：def call_sp_test(): delete_sql = "call sp_test()" # 打开数据库连接 db = pymysql.connect(host=insert_mysqlserver, user=insert_username, password=insert_passwo 阅读全文
posted @ 2021-10-08 13:45 slnngk 阅读(828) 评论(0) 推荐(0)
mysql分页查询
摘要：python 3.6 # -*- coding: utf-8 -*- import pymysql import smtplib import datetime import time mysql_server="192.168.1.22" user_name="root" password= "y 阅读全文
posted @ 2021-09-30 15:22 slnngk 阅读(68) 评论(0) 推荐(0)
crontab下执行python沙盒环境的脚本
摘要：(python37-venv) [yeemiao@yeemiao-oracle-9e96168-prd scripts]$ more sync_cratedbdata_to_clickhouse_temp.sh #!/bin/bash source /etc/profile source /home 阅读全文
posted @ 2021-09-30 11:16 slnngk 阅读(85) 评论(0) 推荐(0)
cratedb导出数据到clickhouse
摘要：python版本:3.6 #!/usr/bin/env python #coding=utf-8 from crate import client import os, time, datetime import time from clickhouse_driver import Client i 阅读全文
posted @ 2021-09-29 13:37 slnngk 阅读(85) 评论(0) 推荐(0)
python发邮件附件
摘要：python 2.7环境 [root@localhost send_wrong_sql]# more send_fujin01.py #!/usr/bin/env python # -*- coding: UTF-8 -*- import smtplib from email.mime.multip 阅读全文
posted @ 2021-06-04 10:35 slnngk 阅读(53) 评论(0) 推荐(0)
python3发送邮件
摘要：python版本:3.7 安装依赖包 pip3 install pymysql pip3 install py-emails (python37-venv) [root@localhost send_wrong_sql]# more py3_mysqlhost_192.168.1.22.py #!/ 阅读全文
posted @ 2021-03-09 14:24 slnngk 阅读(234) 评论(0) 推荐(0)
python2发送邮件
摘要：[root@localhost send_wrong_sql]# python -VPython 2.7.5 # -*- coding: utf-8 -*- import pymysql import smtplib import datetime import time from email.mi 阅读全文
posted @ 2021-03-09 11:44 slnngk 阅读(178) 评论(0) 推荐(0)
pip版本过高导致报错
摘要：[root@localhost send_wrong_sql]# pipTraceback (most recent call last): File "/usr/bin/pip", line 9, in <module> load_entry_point('pip==21.0.1', 'conso 阅读全文
posted @ 2021-03-09 11:41 slnngk 阅读(3517) 评论(0) 推荐(2)
python3安装沙盒环境
摘要：1.安装python3.7可能使用的依赖yum install openssl-devel bzip2-devel expat-devel gdbm-devel readline-devel sqlite-devel2.到python官网找到下载路径, 用wget下载wget https://www 阅读全文
posted @ 2020-10-09 14:37 slnngk 阅读(389) 评论(0) 推荐(0)
python连接oracle
摘要：环境:OS:windowsPython:3.6.81.下载cx-Oraclehttps://pypi.org/project/cx-Oracle/6.4.1/#files2.安装pip.exe install E:\python_oracle\cx_Oracle-6.4.1-cp36-cp36m-w 阅读全文
posted @ 2020-03-18 10:00 slnngk 阅读(154) 评论(0) 推荐(0)
python发送邮件(html)例子
摘要：python2和python3都可以执行 阅读全文
posted @ 2019-07-18 18:02 slnngk 阅读(3823) 评论(0) 推荐(0)
python查库写库例子
摘要：环境: python2.7和python3.6都可以执行 方法1：字段拼接 #!/usr/bin/python3 import pymysql import smtplib import datetime import time now_time = datetime.datetime.now() 阅读全文
posted @ 2019-07-18 17:59 slnngk 阅读(405) 评论(0) 推荐(0)
获取rds的cpu和内存使用情况
摘要：python版本:2.7.12 阅读全文
posted @ 2019-07-16 17:31 slnngk 阅读(928) 评论(0) 推荐(0)
python发送邮件
摘要：[yeemiao@localhost sendmail]$ more sendtest.py # -*- coding: utf-8 -*- # Author: hkey from email.header import Header from email.mime.text import MIMEText from email.mime.multipart import MIMEMult... 阅读全文
posted @ 2019-04-24 10:02 slnngk 阅读(248) 评论(0) 推荐(0)

上一页 1 2