/ 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 : data.py

import tkinter as tk
from tkinter import messagebox, filedialog, simpledialog
import os
import shutil
import mysql.connector
from mysql.connector import Error

def connect_db():
    """ Connect to the MySQL database server """
    return mysql.connector.connect(host='localhost', database='CIPD', user='root', password='1234')

def insert_data(data, image_path):
    """Insert data into the Leaders table."""
    try:
        conn = connect_db()
        cursor = conn.cursor()
        image_name = os.path.basename(image_path)
        data.append(f'images/{image_name}')
        cursor.execute("INSERT INTO Leaders (Name, Designation, Institute_Company, Image, Role, Profile_Link, Description) VALUES (%s, %s, %s, %s, %s, %s, %s)", data)
        conn.commit()
        conn.close()
        messagebox.showinfo("Success", "Leader added successfully")
    except Error as e:
        messagebox.showerror("Error", str(e))

def select_image():
    """Handle image selection and saving."""
    file_path = filedialog.askopenfilename(filetypes=[("Image files", "*.jpg;*.jpeg;*.png")])
    if file_path:
        dest_path = os.path.join('static/images', os.path.basename(file_path))
        os.makedirs(os.path.dirname(dest_path), exist_ok=True)
        shutil.copy(file_path, dest_path)
        return dest_path

def leaders_gui():
    """GUI for managing 'Leaders' table."""
    leaders_window = tk.Toplevel(app)
    leaders_window.title("Leaders Management")
    
    tk.Button(leaders_window, text="Insert New Leader", command=insert_gui).pack(fill=tk.X)
    tk.Button(leaders_window, text="Modify Leader", command=modify_gui).pack(fill=tk.X)

# GUI for inserting new leader data
def insert_gui():
    def submit():
        name = entry_name.get()
        designation = entry_designation.get()
        company = entry_company.get()
        role = entry_role.get()
        link = entry_link.get()
        description = text_description.get("1.0", tk.END)
        image_path = select_image()
        if image_path:
            insert_data([name, designation, company, role, link, description], image_path)
    
    insert_window = tk.Toplevel(app)
    tk.Label(insert_window, text="Name:").pack()
    entry_name = tk.Entry(insert_window)
    entry_name.pack()
    tk.Label(insert_window, text="Designation:").pack()
    entry_designation = tk.Entry(insert_window)
    entry_designation.pack()
    tk.Label(insert_window, text="Company:").pack()
    entry_company = tk.Entry(insert_window)
    entry_company.pack()
    tk.Label(insert_window, text="Role:").pack()
    entry_role = tk.Entry(insert_window)
    entry_role.pack()
    tk.Label(insert_window, text="Profile Link:").pack()
    entry_link = tk.Entry(insert_window)
    entry_link.pack()
    tk.Label(insert_window, text="Description:").pack()
    text_description = tk.Text(insert_window, height=4)
    text_description.pack()
    tk.Button(insert_window, text="Submit", command=submit).pack()

def modify_gui():
    modify_window = tk.Toplevel(app)
    # You would populate this list dynamically with data from your database
    existing_entries = ["Leader 1", "Leader 2", "Leader 3"]  # Placeholder
    for entry in existing_entries:
        btn = tk.Button(modify_window, text=entry, command=lambda e=entry: insert_gui())  # Reuse the insert_gui for editing
        btn.pack()
def open_table(table_name):
    """Handle the button click for table selection."""
    if table_name == "Leaders":
        leaders_gui()
    else:
        messagebox.showinfo("Table Selected", f"You have selected the {table_name} table.")

# Main application setup
app = tk.Tk()
app.title("CIPD Database Management")
app.geometry("300x300")

tables = ["Leaders", "Experts", "Interns", "Partners", "Services", "Banners", "Products"]
for table in tables:
    button = tk.Button(app, text=table, command=lambda t=table: open_table(t))
    button.pack(pady=5)

app.mainloop()

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.