Proctor Level2_86

SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

Suggested flow1) Register/login user
2) Admin login — CRUD
3) Approval/blacklist
4) Booking/apply + edge case
5) Search
6) Logout

Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

Simplemodels.py = har table ki class: columns, PK/FK, relationships. Yeh Model layer hai.

Suggested flow1) Classes list karo
2) Har table ka kaam 1 line
3) Relationships (1-M / M-M)
4) Constraints (unique, nullable)

Example

class Lot(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False)
    spots = db.relationship('Spot', backref='lot', lazy=True)

SimpleCode explain formula: input kya aaya → auth/validation → DB change → response/UI.

Viva tipFunction signature + 3-4 important lines + edge case.

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

Simplelogin_required jaisa decorator protected routes pe: session nahi to login redirect.

Example

def login_required(fn):
    @wraps(fn)
    def wrapper(*a, **k):
        if 'user_id' not in session:
            return redirect(url_for('auth.login'))
        return fn(*a, **k)
    return wrapper

Simplejson.dumps Python object ko JSON string banata hai, jsonify Flask Response banata hai (header ke saath).

json.dumps({'ok': True}) → '{"ok": true}' (sirf string)

jsonify(ok=True) → HTTP response, Content-Type: application/json

API route mein jsonify use karo:
@app.route('/api/users')
def users():
    return jsonify([{'id': u.id, 'name': u.name} for u in User.query.all()])

json.dumps se return karoge to browser ise text samajh sakta hai, JSON nahi.

SimpleSFC ek .vue file: template + script + style. Reusable scoped CSS.

Pages route-level. Components andar. Vue 2 one root; Vue 3 fragments.

Component = reusable UI block (Navbar, Card). Props parent→child data, emit child→parent event. Slots parent HTML inner content.

computed cache + reactive derive (filtered list). watch side-effect (query change pe API). methods events. ref() primitive, reactive() object. Vuex/Pinia global store; localStorage persist, store nahi.

SFC: template + script + style ek .vue file. Parent-child exam favourite: list parent, row child :item + @delete.

Example

<template><div>{{ venue.name }}</div></template>
<script>export default { props: ['venue'] }</script>
<style scoped>.card{padding:8px}</style>

Project example: VenueCard.vue props. views/Home.vue page.

SimpleMAD1 frontend usually Jinja templates + HTML/CSS/Bootstrap (+ thoda JS). MAD2 pe Vue ho to clearly bolo.

SimpleRouter URL ko component se map karta hai. Google Maps for pages.

routes array path+component. router-view jagah. router-link reload nahi.

meta.auth + beforeEach guard. Dynamic /venues/:id.

Nayi page: SFC + routes entry + link.

Example

const routes = [
  { path: '/', component: Home },
  { path: '/login', component: Login },
  { path: '/venues/:id', component: VenueDetail, meta: { auth: true } },
]

Project example: routes.js Login, Register, UserHome, AdminHome, 404.

Viva tipNayi page: component banao, routes array mein path, router-link se jao.

SimpleWebSocket ek phone call hai (dono bolte rehte). HTTP postcard hai (ek request-response).

Persistent two-way. Chat, live scores. MAD2 generally REST + kabhi poll.

Webhook ≠ WebSocket. ws:// / wss://.

HTTP postcard (request-response). WebSocket phone call (dono taraf live). SSE radio (server→client stream). Webhook unka server tumhe POST karta hai (payment).

MAD2 mostly REST. Live dashboard = poll + Redis cache kaafi. Agar implement nahi kiya to design bolo, jhoot mat.

Project example: Humne REST use kiya. Live dashboard ke liye poll/cache. WebSocket extra hota.

Viva tipMAD2 mein mostly REST + polling. Webhook ≠ WebSocket.

SimpleJOIN related tables ek result mein. Inner = match only; left = left side sab + match.

Example

db.session.query(Booking, User).join(User).filter(User.id == uid).all()

SimpleJOIN related tables ek result mein. Inner = match only; left = left side sab + match.

Example

db.session.query(Booking, User).join(User).filter(User.id == uid).all()

SimpleJOIN related tables ek result mein. Inner = match only; left = left side sab + match.

Example

db.session.query(Booking, User).join(User).filter(User.id == uid).all()

SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

Suggested flow1) Register/login user
2) Admin login — CRUD
3) Approval/blacklist
4) Booking/apply + edge case
5) Search
6) Logout

Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

SimpleCode explain formula: input kya aaya → auth/validation → DB change → response/UI.

