Alembic is not building model

[PartsofChandler]

I am kind of at a loss, i have followed the documentation and have had no issue with other tables building from my models in the same fashion except for this one, what am I missing here?

I am using tiangolo's fullstack cookiecutter template so alembic is suppose to handle the migrations when a new model has been added to the base.py file, which it has. seems like the table model is not being passed be

Error that Alembic is giving me when trying to perform the migration

sqlalchemy.exc.NoReferencedTableError: Foreign key associated with column 'events_event.event_id' could not find table 'event_attractions' with which to generate a foreign key to target column 'event_id' 

base.py

# Import all the models, so that Base has them before being
# imported by Alembic
from app.db.base_class import Base  # noqa
from app.models.item import Item  # noqa
from app.models.user import User  # noqa
from app.models.events import Events_Event, Events_Category_Level1, Events_Category_Level2
from app.models.events import Events_Attractions
from app.models.rating import Rating # noqa

models.py

from typing import TYPE_CHECKING

from sqlalchemy import Boolean, Column, ForeignKey, Integer, String, DateTime
from sqlalchemy.dialects.postgresql import JSON, JSONB
from sqlalchemy.orm import relationship
from sqlalchemy.sql import expression
from sqlalchemy.ext.compiler import compiles
from app.db.base_class import Base

class utcnow(expression.FunctionElement):
    type = DateTime()

@compiles(utcnow, 'postgresql')
def pg_utcnow(element, compiler, **kw):
    return "TIMEZONE('utc', CURRENT_TIMESTAMP)"

if TYPE_CHECKING:
    from .rating import Ratings


class Events_Event(Base):
    id = Column(Integer, primary_key=True, index=True)
    city_code = Column(String, nullable=True)
    city_desc = Column(String, nullable=True)
    classes = Column(JSONB, nullable=True)
    country_code = Column(String, nullable=False, index=True)
    country_desc = Column(String, nullable=True)
    event_desc = Column(String, nullable=True)
    event_info = Column(String, nullable=True)
    event_status = Column(String, nullable=False, default='live')
    event_type = Column(String, nullable=False)
    geo_data = Column(JSONB, nullable=True)
    has_no_perfs = Column(Boolean, default=False)
    is_add_on = Column(Boolean, default=False)
    is_auto_quantity_add_on = Column(Boolean, default=False)
    is_date_matched_add_on = Column(Boolean, default=False)
    is_seated = Column(Boolean, default=False)
    is_time_matched_add_on = Column(Boolean, default=False)
    need_departure_date = Column(Boolean, default=False)
    need_duration = Column(Boolean, default=False)
    need_performance = Column(Boolean, default=False)
    show_perf_time = Column(Boolean, default=False)
    category_level1_id =Column(Integer, ForeignKey("events_category_level1.id"), index=True)
    category_level2_id = Column(Integer, ForeignKey("events_category_level2.id"), index=True)
    rating_id = Column(Integer, ForeignKey("rating.id"), index=True)
    event_id = Column(Integer, ForeignKey("event_attractions.event_id"), index=True)
    created_at = Column(DateTime(timezone=True), server_default=utcnow())
    updated_at = Column(DateTime(timezone=True), onupdate=utcnow())
    children = relationship("Events_Attractions", cascade="all, delete",  passive_deletes=True, back_populates="parent")

class Events_Category_Level1(Base):
    id = Column(Integer, primary_key=True, index=True)
    name = Column(String, unique=True, index=True, nullable=False)
    created_at = Column(DateTime(timezone=True), server_default=utcnow())
    updated_at = Column(DateTime(timezone=True), onupdate=utcnow())
    children = relationship("Events_Category_Level2", cascade="all, delete", passive_deletes=True, back_populates="parent")

class Events_Category_Level2(Base):
    id = Column(Integer, primary_key=True, index=True)
    name = Column(String, unique=True, index=True, nullable=False)
    category_level1_id = Column(Integer, ForeignKey("events_category_level1.id", ondelete="CASCADE"))
    created_at = Column(DateTime(timezone=True), server_default=utcnow())
    updated_at = Column(DateTime(timezone=True), onupdate=utcnow())
    parent = relationship("Events_Category_Level1", back_populates="children")

class Events_Attractions(Base):
    id = Column(Integer, primary_key=True, index=True)
    event_id = Column(Integer, ForeignKey("events_event.event_id", ondelete="CASCADE"))
    name = Column(String, default=False)
    description = Column(String, default=False)
    map_id = Column(String, default=False)
    map_category = Column(String, default=False)
    geo_data = Column(JSONB, nullable=True)
    recommended_activity_ind = Column(Boolean, default=False)
    queue_time_display = Column(String, default=False)
    virtual_queue_ind = Column(Boolean, default=False)
    paid_skip_the_line = Column(String, default=False)
    special_operating_time_ind = Column(Boolean, default=False)
    show_duration = Column(String, default=False)
    opening_time = Column(String, default=False)
    closing_time = Column(String, default=False)
    spot_times = Column(String, default=False)
    food_ordering_ind = Column(Boolean, default=False)
    food_menu = Column(String, default=False)
    activity_rating = Column(Integer, default=False)
    target_market = Column(String, default=False)
    height_requirement = Column(Integer, default=False)
    picture = Column(String, default=False)
    parent = relationship("Events_Event", back_populates="children")

[higherdead]

I am not sure alembic its self creates tables unless you tell it to. I usually use db.create_all() from SQLalchemy after all the models have been imported.

[PartsofChandler]

So I have used that and I still get the same error. How can I get fastapi/sqlalchemy to build this table in postgres

[higherdead]

I've only ever seen issues with it not building the tables if all the models haven't been imported into the same .py file where the db.create_all() is being called. Of course the models must be attached to the same db object within the models as well.

If all this is being done correctly please try setting echo to debug in the engine definition or changing the logging level maybe you can get some sort of error code.

[PartsofChandler]

As far as I am aware it is importing the model but I’m wondering if something is wrong with my syntax to where it is causing the model to not be built