Coverage for docs_src / advanced / datetime / tutorial001_py310.py: 100%

1from datetime import datetime, timezone 9 ctx1abcdefghi

2 

3from sqlmodel import Field, Session, SQLModel, create_engine 9 ctx1abcdefghi

4 

5 

6class Event(SQLModel, table=True): 9 ctx1abcdefghi

7 id: int | None = Field(default=None, primary_key=True) 9 ctx1abcdefghi

8 created_at: datetime = Field(default_factory=lambda: datetime.now(timezone.utc)) 18 ctx1ajbkcldmenfogphqir

9 

10 

11sqlite_file_name = "database.db" 9 ctx1abcdefghi

12sqlite_url = f"sqlite:///{sqlite_file_name}" 9 ctx1abcdefghi

13 

14engine = create_engine(sqlite_url, echo=True) 9 ctx1abcdefghi

15 

16 

17def main(): 9 ctx1abcdefghi

18 event = Event() 9 ctx1jklmnopqr

19 print("Event:", event) 9 ctx1jklmnopqr

20 

21 SQLModel.metadata.create_all(engine) 9 ctx1jklmnopqr

22 with Session(engine) as session: 9 ctx1jklmnopqr

23 session.add(event) 9 ctx1jklmnopqr

24 session.commit() 9 ctx1jklmnopqr

25 session.refresh(event) 9 ctx1jklmnopqr

26 print("Event from database:", event) 9 ctx1jklmnopqr

27 

28 

29if __name__ == "__main__": 9 ctx1abcdefghi

30 main()