Skip to content
TheChatArchiveThe Chat Archive
gpt-4o-2024-08-06· OpenAIAi2 WildChat-4.8M (AI2)

Untitled conversation

  1. User

    Assistant: User: User: ``` import asyncio import random from datetime import datetime, timedelta from faker import Faker

    import sys import os from pathlib import Path

    print(Path(file).parent.parent)

    module_path = os.path.abspath(str(Path(file).parent.parent)) sys.path.append(module_path)

    from src.database.models import User, Role, Vacancy, Candidate, CandidateStatus, Task, Interview from src.loader import oauth2, db_manager

    fake = Faker()

    async def create_fake_users(num_users): roles = list(Role) users = [] for _ in range(num_users): users.append(User( username=fake.user_name(), name=fake.name(), email=fake.email(), role=random.choice(roles), hashed_password=random.choice([oauth2.get_password_hash(i) for i in ["1234", "1111", "2222", "12345"]]), refresh_token=None, created_at=datetime.now() ))

    async with db_manager.get_session() as session:
        session.add_all(users)
        await session.commit()
    
        
    

    Function to generate fake vacancies

    async def create_fake_vacancies(num_vacancies): async with db_manager.get_session() as session: users = session.query(User).all()

        for _ in range(num_vacancies):
            vacancy = Vacancy(
                title=fake.job(),
                description=fake.text(max_nb_chars=200),
                location=fake.city(),
                creator_username=random.choice(users).username,
                created_at=datetime.now(),
                status=random.choice([True, False])
            )
            session.add(vacancy)
        await session.commit()
    

    async def create_fake_candidates(num_candidates): async with db_manager.get_session() as session: vacancies = session.query(Vacancy).all()

        for _ in range(num_candidates):
            candidate = Candidate(
                first_name=fake.first_name(),
                family_name=fake.last_name(),
                surname=fake.last_name(),
                phone=fake.phone_number(),
                email=fake.email(),
                city=fake.city(),
                vacancy_id=random.choice(vacancies).id,
                resume_file=fake.file_path(extension='pdf'),
                created_at=datetime.now(),
                updated_at=datetime.now(),
                recruiter_description=fake.text(max_nb_chars=100),
                status=random.choice(list(CandidateStatus))
            )
            session.add(candidate)
    
        await session.commit()
    

    Function to generate fake tasks

    async def create_fake_tasks(num_tasks): async with db_manager.get_session() as session: users = session.query(User).all() for _ in range(num_tasks): task = Task( title=fake.sentence(nb_words=6), description=fake.text(max_nb_chars=200), status=random.choice([True, False]), task_creator=random.choice(users).username, task_receiver=random.choice(users).username, created_at=datetime.now(), updated_at=datetime.now() ) session.add(task) await session.commit()

    Function to generate fake interviews

    async def create_fake_interviews(num_interviews): async with db_manager.get_session() as session: users = session.query(User).all() candidates = session.query(Candidate).all() for _ in range(num_interviews): interview = Interview( recruiter_username=random.choice(users).username, candidate_id=random.choice(candidates).id, datetime=datetime.now() + timedelta(days=random.randint(1, 30)) ) session.add(interview) await session.commit()

    async def main(): await create_fake_users(10) await create_fake_vacancies(5) await create_fake_candidates(20) await create_fake_tasks(15) await create_fake_interviews(10)

    if name == "main": asyncio.run(main())

    
        users = session.query(User).all()
                ^^^^^^^^^^^^^
    AttributeError: 'AsyncSession' object has no attribute 'query'
    User: поправь весь мой код
    
    

    import asyncio import random from datetime import datetime, timedelta from faker import Faker

    import sys import os from pathlib import Path

    print(Path(file).parent.parent)

    module_path = os.path.abspath(str(Path(file).parent.parent)) sys.path.append(module_path)

    from src.database.models import User, Role, Vacancy, Candidate, CandidateStatus, Task, Interview from src.loader import oauth2, db_manager

    fake = Faker()

    async def create_fake_users(num_users): roles = list(Role) users = [] for _ in range(num_users): users.append(User( username=fake.user_name(), name=fake.name(), email=fake.email(), role=random.choice(roles), hashed_password=random.choice([oauth2.get_password_hash(i) for i in ["1234", "1111", "2222", "12345"]]), refresh_token=None, created_at=datetime.now() ))

    async with db_manager.get_session() as session:
        session.add_all(users)
        await session.commit()
    
        
    

    Function to generate fake vacancies

    async def create_fake_vacancies(num_vacancies): async with db_manager.get_session() as session: users = session.query(User).all()

        for _ in range(num_vacancies):
            vacancy = Vacancy(
                title=fake.job(),
                description=fake.text(max_nb_chars=200),
                location=fake.city(),
                creator_username=random.choice(users).username,
                created_at=datetime.now(),
                status=random.choice([True, False])
            )
            session.add(vacancy)
        await session.commit()
    

    async def create_fake_candidates(num_candidates): async with db_manager.get_session() as session: vacancies = session.query(Vacancy).all()

        for _ in range(num_candidates):
            candidate = Candidate(
                first_name=fake.first_name(),
                family_name=fake.last_name(),
                surname=fake.last_name(),
                phone=fake.phone_number(),
                email=fake.email(),
                city=fake.city(),
                vacancy_id=random.choice(vacancies).id,
                resume_file=fake.file_path(extension='pdf'),
                created_at=datetime.now(),
                updated_at=datetime.now(),
                recruiter_description=fake.text(max_nb_chars=100),
                status=random.choice(list(CandidateStatus))
            )
            session.add(candidate)
    
        await session.commit()
    

    Function to generate fake tasks

    async def create_fake_tasks(num_tasks): async with db_manager.get_session() as session: users = session.query(User).all() for _ in range(num_tasks): task = Task( title=fake.sentence(nb_words=6), description=fake.text(max_nb_chars=200), status=random.choice([True, False]), task_creator=random.choice(users).username, task_receiver=random.choice(users).username, created_at=datetime.now(), updated_at=datetime.now() ) session.add(task) await session.commit()

    Function to generate fake interviews

    async def create_fake_interviews(num_interviews): async with db_manager.get_session() as session: users = session.query(User).all() candidates = session.query(Candidate).all() for _ in range(num_interviews): interview = Interview( recruiter_username=random.choice(users).username, candidate_id=random.choice(candidates).id, datetime=datetime.now() + timedelta(days=random.randint(1, 30)) ) session.add(interview) await session.commit()

    async def main(): await create_fake_users(10) await create_fake_vacancies(5) await create_fake_candidates(20) await create_fake_tasks(15) await create_fake_interviews(10)

    if name == "main": asyncio.run(main())

    Assistant:
    Assistant:
    
  2. Assistant

    The AttributeError: 'AsyncSession' object has no attribute 'query' error comes from attempting to use SQLAlchemy's synchronous query method on an asynchronous session object. To resolve this, you'll want to use SQLAlchemy's async querying capabilities. I will refactor your code to use select statements combined with the scalars method to perform queries within an async session.

    Here's how you can update your code:

    import asyncio
    import random
    from datetime import datetime, timedelta
    from faker import Faker
    
    import sys
    import os
    from pathlib import Path
    
    from sqlalchemy.future import select
    
    print(Path(__file__).parent.parent)
    
    module_path = os.path.abspath(str(Path(__file__).parent.parent))
    sys.path.append(module_path)
    
    from src.database.models import User, Role, Vacancy, Candidate, CandidateStatus, Task, Interview
    from src.loader import oauth2, db_manager
    
    fake = Faker()
    
    async def create_fake_users(num_users):
        roles = list(Role)
        users = []
        for _ in range(num_users):
            users.append(User(
                username=fake.user_name(),
                name=fake.name(),
                email=fake.email(),
                role=random.choice(roles),
                hashed_password=random.choice([oauth2.get_password_hash(i) for i in ["1234", "1111", "2222", "12345"]]),
                refresh_token=None,
                created_at=datetime.now()
            ))
    
        async with db_manager.get_session() as session:
            session.add_all(users)
            await session.commit()
    
    async def create_fake_vacancies(num_vacancies):
        async with db_manager.get_session() as session:
            result = await session.execute(select(User))
            users = result.scalars().all()
    
            for _ in range(num_vacancies):
                vacancy = Vacancy(
                    title=fake.job(),
                    description=fake.text(max_nb_chars=200),
                    location=fake.city(),
                    creator_username=random.choice(users).username,
                    created_at=datetime.now(),
                    status=random.choice([True, False])
                )
                session.add(vacancy)
            await session.commit()
    
    async def create_fake_candidates(num_candidates):
        async with db_manager.get_session() as session:
            result = await session.execute(select(Vacancy))
            vacancies = result.scalars().all()
    
            for _ in range(num_candidates):
                candidate = Candidate(
                    first_name=fake.first_name(),
                    family_name=fake.last_name(),
                    surname=fake.last_name(),
                    phone=fake.phone_number(),
                    email=fake.email(),
                    city=fake.city(),
                    vacancy_id=random.choice(vacancies).id,
                    resume_file=fake.file_path(extension='pdf'),
                    created_at=datetime.now(),
                    updated_at=datetime.now(),
                    recruiter_description=fake.text(max_nb_chars=100),
                    status=random.choice(list(CandidateStatus))
                )
                session.add(candidate)
    
            await session.commit()
    
    async def create_fake_tasks(num_tasks):
        async with db_manager.get_session() as session:
            result = await session.execute(select(User))
            users = result.scalars().all()
    
            for _ in range(num_tasks):
                task = Task(
                    title=fake.sentence(nb_words=6),
                    description=fake.text(max_nb_chars=200),
                    status=random.choice([True, False]),
                    task_creator=random.choice(users).username,
                    task_receiver=random.choice(users).username,
                    created_at=datetime.now(),
                    updated_at=datetime.now()
                )
                session.add(task)
            await session.commit()
    
    async def create_fake_interviews(num_interviews):
        async with db_manager.get_session() as session:
            result_users = await session.execute(select(User))
            users = result_users.scalars().all()
    
            result_candidates = await session.execute(select(Candidate))
            candidates = result_candidates.scalars().all()
    
            for _ in range(num_interviews):
                interview = Interview(
                    recruiter_username=random.choice(users).username,
                    candidate_id=random.choice(candidates).id,
                    datetime=datetime.now() + timedelta(days=random.randint(1, 30))
                )
                session.add(interview)
            await session.commit()
    
    async def main():
        await create_fake_users(10)
        await create_fake_vacancies(5)
        await create_fake_candidates(20)
        await create_fake_tasks(15)
        await create_fake_interviews(10)
    
    if __name__ == "__main__":
        asyncio.run(main())
    

    Key Changes:

    1. Queries: Use select() statements to construct SQL queries inside an async context.
    2. Results Handling: Use .scalars().all() on executed queries to extract all instances of a particular model.
    3. Session Management: Keep using the async context to manage sessions appropriately.

    These changes follow best practices with SQLAlchemy for asynchronous database operations.