​【TDSQL-C MySQL实践】实现剪切板历史存储

import base64  
from Crypto.Cipher import PKCS1_v1_5  
from Crypto.PublicKey import RSA  
  
  
# 您准备的RSA私钥
private_key = '-----BEGIN RSA PRIVATE KEY-----\nMII******t5tg==\n-----END RSA PRIVATE KEY-----'  
  
  
def decrypt(text_encrypted_base64):  
    text_encrypted_base64 = text_encrypted_base64.encode('utf-8')  
    text_encrypted = base64.b64decode(text_encrypted_base64)  
    cipher_private = PKCS1_v1_5.new(RSA.importKey(private_key.encode('utf-8')))  
    return cipher_private.decrypt(text_encrypted, b'0').decode()

import base64  
from Crypto.Cipher import PKCS1_v1_5  
from Crypto.PublicKey import RSA  
  
# 您准备的RSA公钥 
public_key = '-----BEGIN PUBLIC KEY-----\nMII****QAB\n-----END PUBLIC KEY-----' 
 
 
def encrypt(text):  
    cipher_public = PKCS1_v1_5.new(RSA.importKey(public_key))  
    text_encrypted = cipher_public.encrypt(text.encode('utf-8')) # 加密（bytes）  
    return base64.b64encode(text_encrypted).decode()

import pyperclip  
import time  
import upload_msg  
import uuid  
import enc  
  
  
clipboard_content = ""  
clipboard_list = []  
  
while True:  
    temp_clipboard = pyperclip.paste() # 获取剪切板内容  
    if temp_clipboard != clipboard_content: # 如果剪切板内容没有变化直接跳过  
        clipboard_content = temp_clipboard  
        clipboard_list.append(clipboard_content)  
        print(clipboard_content, upload_msg.commit_msg(enc.encrypt(clipboard_content), 'doone', uuid.uuid4()))  
    time.sleep(0.5) # 设置每次读取间隔

import pymysql as MySQLdb  
import uuid  
  
sql_url = '**.sql.tencentcdb.com' # 这里填入之前的主机
port = 2** # 这里填入之前的端口
user = 'root' # 这里以root用户为例
passwd = 'root的密码' # 这里填入您设置的root密码

  
def commit_msg(content, ip, uuid):  
    db = MySQLdb.connect(host=sql_url, user=user, passwd=passwd, charset='utf8', port=port)  
    cursor = db.cursor()  
    db.select_db('tdqslnb')  
    try:  
        cursor.execute(  
        """INSERT INTO `pasteboard` (`uuid`, `content`, `ip`) VALUES ('{0}', '{1}', '{2}');""".format(uuid, content,  
        ip))  
        db.commit()  
        db.close()  
        return True  
    except Exception as e:  
        print(e)  
        db.close()  
        return False