Before implementing the Model, you should know the Object Oriented Programming (OOP).

Create:

# main.py(continuation)
from datetime import datetime

class Recipe(db.Model): 
    __tablename__ = "recipes"
	id = db.Column(db.Integer, primary_key=True) 
	title = db.Column(db.String(100), nullable=False, unique=True) 
	description = db.Column(db.Text, nullable=False) 
	author = db.Column(db.String(50)) 
	date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)


    def __repr__(self):
        return "Recipe" + str(self.id)

We need to inherit our model from db.Model.

• id has a special second parameter, which means that this id is going to be the main distinguisher between different recipes because this field is always unique;

• title has datatype String and we limit this to a certain amount of characters. The second parameter means that this field is required and cannot be Null or empty;

• description has type Text, and it goes for as long as it once, and this field is required too;

• author has the same type as title;

• date_posted is a special field with autocomplete, and do not forget to import the datetime module;

• The method __repr__ in our model is going to print out a representation of entries in some different way.

So, we added the SQLAlchemy library to work with our database and defined our database as well as a place to store it. We finished our model. So, let's go down to our Terminal and just start the Python environment by calling python or python3:

Import database:

The next command goes through our models and configurations, and it's going to create the tables in the database with our models in mind.

But if you receive an error message like:

Please run these commands:

>>> from main import app
>>> app_ctx = app.app_context()
>>> app_ctx.push()
>>> db.create_all()
>>> app_ctx.pop()

We have set up an applicational context and run a command to create a database file inside the context. You can see that the new file was created in the same directory as our Flask application.