forked from mtusi2026/mtusi2026lab2
85 lines
3.0 KiB
Python
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()) |