data_insertion.py

from flask import Flask
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///Staff_management.db'
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
db = SQLAlchemy(app)

# Database models
class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(80), unique=True, nullable=False)
    password = db.Column(db.String(120), nullable=False)
    role = db.Column(db.String(20), nullable=False)

class LeaveApplication(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    staff_name = db.Column(db.String(80), nullable=False)
    division = db.Column(db.String(80), nullable=False)
    leave_dates = db.Column(db.String(50), nullable=False)
    reason = db.Column(db.String(200), nullable=False)
    status = db.Column(db.String(20), nullable=False)

class ProxyApplication(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    staff_name = db.Column(db.String(80), nullable=False)
    division = db.Column(db.String(80), nullable=False)
    proxy_for = db.Column(db.String(80), nullable=False)
    dates = db.Column(db.String(50), nullable=False)
    reason = db.Column(db.String(200), nullable=False)
    status = db.Column(db.String(20), nullable=False)

class Faculty(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False)
    division = db.Column(db.String(80), nullable=False)
    contact = db.Column(db.String(20), nullable=False)
    email = db.Column(db.String(120), nullable=False)
    experience = db.Column(db.Integer, nullable=False)
    subjects = db.Column(db.String(200), nullable=False)
    office_hours = db.Column(db.String(100), nullable=False)

# Create the database if it doesn't exist
with app.app_context():
    db.create_all()

    # Sample data
    sample_users = [
        # User(username='admin', password='admin123', role='admin'),
        # User(username='1', password='user123', role='user'),
        # User(username='user2', password='user123', role='user'),
        User(username="2", password='mny123', role="manager")
    ]

    sample_faculties = [
        Faculty(name='John Doe', division='Math', contact='1234567890', email='john@example.com', experience=5, subjects='Algebra, Geometry', office_hours='9AM - 11AM'),
        Faculty(name='Jane Smith', division='Science', contact='0987654321', email='jane@example.com', experience=3, subjects='Biology, Chemistry', office_hours='11AM - 1PM')
    ]

    # Insert sample data into the database
    db.session.bulk_save_objects(sample_users)
    db.session.bulk_save_objects(sample_faculties)
    db.session.commit()

    print("Sample data inserted successfully.")