Files
2026-11-06 04:33:40 +03:00

85 lines
3.0 KiB
Python

import asyncio
import uuid
from datetime import datetime, timezone
from sqlalchemy.ext.asyncio import create_async_engine, async_sessionmaker, AsyncSession
from sqlalchemy import insert
from sqlalchemy.orm import declarative_base
from sqlalchemy import Column, String, DateTime, ForeignKey, Text
from sqlalchemy.dialects.postgresql import UUID
DATABASE_URL = "postgresql+asyncpg://postgres:postgres@db:5432/messenger"
Base = declarative_base()
class User(Base):
__tablename__ = "users"
id = Column(UUID(as_uuid=True), primary_key=True)
username = Column(String(50), unique=True)
display_name = Column(String(100), nullable=False)
password_hash = Column(String(255), nullable=False)
created_at = Column(DateTime(timezone=True), nullable=False)
class Chat(Base):
__tablename__ = "chats"
id = Column(UUID(as_uuid=True), primary_key=True)
title = Column(String(255))
created_at = Column(DateTime(timezone=True), nullable=False)
class ChatMember(Base):
__tablename__ = "chat_members"
chat_id = Column(UUID(as_uuid=True), primary_key=True)
user_id = Column(UUID(as_uuid=True), primary_key=True)
joined_at = Column(DateTime(timezone=True), nullable=False)
class Message(Base):
__tablename__ = "messages"
id = Column(UUID(as_uuid=True), primary_key=True)
chat_id = Column(UUID(as_uuid=True), nullable=False)
sender_id = Column(UUID(as_uuid=True), nullable=False)
text = Column(Text, nullable=False)
created_at = Column(DateTime(timezone=True), nullable=False)
async def main():
engine = create_async_engine(DATABASE_URL)
SessionLocal = async_sessionmaker(engine, class_=AsyncSession, expire_on_commit=False)
async with SessionLocal() as session:
print("Создаем пользователя и чат...")
now = datetime.now(timezone.utc)
user = User(
id=uuid.uuid4(),
username=f"gen_{uuid.uuid4().hex[:6]}",
display_name="Generator",
password_hash="hash",
created_at=now
)
session.add(user)
await session.commit() # Сохраняем пользователя СРАЗУ
chat = Chat(id=uuid.uuid4(), title="Big Chat", created_at=now)
session.add(chat)
await session.commit() # Сохраняем чат СРАЗУ
member = ChatMember(chat_id=chat.id, user_id=user.id, joined_at=now)
session.add(member)
await session.commit()
print(f"Генерируем 10 000 сообщений...")
messages = []
for i in range(10000):
messages.append({
"id": uuid.uuid4(),
"chat_id": chat.id,
"sender_id": user.id,
"text": f"Message {i}",
"created_at": now
})
for i in range(0, len(messages), 1000):
await session.execute(insert(Message).values(messages[i:i+1000]))
await session.commit()
print(f"ГОТОВО! chat_id: {chat.id}")
if __name__ == "__main__":
asyncio.run(main())