import sqlite3

# اتصال به پایگاه داده
conn = sqlite3.connect('school.db')

# ایجاد یک cursor برای اجرای کوئری‌ها
cursor = conn.cursor()

# ایجاد جدول دانش‌آموزان
cursor.execute('''
    CREATE TABLE IF NOT EXISTS students (
        id INTEGER PRIMARY KEY,
        name TEXT NOT NULL,
        age INTEGER NOT NULL,
        grade REAL NOT NULL
    )
''')

# ایجاد جدول معلمان
cursor.execute('''
    CREATE TABLE IF NOT EXISTS teachers (
        id INTEGER PRIMARY KEY,
        name TEXT NOT NULL,
        subject TEXT NOT NULL
    )
''')

# ذخیره تغییرات
conn.commit()

# بستن اتصال
conn.close()

import sqlite3

def add_student(name, age, grade):
    conn = sqlite3.connect('school.db')
    cursor = conn.cursor()
    cursor.execute('INSERT INTO students (name, age, grade) VALUES (?, ?, ?)', (name, age, grade))
    conn.commit()
    conn.close()

def add_teacher(name, subject):
    conn = sqlite3.connect('school.db')
    cursor = conn.cursor()
    cursor.execute('INSERT INTO teachers (name, subject) VALUES (?, ?)', (name, subject))
    conn.commit()
    conn.close()

# مثال: افزودن یک دانش‌آموز
add_student('محمد', 16, 11)

# مثال: افزودن یک معلم
add_teacher('استاد عباسی', 'ریاضی')

import sqlite3

def display_students():
    conn = sqlite3.connect('school.db')
    cursor = conn.cursor()
    cursor.execute('SELECT * FROM students')
    students = cursor.fetchall()
    for student in students:
        print(f"ID: {student[0]}, نام: {student[1]}, سن: {student[2]}, نمره: {student[3]}")
    conn.close()

def display_teachers():
    conn = sqlite3.connect('school.db')
    cursor = conn.cursor()
    cursor.execute('SELECT * FROM teachers')
    teachers = cursor.fetchall()
    for teacher in teachers:
        print(f"ID: {teacher[0]}, نام: {teacher[1]}, درس: {teacher[2]}")
    conn.close()

# نمایش دانش‌آموزان
display_students()

# نمایش معلمان
display_teachers()

import sqlite3

def delete_student(student_id):
    conn = sqlite3.connect('school.db')
    cursor = conn.cursor()
    cursor.execute('DELETE FROM students WHERE id = ?', (student_id,))
    conn.commit()
    conn.close()

def delete_teacher(teacher_id):
    conn = sqlite3.connect('school.db')
    cursor = conn.cursor()
    cursor.execute('DELETE FROM teachers WHERE id = ?', (teacher_id,))
    conn.commit()
    conn.close()

# مثال: حذف یک دانش‌آموز با ID 1
delete_student(1)

# مثال: حذف یک معلم با ID 1
delete_teacher(1)

import sqlite3

def edit_student(student_id, name, age, grade):
    conn = sqlite3.connect('school.db')
    cursor = conn.cursor()
    cursor.execute('UPDATE students SET name = ?, age = ?, grade = ? WHERE id = ?', (name, age, grade, student_id))
    conn.commit()
    conn.close()

def edit_teacher(teacher_id, name, subject):
    conn = sqlite3.connect('school.db')
    cursor = conn.cursor()
    cursor.execute('UPDATE teachers SET name = ?, subject = ? WHERE id = ?', (name, subject, teacher_id))
    conn.commit()
    conn.close()

# مثال: ویرایش یک دانش‌آموز با ID 1
edit_student(1, 'محمد عباسی', 17, 12)

# مثال: ویرایش یک معلم با ID 1
edit_teacher(1, 'استاد عباسی', 'فیزیک')