MAD 1 Quiz 2: 3 December 2023 (September 2023 term)

1CREATE TABLE "student" (
2     "s_id"         INTEGER,
3     "roll_number"        TEXT NOT NULL UNIQUE,
4     "first_name"         TEXT NOT NULL,
5     "last_name" TEXT NOT NULL,
6     PRIMARY KEY("s_id" AUTOINCREMENT)
7);

1>>> s1 = Student(roll_number = "M01", first_name = "John", last_name = "Doe")
2>>> db.session.add(s1)
3>>> s2 = Student(roll_number = "M02", first_name = "John", last_name = "Luther")
4>>> db.session.add(s2)
5>>> s3 = Student(roll_number = "M03", first_name = "Harry", last_name = "Doe")
6>>> db.session.add(s3)
7>>> db.session.commit()
8>>> user1= Student.query.filter_by(first_name="John").first()
9>>> user1.first_name= "Harry"
10>>> user1.last_name= "Luther"
11>>> db.session.commit()
12>>> s1 = Student.query.all()
13>>> for student in s1:
14...  print(student.first_name)
15...  print(student.last_name)
16...

1from flask import Flask, abort
2app = Flask(__name__)
3
4users = ["admin", "user_1", "user_2", "user_3"]
5
6@app.route('/home/<string:username>', methods = ['POST'])
7def home(username):
8    if username in users:
9        return f"<h1>Hello {username}, Welcome!</h1>"
10    else:
11        abort(404)
12
13@app.errorhandler(404)
14def user_error_1(error):
15    return "<h1>The user you are looking for is invalid.</h1>"
16
17@app.errorhandler(405)
18def user_error_2(error):
19    return "<h1>Please check the web request.</h1>"
20
21app.run()

1from flask import Flask, url_for
2app = Flask(__name__)
3
4@app.route('/home')
5def index():
6    return 'Mad-I Student Data'
7
8@app.route('/student/<student_name>/<int:student_id>')
9def profile(student_name,student_id):
10    return f'Student Name:{student_name},Student ID:{student_id}'
11
12with app.test_request_context():
13    #== print statement ==#