IIT M DIPLOMA AN4 EXAM QDD4 03 Dec 2023 - 03 Dec 2023

Consider the schema for the 'student' table created in SQLite database using
flask-sqlalchemy.

```sql
CREATE TABLE "student" (
    "s_id"          INTEGER,
    "roll_number"   TEXT NOT NULL UNIQUE,
    "first_name"    TEXT NOT NULL,
    "last_name" TEXT NOT NULL,
    PRIMARY KEY("s_id" AUTOINCREMENT)
);
```

What will be the output of the flask_sqlalchemy command given below?

```python
>>> s1 = Student(roll_number = "M01", first_name = "John", last_name = "Doe")
>>> db.session.add(s1)
>>> s2 = Student(roll_number = "M02", first_name = "John", last_name = "Luther")
>>> db.session.add(s2)
>>> s3 = Student(roll_number = "M03", first_name = "Harry", last_name = "Doe")
>>> db.session.add(s3)
>>> db.session.commit()
>>> user1= Student.query.filter_by(first_name="John").first()
>>> user1.first_name= "Harry"
>>> user1.last_name= "Luther"
>>> db.session.commit()
>>> s1 = Student.query.all()
>>> for student in s1:
...     print(student.first_name)
...     print(student.last_name)
```

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

users = ["admin", "user_1", "user_2", "user_3"]

@app.route('/home/<string:username>', methods = ['POST'])
def home(username):
    if username in users:
        return f"<h1>Hello {username}, Welcome!</h1>"
    else:
        abort(404)

@app.errorhandler(404)
def user_error_1(error):
    return "<h1>The user you are looking for is invalid.</h1>"

@app.errorhandler(405)
def user_error_2(error):
    return "<h1>Please check the web request.</h1>"

app.run()
```

If the application is running locally on http://127.0.0.1:5000. What will be rendered on the browser for url http://127.0.0.1:5000/home/user_4 ?

Consider the following flask app. Given that test_request_context() allows text to be printed on the terminal, which of the following statements is/are correct?

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

@app.route('/home')
def index():
    return 'Mad-I Student Data'

@app.route('/student/<student_name>/<int:student_id>')
def profile(student_name,student_id):
    return f'Student Name:{student_name},Student ID:{student_id}'

with app.test_request_context():
    #== print statement ==#
```

Consider the following flask application.
app.py

```python
from flask import Flask, abort

app = Flask(__name__)

@app.route('/<uname>')
def index(uname):
    if uname[0].isdigit():
        abort(400, "Bad Request")
    return '<h1>Good Username</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 ?

Consider the following python code snippet.

```python
from string import Template as T1
from jinja2 import Template as T2
temp = "A student needs to complete $c1 level to get to the {{c2}} level."

temp = T1(temp)
out = temp.substitute({'c1':'foundation', 'c2':'diploma'})
print(out)
out= T2(out)
print(out.render({'c2':'diploma'}))
```

What is the generated output on python console?

What relationship do the tables
"channel" and "video" share.

If "ch1" is a channel object created in
"channel" table with primary key 1, then the
correct way(s) of creating a video object
"vid1" in the video table that belongs to
"ch1" object is/are ______. (let
"name" of the video be "Intro to Python")

Map the api resources in column A with the correct URLs given in column B.

| Column A | Column B |
|---|---|
| 1. GET | a. http://127.0.0.1:5000/student |
| 2. PUT | b. http://127.0.0.1:5000/api/Meera |
| 3. POST | c. http://127.0.0.1:5000/app/STU103/Sociology |

If the app first receives the request,
```
curl http://127.0.0.1:5000/app/STU105/Robotics -X PUT
```
what will be the final output on the shell after
writing the following lines of code one
below the other in the Python shell?
```python
>>> from app import *
>>> students = Student.query.filter_by(name = "Ramesh").all()
>>> for student in students:
...     print(student.course)
```

```python
def modify(func):
    def wrapper(n):
        mylist = []
        for i in range(1, n + 1):
            if n % i == 0:
                mylist.append(i)
        return mylist
    return wrapper

@modify
def myFunc(n):
    mylist = []
    for i in range(1, n + 1):
        if i % 2 == 0:
            mylist.append(i)
    return mylist

print(myFunc(14))
```

```python
@app.route("/add", methods = ['GET', 'POST'])
def add_product():
    if request.method == 'POST':
        name = request.form.get('name')
        category = request.form.get('category')
        if name == "":
            return redirect('/add')
        if category == "":
            return redirect('/add')
        return f"Product {name} is added in {category} category."

    return """
    <form action="/add" method="post">
        Product Name: <input type="text" name="name"
        minlength="2"><br>
        Product Category: <input type="text" name="category"
        required><br>
        <input type="submit" value="Add Product">
    </form>
    """
```

Filename: log.py
```python
import logging
import sys

logging.basicConfig(level=logging.WARNING,
                    format='%(levelname)s - %(message)s')

num1, num2 = int(sys.argv[1]), int(sys.argv[2])

if num2 > 0:
    logging.debug(f"Division {num1}/{num2} is possible")
else:
    logging.critical("FATAL - Division by zero is not possible")
```