src / db.py
Agnivesh10M's picture
Update db.py
f9fb3c4 verified
Raw History Blame Contribute Delete
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()