Proctor Level2_3

SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.

SimpleMAD1 typical: Browser → Flask routes → validate/auth → SQLAlchemy → SQLite → Jinja response.

Suggested flowRequest → Route → Auth check → DB → render_template / redirect

SimpleAuthentication: tu kaun hai? (login). Authorization: tujhe permission hai? (role check).

Example

# auth
if check_password_hash(user.password, pwd):
    session['user_id'] = user.id

# authz
if user.role != 'admin':
    abort(403)

SimpleGET data read/show karta hai (idempotent). POST create/submit karta hai (form).

Example

@app.route('/login', methods=['GET', 'POST'])
def login():
    if request.method == 'POST':
        # validate + session
        ...
    return render_template('login.html')

Simpledb.relationship se object graph: lot.spots, booking.user. backref reverse side auto deta hai.

Example

spots = db.relationship('Spot', backref='lot', cascade='all, delete-orphan')

SimpleCascade parent delete pe children pe kya ho: delete-orphan related rows hata deta hai.

Example

db.relationship('Spot', cascade='all, delete-orphan')

Viva tipParking lot delete → uske spots/bookings policy clear bolo.

SimpleSearch: form/query param → ilike filter → results template.

Example

q = request.args.get('q', '').strip()
lots = Lot.query.filter(Lot.name.ilike(f'%{q}%')).all()

SimpleViva wrap-up hai. Short thanks + confirm submission ZIP latest hai.

SimpleLIKE case-sensitive Postgres. ILIKE insensitive. SQLite LIKE often insensitive.

Search use ilike.

Pehle 1-line definition, phir related MAD2 layer (Vue SFC / Flask route / models.py / tasks.py / Redis).

4-line formula: input kahan se aaya, auth/validation kaunsa, DB ya cache ya Celery, kya return.

Related mix mat karo — cache ≠ Celery, authentication ≠ authorization, v-if ≠ v-show, Beat ≠ Worker. Follow-up ke liye ek difference ready rakho.

Project example: Venue.name.ilike(f'%{q}%').

Project example: Venue.name.ilike(f'%{q}%').

SimpleMAD1 mein usually session-based auth: login pe session['user_id'], har request pe verify.

Example

session['user_id'] = user.id
uid = session.get('user_id')
user = User.query.get(uid)

Viva tipSECRET_KEY set karo warna session insecure. logout pe session.clear().