Spaces:
No application file
No application file
File size: 2,713 Bytes
d89fa82 | 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 | import sqlite3
import pandas as pd
from datetime import datetime
def init_database():
conn = sqlite3.connect('school_data.db')
cursor = conn.cursor()
# Students Table
cursor.execute('''
CREATE TABLE IF NOT EXISTS students (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
grade TEXT NOT NULL,
roll_no INTEGER,
parent_name TEXT,
parent_phone TEXT,
address TEXT,
created_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)
''')
# Teachers Table
cursor.execute('''
CREATE TABLE IF NOT EXISTS teachers (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
subject TEXT,
qualifications TEXT,
phone TEXT,
email TEXT,
created_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)
''')
# Attendance Table
cursor.execute('''
CREATE TABLE IF NOT EXISTS attendance (
id INTEGER PRIMARY KEY AUTOINCREMENT,
student_id INTEGER,
date DATE,
status TEXT,
remarks TEXT,
FOREIGN KEY (student_id) REFERENCES students (id)
)
''')
# Marks Table
cursor.execute('''
CREATE TABLE IF NOT EXISTS marks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
student_id INTEGER,
subject TEXT,
exam_type TEXT,
marks REAL,
total_marks REAL,
grade TEXT,
entered_on TIMESTAMP,
FOREIGN KEY (student_id) REFERENCES students (id)
)
''')
# Users Table for Login
cursor.execute('''
CREATE TABLE IF NOT EXISTS users (
id INTEGER PRIMARY KEY AUTOINCREMENT,
username TEXT UNIQUE,
password TEXT,
user_type TEXT,
student_id INTEGER,
teacher_id INTEGER,
FOREIGN KEY (student_id) REFERENCES students (id),
FOREIGN KEY (teacher_id) REFERENCES teachers (id)
)
''')
conn.commit()
conn.close()
def add_student(name, grade, roll_no, parent_name, parent_phone, address):
conn = sqlite3.connect('school_data.db')
cursor = conn.cursor()
cursor.execute('''
INSERT INTO students (name, grade, roll_no, parent_name, parent_phone, address)
VALUES (?, ?, ?, ?, ?, ?)
''', (name, grade, roll_no, parent_name, parent_phone, address))
student_id = cursor.lastrowid
conn.commit()
conn.close()
return f"✅ विद्यार्थी नोंदणी झाली! ID: {student_id}" |