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

1from datetime import UTC, datetime 8 ctx1abcdefgh

2 

3from sqlmodel import Field, Session, SQLModel, create_engine 8 ctx1abcdefgh

4 

5 

6class Event(SQLModel, table=True): 8 ctx1abcdefgh

7 id: int | None = Field(default=None, primary_key=True) 8 ctx1abcdefgh

8 created_at: datetime = Field(default_factory=lambda: datetime.now(UTC)) 16 ctx1aibjckdlemfngohp

9 

10 

11sqlite_file_name = "database.db" 8 ctx1abcdefgh

12sqlite_url = f"sqlite:///{sqlite_file_name}" 8 ctx1abcdefgh

13 

14engine = create_engine(sqlite_url, echo=True) 8 ctx1abcdefgh

15 

16 

17def main(): 8 ctx1abcdefgh

18 event = Event() 8 ctx1ijklmnop

19 print("Event:", event) 8 ctx1ijklmnop

20 

21 SQLModel.metadata.create_all(engine) 8 ctx1ijklmnop

22 with Session(engine) as session: 8 ctx1ijklmnop

23 session.add(event) 8 ctx1ijklmnop

24 session.commit() 8 ctx1ijklmnop

25 session.refresh(event) 8 ctx1ijklmnop

26 print("Event from database:", event) 8 ctx1ijklmnop

27 

28 

29if __name__ == "__main__": 8 ctx1abcdefgh

30 main()