上一页 1 ··· 7 8 9 10 11 12 13 14 15 ··· 22 下一页
摘要: from pyDes import des, CBC, PAD_PKCS5 import binascii # 秘钥 KEY = 'dsj2020q' def des_encrypt(s): """ DES 加密 :param s: 原始字符串 :return: 加密后字符串,16进制 """ se 阅读全文
posted @ 2021-10-15 17:16 cup_leo 阅读(533) 评论(0) 推荐(0) 编辑
摘要: import pymysql import re import time import math from datetime import datetime import traceback import json import threading import logging import que 阅读全文
posted @ 2021-10-15 17:13 cup_leo 阅读(156) 评论(0) 推荐(0) 编辑
摘要: 方法一from pyhive import hive import traceback class Hive_tool: def __init__(self): self.conn = hive.Connection(host="******", port=1****, database='ods' 阅读全文
posted @ 2021-10-15 17:08 cup_leo 阅读(279) 评论(0) 推荐(0) 编辑
摘要: from apscheduler.schedulers.blocking import BlockingScheduler from datetime import datetime,timedelta,date import requests import os def check_related 阅读全文
posted @ 2021-10-15 17:02 cup_leo 阅读(131) 评论(0) 推荐(0) 编辑
摘要: # coding: utf-8 import smtplib from email.mime.text import MIMEText from email.header import Header # 发信方的信息:发信邮箱,QQ邮箱授权码 class QQemail: def __init__( 阅读全文
posted @ 2021-10-15 16:58 cup_leo 阅读(50) 评论(0) 推荐(0) 编辑
摘要: # Definition for singly-linked list. class Node(object): def __init__(self, val=0, next=None): self.val = val self.next = next class Solution: def add 阅读全文
posted @ 2021-09-25 19:18 cup_leo 阅读(29) 评论(0) 推荐(0) 编辑
摘要: select regexp_replace('50.8九 ,c...o【.。。。】。。。$##mmmmQWER@@*&^ 112 历史088天空','([^\\u4E00-\\u9FA5a-zA-Z0-9.]+)','') as name 阅读全文
posted @ 2021-07-05 16:43 cup_leo 阅读(1371) 评论(0) 推荐(0) 编辑
摘要: select phone,CONCAT_WS(',',collect_set(column name)) from table where ***group by phone 阅读全文
posted @ 2021-06-07 10:56 cup_leo 阅读(792) 评论(0) 推荐(0) 编辑
摘要: select concat(unix_timestamp(),cast(rand() * 100000000 as int)) 阅读全文
posted @ 2021-05-26 11:46 cup_leo 阅读(2018) 评论(0) 推荐(0) 编辑
摘要: SELECT cidnum1,count(*) as num from ( SELECT DISTINCT id,cidnum, (CASE WHEN 0<cidnum and cidnum<=1 THEN '1个公司' WHEN 1<cidnum and cidnum<=5 THEN '2-5个公 阅读全文
posted @ 2021-05-07 07:41 cup_leo 阅读(574) 评论(0) 推荐(0) 编辑
上一页 1 ··· 7 8 9 10 11 12 13 14 15 ··· 22 下一页