import os
import time
import sqlite3
from datetime import datetime
import pyperclip
# ------------------------------------------------------------
# PATHS
# ------------------------------------------------------------
DB_PATH = r"c:\Temp\projectClipboard\DB\clipboard.db"
HTML_PATH = r"c:\Temp\projectClipboard\clipboard.html"
os.makedirs(os.path.dirname(DB_PATH), exist_ok=True)
os.makedirs(os.path.dirname(HTML_PATH), exist_ok=True)
# ------------------------------------------------------------
# DATABASE SETUP
# ------------------------------------------------------------
conn = sqlite3.connect(DB_PATH)
cur = conn.cursor()
cur.execute("""
CREATE TABLE IF NOT EXISTS clipboard (
id INTEGER PRIMARY KEY AUTOINCREMENT,
timestamp TEXT NOT NULL,
content TEXT NOT NULL
)
""")
conn.commit()
# ------------------------------------------------------------
# HTML REPORT GENERATOR
# ------------------------------------------------------------
def generate_html():
conn = sqlite3.connect(DB_PATH)
cur = conn.cursor()
cur.execute("SELECT id, timestamp, content FROM clipboard ORDER BY id DESC")
rows = cur.fetchall()
conn.close()
html = f"""
Clipboard Monitor
Clipboard Monitor
Last updated: {datetime.now().strftime("%Y-%m-%d %H:%M:%S")}
| ID |
Timestamp |
Clipboard Content |
"""
for row in rows:
html += f"""
| {row[0]} |
{row[1]} |
{row[2]} |
"""
html += """
"""
with open(HTML_PATH, "w", encoding="utf-8") as f:
f.write(html)
print(f"HTML updated: {HTML_PATH}")
# ------------------------------------------------------------
# CLIPBOARD MONITOR LOOP
# ------------------------------------------------------------
def monitor_clipboard():
print("š Clipboard monitor started. Press CTRL+C to stop.")
last_text = ""
while True:
try:
text = pyperclip.paste()
if text != last_text and text.strip() != "":
timestamp = datetime.now().strftime("%Y-%m-%d %H:%M:%S")
print(f"\nš¹ New clipboard content detected at {timestamp}")
print("-----")
print(text)
print("-----")
conn = sqlite3.connect(DB_PATH)
cur = conn.cursor()
cur.execute("INSERT INTO clipboard (timestamp, content) VALUES (?, ?)", (timestamp, text))
conn.commit()
conn.close()
generate_html()
last_text = text
time.sleep(0.5)
except KeyboardInterrupt:
print("\nš Clipboard monitor stopped.")
break
# ------------------------------------------------------------
# RUN MONITOR
# ------------------------------------------------------------
monitor_clipboard()