Question 15: Consider the schema for the Class Student. What will be …

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 = "Dewis")
2>>> db.session.add(s1)
3>>> s2 = Student(roll_number = "M02", first_name = "John", last_name = "Nector")
4>>> db.session.add(s2)
5>>> s3 = Student(roll_number = "M03", first_name = "Nick", last_name = "Dewis")
6>>> db.session.add(s3)
7>>> db.session.commit()
8>>> user1= Student.query.filter_by(first_name="John").first()
9>>> user1.first_name= "Nick"
10>>> db.session.commit()
11>>> s1 = Student.query.all()
12>>> for student in s1:
13   print(student.first_name)
14   print(student.last_name)