Spaces:
Sleeping
Sleeping
Download models.py from alfarouqwebserver/SWS-Smarta: direct link, hf CLI and curl.
- Browser
- Download file 8.98 kB
-
https://huggingface.co/spaces/alfarouqwebserver/SWS-Smarta/resolve/main/models.py
- Command line
-
hf download hf://spaces/alfarouqwebserver/SWS-Smarta/models.py
-
curl -L -o models.py https://huggingface.co/spaces/alfarouqwebserver/SWS-Smarta/resolve/main/models.py
8.98 kB
| from extensions import db | |
| from flask_login import UserMixin | |
| from datetime import datetime | |
| # --- جدول العلاقات (Many-to-Many) بين المستخدمين --- | |
| # يستخدم لربط المستخدمين ببعضهم (Contacts/Friends) | |
| user_connections = db.Table('user_connections', | |
| db.Column('user_a_id', db.Integer, db.ForeignKey('user.id')), | |
| db.Column('user_b_id', db.Integer, db.ForeignKey('user.id')) | |
| ) | |
| # --- 1. جدول المستخدمين (User) --- | |
| class User(db.Model, UserMixin): | |
| id = db.Column(db.Integer, primary_key=True) | |
| username = db.Column(db.String(150), unique=True, nullable=False) | |
| password = db.Column(db.String(150), nullable=False) | |
| role = db.Column(db.String(50), default='user') # server_admin, project_admin, user, smarta_user | |
| # الصلاحيات والمشاريع (String يخزن نصاً مثل "SMARTA,DINO,WIFI") | |
| allowed_projects = db.Column(db.String(500), default='') | |
| # إعدادات البروفايل | |
| profile_pic = db.Column(db.String(150), default='default.png') | |
| bio = db.Column(db.String(500), default='مستخدم في نظام AWS') | |
| theme = db.Column(db.String(20), default='dark') # dark or light | |
| # Sub-server approvals | |
| subserver_admin_approved = db.Column(db.Boolean, default=False) | |
| subserver_user_approved = db.Column(db.Boolean, default=False) | |
| # العلاقات | |
| # 1. الرسائل المرسلة والمستقبلة | |
| sent_logs = db.relationship('ProjectLog', foreign_keys='ProjectLog.sender_id', backref='sender', lazy=True) | |
| received_logs = db.relationship('ProjectLog', foreign_keys='ProjectLog.recipient_id', backref='recipient', lazy=True) | |
| # 2. المستخدمين المتصلين (Self-Referential Many-to-Many) | |
| connected_users = db.relationship('User', | |
| secondary=user_connections, | |
| primaryjoin=(user_connections.c.user_a_id == id), | |
| secondaryjoin=(user_connections.c.user_b_id == id), | |
| backref=db.backref('friends', lazy='dynamic'), | |
| lazy='dynamic') | |
| # --- 1B. إعدادات مستخدمي SMARTA (صلاحيات ورسائل) --- | |
| class SmartaUserSettings(db.Model): | |
| id = db.Column(db.Integer, primary_key=True) | |
| user_id = db.Column(db.Integer, db.ForeignKey('user.id'), unique=True, nullable=False) | |
| # صلاحيات أساسية | |
| can_message = db.Column(db.Boolean, default=True) | |
| can_upload = db.Column(db.Boolean, default=True) | |
| can_use_ai = db.Column(db.Boolean, default=True) | |
| # صلاحيات الإرسال | |
| allow_broadcast = db.Column(db.Boolean, default=True) | |
| allowed_recipients = db.Column(db.Text, default='') # CSV of user IDs (فارغ = لا قيود) | |
| updated_at = db.Column(db.DateTime, default=datetime.now, onupdate=datetime.now) | |
| user = db.relationship('User', backref=db.backref('smarta_settings', uselist=False)) | |
| # --- 1C. طلبات إنشاء حساب SMARTA --- | |
| class SmartaAccountRequest(db.Model): | |
| id = db.Column(db.Integer, primary_key=True) | |
| full_name = db.Column(db.String(200), nullable=False) | |
| desired_username = db.Column(db.String(150), nullable=False) | |
| phone = db.Column(db.String(50), nullable=False) | |
| email = db.Column(db.String(200), nullable=True) | |
| password_hash = db.Column(db.String(200), nullable=False) | |
| status = db.Column(db.String(20), default='pending') # pending, approved, rejected | |
| created_at = db.Column(db.DateTime, default=datetime.now) | |
| # --- 2. جدول المخازن والوحدات الخارجية (RemoteNode) --- | |
| class RemoteNode(db.Model): | |
| id = db.Column(db.Integer, primary_key=True) | |
| unique_key = db.Column(db.String(100), unique=True, nullable=False) # مفتاح الأمان للربط | |
| name = db.Column(db.String(100), nullable=False) | |
| project_type = db.Column(db.String(50), default='SMARTA') # smarta, inventory, security... | |
| is_active = db.Column(db.Boolean, default=True) | |
| ip_address = db.Column(db.String(50)) # لتسجيل IP الوحدة | |
| last_heartbeat = db.Column(db.DateTime, default=datetime.now) | |
| # --- 3. جدول السجلات والبيانات (ProjectLog) --- | |
| # هذا الجدول هو "قلب" النظام، يخزن الشات، الصور، بيانات الحساسات، والتقارير | |
| class ProjectLog(db.Model): | |
| id = db.Column(db.Integer, primary_key=True) | |
| timestamp = db.Column(db.DateTime, default=datetime.now) | |
| # العلاقات (من أرسل؟) | |
| source_node_id = db.Column(db.Integer, db.ForeignKey('remote_node.id'), nullable=True) | |
| source_node = db.relationship('RemoteNode', backref='logs') | |
| sender_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=True) | |
| # العلاقات (لمن أرسل؟) | |
| recipient_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=True) | |
| # المحتوى | |
| action_type = db.Column(db.String(50)) # message, upload, sensor_data | |
| content = db.Column(db.Text) # نص الرسالة، اسم الملف، أو قراءة الحساس | |
| ai_status = db.Column(db.Text) # نتيجة الذكاء الاصطناعي (Detected: Apple=3) | |
| ai_payload = db.Column(db.Text, nullable=True) # JSON payload with structured detection data | |
| sync_id = db.Column(db.String(80), nullable=True) # Unique sync id for replication | |
| origin_node = db.Column(db.String(80), nullable=True) # Node identifier for replication | |
| # --- 3B. SmartA Mesh Nodes (Replication/Activation) --- | |
| class SmartaNode(db.Model): | |
| id = db.Column(db.Integer, primary_key=True) | |
| install_code = db.Column(db.String(120), unique=True, nullable=False) | |
| node_id = db.Column(db.String(80), unique=True, nullable=True) | |
| node_name = db.Column(db.String(120), default='SMARTA_NODE') | |
| api_key = db.Column(db.String(120), nullable=True) | |
| activation_token = db.Column(db.String(120), nullable=True) | |
| approved = db.Column(db.Boolean, default=False) | |
| can_send = db.Column(db.Boolean, default=True) | |
| allowed_sources = db.Column(db.Text, default='') # CSV of allowed origin_node values or "*" or "none" | |
| public_url = db.Column(db.Text, nullable=True) | |
| last_seen = db.Column(db.DateTime, default=datetime.now) | |
| created_at = db.Column(db.DateTime, default=datetime.now) | |
| # --- 4. جدول الروابط المختصرة (ShortLink) --- | |
| class ShortLink(db.Model): | |
| id = db.Column(db.Integer, primary_key=True) | |
| name = db.Column(db.String(100)) | |
| original_url = db.Column(db.Text, nullable=False) | |
| short_code = db.Column(db.String(50), unique=True, nullable=False) | |
| visits = db.Column(db.Integer, default=0) | |
| created_at = db.Column(db.DateTime, default=datetime.now) | |
| # --- 5. جدول نشاط المستخدمين (UserActivity - Monitor) --- | |
| class UserActivity(db.Model): | |
| id = db.Column(db.Integer, primary_key=True) | |
| username = db.Column(db.String(100)) | |
| role = db.Column(db.String(50)) | |
| ip_address = db.Column(db.String(50)) | |
| device_info = db.Column(db.String(250)) | |
| page_accessed = db.Column(db.String(200)) | |
| method = db.Column(db.String(10)) # GET, POST | |
| timestamp = db.Column(db.DateTime, default=datetime.now) | |
| # --- 6. سجلات النظام (SystemLog - Admin Tools) --- | |
| class SystemLog(db.Model): | |
| id = db.Column(db.Integer, primary_key=True) | |
| level = db.Column(db.String(20)) # INFO, WARNING, ERROR | |
| message = db.Column(db.Text) | |
| timestamp = db.Column(db.DateTime, default=datetime.now) | |
| # --- 7. جدول محادثات الفريق (Collab Chat) --- | |
| class ChatMessage(db.Model): | |
| id = db.Column(db.Integer, primary_key=True) | |
| sender_id = db.Column(db.Integer, db.ForeignKey('user.id')) | |
| sender_name = db.Column(db.String(100)) | |
| content = db.Column(db.Text) | |
| is_general = db.Column(db.Boolean, default=True) | |
| timestamp = db.Column(db.DateTime, default=datetime.now) | |
| # --- 8. جدول المهام (Kanban Tasks) --- | |
| class Task(db.Model): | |
| id = db.Column(db.Integer, primary_key=True) | |
| title = db.Column(db.String(250), nullable=False) | |
| status = db.Column(db.String(50), default='todo') # todo, doing, done | |
| assigned_to = db.Column(db.String(100)) | |
| created_at = db.Column(db.DateTime, default=datetime.now) | |
| # --- 9. Dino Match Results --- | |
| class DinoMatchResult(db.Model): | |
| id = db.Column(db.Integer, primary_key=True) | |
| room = db.Column(db.String(100), default='') | |
| winner_name = db.Column(db.String(100), default='') | |
| winner_id = db.Column(db.Integer, default=-1) | |
| total_rounds = db.Column(db.Integer, default=0) | |
| player_count = db.Column(db.Integer, default=0) | |
| wins_json = db.Column(db.Text, default='{}') | |
| created_at = db.Column(db.DateTime, default=datetime.now) | |