>>> await Band.select(
... Band.name
... ).where(
... Band.popularity > 100
... )
[
{
'name': 'Pythonistas',
}
]
>>> await Band.select(
... Band.name,
... Band.manager.name.as_alias('manager_name')
... )
[
{
'name': 'Pythonistas',
'manager_name': 'Guido'
},
...
]
await Band.delete().where(
(Band.band_members == 0) | (Band.manager.status == 'disabled')
)
await Band.update({Band.members: 5}).where(
Band.name == 'Pythonistas'
)
Or, alternatively:
band = await Band.objects().get(Band.name == 'Pythonistas')
band.members = 5
await band.save()
Read the docs, and learn the basics in 5 minutes.