Viva tipFunction signature + 3-4 important lines + edge case.

SimpleCelery = background naukri. HTTP request ko 10 second email bhejne ke liye mat rokna.

Distributed task queue: aap function ko abhi nahi, worker process mein later/retry/schedule pe chalaate ho.

MAD2 typical jobs: daily reminder mail, monthly HTML report, user-triggered CSV export.

Web request 200ms hona chahiye. 10,000 emails request thread mein = timeout. Worker alag CPU pe kaam kare.

Redis broker chahiye. Beat alag process schedule ke liye.

Example

@celery.task
def daily_reminder():
    for u in User.query.filter_by(active=True):
        send_mail(u.email, 'Book something today!')

Project example: User Export click → 202 Accepted. Worker CSV + email. Daily 6pm Beat reminder.

Viva tipWorker + Redis bina Beat ke user-triggered chalega. Scheduled jobs ke liye Beat bhi chahiye.

SimpleIsliye ki user wait na kare, retry mil jaaye, 6pm automatic ho jaaye.

Slow work (mail, CSV, PDF) request se alag. Schedule crontab. Scale = aur workers.

JS async/await alag cheez hai (browser event loop). Celery server-side process.

Celery Python ka distributed task queue — HTTP request ko 10s email/CSV ke liye mat rokna.

Flow: Flask .delay() → Redis broker → Worker execute. Beat alag process hai (clock): crontab padhke due time pe queue mein daalta hai. Beat khud mail nahi bhejta; Worker haath hai.

MAD2 typical: daily reminder (Beat), monthly report (Beat), user Export CSV (button, Beat nahi). JS async/await browser event loop hai, Celery server-side process — mix mat karo.

Demo: tin terminals — redis-server, celery worker, celery beat — plus Flask. MailHog :8025 inbox. Result backend se task SUCCESS poll optional.

Project example: Reminder 6pm, monthly 1st, export button. Teen alag tasks.py functions.

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

SimpleDemo script pehle se practice: 5–7 min, Admin + User roles, saare mandatory features.

Suggested flow1) Register/login user
2) Admin login — CRUD
3) Approval/blacklist
4) Booking/apply + edge case
5) Search
6) Logout

Viva tipBolte-bolte dikhao. Code tab kholna jab poochhein.

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

SimpleRelational DB tables + rows + columns, relations FK se. SQL se query. SQLite/Postgres examples.

Example

users(id, email)
bookings(id, user_id FK → users.id)

Viva tipVs NoSQL: fixed schema + joins strong; documents flexible but joins weak.

SimpleNoSQL = non-relational store (documents/key-value). Flexible schema, joins weak. MongoDB/Redis examples. MAD1 usually SQLite relational.

SimplePrimary key row ka unique identity — usually id Integer autoincrement.

Example

id = db.Column(db.Integer, primary_key=True)

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

SimpleCamera pe clearly college/IITM ID dikhao — naam aur photo match hone chahiye.

Viva tipPehle se ID haath mein rakho, glare mat aane do. Iske baad GitHub + project run.

SimpleSQLite file-based DB — setup easy, MAD1 ke liye perfect. Production heavy traffic pe Postgres better.

Example

SQLALCHEMY_DATABASE_URI = 'sqlite:///app.db'

SimpleNoSQL = non-relational store (documents/key-value). Flexible schema, joins weak. MongoDB/Redis examples. MAD1 usually SQLite relational.

SimpleIndex kitab ki index jaisi — search tez, poori table scan nahi.

email unique=True already index. Composite: db.Index('ix_user_city_age', User.city, User.age)
Zyada indexes writes slow. Search/filter columns pe lagao.

SimpleJOIN related tables ek result mein. Inner = match only; left = left side sab + match.

Example

db.session.query(Booking, User).join(User).filter(User.id == uid).all()

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

SimpleRedis fridge pe sticky note hai — poori kitchen (database) kholne ki zarurat nahi.

Redis in-memory key-value store hai. Data RAM mein rehta hai, isliye disk wale SQLite/Postgres se kai guna tez.

MAD2 mein Redis do kaam karta hai:
1) Cache — same venue/show/dashboard JSON baar-baar DB se mat nikaalo.
2) Celery message broker — Flask task queue mein daalta hai, worker uthata hai.

Source of truth database hi hai. Redis band ho to cache miss ho jaata hai aur Celery queue ruk sakti hai. Crash pe cache gayab ho sakta hai — isliye important data sirf Redis mein mat rakho.

Example

