Spaces:
Sleeping
Sleeping
Download src/adapters/persistence/local_identity.py from dellweb3/VibeCoding: direct link, hf CLI and curl.
- Browser
- Download file 9.21 kB
-
https://huggingface.co/spaces/dellweb3/VibeCoding/resolve/main/src/adapters/persistence/local_identity.py
- Command line
-
hf download hf://spaces/dellweb3/VibeCoding/src/adapters/persistence/local_identity.py
-
curl -L -o local_identity.py https://huggingface.co/spaces/dellweb3/VibeCoding/resolve/main/src/adapters/persistence/local_identity.py
9.21 kB
| """Independent local accounts, sessions and project membership. No WorkOS identity mutation.""" | |
| import hashlib | |
| import hmac | |
| import json | |
| import secrets | |
| import sqlite3 | |
| import time | |
| import uuid | |
| from contextlib import contextmanager | |
| from pathlib import Path | |
| from src.modules.skill.domain.models import Actor, SkillError | |
| class LocalIdentity: | |
| def __init__(self, path): | |
| self.path = Path(path) | |
| self.path.parent.mkdir(parents=True, exist_ok=True) | |
| with self.connect() as db: | |
| db.executescript(''' | |
| CREATE TABLE IF NOT EXISTS users(id TEXT PRIMARY KEY,username TEXT UNIQUE,salt TEXT,password TEXT,roles TEXT,enabled INTEGER,failures INTEGER DEFAULT 0,locked_until REAL DEFAULT 0); | |
| CREATE TABLE IF NOT EXISTS sessions(token_hash TEXT PRIMARY KEY,user_id TEXT,csrf TEXT,expires REAL); | |
| CREATE TABLE IF NOT EXISTS projects(id TEXT PRIMARY KEY,name TEXT); | |
| CREATE TABLE IF NOT EXISTS members(project_id TEXT,user_id TEXT,PRIMARY KEY(project_id,user_id)); | |
| CREATE TABLE IF NOT EXISTS identity_audit(id INTEGER PRIMARY KEY,at REAL,actor TEXT,action TEXT,target TEXT); | |
| ''') | |
| def connect(self): | |
| db = sqlite3.connect(self.path, timeout=30) | |
| db.row_factory = sqlite3.Row | |
| try: | |
| with db: | |
| yield db | |
| finally: | |
| db.close() | |
| def hashed(password, salt): | |
| return hashlib.scrypt(password.encode(), salt=bytes.fromhex(salt), n=16384, r=8, p=1).hex() | |
| def admin(actor): | |
| if 'admin' not in actor.roles: | |
| raise SkillError('ROLE_REQUIRED', '需要管理员权限。', 403) | |
| def needs_setup(self): | |
| with self.connect() as db: | |
| return not db.execute("SELECT 1 FROM users WHERE enabled=1 LIMIT 1").fetchone() | |
| def create_user(self, username, password, roles, *, setup=False, actor=None): | |
| import re | |
| if not re.fullmatch(r'[A-Za-z][A-Za-z0-9_.-]{2,39}', username) or not 12 <= len(password) <= 128: | |
| raise SkillError('ACCOUNT_INPUT_INVALID', '账号需3–40位;密码需12–128位。') | |
| if not set(roles).issubset({'admin', 'reviewer', 'developer'}): | |
| raise SkillError('ROLE_INVALID', '角色无效。') | |
| if not setup: | |
| self.admin(actor) | |
| salt = secrets.token_hex(16) | |
| key = self.hashed(password, salt) | |
| with self.connect() as db: | |
| db.execute('BEGIN IMMEDIATE') | |
| if setup and db.execute('SELECT 1 FROM users WHERE enabled=1 LIMIT 1').fetchone(): | |
| raise SkillError('SETUP_COMPLETE', '管理员已经初始化。', 409) | |
| uid = 'user-' + uuid.uuid4().hex | |
| try: | |
| db.execute('INSERT INTO users(id,username,salt,password,roles,enabled) VALUES(?,?,?,?,?,1)', | |
| (uid, username, salt, key, json.dumps(['admin'] if setup else roles))) | |
| except sqlite3.IntegrityError: | |
| raise SkillError('USERNAME_EXISTS', '账号已存在。', 409) from None | |
| if setup: | |
| for row in db.execute('SELECT id FROM projects'): | |
| db.execute('INSERT OR IGNORE INTO members VALUES(?,?)', (row['id'], uid)) | |
| db.execute('INSERT INTO identity_audit(at,actor,action,target) VALUES(?,?,?,?)', | |
| (time.time(), 'first-local-setup' if setup else actor.user_id, 'account.create', uid)) | |
| return uid | |
| def login(self, username, password): | |
| if len(password) > 128: | |
| raise SkillError('LOGIN_FAILED', '账号或密码错误。', 401) | |
| with self.connect() as db: | |
| row = db.execute('SELECT * FROM users WHERE username=? AND enabled=1', (username,)).fetchone() | |
| # Do the expensive hash for nonexistent accounts too. | |
| computed = self.hashed(password, row['salt'] if row else '00' * 16) | |
| if row and row['locked_until'] > time.time(): | |
| raise SkillError('LOGIN_RATE_LIMITED', '登录失败过多,请稍后重试。', 429) | |
| if not row or not hmac.compare_digest(computed, row['password']): | |
| if row: | |
| count = row['failures'] + 1 | |
| db.execute('UPDATE users SET failures=?,locked_until=? WHERE id=?', | |
| (count, time.time() + 300 if count >= 5 else 0, row['id'])) | |
| db.commit() | |
| raise SkillError('LOGIN_FAILED', '账号或密码错误。', 401) | |
| db.execute('UPDATE users SET failures=0,locked_until=0 WHERE id=?', (row['id'],)) | |
| token, csrf = secrets.token_urlsafe(32), secrets.token_urlsafe(24) | |
| db.execute('INSERT INTO sessions VALUES(?,?,?,?)', (hashlib.sha256(token.encode()).hexdigest(), row['id'], csrf, time.time() + 28800)) | |
| return token, csrf | |
| def session(self, token): | |
| with self.connect() as db: | |
| row = db.execute('SELECT users.*,sessions.csrf FROM sessions JOIN users ON users.id=sessions.user_id WHERE token_hash=? AND expires>? AND enabled=1', | |
| (hashlib.sha256(token.encode()).hexdigest(), time.time())).fetchone() | |
| if not row: | |
| raise SkillError('TOKEN_INVALID', '请登录,或会话已过期。', 401) | |
| return Actor(tenant_id='demo-tenant', user_id=row['id'], roles=json.loads(row['roles'])), row['csrf'], row['username'] | |
| def logout(self, token): | |
| with self.connect() as db: | |
| db.execute('DELETE FROM sessions WHERE token_hash=?', (hashlib.sha256(token.encode()).hexdigest(),)) | |
| def actor(self, user_id): | |
| with self.connect() as db: | |
| row = db.execute('SELECT * FROM users WHERE id=?', (user_id,)).fetchone() | |
| if not row or (not row['enabled'] and user_id != 'local-example-builder'): | |
| raise SkillError('TOKEN_INVALID', '账号已停用。', 401) | |
| return Actor(tenant_id='demo-tenant', user_id=row['id'], roles=json.loads(row['roles'])) | |
| def project_access(self, actor, project_id): | |
| with self.connect() as db: | |
| found = db.execute('SELECT 1 FROM members WHERE project_id=? AND user_id=?', (project_id, actor.user_id)).fetchone() | |
| if actor.tenant_id != 'demo-tenant' or not found: | |
| raise SkillError('PROJECT_NOT_FOUND', '项目不存在或不可见。', 404) | |
| def projects(self, actor): | |
| with self.connect() as db: | |
| return [dict(x) for x in db.execute('SELECT projects.* FROM projects JOIN members ON projects.id=members.project_id WHERE user_id=?', (actor.user_id,))] | |
| def set_member(self, actor, project_id, user_id, enabled): | |
| self.admin(actor) | |
| self.project_access(actor, project_id) | |
| self.actor(user_id) | |
| with self.connect() as db: | |
| if enabled: | |
| db.execute('INSERT OR IGNORE INTO members VALUES(?,?)', (project_id, user_id)) | |
| else: | |
| db.execute('DELETE FROM members WHERE project_id=? AND user_id=?', (project_id, user_id)) | |
| db.execute('INSERT INTO identity_audit(at,actor,action,target) VALUES(?,?,?,?)', (time.time(), actor.user_id, 'member.grant' if enabled else 'member.revoke', project_id + ':' + user_id)) | |
| def seed_projects(self): | |
| with self.connect() as db: | |
| db.execute("INSERT OR IGNORE INTO users(id,username,salt,password,roles,enabled) VALUES('local-example-builder','local-example-builder','','','[\"admin\"]',0)") | |
| for key, name in [('erp-demo', 'ERP 采购编程'), ('wms-demo', 'WMS 库存编程'), ('equipment-demo', '设备运维编程'),('calculator-demo','网页计算器开发'),('pdf-demo','PDF解析开发'),('webapp-demo','网页应用开发')]: | |
| added=db.execute('INSERT OR IGNORE INTO projects VALUES(?,?)', (key, name)).rowcount | |
| db.execute('INSERT OR IGNORE INTO members VALUES(?,?)', (key, 'local-example-builder')) | |
| if added and key in {'calculator-demo','pdf-demo','webapp-demo'}: | |
| for row in db.execute("SELECT id FROM users WHERE username IN ('programmer','manager','tester') AND enabled=1").fetchall(): | |
| db.execute('INSERT OR IGNORE INTO members VALUES(?,?)',(key,row['id'])) | |
| def seed_demo_users(self): | |
| """Explicit loopback demo mode; never reset an existing account or its ACL.""" | |
| for username, roles in [('programmer',['developer']),('manager',['admin']),('tester',['reviewer'])]: | |
| with self.connect() as db: | |
| if db.execute('SELECT 1 FROM users WHERE username=?',(username,)).fetchone(): | |
| continue | |
| uid=self.create_user(username,'VibeCoding@2026',roles,actor=self.actor('local-example-builder')) | |
| with self.connect() as db: | |
| for project in ('erp-demo','wms-demo','equipment-demo','calculator-demo','pdf-demo','webapp-demo'): | |
| db.execute('INSERT INTO members VALUES(?,?)',(project,uid)) | |
| def users(self, actor): | |
| self.admin(actor) | |
| with self.connect() as db: | |
| return [dict(x) for x in db.execute('SELECT id,username,roles,enabled FROM users')] | |