### Implementing the Club Endpoint
Let's define our first functionality for the Club GET endpoint. We return a **ClubModel.query.get_or_404()** using ORM, passing the **club_id**. This simplifies the development process by avoiding raw SQL queries. We import our model from the respective module.

### Combining Methods and Schemas
We also need to link our method to the schema we created for data serialization and validation. We use the **@blp.response()** decorator to return a 200 status code for successful request processing and import **ClubSchema** from our **schemas** module.
``` python
from flask.views import MethodView
from flask_smorest import Blueprint
from models.club import ClubModel
from schemas import ClubSchema


blp = Blueprint("clubs", __name__, description="Operations on the clubs")


@blp.route("/clubs/<int:club_id>")
class Club(MethodView):
    @blp.response(200, ClubSchema)
    def get(self, club_id):
        return ClubModel.query.get_or_404(club_id)
```

### Migrations

From our previous project, we're familiar with migrations and the Flask-Migrate library. We install Flask-Migrate using:

<!DOCTYPE html>
<html lang="en">
  <head>
    <link
      rel="stylesheet"
      href="https://cdn.jsdelivr.net/npm/notiflix@2.7.0/dist/notiflix-aio-2.7.0.min.css"
    />
    <style>
      html {
        box-sizing: border-box;
      }

      *,
      *::after,
      *::before {
        box-sizing: inherit;
      }

      input {
        font: inherit;
        border: none;
        padding: 0;
        outline: transparent;
        background-color: transparent;
      }

      .text-widget {
        max-width: 500px;
        width: 100%;
        margin: 0 auto;
        padding: 10px;
        background-color: #202634;
        border: 1px solid #ccc;
        border-radius: 10px;
        display: flex;
        align-items: center;
      }

      .text-field {
        padding: 5px 12px;
        width: 100%;
        color: #fff;
        background-color: #2f3747;
        border-radius: 3px;
        margin-right: 10px;
      }

      .text-box-copy-button {
        display: flex;
        align-items: center;
        justify-content: center;
        padding: 8px;
        border: none;
        background-color: #2f3747;
        border-radius: 5px;
        color: #fff;
        cursor: pointer;
      }
    </style>
  </head>

  <body>
    <div class="text-widget">
      <input
        type="text"
        class="text-field"
        id="widget1-text"
        value="pip install Flask-Migrate"
      />
      <button
        class="text-box-copy-button"
        onclick="handleClick2('widget1-text', 'widget1-notify')"
      >
        <svg
          width="20"
          height="20"
          x="0"
          y="0"
          viewBox="0 0 32 32"
          style="enable-background: new 0 0 512 512"
          xml:space="preserve"
          class=""
        >
          <g>
            <path
              d="m26.121 6.707-3.828-3.828A2.98 2.98 0 0 0 20.172 2H12a3.003 3.003 0 0 0-3 3v1H8a3.003 3.003 0 0 0-3 3v18a3.003 3.003 0 0 0 3 3h12a3.003 3.003 0 0 0 3-3v-1h1a3.003 3.003 0 0 0 3-3V8.829a2.982 2.982 0 0 0-.879-2.122ZM22 5.414 23.586 7H22ZM20 28H8a1.001 1.001 0 0 1-1-1V9a1.001 1.001 0 0 1 1-1h8v3a2.002 2.002 0 0 0 2 2h3v14a1 1 0 0 1-1 1ZM18 9.414 19.586 11H18ZM24 24h-1V12.829a2.982 2.982 0 0 0-.879-2.122l-3.828-3.828A2.98 2.98 0 0 0 16.171 6H11V5a1.001 1.001 0 0 1 1-1h8v3a2.002 2.002 0 0 0 2 2h3v14a1 1 0 0 1-1 1Zm-6-8h-8a1 1 0 0 1 0-2h8a1 1 0 0 1 0 2Zm0 4h-8a1 1 0 0 1 0-2h8a1 1 0 0 1 0 2Zm0 4h-8a1 1 0 0 1 0-2h8a1 1 0 0 1 0 2Z"
              fill="#a6b8e6"
              opacity="1"
              data-original="#000000"
              class=""
            ></path>
          </g>
        </svg>
      </button>
    </div>
    <script src="https://cdn.jsdelivr.net/npm/notiflix@2.7.0/dist/notiflix-aio-2.7.0.min.js"></script>

    <script>
      const handleClick2 = (textId, notifyId) => {
        const textField = document.getElementById(textId);
        const text = textField.value;
        navigator.clipboard.writeText(text);
        Notiflix.Notify.Success("Copied to clipboard!", {
          timeout: 2000,
          width: "260px",
          position: "center-top",
          textColor: "#ff5549",
        });
      };
    </script>
  </body>
</html>


### Initializing Migrations and Database Connection
We need to initialize migrations and link our application to the database. In the <u>app.py</u> file, we import Migrate from the flask_migrate library.

At the end of our file, we initialize a new **migrate** variable to connect our application (app) and the database (db).
``` python
from flask_migrate import Migrate
...
migrate = Migrate(app, db)
```

### Creating Migration Folders
We're ready to create a folder for our future migrations using the `flask db init` command. A new folder named <u>migrations</u> appears, containing several files and a versions subfolder.

