2024 Aug04: IIT M AN EXAM QDD2 - 04 Aug 2024

Consider the below flask_sqlalchemy data models "Product", "Supplier" and "Supply" given in the code below.

```python
class Product(db.Model):
    __tablename__ = "product"
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String, nullable=False)

class Supplier(db.Model):
    __tablename__ = "supplier"
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String, nullable=False)
    address = db.Column(db.String, nullable=True)

class Supply(db.Model):
    __tablename__ = "supply"
    id = db.Column(db.Integer, primary_key=True)
    product_id = db.Column(db.Integer, db.ForeignKey("product.id"))
    supplier_id = db.Column(db.Integer, db.ForeignKey("supplier.id"))
```

What will be the cardinality of the "Product" and "Supplier" relationship?

This is an area chart showing "No. of viewers (in Hundreds)" on the y-axis and "Time (minutes)" on the x-axis.

**Y-axis (No. of viewers (in Hundreds)):**
*   Ticks at 0, 5, 10, 15, 20.

**X-axis (Time (minutes)):**
*   Ticks at 0, 10, 20, 30, 40, 50, 60.

**Data points (approximate):**
*   (0, 11.5)
*   (10, 7)
*   (15, 9)
*   (20, 13)
*   (23, 18.5) - Peak 1
*   (30, 6.5)
*   (35, 4) - Valley
*   (40, 8)
*   (45, 13)
*   (47, 17) - Peak 2
*   (50, 15)
*   (55, 6)
*   (60, 4)

The area under the line is filled with a light red color.

Consider the following Python code.

**app.py**
```python
from flask import Flask
from flask_sqlalchemy import SQLAlchemy
import os

app_dir = os.path.dirname(os.path.abspath(__file__))
db_file = "sqlite:///course_database.sqlite3"

app = Flask(__name__)
app.app_context().push()
app.config["SQLALCHEMY_DATABASE_URI"] = db_file
app.config["SQLALCHEMY_TRACK_MODIFICATIONS"] = False

db = SQLAlchemy(app)

class MaxScores(db.Model):
    __tablename__ = "max_scores"
    course_id = db.Column(db.String(10), nullable=False, primary_key=True)
    high_score = db.Column(db.Integer)
    term_year = db.Column(db.String(10))
```
Using *MaxScores* data model in the above “*app.py*”. What is the correct sequence of python commands to insert *MaxScores* record?

```python
def modify(func):
    def wrapper(l):
        res = func(l)
        return res[::-1]
    return wrapper

def update(func):
    def wrapper(l):
        res = func(l)
        return list(map(lambda x: x/2,res))
    return wrapper

@modify
@update
def mylist(l):
    out_list = []
    for i in l:
        out_list.append(i**2)
    return out_list

print(mylist([2,4,1,7,5,9]))
```

```python
from flask import Flask, request
app = Flask(__name__)

@app.route('/home')
def home():
    var_a = request.args.get('method')
    if var_a == "GET":
        return """
        <body style="background-color: lightgray; color: 
purple;text-align: center;font-weight: bold;">
        <p>IIT</p>
        <p>MADRAS</p>
        </body>
        """
    elif var_a == "POST":
        return """
        <body style="background-color: lightgray; color: 
purple;text-align: center;font-weight: bold;">
        <p>IIT</p>
        <span>MADRAS</span>
        </body>
        """
    else:
        return "Invalid Method"
app.run(debug=True)
```
If the application is running locally on http://127.0.0.1:5000 then which of the following statements are correct?

Consider the following code.

```python
from flask import Flask
from flask_restful import Resource, Api

trains_list = [
    {"train_no": 12842, "source": "Madras", "destination": "Howrah"},
    {"train_no": 12727, "source": "VSKP", "destination": "HYD"},
    {"train_no": 12434, "source": "Delhi", "destination": "Madras"},
]
app = Flask(__name__)
api = Api(app)

class TrainsApi1(Resource):
    def get(self, tno):
        for train in trains_list:
            if train["train_no"] == tno:
                return train
        return None

class TrainsApi2(Resource):
    def get(self):
        return trains_list

api.add_resource(TrainsApi1, "/api/ver1/<int:tno>")
api.add_resource(TrainsApi2, "/api/ver2/")

if __name__ == "__main__":
    app.run(debug=True)
```

Assume that the above flask code is running locally on http://127.0.0.1:5000/. Which of the below URL(s) requests renders train data without errors?

What should be the code to run the
application, and the URL respectively
such that the browser gives
output as: Welcome to Application Development!?

What will be the output given by
browser if the application is run with
command `python app.py Application Development DBMS`
on terminal with URL `http://127.0.0.1:5000?course=DBMS` ?

Which of the following is/are the
correct URLs for retrieving the user
from the database with "id": "103"?

Which of the following URLs will trigger
the "get_user" controller in the given
application.

Two data models "Student" and "Sport" are to be created in the database with one-to-many relationship using *flask_sqlalchemy*. Which of the following is the correct implementation of the above two data models?

Consider the following Python code snippet.
Filename: code.py

```python
import logging
import sys

logging.basicConfig(format='%(levelname)s:%(message)s', level=logging.INFO)

logging.warning('This is only for testing.')

if sys.argv[1] == 'info':
    logging.info('This code is working as expected.')

if sys.argv[1] == 'debug':
    logging.debug('This code may have issues, debugging...')

logging.warning('code execution complete!')
```

What will be output on the terminal is the above code snippet is run on the terminal using command: `python code.py debug`

Consider the following flask application.

app.py
```python
from flask import Flask, abort, request
app = Flask(__name__)

@app.route('/login/<id>')
def login(id):
    if id:
        if id.isalpha():
            abort(400, "Bad Request: Invalid ID")
        return f'<h1>Your ID is: {id}</h1>'
    return f'<h1>Invalid ID</h1>'

app.run(debug=True)
```

Which of the following statements is/are true if the application is running locally on http://127.0.0.1:5000 ?

```html
<!DOCTYPE html>
<html lang="en">
<head>
    <title>Login Form</title>
    <style>
        input[type="password"]:valid{
            background-color: green;
        }
        input[type="password"]:invalid{
            background-color: red;
        }
    </style>
</head>
<body>
    <div class="login-form">
        <h2>Login</h2>
        <form>
            E-mail: <input type="email" id="email" name="email" required>
            Password: <input type="password" id="password" name="password"
            required minlength="5" maxlength="8">
            <input type="submit" value="Login">
        </form>
    </div>
</body>
</html>
```