🐛: Inconsistent API Dev project

[yashksaini-coder]

Title

Inconsistent code, Bugs and errors in Database Setup, FastAPI API, and SQLAlchemy Model

Bug

Several issues were identified across three files related to database setup, FastAPI API development, and model constraints. These bugs affect database table creation, API responses, and data validation. Specifically:

• Missing model creation in the database setup file.
• Inconsistent API response models in the FastAPI endpoints.
• Improper handling of unique constraints and string lengths in the SQLAlchemy model.

Changes

Database Setup File

• Add Base.metadata.create_all(bind=engine) to ensure the tables are created in the database.

FastAPI API File

• Add a response_model=BookBase to the get_book() method decorator.
• Implement checks for existing books or handle the SQLAlchemy Integrity Error.
• Adjust the return to None or change the status code to 200 OK with a message.

SQLAlchemy Model File

• Remove the (unique=True) from author if duplicate authors are allowed.
• Increase the character limit from String(100) or String(255) for more flexibility.

Screenshots 📷

Full Name

Yash K. Saini

Participant Role

GSSOC

[github-actions]

🙌 Thank you for bringing this issue to our attention! We appreciate your input and will investigate it as soon as possible.

Feel free to join our community on Discord to discuss more!

[yashksaini-coder]

@UTSAVS26 can you assign me this issue with proper labels

[yashksaini-coder]

hey @UTSAVS26 can you assign me this issue

[github-actions]

✅ This issue has been closed. Thank you for your contribution! If you have any further questions or issues, feel free to join our community on Discord to discuss more!

[github-actions]

✅ This issue has been closed. Thank you for your contribution! If you have any further questions or issues, feel free to join our community on Discord to discuss more!