import redis
r = redis.Redis(host='localhost', port=6379, db=0)
r.set('venues', json.dumps(data), ex=30)
print(r.get('venues'))

Project example: GET /api/venues pehle Redis dekho. Miss pe SQLAlchemy query, phir SET with timeout. Celery worker Redis list se daily reminder uthata hai.

Viva tipCache ke liye db=1, broker ke liye db=0 rakhna smart hai taaki keys mix na hon. Viva mein redis-cli ping → PONG dikhana strong hai.

SimpleMAD1 mein common: Werkzeug generate_password_hash — default usually pbkdf2:sha256. Apna code dikhao.

Example

from werkzeug.security import generate_password_hash
print(generate_password_hash('secret'))  # pbkdf2:sha256:...

SimpleIndex kitab ki suchi — search tez, write thoda mehnga.

B-tree typically. filter wale columns, FKs. Over-index mat.

joinedload N+1 alag.

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.

Example

db.Column(db.String(80), index=True)
db.Index('ix_name_city', User.name, User.city)

Project example: email index, venue.name search index.

SimpleMemoize = function(args) ka answer copy. Caching broader (HTTP, Redis, page).

Fibonacci textbook. Flask @cache.memoize. cached whole view.

Redis in-memory key-value store hai — fridge pe sticky note, poori kitchen (SQL database) har baar mat kholo.

MAD2 mein Redis do kaam: (1) cache — same venues/shows/dashboard JSON baar-baar DB se nahi (2) Celery broker — Flask task queue mein daalta hai, worker uthata hai.

Flow: cache.get(key) → hit pe return, miss pe SQLAlchemy + SET with timeout. Admin write ke baad cache.delete, warna stale list.

Source of truth database hi hai. Redis crash/band = cache miss (app chalni chahiye) + queue ruk sakti hai. Important bookings sirf Redis mein mat rakho.

Alag: Redis ≠ Memcached (Celery broker nahi). Redis ≠ localStorage (woh browser). redis-cli ping → PONG viva proof.

Project example: get_user(id) memoize. venues list cached.

SimplePrimary key row ka unique identity — usually id Integer autoincrement.

Example

id = db.Column(db.Integer, primary_key=True)

SimpleSQLite file-based DB — setup easy, MAD1 ke liye perfect. Production heavy traffic pe Postgres better.

Example

SQLALCHEMY_DATABASE_URI = 'sqlite:///app.db'

SimpleRelational DB tables + rows + columns, relations FK se. SQL se query. SQLite/Postgres examples.

Example

users(id, email)
bookings(id, user_id FK → users.id)

Viva tipVs NoSQL: fixed schema + joins strong; documents flexible but joins weak.

SimpleNoSQL = non-relational store (documents/key-value). Flexible schema, joins weak. MongoDB/Redis examples. MAD1 usually SQLite relational.

SimpleJOIN related tables ek result mein. Inner = match only; left = left side sab + match.

Example

db.session.query(Booking, User).join(User).filter(User.id == uid).all()

SimpleLive coding: notepad/editor mein chhota Flask route / Jinja loop / model field. Calm raho, run karke dikhao.

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

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

SimpleLive Flask coding: chhota route likho, save, browser/curl se test. Syntax error terminal mein padho.

Example

@app.route('/ping')
def ping():
    return jsonify(ok=True)

@app.route('/even/<int:n>')
def even(n):
    return 'even' if n % 2 == 0 else 'odd'

SimpleJOIN related tables ek result mein. Inner = match only; left = left side sab + match.

Example

db.session.query(Booking, User).join(User).filter(User.id == uid).all()

SimpleSMTP = Simple Mail Transfer Protocol — email bhejne ka standard. Flask-Mail / smtplib se reminders/reports.

Example

from flask_mail import Message
msg = Message('Subject', recipients=[user.email])
msg.body = 'Hello'
mail.send(msg)

Viva tipViva mein MailHog/inbox dikhao. Port 587 TLS common; local pe MailHog 1025.

SimpleCode explain formula: input kya aaya → auth/validation → DB change → response/UI.

Viva tipFunction signature + 3-4 important lines + edge case.

SimpleORM = Object Relational Mapping. Tables → Python classes. Raw SQL kam likhte ho.

Example

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    email = db.Column(db.String(120), unique=True)

User.query.get(5)  # SELECT ... WHERE id=5

SimpleCamera pe clearly college/IITM ID dikhao — naam aur photo match hone chahiye.

Viva tipPehle se ID haath mein rakho, glare mat aane do. Iske baad GitHub + project run.

