/ var / www / html / cipd-org-old / [ HOME SHELL ]

Name	Size	Permission	Action
database-bkup	[ DIR ]	drwxr-xr-x
instance	[ DIR ]	drwxr-xr-x
old-data	[ DIR ]	drwxr-xr-x
static	[ DIR ]	drwxr-xr-x
templates	[ DIR ]	dr-xr-xr-x
CIPD.zip	110.34 MB	-rw-r--r--
app.py	6.63 KB	-rwxr-xr-x
cipd.sql	12.2 KB	-rw-r--r--
data.py	3.91 KB	-rw-r--r--
get-pip.py	1.82 MB	-rw-r--r--
index.html-old	20 B	-rw-r--r--
nohup.out	12.27 MB	-rw-------
tempCodeRunnerFile.py	4.74 KB	-rw-r--r--
test_connection.py	307 B	-rw-r--r--

Code Editor : tempCodeRunnerFile.py

from flask import Flask, render_template, request, redirect, url_for
from flask_sqlalchemy import SQLAlchemy
from datetime import date
from sqlalchemy import or_ ,and_
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql+pymysql://root:1234@localhost/CIPD'
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
db = SQLAlchemy(app)

# Models
class Banners(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    location = db.Column(db.String(255), nullable=False)
    type = db.Column(db.Enum('video', 'image'), nullable=False)
    device = db.Column(db.Enum('mobile', 'laptop'), nullable=False)
    date_valid_from = db.Column(db.Date)
    date_valid_to = db.Column(db.Date)

def is_active(self):
        if not self.date_valid_from and not self.date_valid_to:
            return True
        today = date.today()
        return (self.date_valid_from <= today if self.date_valid_from else True) and \
               (self.date_valid_to >= today if self.date_valid_to else True)
class Leaders(db.Model):
    __tablename__ = 'Leaders'
    PID = db.Column(db.Integer, primary_key=True)
    Name = db.Column(db.String(255), nullable=False)
    Designation = db.Column(db.String(255), nullable=False)
    Institute_Company = db.Column(db.String(255))
    Image = db.Column(db.String(255))
    Role = db.Column(db.String(255))
    Profile_Link = db.Column(db.String(255))
    Description = db.Column(db.Text)

class Experts(db.Model):
    __tablename__ = 'Experts'
    PID = db.Column(db.Integer, primary_key=True)
    Name = db.Column(db.String(255), nullable=False)
    Designation = db.Column(db.String(255), nullable=False)
    Institute_Company = db.Column(db.String(255))
    Image = db.Column(db.String(255))
    Profile_Link = db.Column(db.String(255))
    Qualification = db.Column(db.String(255))

class Interns(db.Model):
    __tablename__ = 'Interns'
    PID = db.Column(db.Integer, primary_key=True)
    Name = db.Column(db.String(255), nullable=False)
    Student_Category = db.Column(db.String(255))
    Institute = db.Column(db.String(255))
    Image = db.Column(db.String(255))
    LinkedIn_Profile_Link = db.Column(db.String(255))

class Partners(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(100))
    image_url = db.Column(db.String(200))
    category = db.Column(db.String(50))

class Services(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(255), nullable=False)
    description = db.Column(db.Text, nullable=False)
    image = db.Column(db.String(255))
class Products(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(255), nullable=False)
    image = db.Column(db.String(255))
    description = db.Column(db.Text)
    key_point_1 = db.Column(db.String(255))
    key_point_2 = db.Column(db.String(255))
    key_point_3 = db.Column(db.String(255))
    key_point_4 = db.Column(db.String(255))
    key_point_5 = db.Column(db.String(255))
    key_point_6 = db.Column(db.String(255))
# Routes
@app.route('/')
def index():
    device_type = 'mobile' if request.user_agent.platform in ['android', 'iphone', 'ipad'] else 'laptop'
    active_banners = Banners.query.filter(Banners.device == device_type, or_(Banners.date_valid_from == None, Banners.date_valid_to == None, and_(Banners.date_valid_from <= date.today(), Banners.date_valid_to >= date.today()))).all()
    return render_template('index.html', banners=active_banners)
@app.route('/team')
def team():
    leaders = Leaders.query.all()
    experts = Experts.query.all()
    interns = Interns.query.all()
    return render_template('meetourteam.html', leaders=leaders, experts=experts, interns=interns)

@app.route('/partner')
def partner():
    academic_partners = Partners.query.filter_by(category='Academic').all()
    industry_partners = Partners.query.filter_by(category='Industry').all()
    
    return render_template('partner.html', academic_partners=academic_partners, industry_partners=industry_partners)

@app.route('/about')
def about():
    return render_template('about.html')

@app.route('/service')
def service():
    services = Services.query.all()
    return render_template('services.html', services=services)

@app.route('/product')
def product():
    # Fetch the first product
    products = Products.query.all()  # You might want to adjust this based on how you want to display or select products.
    return render_template('products.html', products=products)

@app.route('/event')
def event():
    return render_template('events.html')

@app.route('/join')
def join():
    return render_template('joinus.html')

if __name__ == '__main__':
    app.run(host='0.0.0.0', debug=True)

Urban Research Lab

Urban Research Lab

The Urban Research Lab (URL) at IIIT-Delhi was established in 2020, during a time when the pandemic brought the complexities of urban life more visible than ever. What started as an initiative by faculty and students has grown into a collaborative space for critically exploring and reimagining the urban questions through research, dialogue, and interdisciplinary engagement.