Spaces:
Sleeping
Sleeping
File size: 4,607 Bytes
76e3015 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 | import gradio as gr
import sqlite3
import os
from transformers import pipeline
# -----------------------------
# LOAD LIGHT MODEL (HF SAFE)
# -----------------------------
generator = pipeline(
"text-generation",
model="distilgpt2",
device=-1 # CPU only
)
# -----------------------------
# DATABASE SETUP
# -----------------------------
DB = "college.db"
def init_db():
conn = sqlite3.connect(DB)
c = conn.cursor()
c.execute("""CREATE TABLE IF NOT EXISTS questions(
id INTEGER PRIMARY KEY AUTOINCREMENT,
student TEXT,
year TEXT,
question TEXT,
answer TEXT
)""")
c.execute("""CREATE TABLE IF NOT EXISTS materials(
id INTEGER PRIMARY KEY AUTOINCREMENT,
year TEXT,
subject TEXT,
filename TEXT
)""")
conn.commit()
conn.close()
init_db()
UPLOAD_DIR = "uploads"
os.makedirs(UPLOAD_DIR, exist_ok=True)
# -----------------------------
# FUNCTIONS
# -----------------------------
def login(name, year):
if year not in ["First Year", "Second Year"]:
return "❌ Only First & Second Year Students Allowed"
return f"✅ Welcome {name}"
def generate_ai_answer(question):
prompt = f"Answer this academic question clearly:\n{question}\nAnswer:"
result = generator(prompt, max_length=150, do_sample=True)[0]["generated_text"]
# Clean output
answer = result.split("Answer:")[-1].strip()
return answer
def ask_question(name, year, question):
if year not in ["First Year", "Second Year"]:
return "Access Denied"
answer = generate_ai_answer(question)
conn = sqlite3.connect(DB)
conn.execute(
"INSERT INTO questions(student,year,question,answer) VALUES(?,?,?,?)",
(name, year, question, answer)
)
conn.commit()
conn.close()
return answer
def view_materials(year):
conn = sqlite3.connect(DB)
rows = conn.execute(
"SELECT subject, filename FROM materials WHERE year=?",
(year,)
).fetchall()
conn.close()
if not rows:
return "No materials uploaded yet."
return "\n".join([f"{s} → {f}" for s, f in rows])
def upload_material(year, subject, file):
if file is None:
return "Upload a file"
path = os.path.join(UPLOAD_DIR, file.name)
with open(path, "wb") as f:
f.write(file.read())
conn = sqlite3.connect(DB)
conn.execute(
"INSERT INTO materials(year,subject,filename) VALUES(?,?,?)",
(year, subject, file.name)
)
conn.commit()
conn.close()
return "✅ Uploaded Successfully"
def teacher_view():
conn = sqlite3.connect(DB)
rows = conn.execute("SELECT * FROM questions").fetchall()
conn.close()
text = ""
for r in rows:
text += f"\nID {r[0]} | {r[1]} ({r[2]})\nQ: {r[3]}\nA: {r[4]}\n"
return text
def update_answer(qid, new_answer):
conn = sqlite3.connect(DB)
conn.execute(
"UPDATE questions SET answer=? WHERE id=?",
(new_answer, qid)
)
conn.commit()
conn.close()
return "Answer Updated"
# -----------------------------
# UI
# -----------------------------
with gr.Blocks(theme=gr.themes.Soft(), title="College LMS") as app:
gr.Markdown("# 🎓 AI-Powered College LMS")
with gr.Tab("Student Portal"):
name = gr.Textbox(label="Name")
year = gr.Dropdown(["First Year", "Second Year", "Other"])
login_btn = gr.Button("Login")
login_msg = gr.Textbox()
login_btn.click(login, [name, year], login_msg)
question = gr.Textbox(label="Ask Question")
ask_btn = gr.Button("Ask AI")
answer = gr.Textbox(lines=6)
ask_btn.click(ask_question, [name, year, question], answer)
mat_btn = gr.Button("View Materials")
materials = gr.Textbox()
mat_btn.click(view_materials, year, materials)
with gr.Tab("Teacher Panel"):
t_year = gr.Dropdown(["First Year", "Second Year"])
subject = gr.Textbox(label="Subject")
file = gr.File()
upload_btn = gr.Button("Upload")
upload_msg = gr.Textbox()
upload_btn.click(upload_material, [t_year, subject, file], upload_msg)
view_btn = gr.Button("Show Questions")
all_q = gr.Textbox(lines=10)
view_btn.click(teacher_view, outputs=all_q)
qid = gr.Number(label="Question ID")
new_ans = gr.Textbox(label="New Answer")
upd_btn = gr.Button("Update")
upd_msg = gr.Textbox()
upd_btn.click(update_answer, [qid, new_ans], upd_msg)
if __name__ == "__main__":
app.launch()
|