Event-Scheduler/database.py at main · Tarunkumar0601/Event-Scheduler · GitHub

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
from datetime import datetime
from app import app
from extensions import db
from models import Event, Resource


def seed():
    with app.app_context():
        db.create_all()
        r1 = Resource(resource_name="Room A", resource_type="room")
        r2 = Resource(resource_name="Instructor John", resource_type="instructor")
        r3 = Resource(resource_name="Projector", resource_type="equipment")

        db.session.add_all([r1, r2, r3])

        e1 = Event(
            title="Python Workshop",
            start_time=datetime(2025, 1, 10, 10, 0),
            end_time=datetime(2025, 1, 10, 12, 0),
            description="Intro to Python"
        )

        e2 = Event(
            title="Data Science Seminar",
            start_time=datetime(2025, 1, 10, 11, 0),
            end_time=datetime(2025, 1, 10, 13, 0),
            description="Advanced topics"
        )

        db.session.add_all([e1, e2])
        db.session.commit()

        Event.query.all()
        Resource.query.all()


if __name__ == '__main__':
    seed()