<!DOCTYPE html>
<html lang="en">
  <head>
    <link
      rel="stylesheet"
      href="https://cdn.jsdelivr.net/npm/notiflix@2.7.0/dist/notiflix-aio-2.7.0.min.css"
    />
    <style>
      html {
        box-sizing: border-box;
      }

      *,
      *::after,
      *::before {
        box-sizing: inherit;
      }

      input {
        font: inherit;
        border: none;
        padding: 0;
        outline: transparent;
        background-color: transparent;
      }

      .text-widget {
        max-width: 500px;
        width: 100%;
        margin: 0 auto;
        padding: 10px;
        background-color: #202634;
        border: 1px solid #ccc;
        border-radius: 10px;
        display: flex;
        align-items: center;
      }

      .text-field {
        padding: 5px 12px;
        width: 100%;
        color: #fff;
        background-color: #2f3747;
        border-radius: 3px;
        margin-right: 10px;
      }

      .text-box-copy-button {
        display: flex;
        align-items: center;
        justify-content: center;
        padding: 8px;
        border: none;
        background-color: #2f3747;
        border-radius: 5px;
        color: #fff;
        cursor: pointer;
      }
    </style>
  </head>

  <body>
    <div class="text-widget">
      <input
        type="text"
        class="text-field"
        id="widget4-text"
        value="flask db init"
      />
      <button
        class="text-box-copy-button"
        onclick="handleClick4('widget4-text', 'widget1-notify')"
      >
        <svg
          width="20"
          height="20"
          x="0"
          y="0"
          viewBox="0 0 32 32"
          style="enable-background: new 0 0 512 512"
          xml:space="preserve"
          class=""
        >
          <g>
            <path
              d="m26.121 6.707-3.828-3.828A2.98 2.98 0 0 0 20.172 2H12a3.003 3.003 0 0 0-3 3v1H8a3.003 3.003 0 0 0-3 3v18a3.003 3.003 0 0 0 3 3h12a3.003 3.003 0 0 0 3-3v-1h1a3.003 3.003 0 0 0 3-3V8.829a2.982 2.982 0 0 0-.879-2.122ZM22 5.414 23.586 7H22ZM20 28H8a1.001 1.001 0 0 1-1-1V9a1.001 1.001 0 0 1 1-1h8v3a2.002 2.002 0 0 0 2 2h3v14a1 1 0 0 1-1 1ZM18 9.414 19.586 11H18ZM24 24h-1V12.829a2.982 2.982 0 0 0-.879-2.122l-3.828-3.828A2.98 2.98 0 0 0 16.171 6H11V5a1.001 1.001 0 0 1 1-1h8v3a2.002 2.002 0 0 0 2 2h3v14a1 1 0 0 1-1 1Zm-6-8h-8a1 1 0 0 1 0-2h8a1 1 0 0 1 0 2Zm0 4h-8a1 1 0 0 1 0-2h8a1 1 0 0 1 0 2Zm0 4h-8a1 1 0 0 1 0-2h8a1 1 0 0 1 0 2Z"
              fill="#a6b8e6"
              opacity="1"
              data-original="#000000"
              class=""
            ></path>
          </g>
        </svg>
      </button>
    </div>
    <script src="https://cdn.jsdelivr.net/npm/notiflix@2.7.0/dist/notiflix-aio-2.7.0.min.js"></script>

    <script>
      const handleClick4 = (textId, notifyId) => {
        const textField = document.getElementById(textId);
        const text = textField.value;
        navigator.clipboard.writeText(text);
        Notiflix.Notify.Success("Copied to clipboard!", {
          timeout: 2000,
          width: "260px",
          position: "center-top",
          textColor: "#ff5549",
        });
      };
    </script>
  </body>
</html>


### Using SQLite Studio
Please follow the video to quickly and practically learn how to use the SQLite Studio app.

In the next chapters, we'll explore additional documentation features and testing capabilities for our API and continue defining functionalities for all models.

This meticulously crafted course takes you from the foundational principles of APIs and REST, through the complexities of database relationships and schema management, to the intricacies of endpoint creation, authentication, and deployment. With a hands-on approach, you'll master Flask, SQLAlchemy, Flask-Smorest, and JWT authentication, culminating in a fully functional, secure, and deployable web API. Whether you're a beginner eager to dive into the world of web development or a seasoned programmer looking to refine your skills, this course offers a comprehensive, engaging, and practical learning experience, setting you up for professional success.

Dive into the world of web APIs with Flask, starting with the basics. You'll learn what APIs and REST APIs are, how to set up your project, configure your environment, and establish a GitHub SSH connection. This foundational knowledge will set you up for success.

Explore the core of database handling with SQLAlchemy. You'll learn to create robust models and understand many-to-one, one-to-one, and many-to-many relationships. This section empowers you with the skills to structure complex databases for real-world applications.

Unveil the power of Flask-Smorest and Marshmallow for managing web APIs and data serialization. You'll delve into JSON, schema handling, and the intricacies of data representation and validation, paving the way for advanced API development.

Master the art of creating and managing endpoints with Flask's Blueprints and MethodView. From setting up your first endpoints to exploring Flask-Migration and SQLite Studio, and utilizing tools like Postman and Insomnia, you'll craft scalable and maintainable web architectures.

Secure your web APIs with JWT authentication. Learn to set up Flask-JWT-Extended, handle user registration, login, and logout processes, and implement permissions and security measures. By the end of this section, you'll be adept at protecting and testing your endpoints.

Prepare your Flask project for deployment. This final leap covers the essentials: creating a requirements.txt, code formatting with Black and Flake8, and documenting your project with a README.md. You'll also master Git for version control and branch merging, readying you for a seamless project launch.

First Endpoint, Flask-Migration and SQLite Studio

Awesome!

First Endpoint, Flask-Migration and SQLite Studio