🔒 Trying to create all mysql tables in sql alchemy but i suck

[weary schooner]

im trying to create the "users" table
i defined the database.py (where i create all the tables) here: https://github.com/SockYeh/stockyeh/blob/database-integration/stockyeh/backend/database.py#L42-L45
and this is where i define the model: https://github.com/SockYeh/stockyeh/blob/database-integration/stockyeh/backend/models/user.py

[trail patrol]

@weary schooner

Python help channel opened

Remember to:

• Ask your Python question, not if you can ask or if there's an expert who can help.
• Show a code sample as text (rather than a screenshot) and the error message, if you've got one.
• Explain what you expect to happen and what actually happens.

:warning: Do not pip install anything that isn't related to your question, especially if asked to over DMs.

Closes after a period of inactivity, or when you send !close.

stockyeh/backend/database.py lines 42 to 45

async def create_tables():
    async with async_engine.begin() as conn:
        e = await conn.run_sync(MappedBase.metadata.create_all)
        print(e)```

[weary schooner]

but when i run the code

it doesnt create any tables

[weary schooner]

the create_table function is called here btw: https://github.com/SockYeh/stockyeh/blob/database-integration/stockyeh/backend/main.py#L9-L15

[trail patrol]

stockyeh/backend/main.py lines 9 to 15

@asynccontextmanager
async def lifespan(app: FastAPI):
    await create_tables()
    yield


app = FastAPI(lifespan=lifespan)```

[weary schooner]

im new to sql alchemy so i have no clue whats going on :p

[pastel girder]

you wanna create table using python?

[weary schooner]

yes

[pastel girder]

you need to use ALTER

[weary schooner]

my guy

its sql alchemy

[pastel girder]

metadata?

[weary schooner]

e

[weary schooner]

!close

[trail patrol]

Python help channel closed

This help channel has been closed and it's no longer possible to send messages here. If your question wasn't answered, feel free to create a new post in #1035199133436354600. To maximize your chances of getting a response, check out this guide on asking good questions.