AttributeError: 'function' object has no attribute 'metadata

[3lnyn0]

Hi!
Please help me with the error below.

Error:
    Base.metadata.create_all(engine)
AttributeError: 'function' object has no attribute 'metadata

repository -> users.py

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43

from Model.Domain.users import Users from sqlalchemy.orm import sessionmaker from datetime import datetime   from Utils.utils import Base, engine     class DBUsersRepository:     def __init__(self):         self.session = sessionmaker(engine)()       # Create new user     def add_user(self, user_id, first_name, last_name, email_name, phone_number, address, date_of_birth, join_date):         new_user = Users(             user_id=user_id,             first_name=first_name,             last_name=last_name,             email_name=email_name,             address=address,             phone_number=phone_number,             date_of_birth=date_of_birth,             join_date=join_date         )           self.session.add(new_user)         self.session.commit()       if __name__ == '__main__':     Base.metadata.create_all(engine)     user_repo = DBUsersRepository()       user_repo.add_user(         user_id='1234567890123',         first_name='fname',         last_name='lname',         email_name='fname.lname@yahoo.com',         address='address1',         phone_number=757271432,         date_of_birth='2000-22-10',         join_date=datetime.now()     )

Utils.py

1 2 3 4 5 6

from sqlalchemy.ext.declarative import declarative_base from sqlalchemy import create_engine   Base = declarative_base   engine = create_engine('mysql+pymysql://root@localhost:3306/BankApp')

domain -> users.py

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

from sqlalchemy.ext.declarative import declarative_base from sqlalchemy import Column, String, Integer from sqlalchemy.types import DateTime   Base = declarative_base()     class Users(Base):       __tablename__ = 'users'       user_id = Column(String(13), primary_key=True)     first_name = Column(String(30), nullable=False)     last_name = Column(String(30), nullable=False)     email_name = Column(String(50), nullable=False)     address = Column(String(50), nullable=False)     phone_number = Column(String(10), nullable=False)     date_of_birth = Column(DateTime, nullable=False)     join_date = Column(DateTime, nullable=False)       def __repr__(self):         return f'user id = {self.user_id}\n' \                f'first name = {self.first_name}\n' \                f'last name = {self.last_name}\n' \                f'email = {self.email_name}\n' \                f'phone = {self.phone_number}\n' \                f'date of birth = {self.date_of_birth}\n' \                f'join date = {self.join_date}'

[deanhystad]

In utils.py you have this:

1	Base = declarative_base

declaritive_base is a function, so Base = declaritive_base is a function. Base = declaritive_base() calls the function and assigns the result to Base.

[3lnyn0]

In utils.py you have this:

1	Base = declarative_base

declaritive_base is a function, so Base = declaritive_base is a function. Base = declaritive_base() calls the function and assigns the result to Base.

You're right, I got rid of the first mistake.
But now I'm getting another error

Error:
sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'BankApp.users' doesn't exist")
[SQL: INSERT INTO users (user_id, first_name, last_name, email_name, address, phone_number, date_of_birth, join_date) VALUES (%(user_id)s, %(first_name)s, %(last_name)s, %(email_name)s, %(address)s, %(phone_number)s, %(date_of_birth)s, %(join_date)s)]
[parameters: {'user_id': '1234567890123', 'first_name': 'fname', 'last_name': 'lname', 'email_name': 'fname.lastname@yahoo.com', 'address': 'address1', 'phone_number': 757271432, 'date_of_birth': '2000-22-10', 'join_date': datetime.datetime(2022, 3, 28, 8, 27, 3, 742772)}]
(Background on this error at: https://sqlalche.me/e/14/f405)

[ibreeden]

(1146, "Table 'BankApp.users' doesn't exist")

I think this means you should first create the table "users" in schema "BankApp".

[3lnyn0]

(1146, "Table 'BankApp.users' doesn't exist")

I think this means you should first create the table "users" in schema "BankApp".

That's why I use base.metadata to automatically create my tables.
If I create them I don't use the base anymore.

[Larz60+]

I have a tutorial here: https://python-forum.io/thread-24127.html
take a look at the model in the tutorial