Consider the below model definitions, and answer the given subquestions.\ Consider the following model classes “Movies” and “Producers” corresponding to tables “movies” and “producers”, respectively, in the SQLite database. class Movies(db.Model): id = db.Column(db.Integer(), primary_key = True) movie_name = db.Column(db.String(50), nullable = False, unique = True) movie_year = db.Column(db.Integer, nullable = False) producers = db.relationship('Producer', backref = 'movie', secondary = 'groups') class Producer(db.Model): id = db.Column(db.Integer(), primary_key = True) producer_name = db.Column(db.String(50), nullable = False, unique = True) productions = db.Column(db.Integer()) class Groups(db.Model): movie_id = db.Column(db.Integer(),db.ForeignKey('movies.id'), primary_key = True) prod_id = db.Column(db.Integer(),db.ForeignKey('producer.id'), primary_key = True) If an object “p1” that represents an existing record in the table “producer” is defined as p1 = Producer.query.get(2), The correct way to create a new record in the “movies” table that is produced by the producer represented by object ‘p1’ using terminal is.

(A) Option figure from the original question paper

(B) Option figure from the original question paper

(C) Option figure from the original question paper

(D) Option figure from the original question paper

Modern Application Development I · End Term · 11 Dec 2022 · September 2022 term · Set ETD1

Question 29: If an object “p1” that represents an existing record in …

Question 29

+4.5 marksOne or more correct options

Consider the below model definitions, and answer the given subquestions.
Consider the following model classes “Movies” and “Producers” corresponding to tables “movies” and “producers”, respectively, in the SQLite database.

python

1class Movies(db.Model):
2    id = db.Column(db.Integer(), primary_key = True)
3    movie_name = db.Column(db.String(50), nullable = False, unique = True)
4    movie_year = db.Column(db.Integer, nullable = False)
5    producers = db.relationship('Producer', backref = 'movie', secondary = 'groups')
6
7class Producer(db.Model):
8    id = db.Column(db.Integer(), primary_key = True)
9    producer_name = db.Column(db.String(50), nullable = False, unique = True)
10    productions = db.Column(db.Integer())
11
12class Groups(db.Model):
13    movie_id = db.Column(db.Integer(),db.ForeignKey('movies.id'), primary_key = True)
14    prod_id = db.Column(db.Integer(),db.ForeignKey('producer.id'), primary_key = True)

If an object “p1” that represents an existing record in the table “producer” is defined as p1 = Producer.query.get(2), The correct way to create a new record in the “movies” table that is produced by the producer represented by object ‘p1’ using terminal is.

Select all that apply.

Show answer

Correct answers

See the whole paper Take it as a mock test

Question 29 of 32 in the IIT Madras BS Modern Application Development I (MAD 1) End Term paper sat on 11 Dec 2022, in the September 2022 term (IIT M DIPLOMA FN1 EXAM ETD1 11 Dec 2022). It carries 4.5 marks.

Question 29: If an object “p1” that represents an existing record in …

Question 29

More questions from this paper