FilesExpand file tree

 develop

/

basic.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

39 lines (27 loc) · 1005 Bytes

 develop

/

basic.py

Copy path

Top

File metadata and controls

• Code
• Blame

39 lines (27 loc) · 1005 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

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

"""

This example demonstrates most basic operations with single model

"""

from tortoise import Tortoise, fields, run_async

from tortoise.models import Model

class Event(Model):

id = fields.IntField(pk=True)

name = fields.TextField()

datetime = fields.DatetimeField(null=True)

class Meta:

table = "event"

def __str__(self):

return self.name

async def run():

await Tortoise.init(db_url="sqlite://:memory:", modules={"models": ["__main__"]})

await Tortoise.generate_schemas()

event = await Event.create(name="Test")

await Event.filter(id=event.id).update(name="Updated name")

print(await Event.filter(name="Updated name").first())

# >>> Updated name

await Event(name="Test 2").save()

print(await Event.all().values_list("id", flat=True))

# >>> [1, 2]

print(await Event.all().values("id", "name"))

# >>> [{'id': 1, 'name': 'Updated name'}, {'id': 2, 'name': 'Test 2'}]

if __name__ == "__main__":

run_async(run())