File size: 2,795 Bytes
6aa6081
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
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
import pytest
from datetime import date
from sqlalchemy import create_engine, Column, BigInteger, String, Date, DateTime, Integer
from sqlalchemy.orm import sessionmaker
from sqlalchemy.orm import declarative_base

TestBase = declarative_base()


class User(TestBase):
    __tablename__ = "users"
    id = Column(Integer, primary_key=True, autoincrement=True)
    account_id = Column(BigInteger, nullable=False, default=1)
    name = Column(String(100), nullable=False)
    lastname = Column(String(100), nullable=False)
    card_id = Column(String(50), unique=True)
    email = Column(String(150), unique=True)
    role = Column(String(20), nullable=False)
    is_active = Column(String(1), default="1")


class Section(TestBase):
    __tablename__ = "sections"
    id = Column(Integer, primary_key=True, autoincrement=True)
    account_id = Column(BigInteger, nullable=False, default=1)
    name = Column(String(150), nullable=False)
    max_students = Column(Integer, default=40)


class Enrollment(TestBase):
    __tablename__ = "enrollments"
    id = Column(Integer, primary_key=True, autoincrement=True)
    section_id = Column(BigInteger, nullable=False)
    student_id = Column(BigInteger, nullable=False)
    account_id = Column(BigInteger, nullable=False)


class Attendance(TestBase):
    __tablename__ = "attendances"
    id = Column(Integer, primary_key=True, autoincrement=True)
    account_id = Column(BigInteger, nullable=False, default=1)
    user_id = Column(BigInteger, nullable=False)
    action = Column(String(10))
    checkout_time = Column(DateTime(timezone=True), nullable=True)
    note = Column(String(255))


class Holiday(TestBase):
    __tablename__ = "holidays"
    id = Column(Integer, primary_key=True, autoincrement=True)
    account_id = Column(BigInteger, nullable=False, default=1)
    name = Column(String(255), nullable=False)
    date = Column(Date, nullable=False)
    type = Column(String(20), nullable=False)


@pytest.fixture(scope="function")
def db():
    engine = create_engine("sqlite:///:memory:", echo=False)
    TestBase.metadata.create_all(engine)
    TestingSession = sessionmaker(bind=engine)
    session = TestingSession()
    yield session
    session.close()


@pytest.fixture
def section(db):
    s = Section(name="1ro A", max_students=2)
    db.add(s)
    db.commit()
    db.refresh(s)
    return s


@pytest.fixture
def students(db):
    result = []
    for i in range(3):
        s = User(name=f"S{i+1}", lastname="T", card_id=f"C{i+1}", role="student", email=f"s{i+1}@t.com")
        db.add(s)
        db.flush()
        result.append(s)
    db.commit()
    return result


@pytest.fixture
def holiday(db):
    h = Holiday(name="Test", date=date.today(), type="national")
    db.add(h)
    db.commit()
    db.refresh(h)
    return h