Spaces:
Running on Zero
Running on Zero
Download db.py from Agnivesh10M/src: direct link, hf CLI and curl.
- Browser
- Download file 7.17 kB
-
https://huggingface.co/spaces/Agnivesh10M/src/resolve/main/db.py
- Command line
-
hf download hf://spaces/Agnivesh10M/src/db.py
-
curl -L -o db.py https://huggingface.co/spaces/Agnivesh10M/src/resolve/main/db.py
7.17 kB
| import os | |
| from datetime import datetime, timedelta, timezone | |
| from supabase import create_client, Client | |
| from config import SUPABASE_URL, SUPABASE_KEY, API_ID, API_HASH | |
| class Database: | |
| def __init__(self): | |
| self.supabase: Client = create_client(SUPABASE_URL, SUPABASE_KEY) | |
| def add_user(self, user_id: int, name: str): | |
| try: | |
| res = self.supabase.table("users").select("user_id").eq("user_id", user_id).execute() | |
| if not res.data: | |
| self.supabase.table("users").insert({ | |
| "user_id": user_id, | |
| "name": name, | |
| "session": None, | |
| "api_id": None, | |
| "api_hash": None, | |
| "plan_expiry": None, | |
| "lang": "hi" | |
| }).execute() | |
| except Exception as e: | |
| print(f"Database add_user error: {e}") | |
| def get_user(self, user_id: int): | |
| try: | |
| res = self.supabase.table("users").select("*").eq("user_id", user_id).execute() | |
| return res.data[0] if res.data else None | |
| except Exception as e: | |
| print(f"Database get_user error: {e}") | |
| return None | |
| def get_all_users(self): | |
| try: | |
| res = self.supabase.table("users").select("*").execute() | |
| return res.data or [] | |
| except Exception as e: | |
| print(f"Database get_all_users error: {e}") | |
| return [] | |
| def set_session(self, user_id: int, session: str): | |
| try: | |
| self.supabase.table("users").update({"session": session}).eq("user_id", user_id).execute() | |
| except Exception as e: | |
| print(f"Database set_session error: {e}") | |
| def get_session(self, user_id: int): | |
| user = self.get_user(user_id) | |
| if user and user.get("session"): | |
| sess = str(user.get("session")).strip() | |
| return sess if len(sess) > 10 else None | |
| return None | |
| def remove_session(self, user_id: int): | |
| try: | |
| self.supabase.table("users").update({"session": None, "api_id": None, "api_hash": None}).eq("user_id", user_id).execute() | |
| except Exception as e: | |
| print(f"Database remove_session error: {e}") | |
| def set_api_id(self, user_id: int, api_id: str): | |
| try: | |
| self.supabase.table("users").update({"api_id": str(api_id)}).eq("user_id", user_id).execute() | |
| except Exception as e: | |
| print(f"Database set_api_id error: {e}") | |
| def get_api_id(self, user_id: int): | |
| user = self.get_user(user_id) | |
| val = user.get("api_id") if user else None | |
| if val and str(val).strip().isdigit(): | |
| return int(str(val).strip()) | |
| return API_ID | |
| def set_api_hash(self, user_id: int, api_hash: str): | |
| try: | |
| self.supabase.table("users").update({"api_hash": str(api_hash).strip()}).eq("user_id", user_id).execute() | |
| except Exception as e: | |
| print(f"Database set_api_hash error: {e}") | |
| def get_api_hash(self, user_id: int): | |
| user = self.get_user(user_id) | |
| val = user.get("api_hash") if user else None | |
| if val and len(str(val).strip()) >= 10: | |
| return str(val).strip() | |
| return API_HASH | |
| def set_lang(self, user_id: int, lang: str): | |
| try: | |
| self.supabase.table("users").update({"lang": lang}).eq("user_id", user_id).execute() | |
| except Exception as e: | |
| print(f"Database set_lang error: {e}") | |
| def get_lang(self, user_id: int): | |
| user = self.get_user(user_id) | |
| return user.get("lang") if (user and user.get("lang")) else "hi" | |
| def add_vip_user(self, user_id: int, days: int): | |
| try: | |
| user = self.get_user(user_id) | |
| now = datetime.now(timezone.utc) | |
| if user and user.get("plan_expiry"): | |
| try: | |
| exp_clean = user["plan_expiry"].replace("Z", "+00:00") | |
| current_exp = datetime.fromisoformat(exp_clean) | |
| if current_exp > now: | |
| new_exp = current_exp + timedelta(days=days) | |
| else: | |
| new_exp = now + timedelta(days=days) | |
| except Exception: | |
| new_exp = now + timedelta(days=days) | |
| else: | |
| new_exp = now + timedelta(days=days) | |
| exp_str = new_exp.isoformat() | |
| if user: | |
| self.supabase.table("users").update({"plan_expiry": exp_str}).eq("user_id", user_id).execute() | |
| else: | |
| self.supabase.table("users").insert({ | |
| "user_id": user_id, | |
| "name": "User", | |
| "plan_expiry": exp_str, | |
| "lang": "hi" | |
| }).execute() | |
| except Exception as e: | |
| print(f"Database add_vip_user error: {e}") | |
| def remove_vip_user(self, user_id: int): | |
| try: | |
| self.supabase.table("users").update({"plan_expiry": None}).eq("user_id", user_id).execute() | |
| except Exception as e: | |
| print(f"Database remove_vip_user error: {e}") | |
| def is_user_vip(self, user_id: int, admin_ids): | |
| # एडमिन हमेशा लाइफटाइम वीआईपी हैं | |
| if isinstance(admin_ids, list): | |
| if int(user_id) in [int(x) for x in admin_ids]: | |
| return True | |
| elif int(user_id) == int(admin_ids): | |
| return True | |
| user = self.get_user(user_id) | |
| if not user or not user.get("plan_expiry"): | |
| return False | |
| try: | |
| exp_clean = str(user["plan_expiry"]).replace("Z", "+00:00") | |
| exp = datetime.fromisoformat(exp_clean) | |
| if exp.tzinfo is None: | |
| exp = exp.replace(tzinfo=timezone.utc) | |
| return datetime.now(timezone.utc) < exp | |
| except Exception as e: | |
| print(f"VIP verification error for user {user_id}: {e}") | |
| return False | |
| def get_all_plans(self): | |
| default_plans = { | |
| "1day": "20", | |
| "5days": "50", | |
| "15days": "120", | |
| "30days": "199" | |
| } | |
| try: | |
| res = self.supabase.table("bot_settings").select("key, value").execute() | |
| if res.data: | |
| for row in res.data: | |
| k = row.get("key") | |
| v = row.get("value") | |
| if k in default_plans and v: | |
| default_plans[k] = str(v) | |
| except Exception as e: | |
| print(f"Database get_all_plans error: {e}") | |
| return default_plans | |
| def set_plan_price(self, plan_key: str, price: str): | |
| try: | |
| res = self.supabase.table("bot_settings").select("key").eq("key", plan_key).execute() | |
| if res.data: | |
| self.supabase.table("bot_settings").update({"value": str(price)}).eq("key", plan_key).execute() | |
| else: | |
| self.supabase.table("bot_settings").insert({"key": plan_key, "value": str(price)}).execute() | |
| except Exception as e: | |
| print(f"Database set_plan_price error: {e}") | |
| db = Database() | |