SimpleCache baar-baar DB/compute na karne ke liye result yaad rakhta hai.

Browser cache, Flask cache, Redis. Example: dashboard counts 30 sec Redis mein.
Cookies alag (client data). HTTP 304 Not Modified bhi cache related.
MAD1 mein optional. Scale poochhe to pehle indexes + cache, phir extra servers.

SimpleTheory = concepts: ORM, MVC, auth vs authz, Jinja inheritance, sessions. 1-line def + project example.

SimpleSQLite file-based DB — setup easy, MAD1 ke liye perfect. Production heavy traffic pe Postgres better.

Example

SQLALCHEMY_DATABASE_URI = 'sqlite:///app.db'

SimpleCron/crontab = schedule pe job. Celery Beat app-level cron (daily email). OS crontab alag.

Example

crontab(hour=18, minute=0)  # har din 6pm

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

SimpleDemo script pehle se practice karo, 5-7 minute, saari roles.

Suggested flow

1) Register/login user 2) Admin login — CRUD 3) Approval/blacklist 4) Booking/apply 5) Search 6) Validation edge (slots 0, duplicate) 7) Logout
Bolte-bolte dikhao: 'Yahan overbooking rokta hoon'. Code tab kholna jab poochhein.
Crash ho to debug calmly: terminal error, typo, DB path.
Mandatory features skip mat karna — examiner list tick karta hai.

Simplemodels.py har table ki class hai — columns, PK/FK, relationships. Yeh Model layer hai.

Viva mein file khol ke bolo:
1) Kaunsi classes/tables hain (User, Role-specific, Booking...)
2) Har table ka kaam 1 line
3) Relationships: 1-1 / 1-M / M-M, backref, cascade, lazy
4) Constraints: unique email, nullable, default status

Example skeleton

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    email = db.Column(db.String(120), unique=True, nullable=False)
    role = db.Column(db.String(20), default='user')
    bookings = db.relationship('Booking', backref='user', cascade='all, delete-orphan')

ER diagram: rectangles entities, lines relationships, PK/FK mark. Schema = yahi structure.
Tables create: db.create_all() ya migrations. SQLite file SQL viewer se dikha sakte ho.

SimpleUserMixin Flask-Login ko batata hai user object kaise treat karna hai (is_authenticated, get_id).

class User(db.Model, UserMixin):
    id = db.Column(db.Integer, primary_key=True)

current_user proxy logged-in user. Initialize: login_user(user) / user_loader callback.
Flask-WTF: Python classes se forms, CSRF, validators. RegisterForm forms.py mein.
fs_uniquifier Flask-Security mein token/session identity — email change pe sessions invalidate.
enctype='multipart/form-data' file upload pe zaroori. request.files.get('resume').

SimpleRBAC = Role-Based Access Control — permission role se (admin/staff/user), har user pe alag nahi.

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

Same login page, role ke hisaab dashboard. Multiple roles: roles table Many-to-Many, ya comma field (behtar normalized table).
Unapproved staff: is_approved flag, login pe check.
Flask-Security/UserMixin is_authenticated, is_active, get_id dete hain.

SimpleCache baar-baar DB/compute na karne ke liye result yaad rakhta hai.

Browser cache, Flask cache, Redis. Example: dashboard counts 30 sec Redis mein.
Cookies alag (client data). HTTP 304 Not Modified bhi cache related.
MAD1 mein optional. Scale poochhe to pehle indexes + cache, phir extra servers.

SimpleVue.js frontend framework — reactive UI components. MAD2 mein common, MAD1 optional.

Component: reusable UI (Navbar.vue) + data + template.
Props: parent → child data. Child → parent: $emit('update', val).
Slots: parent child ke andar extra HTML daal sakta hai.
Lifecycle: created (data setup), mounted (DOM ready — API call), updated, unmounted.
v-model two-way bind. Vue Router SPA routes (routes.js). Vuex/Pinia global state; mutations sync change, actions async.
Standalone component: khud ke saath compile, parent register kam.

SimpleVue.js frontend framework — reactive UI components. MAD2 mein common, MAD1 optional.

Component: reusable UI (Navbar.vue) + data + template.
Props: parent → child data. Child → parent: $emit('update', val).
Slots: parent child ke andar extra HTML daal sakta hai.
Lifecycle: created (data setup), mounted (DOM ready — API call), updated, unmounted.
v-model two-way bind. Vue Router SPA routes (routes.js). Vuex/Pinia global state; mutations sync change, actions async.
Standalone component: khud ke saath compile, parent register kam.