做了一个可以让大家视奸我的网站

1
# 获取活动窗口
2
hwnd = win32gui.GetForegroundWindow()
3
title = win32gui.GetWindowText(hwnd)
4

5
# 通过 REST API 写入 Supabase
6
rest_post("windows", {
7
    "id": 1,
8
    "title": title,
9
    "process": exe_name,
10
    "updated_at": "now()",
11
})
12

13
# 同时累积使用时长
14
usage[prev_process] += elapsed
15
rest_post("usage_stats", {"process": proc, "seconds": secs})

1
// 订阅 realtime 变更
2
sb.channel('w')
3
  .on('postgres_changes', {
4
    event: '*',
5
    schema: 'public',
6
    table: 'windows',
7
    filter: 'id=eq.1'
8
  }, (payload) => {
9
    show(payload.new);   // 实时更新界面
10
  })
11
  .subscribe();

1
-- 当前窗口表
2
CREATE TABLE public.windows (
3
  id          INTEGER PRIMARY KEY DEFAULT 1,
4
  title       TEXT NOT NULL DEFAULT '',
5
  process     TEXT NOT NULL DEFAULT '',
6
  updated_at  TIMESTAMPTZ NOT NULL DEFAULT now()
7
);
8

9
-- 使用统计表
10
CREATE TABLE public.usage_stats (
11
  process    TEXT PRIMARY KEY,
12
  seconds    INTEGER NOT NULL DEFAULT 0,
13
  icon_url   TEXT,
14
  updated_at TIMESTAMPTZ NOT NULL DEFAULT now()
15
);
16

17
-- Realtime
18
ALTER PUBLICATION supabase_realtime ADD TABLE public.windows;
19
ALTER PUBLICATION supabase_realtime ADD TABLE public.usage_stats;
20

21
-- RLS
22
CREATE POLICY "allow_anon" ON public.windows FOR ALL USING (id = 1) WITH CHECK (id = 1);
23
CREATE POLICY "allow_anon" ON public.usage_stats FOR ALL USING (true) WITH CHECK (true);
24

25
INSERT INTO public.windows (id, title, process) VALUES (1, '', '');

1
SUPABASE_URL = "https://你的项目.supabase.co"
2
SUPABASE_KEY = "你的anon key"