Question 24: Consider the below flask application. If you run the fla…

1from flask_sqlalchemy import SQLAlchemy
2from flask import Flask
3
4app = Flask (__name__)
5app.config ['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///testdb.sqlite3'
6db = SQLAlchemy(app)
7app.app_context().push()
8
9class Material(db.Model):
10   m_id = db.Column('m_id', db.Integer, primary_key = True)
11   name = db.Column('name', db.String(100), unique = True)
12
13db.create_all()
14
15material1 = Material(name = 'Steel')
16db.session.add(material1)
17material2 = Material(name = 'Iron')
18material3 = Material(name = 'Aluminium')
19db.session.add(material2)
20db.session.commit()
21
22all_material = Material.query.all()
23print([(x.m_id, x.name) for x in all_material])